Usually it's when you try to access some api from another domain; and the browser does not like that

Seems like Supabase login timed out on Supabase backend. We see 522 response, sent via CloudFlare.

They have an access control allow origin so that should be fine

I think something got stuck with the project pausing. We can't even see auth logs in the Supabase admin. Restarting the server didn't help :/ CORS seems to be only a side-effect of the timeouts produced by Supabase backend response taking too long, which resulted in CloudFlare's 522 response (without header).

Ok, so apparently everything times out, not just the auth. Is there any known issue related to this linked to project pausing?

Quick bump on this. tl;dr: how to use Supabase with OAuth provider that's not supported officially?

How do I make the default value for a varchar an empty string on the interface?

I have a strange problem with the

supabase.auth.onAuthStateChange

not firing sometimes after a users clicks on a confirmation link, which makes my NextJS app not setting the authCookie correctly, causing the user to be redirected back to the sign in page. Anyone else came across this issue? 1. The user clicks on the confirmation link in the email 2. The user comes to my specified redirectUrl. 3. The onAuthStateChange-function, which lives in a context called useUser is not being fired at all, as I can't see the

console.log(event)

firing at all. 4. The user goes to a different page, which has a getServerSideProps-function that checks if user exists on the server. If not, it redirects the user to the signin page

onAuthStateChanged NOT firing on confirmation links

Anyone else having problems adding the Supabase integration to Vercel? Other integrations work.

I am running into some hiccups trying to sort a list of products by price, I took a look at the documentation, but I am a bit confused about the

foreignTable

property. I tried to pass the name of the table and the name column that makes the foreign-key relation, but none of those seem to work. Any advice will be appreciated

const products = await supabase
    .from("products_tagged")
    .select("id, productID(*)")
    .eq("tagID", 7)
    .order("price", { foreignTable: "productID" });

Has anyone figured out what to do when you get constant

{ "message": "JWT expired" }

responses from supabase on all api calls? It happened on my prod server yesterday (and seemingly resolved itself after ~2 hours + a server restart). It's now occurring on my dev environment and a restart hasn't fixed it

Scratch that, it's happening in both my dev and prod

I have submitted a ticket via https://app.supabase.io/support/new

We got your ticket, we'll get someone to look into this

I think the issue is that I don't have a way to refresh the JWT for my SvelteKit server? I set it up following https://www.ashleyconnor.co.uk/2021/06/24/authenticated-server-rendered-pages-with-sveltekit-and-supabase which lists

There’s no refresh mechanism on a SSR request.

as a drawback

Same issue here, getting JWT expired in two different projects, performing a restart didn't fix it either

Has this happened for you in the past?

Or just recently?

Not that I'm aware of

Just recently

I just realized that it wasn't working a few minutes ago in two diferent servers (one in eu-central-1 and the other in eu-west-2)

is it possible to create a trigger to store public URL to a table after an upload to the storage?

Alright, kind of a weird question but I was wondering if there was a way to make the ID fields of a table be incrimental integers

I believe that's how they're setup by default. You can edit the table, and click the little "gear" icon next to the automatically-added

id

column for the table and see that it's set to an identity type.

okay, because right now they're generating long ID's like this: 43e28e19-eff2-424b-8e78-c4591dbf2220

I would guess somehow it got changed to a

uuid

type instead of

int8

OK, I'mma try this one again over here ...

Hey everyone. I've been reading through the docs, and have been having some trouble wrapping my head around something. This section in the docs states "If your database has relationships...", but I've not been able to figure out what exactly it means by relationships. I created a few tables, but wasn't able to figure out how to establish true foreign key relationships. Is that what this is referring to? Or does it just mean, for example, if I have a posts table, that has an author_id column whose value matches the id column from the users table ... is it referring to that as a relationship, even though there isn't a true foreign key between the two tables? https://supabase.io/docs/reference/javascript/select#query-foreign-tables