Error changing order state

  • Resolved plfiumi

    (@plfiumi)


    3 years, 1 month ago

    Hi, I’m getting the following error once I change an order state from “processing” to “completed”:

    [08-May-2023 20:43:22 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SHOW FULL COLUMNS FROM wp_actionscheduler_groups made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, wc_webhook_execute_queue, WC_Action_Queue->add, WC_Action_Queue->schedule_single, as_schedule_single_action, ActionScheduler_ActionFactory->single_unique, ActionScheduler_ActionFactory->store, ActionScheduler_DBStore->save_action, ActionScheduler_DBStore->save_action_to_db, ActionScheduler_DBStore->get_group_id, ActionScheduler_DBStore->create_group
    [08-May-2023 20:43:22 UTC] WordPress database error Commands out of sync; you can’t run this command now for query
    INSERT INTO wp_actionscheduler_actions ( hook, status, scheduled_date_gmt, scheduled_date_local, schedule, group_id, args )
    SELECT ‘woocommerce_deliver_webhook_async’, ‘pending’, ‘2023-05-08 20:43:22’, ‘2023-05-08 20:43:22’, ‘O:30:\”ActionScheduler_SimpleSchedule\”:2:{s:22:\”\0*\0scheduled_timestamp\”;i:1683578602;s:41:\”\0ActionScheduler_SimpleSchedule\0timestamp\”;i:1683578602;}’, 0, ‘{\”webhook_id\”:4,\”arg\”:15717}’ FROM DUAL
    WHERE ( SELECT NULL FROM DUAL ) IS NULL made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, wc_webhook_execute_queue, WC_Action_Queue->add, WC_Action_Queue->schedule_single, as_schedule_single_action, ActionScheduler_ActionFactory->single_unique, ActionScheduler_ActionFactory->store, ActionScheduler_DBStore->save_action, ActionScheduler_DBStore->save_action_to_db
    [08-May-2023 20:43:22 UTC] PHP Fatal error: Uncaught RuntimeException: Error saving action: Commands out of sync; you can’t run this command now in /data/wwwroot/laboratoriotabor.com.ar/wp-content/plugins/mailchimp-for-woocommerce/includes/vendor/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php:118
    Stack trace:

    0 /data/wwwroot/laboratoriotabor.com.ar/wp-content/plugins/mailchimp-for-woocommerce/includes/vendor/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php(62): ActionScheduler_DBStore->save_action_to_db()

    1 /data/wwwroot/laboratoriotabor.com.ar/wp-content/plugins/mailchimp-for-woocommerce/includes/vendor/action-scheduler/classes/ActionScheduler_ActionFactory.php(244): ActionScheduler_DBStore->save_action()

    2 /data/wwwroot/laboratoriotabor.com.ar/wp-content/plugins/mailchimp-for-woocommerce/includes/vendor/action-scheduler/classes/ActionScheduler_ActionFactory.php(114): ActionScheduler_ActionFactory->store()

    3 /data/wwwroot/laboratoriotabor.com.ar/wp-content/plugins/mailchimp-for-woocommerce/includes/vendor/action-s in /data/wwwroot/laboratoriotabor.com.ar/wp-content/plugins/mailchimp-for-woocommerce/includes/vendor/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php on line 118

    Any clue?

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

Viewing 1 replies (of 1 total)
  • Plugin Support khungate

    (@khungate)

    3 years ago

    Hi @plfiumi,

    Thanks for reaching out. I’m sorry to hear that you’re experiencing this error.

    The error message “Commands out of sync; you can’t run this command now” indicates that there is a problem with the database. This could be caused by a number of things, such as a plugin conflict, a corrupt database, or a hardware failure.

    To troubleshoot this issue, I would recommend the following steps:

    1. Check for plugin conflicts. Disable all plugins except for WooCommerce and Mailchimp for WooCommerce. If the error goes away, then you know that one of your plugins is causing the problem. Enable plugins one by one until you find the culprit.
    2. Repair the database. If you’re using a hosting provider that offers a database management tool, you can use it to repair the database. If not, you can use a WordPress database repair plugin.

    If you’re still having trouble after trying these steps, I’d recommend getting in touch with the folks over at Automattic who support the Action Scheduler library since the specific error points to the ActionScheduler_DBStore.php file. They may be able to assist you further.

    I hope this helps!

Viewing 1 replies (of 1 total)

The topic ‘Error changing order state’ is closed to new replies.