DATABASE ERROR QUERYING SCHEMA
Fetch error from https://phnzcyzmiuxndowocamf.supabase.co/auth/v1/token?grant_type=password:
{
"code": 500,
"error_code": "unexpected_failure",
"msg": "Database error querying schema",
"error_id": "971133338050fec5-MNL"
}
12 Replies
Did you turn off the Data API when you first setup your project?
when can i turn it on
i didnt do anything after setting up the supabase
i just prompting from hostinger horizon and i found that eror just repeating
Go to this page https://supabase.com/dashboard/project/_/settings/api and see if Data API is enabled or disabled.
In that case do you have any database trigger functions that might be doing some query when you try to sign in?
im making a separate log in for customers and admin maybe the customer
i dont code i just prompt message to hostinger horizon which is connected to supabase , i dont know how to fix it yet
when i want to log in as admin thats the error
You will need to check the Postgres log in the dashboard for error and check your auth.users for a trigger calling a function.
can you give me a step by step sir im new to supabase
There is no step by step guide to debugging.
Go to the logs tab in the dashboard after you get the error and then Postgres log and see what the detailed error message is.
You can show it here.
Then go to the Database tab and the Triggers tab, select auth schema and see if you have a trigger on auth.users.
"connection authorized: user=supabase_admin database=postgres application_name=undefined SSL enabled (protocol=TLSv1.3, cipher=TLS_AES_256_GCM_SHA384, bits=256)"
