ireeps

yes, this works! Thank you. ??

Hi Stef

I am still getting errors, but now I am also now getting failed credit card payments via woopayments..I am assuming they are related? We may need to turn the connection back on and continue troubleshooting.

[05-Apr-2024 07:06:30 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT option_value FROM wp_options WHERE option_name = ‘jetpack_sync_full_status’ LIMIT 1 made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\Jetpack\Sync\Sender->do_full_sync, Automattic\Jetpack\Sync\Modules\Full_Sync_Immediately->get_status, Jetpack_Options::get_raw_option
[05-Apr-2024 07:08:17 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SHOW FULL COLUMNS FROM wp_options made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Blocks\Assets\Api->update_script_data_cache, set_transient, update_option
[05-Apr-2024 07:08:17 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT option_value FROM wp_options WHERE option_name = ‘jpsq_sync_checkout’ made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\Jetpack\Sync\Sender->do_sync, Automattic\Jetpack\Sync\Dedicated_Sender::spawn_sync, Automattic\Jetpack\Sync\Queue->is_locked, Automattic\Jetpack\Sync\Queue->get_checkout_id
[05-Apr-2024 07:08:17 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT count() FROM wp_jetpack_sync_queue WHERE queue_id = ‘sync’ made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\Jetpack\Sync\Sender->do_sync, Automattic\Jetpack\Sync\Dedicated_Sender::spawn_sync, Automattic\Jetpack\Sync\Queue->size, Automattic\Jetpack\Sync\Queue\Queue_Storage_Table->get_item_count [05-Apr-2024 07:08:17 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT option_value FROM wp_options WHERE option_name = ‘jetpack_sync_full_status’ LIMIT 1 made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\Jetpack\Sync\Sender->do_full_sync, Automattic\Jetpack\Sync\Modules\Full_Sync_Immediately->get_status, Jetpack_Options::get_raw_option [05-Apr-2024 07:08:50 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SHOW FULL COLUMNS FROM wp_options made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Blocks\Assets\Api->update_script_data_cache, set_transient, update_option [05-Apr-2024 07:08:50 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT option_value FROM wp_options WHERE option_name = ‘jpsq_sync_checkout’ made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\Jetpack\Sync\Sender->do_sync, Automattic\Jetpack\Sync\Dedicated_Sender::spawn_sync, Automattic\Jetpack\Sync\Queue->is_locked, Automattic\Jetpack\Sync\Queue->get_checkout_id [05-Apr-2024 07:08:50 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT count() FROM wp_jetpack_sync_queue WHERE queue_id = ‘sync’ made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\Jetpack\Sync\Sender->do_sync, Automattic\Jetpack\Sync\Dedicated_Sender::spawn_sync, Automattic\Jetpack\Sync\Queue->size, Automattic\Jetpack\Sync\Queue\Queue_Storage_Table->get_item_count
[05-Apr-2024 07:08:50 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT option_value FROM wp_options WHERE option_name = ‘jetpack_sync_full_status’ LIMIT 1 made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\Jetpack\Sync\Sender->do_full_sync, Automattic\Jetpack\Sync\Modules\Full_Sync_Immediately->get_status, Jetpack_Options::get_raw_option

and from the woopayments log:
2024-04-05T18:35:02+00:00 INFO Sorry, you cannot access this resource. (wcpay_authorization_failure)
2024-04-05T18:37:25+00:00 INFO ENVIRONMENT: array (
‘WP_User’ => ‘Guest (non logged-in user)’,
‘HTTP_REFERER’ => ‘–‘,
‘HTTP_USER_AGENT’ => ‘Mozilla/5.0 (compatible; Googlebot/2.1; +https://www.google.com/bot.html)’,
‘REQUEST_URI’ => ‘/robots.txt’,
‘DOING_AJAX’ => false,
‘DOING_CRON’ => false,
‘WP_CLI’ => false,

I’d be happy for you to disconnect from your end and if it persists, then I will look at setting up a staging site.

Hi Mehdi.

It still happens after optimising and deleting transients.

It is a live site, so not able to turn everything off… What I’m trying to figure out is why this is happening in the first place? We don’t use jetpack, don’t have it installed, so what exactly is syncing and to where and why?

Can it just be turned off completely? From my end or your end?

Im still seeing errors unfortunately..

[27-Jan-2024 06:32:59 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT option_value FROM wp_options WHERE option_name = ‘jpsq_sync_checkout’ made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\Jetpack\Sync\Sender->do_sync, Automattic\Jetpack\Sync\Dedicated_Sender::spawn_sync, Automattic\Jetpack\Sync\Queue->is_locked, Automattic\Jetpack\Sync\Queue->get_checkout_id
[27-Jan-2024 06:32:59 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT count(*) FROM wp_jetpack_sync_queue WHERE queue_id = ‘sync’ made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\Jetpack\Sync\Sender->do_sync, Automattic\Jetpack\Sync\Dedicated_Sender::spawn_sync, Automattic\Jetpack\Sync\Queue->size, Automattic\Jetpack\Sync\Queue\Queue_Storage_Table->get_item_count
[27-Jan-2024 06:32:59 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT option_value FROM wp_options WHERE option_name = ‘jetpack_sync_full_status’ LIMIT 1 made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\Jetpack\Sync\Sender->do_full_sync, Automattic\Jetpack\Sync\Modules\Full_Sync_Immediately->get_status, Jetpack_Options::get_raw_option

I’ve just had another look, and it doesnt appear to have come back, so maybe it is sorted! ?? I’ll keep an eye on it over the next few days and report back.

I cleared the php error log this morning, and have checked it just now… I’ve had a few instances of this showing up:

[25-Jan-2024 21:57:53 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SHOW FULL COLUMNS FROM wp_options made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Blocks\Assets\Api->update_script_data_cache, set_transient, update_option
[25-Jan-2024 21:57:53 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT option_value FROM wp_options WHERE option_name = ‘jpsq_sync_checkout’ made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\Jetpack\Sync\Sender->do_sync, Automattic\Jetpack\Sync\Dedicated_Sender::spawn_sync, Automattic\Jetpack\Sync\Queue->is_locked, Automattic\Jetpack\Sync\Queue->get_checkout_id
[25-Jan-2024 21:57:53 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT count(*) FROM wp_options WHERE option_name LIKE ‘jpsq_sync-%’ made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\Jetpack\Sync\Sender->do_sync, Automattic\Jetpack\Sync\Dedicated_Sender::spawn_sync, Automattic\Jetpack\Sync\Queue->size
[25-Jan-2024 21:57:53 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT option_value FROM wp_options WHERE option_name = ‘jetpack_sync_full_status’ LIMIT 1 made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\Jetpack\Sync\Sender->do_full_sync, Automattic\Jetpack\Sync\Modules\Full_Sync_Immediately->get_status, Jetpack_Options::get_raw_option
[25-Jan-2024 21:58:00 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SHOW FULL COLUMNS FROM wp_options made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Blocks\Assets\Api->update_script_data_cache, set_transient, update_option

Yes, the site is running woocommerce.
site url is lawnaddicts.com.au

thanks

please see screenshots.

https://prnt.sc/IyD6Y4jjVIws

https://prnt.sc/bfoLUQTVAYdU

Hi CHristine.

I think I figured out why you couldnt see it. There was a js conflict after a recent theme update. I’v corrected this.

Would it be too much trouble to have another look?

Rob

Yes, it is showing here. see screenshot:

https://reepa.com/waxmelts08092020.png

Thanks Christine… the plugin is still active, and Im not sure why you coulnd’t see it.

I have this installed on 2 different sites, running 2 different themes, and have the same result.

If you could have another look, it would be most appreciated ??

Hi @christineskyverge

I have tried clearing cache.. I’m not sure if you’ve looked at the screenshot i provided here: https://reepa.com/waxmelts.png
On mobile, when first loaded, it has a horizontal bar, not the round bubble, and I am not able to duplicate this on a desktop to use the inspect tools.
If you click on the bar to open the popup, and then close, it minimises down to the round bubble that I an control using the above code.

Thanks Christine.. This isnt reflecting on my site either…
Will this work on mobile? or is it only for desktop?

It moves the bubbble and chat box on desktop, but my issue is only on mobile..

https://reepa.com/waxmelts.png

I need to move this box up

• This reply was modified 4 years, 6 months ago by ireeps.