skinnybloke Posted October 23 Share Posted October 23 Hi - I have a problem with the ps_layered_filter_block table continually increasing in size. The cron job runs every night but does not decrease the size of the table. The cron log shows the following: Oct 22 04:30:01 server CROND[26900]: (xxx) CMD (/usr/bin/curl --user-agent cPanel-Cron https://www.domain.com/module/ps_facetedsearch/cron?ajax=1&action=indexAttributes&token=03e88dba6a) The job truncates the table if I run it from the back office module. Does anybody have any ideas on how I can rectify this? Link to comment Share on other sites More sharing options...
Prestashop Addict Posted October 23 Share Posted October 23 Did you take a look at your logs, mays be an issue with curl execution? Link to comment Share on other sites More sharing options...
skinnybloke Posted October 23 Author Share Posted October 23 (edited) Which logs would these be? Is this the error_log in the apache2 folder? Edited October 23 by skinnybloke (see edit history) Link to comment Share on other sites More sharing options...
Prestashop Addict Posted October 23 Share Posted October 23 il y a 23 minutes, skinnybloke a dit : Is this the error_log in the apache2 folder? Yes and if well configured you should have a domain_error_log file Link to comment Share on other sites More sharing options...
skinnybloke Posted October 25 Author Share Posted October 25 There is nothing in the error_log at the time that the cron job runs. I cannot find a domain_error_log file Link to comment Share on other sites More sharing options...
skinnybloke Posted November 19 Author Share Posted November 19 I have been monitoring the SQL table ps_layered_filter_block over the last few weeks. The size of the table has been growing slowly up to 2.5mb and 180 rows (a lot slower than it did previously - maybe a version upgrade improved this). This morning it had reduced to 16k and 0 rows. Is there a level at which the corn job routine will not clear the table? Link to comment Share on other sites More sharing options...
Prestashop Addict Posted November 19 Share Posted November 19 (edited) Please can you specify PS, PHP versions Edited November 19 by Prestashop Addict (see edit history) Link to comment Share on other sites More sharing options...
skinnybloke Posted November 19 Author Share Posted November 19 PrestaShop version: 8.1.7 PHP version: 8.1.30 Faceted search: 3.16.1 Link to comment Share on other sites More sharing options...
Prestashop Addict Posted November 19 Share Posted November 19 If you execute the link in browser does ti truncate table? Link to comment Share on other sites More sharing options...
skinnybloke Posted November 19 Author Share Posted November 19 Yes. Link to comment Share on other sites More sharing options...
Prestashop Addict Posted November 19 Share Posted November 19 So you have an issue with your cron task. Link to comment Share on other sites More sharing options...
skinnybloke Posted November 19 Author Share Posted November 19 OK thanks. I'm moving to a new server next week so I will have another look then. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now