Hello Olga,

do you have updates for me? This would be the last stone of a perfect theme :).

THANK YOU!!!

Hi Olga, the plugin authors found the problem. Would you please fix this in your next theme release? Would be great!

…
Thanks for sharing the theme files.

Okky here, support level two who will help you with this issue. Harry asked me to check this and see if there’s anything we can do.

I’ve just checked the theme and it seems they use the “posts_clauses” hooks to modify the product search query. Please keep in mind that using “posts_clauses” is not recommended to modify the query as stated in the WordPress documentation here https://codex.wordpress.org/Plugin_API/Filter_Reference/posts_clauses:

The posts_clauses filter runs before the query gets executed and is essentially the sum of all filters that run immediately before it. So it should be used if you don’t intend to let another plugin override it, or if you need to alter several different parts of the query at once.

The problem is that your theme has this code in “wp-content/themes/xstore-responsive-woocommerce-theme-wordpress-theme/xstore/framework/theme-functions.php” on line 824:

$pieces[‘join’] .= “JOIN $wpdb->postmeta on $wpdb->posts.ID = $wpdb->postmeta.post_id”;

Because it’s coded to add the JOIN query instead of replacing it, it produces multiple JOINs in the query:

JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id )JOIN wp_postmeta on wp_posts.ID = wp_postmeta.post_id

For now, I suggest to change the code to this one:

$pieces[‘join’] = “JOIN $wpdb->postmeta on $wpdb->posts.ID = $wpdb->postmeta.post_id”;

Also, please ask the theme author to use the “pre_get_posts” filter instead of the “posts_clauses” if they only need to modify the meta query.

I hope this helps 🙂

Thanks,
​Okky
— Development Team
Support

WholesaleSuite – WooCommerce plugins that help you sell to wholesale customers
…

Hi Olga,

no problem. I’m waiting for the next update.

Hi there.

Yes I know. But it would be so much nicer, if you can implement this in next theme updates. It would be only a little change in files.

BEst :-/

Problem is still there…

Hi!
Thank you. Can you tell me what did you change :)?

Best!

EDIT: And can you tell me where I can find the recommended plugin site in backend?

Problem is solved with Yoast SEO 4.6! Thread could be closed.

Some news?

I solved the plugin update problem but javascript bug is still there…

So. Some errors were gone when I deactivated the specific plugin. But the Notice over the sidebar AND within the sidebar are caused from the theme:

Notice: id wurde fehlerhaft aufgerufen. Product properties should not be accessed directly. Weitere Informationen: Debugging in WordPress (engl.) (Diese Meldung wurde in Version 3.0 hinzugefügt.) in /html/wordpress/wp-includes/functions.php on line 4137

Ok. Thank you. I will investigate.

YOu were right. Fancy product designer is causing the problems. Yeah but i wanna try and test before the site is live ;)…

Woocommerce System report says this files are out of date:
#xstore/woocommerce/checkout/form-billing.php version 2.1.2 is out of date. The core version is 3.0.0,

xstore/woocommerce/content-product.php version 2.6.1 is out of date. The core version is 3.0.0,

xstore/woocommerce/single-product/up-sells.php version 1.6.4 is out of date. The core version is 3.0.0,

Best regards,

Tobi

Thank you Olga.

Will it be fixed in upcoming theme update too?

Thanks.

Best,
Tobi