Catch 406 errors when fetching with .single() returns no result

[jonohewitt]

I'm trying to set up a function to check if a user has a username:

    const getUsername = async () => {
      let username: string = null
      try {
        const { data, error } = await supabase
          .from("public_user_info")
          .select("username")
          .eq("user_id", supabase.auth.user().id)
          .single()

        if (error) throw error
        if (data) username = data.username
      } catch (error) {
        // handle error
      }
      return username
    }

Despite this catch statement, if the user doesn't have a username yet, I get a 406 Not Acceptable error in the console:

details: "Results contain 0 rows, application/vnd.pgrst.object+json requires 1 row",
message: "JSON object requested, multiple (or no) rows returned"

Is it possible to catch this error and prevent it showing in the console? Thanks!

[inian]

HI @jonohewitt, I don't think the library itself prints errors to the console. Do you have a error logging setup which does this?

[HORACINIS]

Thanks @Psaw19 that maybeSingle() did the trick for me!

[MateoWartelle]

Thanks @Psaw19

[dadashvespek]

thanks! @Psaw19

[salimdellali]

mayeSingle() did the trick for me too, thank's @Psaw19

I had this table public.accounts (with RLS enabled) that maps 1 to 1 with auth.users (public.accounts has a column called user_id which is a foreign key referencing id in auth.users). I have this state in my system where when a user signs up, supabase automatically inserts a record into auth.users (but not in public.accounts), then the user is invited to fill in his account information, it is then where a new row is inserted into public.accounts

So when I do

const { data, error } = await supabase
        .from("accounts")
        .select("*")

the resulted data is either:

• an empty array [] (a.k.a no account associated to the authenticated user (yet))
• an array of 1 and only 1 account object, containing the account information associated with the authenticated user

so appending maybeSingle() after the .select("*") resulted in data be either:

• null if no account is associated to the authenticated user
• an account object with information associated with the authenticated user

[joepolask86]

thanks my issue was the same and it got resolved when i used maybeSingle() instead of single()

This will did the job for me.