SupabaseS
Supabase2mo ago
Dexter

Messed up my DB

Hello, I somehow managed to mess up my auth schema or smth and now I cannot login or create users. The error i see in the console is "GET /auth/oauth?error=server_error&error_code=unexpected_failure&error_description=Database+error+saving+new+user&next=%2F 307".

The error happens when I click on the oauth sign in flow. I think I might have deleted something on accident from the auth schema.

Luckily I had no useful data in my db. Is there a way to completely reset the database to what it was before and then rerun my migrations ?

I wanted to clear all users so I run the following:
delete from auth.users;
delete from auth.identities;
delete from auth.sessions;
delete from auth.refresh_tokens;
Was this page helpful?