Hey all, new to Supabase and Postgres. When trying to invite a user via the UI I now receive a

Failed to invite user: Database error saving new user

and 500 error in the logs. This is after adding a trigger to update my profiles table from user auth additions. I see it is a common error from a search, but I'm not sure what the solution for me is. Any suggestions?

Hello @gehrig! This thread has been automatically created from your message in #843999948717555735 a ``few seconds ago``. Pinging @User so that they see this as well! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ... menu) and select Leave Thread to unsubscribe from future updates. Want to change the title? Use the

/title

command! We have solved your problem? Click the button below to archive it.

Fwiw, this was after following Jon's very nicely done video.

It means your trigger is storing additional information which isn’t provided on invite. The UI invite feature won’t allow you to add the additional information so this won’t work.

gehrig (2022-04-24)

Odd. After playing around (deleting and re-adding) it is now working. The trigger is only taking the auto generated user ID and adding to the public profiles table.

Thread was archived by @gehrig. Anyone can send a message to unarchive it.