When I do a search, I got an empty result even though the result shouldn't be null. I even get a null result if I don't filter anything. However fulltext search works, only facets corresponding to a field seems to not work.
I copied a production database to a test server. Everything works fine on production, but I can make the test copy works.
I've seen there is some issue with facets if the user doesn't have the permission to create temporary table. I checked that, and I think I have the permission.
Any idea ? (I use drupal commerce)