Supabase

S

Supabase

Join the community to ask questions about Supabase and get answers from other members.

Join

error in email configuration

Hello, good evening. Could you help me? I have Supabase on my host, but when I try to save the email settings, I get this error: { "data": null, "error": { "message": "Method PATCH Not Allowed" }...
No description

HTML code rendered as text

"Edge Function returning HTML content gets wrapped in <pre> tags despite correct Content-Type headers, preventing proper widget rendering."

Proper RLS for audit table

In our project, we have a table where we keep an audit of any other changes made to the other tables, the data is populated via triggers on the other tables, for example, if someone updates a field on table1, a Supabase trigger will store the old value, new value, column name, table name and the id of who made the change. I'm struggling to figure it out what would be the proper RLS for that audit table. It will not be queried on the application, it is only for record keeping and the only way it gets data populated is from the Supabase triggers on the other tables. Can anyone share some ideas?...

can i create my trading bot backend in supabase?

i hve created trading bot using lovable.dev and connected supabase as backend all ai and i am close to complete my bot i want to know how to host my bot or supabse offer any premium feature if i want scale my bot or for private use.

Insert row into RLS enabled table from edge function using new keys

Using the new types of assymetric keys, could anyone share an example of a react / vite function that would retrieve the necessary information to be allowed to insert a row into a table? It would also be great to confirm how the able needs to be set up in RLS for this to work. Thanks!...

Edge function workers failing to boot, Typescript error

We are seeing a major problem with about half of our edge function workers failing to initialize due to a typescript error. Our production code hasn't been upated in a month. event loop error: TypeError: Cannot read properties of undefined (reading 'wasm') at Object../src/env.js (https://cdn.jsdelivr.net/npm/@xenova/transformers@2.9.0:67:467) at webpack_require (https://cdn.jsdelivr.net/npm/@xenova/transformers@2.9.0:106:9092) at Object../src/utils/hub.js (https://cdn.jsdelivr.net/npm/@xenova/transformers@2.9.0:97:191) at webpack_require (https://cdn.jsdelivr.net/npm/@xenova/transformers@2.9.0:106:9092) at Object../src/tokenizers.js (https://cdn.jsdelivr.net/npm/@xenova/transformers@2.9.0:79:1019) at webpack_require (https://cdn.jsdelivr.net/npm/@xenova/transformers@2.9.0:106:9092) at Object../src/pipelines.js (https://cdn.jsdelivr.net/npm/@xenova/transformers@2.9.0:73:801) at webpack_require (https://cdn.jsdelivr.net/npm/@xenova/transformers@2.9.0:106:9092) at Object../src/transformers.js (https://cdn.jsdelivr.net/npm/@xenova/transformers@2.9.0:82:16514) at webpack_require (https://cdn.jsdelivr.net/npm/@xenova/transformers@2.9.0:106:9092)...

I can not for the life of me find my pro plan invoice/reciept.

I go to billing invoices all invoices show zero. I confirm my card was charged, and that I am on the pro plan. I search all folders of my email I cannot find my pro plan invoice anywhere please help I have to upload the invoice to my accounting system I have already wasted an hour looking. It should not be this hard

Is it ok to delete migrations produced by drizzle?

I use Drizzle to manage schemas and what not. It has been awhile since I pushed changes to my DB (probably over a year) so I am trying to figure out the best way to go about that. I was running drizzle-kit migrate locally and I guess it's going through every single migration and failing on a migration from 12 months ago.
ALTER TABLE "users_table" RENAME COLUMN "mediaAffiliation" TO "organization";
ALTER TABLE "users_table" RENAME COLUMN "mediaAffiliation" TO "organization";
...

Clone branch with tables schema and data, Authentication users and Storage

Hi all! I was trying to create a new branch and then have a clone of everything that's on the main branch but looks like this is not something we can do easily. Is there a way of doing this? So if I create a new branch I have the schema, but I also need the tables data, authentication users and storage. I've tried a bunch of things, but non of them worked properly.

Error SQL query

So i am trying to create policy(RLS) on supabase to delete a row using id, it keep showing this error ( uuid = bigint ) also tried changing the type on user_id to uuid on table column but still same thing.
No description

typescript lib types have too many optional fields

I noticed supabase's typescript lib has a ton of optional fields for the user/auth types, which means a lot of convoluted typescript code for type assertions and null/undefined checking (see screenshot) according to the docs, these fields shouldn't be optional. is the typescript lib outdated?...
No description

Create or replace function creating duplicate

Hey, When deploying an update of a function via SQL ('CREATE OR REPLACE FUNCTION my_function'), it no longer replaces the function. Instead, it creates a duplicate function with the same name. Does anyone know if this is an intentional change by Supabase? Or a bug? Thank you....

Getting an 204 status code without content using supabase.functions.invoke cause error

When we invoke an supabase function and getting an 204 return with no content then the function crash. While i'm expacting that when resolved to an 204 (no-content see https://developer.mozilla.org/en-US/docs/Web/HTTP/Reference/Status/204) it doesn't try to parse the json. Is this an bug or do we need to send something extra with the invoke method to make sure we don't parse the response by default? Our code looks like this: await supabase.functions.invoke(...

user_metadata changes based on last provider user logged in with

has anyone else noticed this? the docs say "Defaults to the first provider's identity data" but I found this to not be true?
No description

Supabase Api is not calling on client side

I am building the Sass platform using Next.js with Supabase. Currently I am using Supabase on the client side to retrieve data for my user list view table, but after the initial load, it is not called again. However, after refreshing the browser, I can retrieve data from Supabase. Why is that?...

RLS Connection Error with Next.js + Prisma (service_role)

After enabling RLS on my tables, my Next.js backend API routes using Prisma Client are failing with PrismaClientInitializationError: Can't reach database server. This error occurs even when the Prisma Client is configured to use the service_role key and the direct database connection string (port 5432). The most confusing part is that a CLI command like npx prisma migrate dev connects successfully, but the exact same Prisma Client fails within the Next.js application runtime....

Unacceptable audience in id_token" Error with Native Sign-In on Local Supabase Instance

I am using Supabase Auth with Expo. - "@supabase/supabase-js": "^2.49.4" - "supabase": "^2.33.9" ...

Urgent: Need help in my production app with new users not being able to sign in

The issue is - when they go to sign in with said email and password - it is not actually signing them in. I see the auth token saved to my cookies, and when I console log the data response from the SignInWithEmailAndPassword() it shows all the data there. The weird part is on older accounts, like the one I made when I first launched and my original users - we can all sign in fine no problem. It is only newly created accounts that cannot sign in. I confirmed evrything on the supabase side seems to be working, it says the emails were confirmed etc.. but still no luck. Not sure where to really begin here. I am using Turnstile for CAPTCHA protection, and have since I launched. I also am using supabase email/pw auth. ...

I removed data from table by wrong and i am in free plan

I removed data from table by wrong and i am in free plan help me........

RealtimeClient.js:153 WebSocket connection to 'ws://localhost:54321/realtime/v1/websocket?apikey=xx

Hi, I have upgraded to 2.33.9 and im running this locally - this is an important distinction because when I push to vercel and connect to supabase.com, we dont have this issue. Where Im running a real time connection on a page I get repetitive errors in my browser console (Ive checked 3 browsers and incognito) and I keep getting RealtimeClient.js:153 WebSocket connection to 'ws://localhost:54321/realtime/v1/websocket?apikey=xx. Supabase has been started and is running without issues. Any idea what is causing this please, I can ping curl -I "http://localhost:54321/realtime/v1/api/ping" and it returns a 200. I didnt have this problem before. I have this policy set in my realtime settings for select: alter policy "Users can receive memorial broadcasts" on "realtime"."messages"...