Β© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabaseβ€’3y agoβ€’
19 replies
noli

500 (Internal Server Error) w/ Auth

I'm getting a 500 error whenever I try to run:

const handleSignUp = async () => {

        const { data:datas, error:errors } = await supabase
    .from('profiles')
    .select()
    .eq('userName', user_name)
    if (datas.length != 0) {setWarning("Username already being used"); return}
    if (user_name == '' || email == '' || password == ''){
        setWarning("No empty usernames, email, or passwords");
        return}

    const res = await supabase.auth.signUp({
        email,
        password,
        options: {
            data: {user_name: user_name},
            emailRedirectTo: `${location.origin}/auth/callback`
        }
    })
    setUser(res.data.user);
    router.refresh();
    setEmail('');
    setPassword('');
    }
const handleSignUp = async () => {

        const { data:datas, error:errors } = await supabase
    .from('profiles')
    .select()
    .eq('userName', user_name)
    if (datas.length != 0) {setWarning("Username already being used"); return}
    if (user_name == '' || email == '' || password == ''){
        setWarning("No empty usernames, email, or passwords");
        return}

    const res = await supabase.auth.signUp({
        email,
        password,
        options: {
            data: {user_name: user_name},
            emailRedirectTo: `${location.origin}/auth/callback`
        }
    })
    setUser(res.data.user);
    router.refresh();
    setEmail('');
    setPassword('');
    }


and it wasn't like that until I added my trigger for function "create_profile_for_new_user":
BEGIN
  INSERT INTO public.profiles (id, userName, avatar_url)
  VALUES (NEW.id, NEW.raw_user_meta_data ->> 'user_name', 'https://i.imgur.com/Rg4oOtW.png');
  RETURN NEW;
END;
BEGIN
  INSERT INTO public.profiles (id, userName, avatar_url)
  VALUES (NEW.id, NEW.raw_user_meta_data ->> 'user_name', 'https://i.imgur.com/Rg4oOtW.png');
  RETURN NEW;
END;




I need help figuring what went wrong! It was working fine before I ran
create trigger create_profile_for_new_user after insert on auth.users for each row execute function create_profile_for_new_user();
create trigger create_profile_for_new_user after insert on auth.users for each row execute function create_profile_for_new_user();
Supabase banner
SupabaseJoin
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.
45,816Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

auth v1 user 500 Internal Server Error
SupabaseSSupabase / help-and-questions
4y ago
500 Internal Server Error
SupabaseSSupabase / help-and-questions
6mo ago
AuthApiError Internal server error
SupabaseSSupabase / help-and-questions
4y ago
Supabase Website - Error 500 - Internal Server Error
SupabaseSSupabase / help-and-questions
4y ago