SupabaseS
Supabase2y ago
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('');
    }


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;




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();
Was this page helpful?