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 solution

Supabase Auth: Unsupported provider after clicking “Google”

The OAuth button reports an error, although redirecting the application is correct.

Read the solution

Supabase Auth: updateUser password needs to be authenticated again

The logged user cannot change the password in the account panel.

Read the solution

Supabase Auth: Weak Password blocks account creation

The user cannot set the password even though it has enough characters.

Read the solution

Supabase 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 solution

Supabase CLI: migration history does not match

The migration command refuses further changes by the divergence of local and remote history.

Read the solution

Supabase Database Webhook Triggers an Update Loop

Webhook since status change saves the same record and generates a series of consecutive webhooks.

Read the solution

Supabase Edge Function: Invalid JWT

The function returns 401 or Invalid JWT, while a simple query to the database works.

Read the solution

Supabase 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 solution

Supabase MFA: access token has AAL1 instead of AAL2

Action requiring MFA returns the refusal despite the correct login and password.

Read the solution

Supabase MFA: TOTP code is constantly rejected

Authorizing application shows code, but Supabase returns invalid challenge.

Read the solution

Supabase OAuth: redirect uri mismatch in Google

When Google selects to log in, it appears that it refuses to redirect.

Read the solution

Supabase PGRST116: .single() Returns No Rows

Call .single() returns PGRST116 and no single object message.

Read the solution

Supabase 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 solution

Supabase Realtime does not update the list without refresh

Database changes don't appear in React? Check table publication, subscription, filters and RLS.

Read the solution

Supabase Realtime: Missing Updates After Reconnection

After reconnecting WebSocket UI retains an older set of records.

Read the solution

Supabase 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 solution

Supabase 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 solution

Supabase 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 solution

Supabase 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 solution

Supabase SSR: Server Cannot Read the Logged-In Session

Client Component recognizes user, but Server Component returns guest view.

Read the solution

Supabase 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 solution

Supabase 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 solution

Supabase 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
All English guides
Supabase and databases — troubleshooting and solutions