JSON type filter query works in development, but gives me "status": 500" in prod

System Information
  • Strapi Version:
  • Operating System:
  • Database:
  • Node Version:
  • NPM Version:
  • Yarn Version:

Hello all,

I am building a forum with Strapi as backend and experiencing a weird bug.
In my collection i have 1 JSON type where i perform the following successful query in development.


This line goes through all my threads and give me back the threads that have that tag. The JSON type is array with each type as string and every threads has tags, standard forum stuff.

This is working in development, but when i build the projects and start them in EC2 instance (backend Strapi + front with Next), this query returns => “status”: 500, “name”: “InternalServerError”.

Has somebody encountered this problem or has any idea where is the issue coming from? Been stuck on it for 2 days and would appreciate some pointers. Cheers

EDIT - changed from SQlite in dev to Postgres in prod

Founds the answer for the next people who have this problem…
I changed the [$contains] to [$containsi] (with added i for case sensitive) and this fixed it.