To create a filter for my site I have installed following modules Search api, Search api db, Facet api

I followed the steps mentioned in http://www.webwash.net/tutorials/intro-search-api-part-1-how-create-search-pages and http://www.webwash.net/tutorials/intro-search-api-part-2-faceted-search for creating facets.

I have created server and indexed my fields. Then I placed the Facet blocks in the particular region. But blocks are not displaying. Please Let me know what mistake I have done. Thank You

  • Have you cleared cache? Have you correctly set up the block in terms of visibility etc? Oct 14, 2015 at 8:58
  • Yes, I cleared all caches. I have set block to visible in all pages, but it is not displaying any wher @PotneySwitters
    – user50991
    Oct 14, 2015 at 9:01
  • As far as I understand it shouldn't be visible at all pages but only at /search-page Oct 14, 2015 at 9:11
  • I don't have search page how to display it in non search pages
    – user50991
    Oct 14, 2015 at 9:29
  • On admin/structure/block find the block and edit where you want it to appear. The search page is not "yours". As far as I understand and according to the tutorials you posted it is coming along with them. Oct 14, 2015 at 9:32

1 Answer 1


I experienced the same problem. I desperately seeked a solution or even a little hint on the Internet but finally I figured it out.

My problem was about the database privileges of the default mysql user (the one with credentials in the settings.php). Facet api requires Create Temporary Tables privilege to run properly. And as you can tell, my db user was not granted that privilege. Running the following commands on mysql console solved the problem:

GRANT ALL PRIVILEGES ON your_db.* TO 'your_user'@'localhost';

I hope this helps someone..