Invalid input syntax for type bigint

Hi, i've just started using supabase with nextjs. I have i simple function that retrieve user data from 'profiles'

let { data, error, status } = await supabase
          .from("profiles")
          .select(`username`)
          .eq("id", id)
          .single();

        if (error && status !== 406) {
          throw error;
        }

        if (data?.username) {
          router.push({ pathname: "/[account]", query: { account: id } });
          return;
        }

let { data, error, status } = await supabase
          .from("profiles")
          .select(`username`)
          .eq("id", id)
          .single();

        if (error && status !== 406) {
          throw error;
        }

        if (data?.username) {
          router.push({ pathname: "/[account]", query: { account: id } });
          return;
        }

let { data, error, status } = await supabase
          .from("profiles")
          .select(`username`)
          .eq("id", id)
          .single();

        if (error && status !== 406) {
          throw error;
        }

        if (data?.username) {
          router.push({ pathname: "/[account]", query: { account: id } });
          return;
        }

let { data, error, status } = await supabase
          .from("profiles")
          .select(`username`)
          .eq("id", id)
          .single();

        if (error && status !== 406) {
          throw error;
        }

        if (data?.username) {
          router.push({ pathname: "/[account]", query: { account: id } });
          return;
        }

At the [account].tsx page i'm receiving the id and making another query to 'profiles' to get user data, but this time i'm also getting the property avatar, which in my schema is defined as 'text'. But i'm receiving this error when i try to retrieve the avatar. The "4bc97434-c7a5-4a5e-a32d-e1c66a6a588e" is my user.id. After i uploaded the image to storage i retrieve it's url by getPublicUrl and updated the avatar property of the user. I don't understand what am i doing wrong here.

garyaustin•10/9/22, 3:27 PM

You don't provide much info on your tables. But seems you have an id column that is bigint and you are passing a UUID string.

TalajaxOP•10/9/22, 7:15 PM

These are my columns schema

Brandon•10/9/22, 7:42 PM

I had a similar problem, I think I solved it by deleting the "profiles" and re-creating it, selecting uuid as I created it. For some reason that worked.

Even though the schema appeared to be 100% right in the dashboard.

TalajaxOP•10/9/22, 7:46 PM

Thanks, i'll try it

TalajaxOP•10/9/22, 8:48 PM

So i created another property called avatar_url and defined it as varchar

TalajaxOP•10/9/22, 8:48 PM

And it's working apparently

Invalid input syntax for type bigint

Similar Threads

Similar Threads

Similar Threads