Auth error: "relation audit_logs does not exist" - blocking all new user signups
Description:
I'm trying to allow users to sign up for my application (both email/password and Google OAuth), but every signup attempt is failing with a database error.
What's going wrong:
All user creation attempts fail with this error:
ERROR: relation "audit_logs" does not exist (SQLSTATE 42P01) Database error creating new user
What I've discovered:
- My auth schema contains a table named audit_log_entries (not audit_logs)
- The Supabase Auth service is looking for auth.audit_logs which doesn't exist
- I cannot create the missing table because auth schema is read-only
- This was working previously and suddenly stopped working
Environment details:
- Platform: Web (Next.js)
- Framework: Next.js 15.3.3
- Library: @supabase/supabase-js@2.50.0
- @supabase/ssr@0.5.2
- @supabase/auth-helpers-nextjs@0.10.0
- Project ref: wgofkssqahgiwjtypipc
- OS: Production deployment on Vercel
Impact:
No new users can create accounts. All authentication methods are failing with the same error.
I'm trying to allow users to sign up for my application (both email/password and Google OAuth), but every signup attempt is failing with a database error.
What's going wrong:
All user creation attempts fail with this error:
ERROR: relation "audit_logs" does not exist (SQLSTATE 42P01) Database error creating new user
What I've discovered:
- My auth schema contains a table named audit_log_entries (not audit_logs)
- The Supabase Auth service is looking for auth.audit_logs which doesn't exist
- I cannot create the missing table because auth schema is read-only
- This was working previously and suddenly stopped working
Environment details:
- Platform: Web (Next.js)
- Framework: Next.js 15.3.3
- Library: @supabase/supabase-js@2.50.0
- @supabase/ssr@0.5.2
- @supabase/auth-helpers-nextjs@0.10.0
- Project ref: wgofkssqahgiwjtypipc
- OS: Production deployment on Vercel
Impact:
No new users can create accounts. All authentication methods are failing with the same error.
