When order status change cant open any product on frontpage as loged in admin
-
Hey, after update our site to last version we got strange SQL error that effects only loged in users. When order arrive or change we got 20-40s till products page loaded on frontend as loged in user. After 5 minutes no problem at all
as guest there is no problem. It seems like SQL get 2 reguest for order or order change. any idea? we test all the plugins, and cant found any good reasons for that.
# Time: 220222 11:45:55
# User@Host: haloknau_wp1492[haloknau_wp1492] @ localhost []
# Thread_id: 5681490 Schema: haloknau_wp1492 QC_hit: No
# Query_time: 26.486191 Lock_time: 0.000100 Rows_sent: 149 Rows_examined: 9471855
# Rows_affected: 0 Bytes_sent: 1459
SET timestamp=1645526755;
SELECT im.meta_value FROM knauffposts AS p
INNER JOIN knauffpostmeta AS pm ON p.ID = pm.post_id
INNER JOIN knauffwoocommerce_order_items AS i ON p.ID = i.order_id
INNER JOIN knauffwoocommerce_order_itemmeta AS im ON i.order_item_id = im.order_item_id
WHERE p.post_status IN ( ‘wc-processing’,’wc-completed’ )
AND pm.meta_key IN ( ‘_billing_email’, ‘_customer_user’ )
AND im.meta_key IN ( ‘_product_id’, ‘_variation_id’ )
AND im.meta_value != 0
AND pm.meta_value IN ( ‘104’,’groznik.rok@gmail.com’ );
# User@Host: haloknau_wp1492[haloknau_wp1492] @ localhost []
# Thread_id: 5681462 Schema: haloknau_wp1492 QC_hit: No
# Query_time: 28.947830 Lock_time: 0.000116 Rows_sent: 149 Rows_examined: 9471855
# Rows_affected: 0 Bytes_sent: 1459
SET timestamp=1645526755;
SELECT im.meta_value FROM knauffposts AS p
INNER JOIN knauffpostmeta AS pm ON p.ID = pm.post_id
INNER JOIN knauffwoocommerce_order_items AS i ON p.ID = i.order_id
INNER JOIN knauffwoocommerce_order_itemmeta AS im ON i.order_item_id = im.order_item_id
WHERE p.post_status IN ( ‘wc-processing’,’wc-completed’ )
AND pm.meta_key IN ( ‘_billing_email’, ‘_customer_user’ )
AND im.meta_key IN ( ‘_product_id’, ‘_variation_id’ )
AND im.meta_value != 0
AND pm.meta_value IN ( ‘104’,’groznik.rok@gmail.com’ );
# Time: 220222 11:46:08
# User@Host: haloknau_wp1492[haloknau_wp1492] @ localhost []
# Thread_id: 5681628 Schema: haloknau_wp1492 QC_hit: No
# Query_time: 27.789360 Lock_time: 0.000082 Rows_sent: 149 Rows_examined: 9471855
# Rows_affected: 0 Bytes_sent: 1459
SET timestamp=1645526768;
SELECT im.meta_value FROM knauffposts AS p
INNER JOIN knauffpostmeta AS pm ON p.ID = pm.post_id
INNER JOIN knauffwoocommerce_order_items AS i ON p.ID = i.order_id
INNER JOIN knauffwoocommerce_order_itemmeta AS im ON i.order_item_id = im.order_item_id
WHERE p.post_status IN ( ‘wc-processing’,’wc-completed’ )
AND pm.meta_key IN ( ‘_billing_email’, ‘_customer_user’ )
AND im.meta_key IN ( ‘_product_id’, ‘_variation_id’ )
AND im.meta_value != 0
AND pm.meta_value IN ( ‘104’,’groznik.rok@gmail.com’ );The page I need help with: [log in to see the link]
-
Hi @haloknauf!
Thank you for sending the System Status!
I can see that your WordPress version is out of date. It is recommended you update it to the latest version (5.9.1).
”)
Since you recently made an update, I think a conflict between WooCommerce and your theme or another plugin you have installed on your site might be occurring.
To be sure of this, please perform a full conflict test by temporarily switching your theme back to Storefront, disabling all plugins except WooCommerce, and then check again if the issue persists. If that solves it, then re-enable all plugins one-by-one, until you find the one creating the conflict.
If you cannot perform a conflict test on your live site, we recommend creating a staging site using the WP Staging plugin.
You can find a more detailed explanation on how to do a conflict test here: https://docs.woocommerce.com/document/how-to-test-for-conflicts/.
Let us know how that goes for you!
”)
- The topic ‘When order status change cant open any product on frontpage as loged in admin’ is closed to new replies.
