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)

  • Well, I think the obvious issue is that there is something different between production and testing ... it's likely the index server (I assume it's search api and/or solr powered faceting) is not available. Are you seeing index errors? What are you using to index your data? Have you tried flushing the index on the non-production server?
    – joshmiller
    Feb 2, 2016 at 21:45
  • I've cleared the index, rebuilt it, the index tables are correct, but that doesn't seem to be enough. I'm using the basic sql backeng.
    – mb14
    Feb 2, 2016 at 21:47
  • Would need a full export of the view + search api setup to debug. You're right, if all is perfect, it should work. It's even more mysterious that it works in one environment, but not the other. Leads me to think the issue is outside of Drupal. Perhaps an older MySQL or too limited of a setup. Do you see any errors in your logs that would help you point to a problem?
    – joshmiller
    Feb 4, 2016 at 13:47
  • I'm using docker (one container for apache and one for mysql and there are exactly the same between the two environment). I'm happy to add some trace and do some debugging but I don't how where to start
    – mb14
    Feb 4, 2016 at 18:22

1 Answer 1


The problem was due to different behavior between mysql 5.6 and 5.7. I thought I had the same environment between production and test but I was wrong. I use a docker image for mysql but didn't specify a version so I ended up with two different versions on the two systems, even though the provisioning looked the same.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.