© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•4y ago•
10 replies
Nin

Getting status code 406 with maybeSingle when returning 0 rows

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


Code:
const [wishlist] = createResource(
    () =>
      from('wishlists')
        .select('uuid, name, description, wishlist_items!inner(*)')
        .maybeSingle() as any,
  )
const [wishlist] = createResource(
    () =>
      from('wishlists')
        .select('uuid, name, description, wishlist_items!inner(*)')
        .maybeSingle() as any,
  )
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

How to use .maybeSingle() with .returns()?
SupabaseSSupabase / help-and-questions
3y ago
Why is Supabase giving me an error about returning 0 rows?
SupabaseSSupabase / help-and-questions
3y ago
Getting CHANNEL_ERROR status
SupabaseSSupabase / help-and-questions
4y ago
[RESOLVED - user caused] Signing with magic link is failing - API Gateway returning status code 500
SupabaseSSupabase / help-and-questions
4mo ago