Update to Husky v. 3.3.4.2 crashes site
The support doesn work on Saturdays and Sundays, so some Friday requests can be answered on Monday. If you have problems with registration ask help on contact us page pleaseIf you not got email within 24~36 business hours, firstly check your spam box, and if no any email from the support there - back to the forum and read answer here. DO NOT ANSWER ON EMAILS [noreply@pluginus.net] FROM THE FORUM!! Emails are just for your info, all answers should be published only here.
The support doesn work on Saturdays and Sundays, so some Friday requests can be answered on Monday.
Hi,
we are running Woof (2.2.8) on our site and it works well on our production site.
We tried updating to the current version three times and it crashes our site within 5 minutes. Since it is our live production server we could not leave it like this and had to reset to 2.2.8
We could see in our DB Monitoring that the The SQL Query trigged in get_filtered_price() is the cause of the server slowing down, leading to a complete crash, it looks like the query is trying and trying and not getting a response.
We have set: Hide Empty terms to yes and dynamic recounting to yes, we also tried, but failed with the option Optimize Price Filter to Yes.
And we do not show a price filter anyways.
We do however have a large group of attributes (20+) with some of them up to 250+ terms. We read in another thread that this might be a problem, is there a recommendation on how many terms.
And up to 30.000 unique visits a day.
We do not have the same issues on our test environment, but there's hardly any traffic.
What would be the best approach here?
thanks
M.
Hello
Please paste your license key here - https://share.pluginus.net/image/i20230222134241.png -> https://share.pluginus.net/image/i20230222134511.png
Read this - https://products-filter.com/searching-is-slow
Try in file - woocommerce-products-filter\classes\helper.php - add code - https://c2n.me/4jc57Yc.png and https://share.pluginus.net/image/i20230822123710.png and do a test
Thanks for your reply, I added the license key above.
Read this - https://products-filter.com/searching-is-slow
I have already read this article, it will not be an option for us to switch off ‘dynamic recount‘ in the filter and ‘hide empty terms‘ options, longer that for a test.
The recommended Plugins we are already using
The other suggestions we will have to try out, we need to find a time slot for this.
Thank you in advance
Hello
Have you enabled caching? - https://c2n.me/4jcuKIz.png If yes, please try it - https://products-filter.com/hook/woof_use_wp_cache
Hi Pablo,
thanks for your help, we tried some of your fixes today.
the fix you provided in your first answer helped with the problem, everything else unfortunately did not help.
How do we go on about this, because of course we can now add your fix but with every update in the future it will break again. Not updating will only be a temporary solution. Will you be working on a solution for one of your next releases?
Without looking into your code too deep, I guess your fix is a quick exit in the case that filtering via price is not used - but what would happen if the price filter would be activated?
Thanks very much.
M.
Hello
yes we will redo the request for the price so that it can be changed with a hook
but what would happen if the price filter would be activated? - then you should specify your price range