Peter Sejersen

OK.

So correct format is?
– Tracking ID = xxxxxxxx-x
– Client ID = xxxxxxxx

I have just updated the plugin and tested everything. It works as a charm – even on WP Engine.

Thank you so much for pursuing this and fixing it.

I will try and check with WP Engine, since I can’t do anything about this myself.

However, I still find it hard to believe that the bug is at their end, since everything else on my site and all other plugins run fine. And that the old version of your plugin (2.1.5) also works fine.

But of course it’s also hard for you to check if you cannot reproduce the error.

Nope. I use Codestyling Localization https://wordpress.org/plugins/codestyling-localization/

Here’s the result

[02-Oct-2014 15:37:26 UTC] LONG QUERY (1083 characters long generated in /nas/wp/www/cluster-10111/vinhit/wp-content/plugins/woocommerce/includes/class-wc-cart.php:464):
							SELECT SUM( order_item_meta.meta_value ) AS held_qty

							FROM wp_vinhitposts AS posts

							LEFT JOIN wp_vinhitwoocommerce_order_items as order_items ON posts.ID = order_items.order_id
							LEFT JOIN wp_vinhitwoocommerce_order_itemmeta as order_item_meta ON order_items.order_item_id = order_item_meta.order_item_id
							LEFT JOIN wp_vinhitwoocommerce_order_itemmeta as order_item_meta2 ON order_items.order_item_id = order_item_meta2.order_item_id
							LEFT JOIN wp_vinhitterm_relationships AS rel ON posts.ID=rel.object_ID
							LEFT JOIN wp_vinhitterm_taxonomy AS tax USING( term_taxonomy_id )
							LEFT JOIN wp_vinhitterms AS term USING( term_id )

							WHERE 	order_item_meta.meta_key   = '_qty'
							AND 	order_item_meta2.meta_key  = '_product_id' AND order_item_meta2.meta_value  = 2002
							AND 	posts.post_type            = 'shop_order'
							AND 	posts.post_status          = 'publish'
							AND 	tax.taxonomy               = 'shop_order_status'
							AND		term.slug			       IN ('pending')
							AND		posts.ID                   != 0

[02-Oct-2014 15:37:32 UTC] LONG QUERY (1083 characters long generated in /nas/wp/www/cluster-10111/vinhit/wp-content/plugins/woocommerce/includes/class-wc-cart.php:464):
							SELECT SUM( order_item_meta.meta_value ) AS held_qty

							FROM wp_vinhitposts AS posts

							LEFT JOIN wp_vinhitwoocommerce_order_items as order_items ON posts.ID = order_items.order_id
							LEFT JOIN wp_vinhitwoocommerce_order_itemmeta as order_item_meta ON order_items.order_item_id = order_item_meta.order_item_id
							LEFT JOIN wp_vinhitwoocommerce_order_itemmeta as order_item_meta2 ON order_items.order_item_id = order_item_meta2.order_item_id
							LEFT JOIN wp_vinhitterm_relationships AS rel ON posts.ID=rel.object_ID
							LEFT JOIN wp_vinhitterm_taxonomy AS tax USING( term_taxonomy_id )
							LEFT JOIN wp_vinhitterms AS term USING( term_id )

							WHERE 	order_item_meta.meta_key   = '_qty'
							AND 	order_item_meta2.meta_key  = '_product_id' AND order_item_meta2.meta_value  = 2002
							AND 	posts.post_type            = 'shop_order'
							AND 	posts.post_status          = 'publish'
							AND 	tax.taxonomy               = 'shop_order_status'
							AND		term.slug			       IN ('pending')
							AND		posts.ID                   != 0

[02-Oct-2014 15:37:33 UTC] LONG QUERY (1676 characters long generated in /nas/wp/www/cluster-10111/vinhit/wp-content/plugins/woocommerce/includes/class-wc-tax.php:305):
				SELECT * FROM (
					SELECT tax_rates.* FROM
						wp_vinhitwoocommerce_tax_rates as tax_rates
					LEFT OUTER JOIN
						wp_vinhitwoocommerce_tax_rate_locations as locations ON tax_rates.tax_rate_id = locations.tax_rate_id
					LEFT OUTER JOIN
						wp_vinhitwoocommerce_tax_rate_locations as locations2 ON tax_rates.tax_rate_id = locations2.tax_rate_id
					WHERE
						tax_rate_country IN ( 'DK', '' )
						AND tax_rate_state IN ( '', '' )
						AND tax_rate_class = ''
						AND
						(
							(
								locations.location_type IS NULL
							)
							OR
							(
								locations.location_type = 'postcode'
								AND locations.location_code IN ('*','8240','824*','82*','8*','*')
								AND locations2.location_type = 'city'
								AND locations2.location_code = 'RISSKOV'
							)
							OR
							(
								locations.location_type = 'postcode'
								AND locations.location_code IN ('*','8240','824*','82*','8*','*')
								AND 0 = (
									SELECT COUNT(*) FROM wp_vinhitwoocommerce_tax_rate_locations as sublocations
									WHERE sublocations.location_type = 'city'
									AND sublocations.tax_rate_id = tax_rates.tax_rate_id
								)
							)
							OR
							(
								locations.location_type = 'city'
								AND locations.location_code = 'RISSKOV'
								AND 0 = (
									SELECT COUNT(*) FROM wp_vinhitwoocommerce_tax_rate_locations as sublocations
									WHERE sublocations.location_type = 'postcode'
									AND sublocations.tax_rate_id = tax_rates.tax_rate_id
								)
							)
						)
					GROUP BY
						tax_rate_id
					ORDER BY
						tax_rate_priority, tax_rate_order
				) as ordered_taxes
				GROUP BY
					tax_rate_priority

[02-Oct-2014 15:37:38 UTC] LONG QUERY (1083 characters long generated in /nas/wp/www/cluster-10111/vinhit/wp-content/plugins/woocommerce/includes/class-wc-cart.php:464):
							SELECT SUM( order_item_meta.meta_value ) AS held_qty

							FROM wp_vinhitposts AS posts

							LEFT JOIN wp_vinhitwoocommerce_order_items as order_items ON posts.ID = order_items.order_id
							LEFT JOIN wp_vinhitwoocommerce_order_itemmeta as order_item_meta ON order_items.order_item_id = order_item_meta.order_item_id
							LEFT JOIN wp_vinhitwoocommerce_order_itemmeta as order_item_meta2 ON order_items.order_item_id = order_item_meta2.order_item_id
							LEFT JOIN wp_vinhitterm_relationships AS rel ON posts.ID=rel.object_ID
							LEFT JOIN wp_vinhitterm_taxonomy AS tax USING( term_taxonomy_id )
							LEFT JOIN wp_vinhitterms AS term USING( term_id )

							WHERE 	order_item_meta.meta_key   = '_qty'
							AND 	order_item_meta2.meta_key  = '_product_id' AND order_item_meta2.meta_value  = 2002
							AND 	posts.post_type            = 'shop_order'
							AND 	posts.post_status          = 'publish'
							AND 	tax.taxonomy               = 'shop_order_status'
							AND		term.slug			       IN ('pending')
							AND		posts.ID                   != 0

[02-Oct-2014 15:37:38 UTC] PHP Notice:  Undefined index: woo_nonce in /nas/wp/www/cluster-10111/vinhit/wp-content/themes/canvas/functions/classes/class-wf-meta.php on line 144