SupabaseS
Supabase11mo ago
Erik

500: Database error saving new user - app_role does not exist

Hi,

I am having issues. I can't manually create new users, it gives a error 500.
Under tables, I have created one called user_roles, where I have a app_role column (also called app_role).

Here i have Custom enumerated types:
public | app_role | dealer, admin

But yet I am receiving the error below:

{"component":"api","error":"failed to close prepared statement: ERROR: current transaction is aborted, commands ignored until end of transaction block (SQLSTATE 25P02): ERROR: type "app_role" does not exist (SQLSTATE 42704)","level":"error","method":"POST","msg":"500: Database error saving new user"

Does anyone have a clue on what to do?
Was this page helpful?