Troubleshooting guides by topic
Supabase and databases
PostgreSQL, RLS, authentication, storage and database permissions.
77 English guides in this category
Supabase Auth: The role of admin with user metadata does not protect API
The application recognises the user metadata.role value given by the client as the administrator's permission.
Read the solutionSupabase Auth: Unsupported provider after clicking “Google”
The OAuth button reports an error, although redirecting the application is correct.
Read the solutionSupabase Auth: updateUser password needs to be authenticated again
The logged user cannot change the password in the account panel.
Read the solutionSupabase Auth: Weak Password blocks account creation
The user cannot set the password even though it has enough characters.
Read the solutionSupabase Branching: preview has a different structure of tables than main
Preview operates on a separate branch of the base and does not see columns added on production.
Read the solutionSupabase CLI: migration history does not match
The migration command refuses further changes by the divergence of local and remote history.
Read the solutionSupabase Database Webhook Triggers an Update Loop
Webhook since status change saves the same record and generates a series of consecutive webhooks.
Read the solutionSupabase Edge Function: Invalid JWT
The function returns 401 or Invalid JWT, while a simple query to the database works.
Read the solutionSupabase JWT: new roles do not appear in active token
After changing the role in the database, the user still receives a refusal or retains the old permission.
Read the solutionSupabase MFA: access token has AAL1 instead of AAL2
Action requiring MFA returns the refusal despite the correct login and password.
Read the solutionSupabase MFA: TOTP code is constantly rejected
Authorizing application shows code, but Supabase returns invalid challenge.
Read the solutionSupabase OAuth: redirect uri mismatch in Google
When Google selects to log in, it appears that it refuses to redirect.
Read the solutionSupabase PGRST116: .single() Returns No Rows
Call .single() returns PGRST116 and no single object message.
Read the solutionSupabase PGRST202: Function Missing from Schema Cache
The newly created SQL function is not accessible by rpc(), although it is performed in SQL Editor.
Read the solutionSupabase Realtime does not update the list without refresh
Database changes don't appear in React? Check table publication, subscription, filters and RLS.
Read the solutionSupabase Realtime: Missing Updates After Reconnection
After reconnecting WebSocket UI retains an older set of records.
Read the solutionSupabase Realtime: subscription works, but there are no changes in the table
The realtime channel shows the status of SUBSCRIBED, but INSERT and UPDATE do not refresh the list.
Read the solutionSupabase Realtime: the same change appears several times in the table
After entering the screen several times each INSERT adds a record several times.
Read the solutionSupabase returns an empty list after logging in — check RLS
No records on a valid query need not mean an empty table. Row Level Security policy can hide poems from a specific user. You
Read the solutionSupabase RLS: Record counter is different from user list
The difference between SELECT, count and administrator access in Supabase. How to test the counter without leaking data.
Read the solutionSupabase SSR: Server Cannot Read the Logged-In Session
Client Component recognizes user, but Server Component returns guest view.
Read the solutionSupabase Storage 403: the file is, but the photo does not open
Error 403 on photos and attachments of the Supabase Storage. Bucket, signed URL and access policy.
Read the solutionSupabase Storage 413 EntityTooLarge on photo or video upload
Supabase returns HTTP 413 at upload? Set global limit and bucket limit, check file size and upload method.
Read the solutionSupabase Storage: 403 when downloading a private file
The file exists in a buget, but the public address Storage returns the refusal to access.
Read the solution