I cant create Accounts
Hello dear Community, I am a newbie in Programming so I dont know much, im creating a App with the help of lovable but everytime I try to create a Account in supabase or in loveable it Doesnt work; Database error creating new user. I tried with some sql Commands with the help of Chat gpt: • Created profiles table with id, user_id, full_name, created_at
• Enabled RLS on profiles
• Deleted old overlapping policies; added clean INSERT, SELECT, UPDATE policies
• Tried trigger on auth.users to auto-create profile → failed due to NOT NULL columns
• Removed trigger; kept only SELECT/UPDATE policies → still “Database error creating new user”
• Identified causes: RLS blocking inserts, NOT NULL fields, Supabase Auth misconfiguration (email sign-ups, Google OAuth, SMTP)
• Proposed clean approach:
1. Remove triggers
2. Create user in Supabase Auth first
3. Create profile afterward via frontend/backend code
• This method avoids trigger issues, respects RLS, and allows email + Google login to work correctly.
Can anyone help me ?
• Enabled RLS on profiles
• Deleted old overlapping policies; added clean INSERT, SELECT, UPDATE policies
• Tried trigger on auth.users to auto-create profile → failed due to NOT NULL columns
• Removed trigger; kept only SELECT/UPDATE policies → still “Database error creating new user”
• Identified causes: RLS blocking inserts, NOT NULL fields, Supabase Auth misconfiguration (email sign-ups, Google OAuth, SMTP)
• Proposed clean approach:
1. Remove triggers
2. Create user in Supabase Auth first
3. Create profile afterward via frontend/backend code
• This method avoids trigger issues, respects RLS, and allows email + Google login to work correctly.
Can anyone help me ?
