Help! Why Im facing this issue?

"POST | 500 | 103.189.186.157 | 97e663a94cd8da0d | https://baypdaiwqqpzabvbfzjs.supabase.co/auth/v1/token?grant_type=password | Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36" h
24 Replies
DevsrealmGuy
DevsrealmGuy2mo ago
What error message did it return aside from the status code 500?
affhrms
affhrmsOP2mo ago
Yes got 500 status code
affhrms
affhrmsOP2mo ago
No description
affhrms
affhrmsOP2mo ago
No description
affhrms
affhrmsOP2mo ago
No description
DevsrealmGuy
DevsrealmGuy2mo ago
Why have the user banned?
affhrms
affhrmsOP2mo ago
If I tried using authentication, it also did not work
DevsrealmGuy
DevsrealmGuy2mo ago
The error occurs when you try to log in a user, correct?
affhrms
affhrmsOP2mo ago
Yes when I try to login then facing this error
DevsrealmGuy
DevsrealmGuy2mo ago
This is all still blackbox as the info is still limited, so, here is a suggestion: - Try to create a separate user and see if that works? ...and what stack is this: Next/React/etc?
affhrms
affhrmsOP2mo ago
client site using React
garyaustin
garyaustin2mo ago
This most likely is your auth signup failing because of a trigger function on auth.users. Check your Postgres logs for the detailed database error.
affhrms
affhrmsOP2mo ago
"POST | 500 | 143.110.189.147 | 97f4e6409f8158e1 | https://baypdaiwqqpzabvbfzjs.supabase.co/auth/v1/token?grant_type=password | Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36" This error is facing Supabase log Can you help me to solve this issue
garyaustin
garyaustin2mo ago
As I said check your Postgres logs in the dashboard. But my assumption is you have an auth.user trigger function you added (or if using an AI added) and it has an error in it. You can see if you have a trigger function in the Database tab, Triggers and then select the Auth schema.
affhrms
affhrmsOP2mo ago
No description
affhrms
affhrmsOP2mo ago
No description
garyaustin
garyaustin2mo ago
That is the public schema look at the auth schema.
affhrms
affhrmsOP2mo ago
No description
affhrms
affhrmsOP2mo ago
in here brother? Brother if you can please help me last 5days I facing this issue, not found any solution from google
garyaustin
garyaustin2mo ago
Are you using an AI? The handle user function seems like you added a trigger function to auth.user to create something like a profile table.
affhrms
affhrmsOP2mo ago
Yes I developed the project using hostinger horizon AI
affhrms
affhrmsOP2mo ago
No description
garyaustin
garyaustin2mo ago
This link https://supabase.com/dashboard/project/_/database/triggers should take you to the triggers page. Select the auth schema. It will probably show a trigger function. And that trigger function is not working. The reason it is not working will be in the dashboard Postgres log. I'm out for the night. You or your AI needs to resolve the issue with the function.
affhrms
affhrmsOP2mo ago
No description

Did you find this page helpful?