Confirmation links broken - not verifying new user accounts
As the title describes. Supabase registration confirmation links error out activating user accounts.
Innitially it was indicated that the issue stems from a confusion between the auth.users table and my created public.users table. But after spending hours to rename the db table and adjusting the frontend application to account for the change the issue still persists.
I've created two tickets but so far have neither gotten a response or an acknowledgement that the ticket has been received.
I am on a deadline and am willing to pay for support. So could someone please get in touch with me?
3 Replies
Support does not usually help with debug of your code. Your error points to a trigger function you created having an issue.
This is a user helping user forum and not regularly monitored by staff.
Show your trigger functions and table definition.
The trigger called on confirmation is trigger_welcome_email_on_user_creation which calls a function which adds the user to the additional "app_users" table.
I don't see how the trigger/function is the issue. The function does not use the "raw_user_meta_data". From my understanding this is used internally for the auth.users table.
The function itself (see screenshot) is not doing anything related to the raw_user_meta_data
Do you have another trigger on auth.users? Did you ever have a public users table?
I have seen this where the trigger function sets the search path in the function and does not include auth schema. Same error as yours.
Do either of your two tables have triggers on them?