Supabase returning "JSON object requested, multiple (or no) rows returned" in production (vercel)
I am using a tech stack consisting of Next.js 13 and Supabase. In local development, I can fetch the data properly; however, in production, the same query returns empty data or the error message "JSON object requested, multiple (or no) rows returned." I have double-checked environment variables and configurations, and there is nothing wrong there.
I fetch data from Supabase using Next.js's API and then use those endpoints within my frontend to hide/process sensitive data.
I've already tried integrating Vercel and Supabase, using the same variables that these services provided. I believe I have proper Row-Level Security (RLS) policies in place, as they work as intended in local development.
All the tables have similar RLS policy.
As per the RLS Policy:
- All SELECT queries have
anonandauthenticatedrules, which, according to the documentation, should be sufficient for reading data without the need for authentication. - All other types of requests are reserved for the
authenticatedrole.
The error message you are facing suggests that you are using .single() in your query, yet the query returns multiple or no rows. When you use .single() on your query, you have to make sure the query returns 1 and only 1 row. Using filters and / or limits.
- Next.js 15 API Route - “Invalid GET Export” Error in Dynamic Route [id]
- Usetranslation, next.js SSR
- using .env.local with playwright
- ESLint error saying that my react hook may be executed more than once
- Tailwind media queries don't work properly on Safari
- Values of step 2 getting duplicated in step 1 of multi step form. (NextJs, Shadcn, react-hook-form,zod)
- How to fix Next.js Vercel deployment module not found error
- BrowserRouter changing URL and not linking to page
- Locally developing NextJS and fetch getting self signed cert error
- NextJS - Most Tailwind classes work... but not all
- Can we use the action returned by useActionState outside forms?
- NextJS app router - get all query parameters in string
- TypeError: Cannot read properties of undefined (reading 'call') on Next.js
- How can I persist data in client side while using SSR in Next 14.1?
- Accessing Parameter from Dynamic Route in Next.js
- can next js api endpoint be access from other app
- React how to Pass data from component to its sub-component
- Middleware Redirection Not Working Properly
- @node_modules keeps showing in Visual Studio Code auto import and suggesions in Nextjs 15
- Microsoft clarity not working with Next js/React Js project
- How to configure next.js project with tailwindcss when module.css structure is already being used
- NextJS SyntaxError: Unexpected token 'export' on node_modules
- NextJS 15.0.2 - Failed to compile
- What is the best way to add Monetag's ads (PropellerAds) to a NextJs app
- Fetch api only works after second Enter key input NextJS
- Tailwindcss custom animation not working in Next.js
- How to set document's title per page?
- TypeError while running a database seeding script in Next.js, Prisma ORM
- tailwind styling failed to work in shadcn ui and next
- Supabase does not append code parameter to the redirect URL after OAuth login