I'm checking my tables right now and they're fine

Maybe if you close the browser tab and try again it will work. It may already have worked and just crashed the loading (When you login you'll see the project created). When I created created a project it took a while too... But something like 15 mins I think. I shouldn't take that long

are there any react tutorials? I'm struggling with auth...

They have a quick guide

I managed to solve

It looks like my country_codes table was broken Has anyore here had this problem before?

I created a new table, with the same entries, columns and keys/properties. Then I changed the references from the old table to this new one, and now everything is fine

I've renamed a table, deleted and re-created the foreign key constraints but somehow the query fails because something thinks there are multiple relationships. But I can only see the correct relationships. I've restarted the server. I've run

NOTIFY pgrst, 'reload schema'

to reload the schema cache. Any other ideas?

I think my problem is related to yours @User . Everything was working and now it fails again... it is also related to foreign key issues

I'm creating a composite primary key compound of multiple foreign keys

Hmmm, I think mine is related to renaming the table and something being cached somewhere. Where I query the database I can see the correct foreign key constraints but my query fails because it thinks the OLD foreign key constraint is still present.

Now that you said.... I think I did rename my problematic table...

Hey! I am curios about something - wanna build an open source project where supabase would serve as an api. So basic setup next.js Frontend + supabase. But I am already doing a lot of setup on supabase level, creating tables, setting relations etc. if I want to allow self hosted version of the project - is there any chance that somebody could just clone my supabase project?

How do you get the id of a column you just inserted? For some reason, when I try to use that id to insert another column, it shows up as null. I thought it returned the inserted column with the new id when you did an insert

did you give the permissions to read (SELECT) the column?

I changed supabase_admin role/user password via sql command

ALTER USER user_name WITH PASSWORD 'new_password';

and now I get errors and can't see users in authentication, policies, etc.

Error connecting to API
SyntaxError: JSON.parse: unexpected character at line 1 column 1 of the JSON data

I tried changing the password in the sql page without success,

password authentication failed for user "supabase_admin"

here's a screen cap

Not sure why you changed that user's password, but you shouldn't modify user's passwords that you don't own. The only password you should modiffy is the

postgres

one if you think it has been compromised.

You will need to use the feedback widget in the dashboard to alert the supabase team of this change and see if they can rectify it for you

Trying to get a 3rd party service running on top of supabase postgres instance. The postgres role isn't a super user. supabase_admin is, but there was an issue with a character in the password (causing the 3rd party service to be unable to connect to db)

Thus I had to change the password so it wouldn't include invalid char.

I just sent via cms feedback component

Hi! I tried updating a row in my table and got this error:

Error: Error: "users" has no attribute "updatedat"

Error received from both js client and ui

@User What are your table columns?

id: uuid telegramUsername:varchar telegramId: int8 fullName:varchar gender:varchar email:varchar phoneNumber:varchar acceptedTos:: bool createdAt:timestamptz data: jsonb paystackSubaccountId:varchar avatar:text updatedAt:timestamptz

You're missing

updatedat:timestamptz

Yep, your error is correct - there is no

updatedat

Do i have to have that column got updates to work?