Return to previous page

Topic: price filter not working

Tagged: price filter

G€n!u$

Participant

March 1, 2017 1:13 pm

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.

Content is visible for topic creator and
support staff only.

#155996 copied to clipboard

Like

Jack Richardson

Support staff

March 3, 2017 11:59 am

Hello,

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

Regards,
Jack Richardson.

#156173 copied to clipboard

Like

G€n!u$

Participant

March 12, 2017 2:54 am

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 to clipboard

Like

G€n!u$

Participant

March 14, 2017 11:30 am

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 to clipboard

Like

Jack Richardson

Support staff

March 14, 2017 1:39 pm

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 to clipboard

Like

G€n!u$

Participant

March 22, 2017 11:39 am

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

#157504 copied to clipboard

Like

Jack Richardson

Support staff

March 23, 2017 1:47 pm

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 to clipboard

Like