Unhandled server error: ERROR: relation \"users\" does not exist

In my Next.js app, after signing in, the middleware should, of course, run. The problem is that I am calling supabase.auth.getUser() there, but the auth server responds with the error: "Unhandled server error: ERROR: relation "users" does not exist," even though the signup is successful, everything is set up correctly, and the cookies are present. What can I do to resolve this?

imam_janjuaOP•1/14/25, 4:29 PM

And Also like after signin, it gives me like 10 or so undefinied user and than all works normal

garyaustin•1/14/25, 4:37 PM

Do you have any trigger functions on auth.users? Auth hooks?
Can you check the Postgres log for the database error, somethings that shows what called it.

imam_janjuaOP•1/14/25, 4:59 PM

@garyaustin yes I have a auth hook running, but as far as i can see its working fine, postgres but it giving the same error, so users relations not definied

garyaustin•1/14/25, 5:05 PM

There should be detail on that error.
What is your auth hook code? I'm guessing it is not correct in grants or RLS.

imam_janjuaOP•1/14/25, 5:19 PM

@garyaustin like thats all I am gettig from the error, no detailed message I can see

imam_janjuaOP•1/14/25, 5:20 PM

This is how my auth hook looks like

garyaustin•1/14/25, 5:42 PM

Check if you have auth.users in the table UI.
It is auth_admin running, so I'm guessing it is the auth.users table and not an attempt at a public users table.

You have a set search_path to '' in your code. I don't see that in the guide. Wonder if that takes auth out of the search_path for something later. I would think it is local to the function though.

imam_janjuaOP•1/14/25, 5:59 PM

@garyaustin thanks man its working, was struggling with that alot.

imam_janjuaOP•1/14/25, 6:01 PM

I have a auth related question for mobile, but which does not have nothing to do with this one. If u are okay can i asked u that one, maybe u know more aboult it

garyaustin•1/14/25, 6:07 PM

Ask a new question in a new topic. I’ll check when I get back.

imam_janjuaOP•1/14/25, 6:07 PM

ok, I will do that

imam_janjuaOP•1/14/25, 6:13 PM

@garyaustin I have made once called "Session not persisting on mobile"

Unhandled server error: ERROR: relation \"users\" does not exist

Similar Threads

Similar Threads

Similar Threads