This guide helps you troubleshoot an issue with the CMS Prestashop, specifically with its “Faceted search” module, which manages filters on product category pages.

The problem

This specific Prestashop search module creates a database cache to speed up searches, however, the corresponding table is never cleared, which poses a problem for the hosting infrastructure.

First solution

The first solution is to disable the caching feature.

To do this:

1. In the PrestaShop administration panel, go to Modules → Module Manager.
2. Select Modules and use the search field to find “facet”.
3. Click on Configure next to the module found:
   
4. Disable this button:
   

Second solution

The second solution is to set up a cron job to clean the table, for example, every evening:

1. From the module settings, copy the existing URL from the Clear cache button:
   

Then, from the Infomaniak Manager, create a webcron (refer to this other guide for more information) to execute the URL copied in step 1 above, for example once a day and at night.