database error Commands

  • Resolved Jakours2

    (@jakours2)


    1 year, 2 months ago

    Hello!

    I got a lot of warning about that problem

    [04-Jan-2024 08:02:17 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SHOW FULL COLUMNS FROM cc_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 [04-Jan-2024 08:02:18 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SHOW FULL COLUMNS FROM cc_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-Jan-2024 11:08:27 UTC] WordPress database error Commands out of sync; you can’t run this command now for query UPDATE cc_options SET option_value = ‘1707044907’ WHERE option_name = ‘_transient_timeout_woocommerce_blocks_asset_api_script_data_ssl’ 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-Jan-2024 12:06:53 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SHOW FULL COLUMNS FROM cc_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-Jan-2024 14:01:57 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SHOW FULL COLUMNS FROM cc_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-Jan-2024 16:31:21 UTC] Cron unschedule event error for hook: spotlight/instagram/import_batch, Error code: could_not_set, Error message: The cron event list could not be saved., Data: {“schedule”:false,”args”:[{“source”:{“id”:”voiliervikingr”,”type”:”PERSONAL_ACCOUNT”,”data”:[]},”cursor”:”QVFIUllyVUJFOTd3SzRSNXEzT0dEQXAtLS1ES29jWDQwVXROeWFQYVgtUEtNUUVBSEN2N3NmVUc4VWJLLWNyUG14U09kN1gtZA3lzdHNCbjNDWXpBWFZApMGpn”,”count”:50,”accrual”:4}]} [06-Jan-2024 06:57:21 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SHOW FULL COLUMNS FROM cc_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

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)
  • Saif

    (@babylon1999)

    Hello @jakours2,

    Thank you for reaching out!

    I got a lot of warning about that problem

    Upon investigating, it appears that this error often occurs due to either server memory exhaustion or caching issues.

    Could you transfer your store to a staging environment and deactivate all caching plugins there? This will help confirm if the issue stems from caching problems.

    If your hosting provider doesn’t provide a staging solution, consider using a plugin like WP-Stage.

    Let us know how it goes!

    Is this now resolved or you still having issues?

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘database error Commands’ is closed to new replies.