Troubleshooting the "Database error saving new user" in Supabase

Discover how to troubleshoot the 'Database error saving new user', 'Failed to invite user: failed to make invite request: Database error saving new user' or 'relation public.profiles does not exist supabase' error in Supabase. Our step-by-step guide helps you pinpoint the issue, review SQL code, and resolve conflicts. Perfect for developers looking to overcome this common challenge.

Step 1: Review Supabase Logs

To identify the cause of the error in Supabase, follow these steps:

1. Log in to your Supabase account.
2. Access the "Logs" section.
3. Click on the "Auth" category.
4. In the "Auth" logs, filter by "severity."
5. Look for the error message related to the missing relation.

This step will help you pinpoint the specific error message and its context.

In this case, i got error: 'relation public.profiles does not exist'

Step 2: Examine SQL Editor

Inspect your SQL code in the Supabase SQL editor to ensure your User Manager Starter code or any related queries for creating the "profiles" table are correct:

1. Open the SQL editor in Supabase.
2. Execute the SQL code responsible for creating the "profiles" table.
3. Check for any warnings or errors.

If there are issues in your SQL code, this step will help you identify and address them.

Step 3: Delete Problematic Functions

In certain cases, functions or triggers might conflict with your database setup. If you've identified issues related to functions like "handle_new_user, or create trigger on_auth_user_created" consider deleting them:

create function public.handle_new_user()
returns trigger as $$
begin
  insert into public.profiles (id, full_name, avatar_url)
  values (new.id, new.raw_user_meta_data->>'full_name', new.raw_user_meta_data->>'avatar_url');
  return new;
end;
$$ language plpgsql security definer;
create trigger on_auth_user_created
  after insert on auth.users
  for each row execute procedure public.handle_new_user();

or run these new queries

DROP FUNCTION IF EXISTS public.handle_new_user();

DROP TRIGGER IF EXISTS on_auth_user_created ON auth.users;

By removing conflicting functions and triggers, you can resolve potential conflicts and retest your database setup. After all steps I am able to create a new user and send links.

I hope this post will be helpul to you too. Happy coding!