Return to previous page

Price filter not working - by G€n!u$ - on WordPress WooCommerce support

This topic has 7 replies, 2 voices, and was last updated 7 years, 9 months ago ago by Jack Richardson

G€n!u$

Participant

March 1, 2017 at 13:13

Hello great people of support,

I am having issues with the woocommerce price filter on the website. Can you please look what is wrong?

Unfortunately it is not working. I have turned it off now because using this filter will cause my website to go down.

When I look into PHPMyAdmin I can see the following error notification which is holding up all other querys:

###START###
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_postmeta ON ( wp_posts.ID = wp_p
###END###

Is this the right place to ask for help? If you need more information, please let me know.

Cheers,

G.

Please, contact administrator
for this information.

#155996 Copied

6 Answers

Jack Richardson

Support staff

March 3, 2017 at 11:59

Hello,

Please check if the same issue persists with default woocommerce theme Storefront.

Regards,
Jack Richardson.

#156173 Copied

G€n!u$

Participant

March 12, 2017 at 02:54

Thanks Jack. We tested it with Storefront version 2.1.8. We activated the price filter on the shop page and filtered several times. The page was able to succesfully filter products according to the price values. There was no error. The website did not go down. But I have to say that it was slow.

Are you able to look into it?

G.

#156761 Copied

G€n!u$

Participant

March 14, 2017 at 11:30

Hello,

Can you delete the url (*?max_price=1000&filter_leeftijd=7-9-jaar%2C4-6-jaar) in post #155996 (March 1, 2017 at 1:13 pm)? If someone or a bot follows this link it will slow down the website.

Thanks,

George

#156893 Copied

Jack Richardson

Support staff

March 14, 2017 at 13:39

Hello,

Try to increase the following settings:
WP Memory Limit – 500M;
PHP Time Limit 300.

Also disable unneeded 3-rd party plugins as each of them sends queries to database and can cause the problem with filtering.

Regards,
Jack Richardson.

#156900 Copied

G€n!u$

Participant

March 22, 2017 at 11:39

Many thanks for your reply. Unfortunately increasing WP Memory Limit en PHP Time Limit does not solve the real problem.

#157504 Copied

Jack Richardson

Support staff

March 23, 2017 at 13:47

Hello,

In this case you need contact your hosting provider support to check if there are issues with database when filtering products.

Regards,
Jack Richardson.

#157696 Copied
Tagged: price filter, repair, templates, wordpress woocommerce
Viewing 7 results - 1 through 7 (of 7 total)