A new user fills in your sign-up form, clicks the button, and gets nothing. Your console shows a 500 from Supabase Auth with the message Database error saving new user . Existing users can still sign in. Nobody new can get in.
I see this a lot in Lovable, Bolt and Vite apps that keep a profiles table next to Supabase Auth. It sounds like Supabase is broken. It almost never is: something in your own database stopped the user row from being written.
Below is how I track it down, in order. Everything here comes from Supabase's Database error saving new user and Errors when creating / updating / deleting users troubleshooting guides, the Managing user data guide, the Database functions guide and the Auth error codes page, all read on 10 November 2026.
What the error actually means
When someone signs up, Supabase Auth inserts a row into auth.users . If anything attached to that insert fails, the transaction is aborted and Auth returns a generic wrapper.…