Error 500 - user management
I'm a newbie, i say it like it is. No experience with SQL, Supabase, ... Thought I give it a try, but struggling right from the start.
Being new to this, I used the quickstart on user management, to create a public 'profiles' table with data from the user table. (table, policies, trigger, function).
I altered the table name and added a number of colums to the table in the SQL code. All this prior to creation of the table.
When I have the created function only to put the user new.id into the profile table, it works just fine.
As soon as I alter the function to put the email as well in the profile table, I get an error 500.
Logs are stating that the column email1 can not be found in the profile table. However, the email1 column in the profile table is created and type= 'Text'.
Thx for any help, tips,...
Being new to this, I used the quickstart on user management, to create a public 'profiles' table with data from the user table. (table, policies, trigger, function).
I altered the table name and added a number of colums to the table in the SQL code. All this prior to creation of the table.
When I have the created function only to put the user new.id into the profile table, it works just fine.
As soon as I alter the function to put the email as well in the profile table, I get an error 500.
Logs are stating that the column email1 can not be found in the profile table. However, the email1 column in the profile table is created and type= 'Text'.
Thx for any help, tips,...
