PHP errors

  • Resolved GhostMaster

    (@ghostmaster)


    1 year, 7 months ago

    Hi, im getting php errors with jetpack. at first i thinked it was the php memory and was increased to 512MB, them i disabled the cache plugin and still have the issue, it’s related to something else.

    [29-Apr-2023 06:46:24 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
    [29-Apr-2023 06:46:24 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 [29-Apr-2023 06:46:24 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 [29-Apr-2023 16:11:04 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 [29-Apr-2023 16:11:04 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
    [29-Apr-2023 16:11:04 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

Viewing 3 replies - 1 through 3 (of 3 total)

  • What exactly were you trying to do on the site, or with Jetpack, when the error appeared?

    MySQL gives a “Commands out of sync” error when the client sends a new query before reading all of the data from a previous query. It’s not necessarily Jetpack that’s making a query and not reading all the data, but there’s no way to tell from the data you’ve shared here.
    ?
    Since all the traces quoted here are happening during a shutdown handler, it may be that some code somewhere is triggering an exit in the middle of reading data from the database.

    I’d recommend deactivating all plugins except Jetpack, and activating a default theme like Twenty Twenty-Two, and checking if the error remains after that.

    If you need more help after that, please post your site URL here so that we can have a look.

    If you want it to remain private, you can also contact us via this contact form. If you choose to reach out directly, please include a link to this thread.

    Thanks!

    Thread Starter GhostMaster

    (@ghostmaster)

    Thanks for the advice, i will try to test this better, ive disabled some plugins so that may help too.

    Plugin Support Jay

    (@bluejay77)

    @ghostmaster,

    I’m glad to hear that!

    For now, I’m marking this topic as resolved. But if you have any further questions or need some more help, you’re welcome to reply here or open another thread.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘PHP errors’ is closed to new replies.