Woocommerce 7.9.0 Action Scheduler Not Working Properly

  • Resolved kevinstan

    (@kevinstan)


    1 year, 3 months ago

    I upgraded to Woocommerce 7.9.0 the day it came out on all of my WordPress sites. The next day I woke up to find numerous errors and websites not functioning. I narrowed it down to Woocommerce and saw on all of my websites the Action Scheduler was not working and displays this: “Action Scheduler:?2?past-due actions?found; something may be wrong.?Read documentation ?“

    If I tried to make any changes or do anything on the WordPress admin screen I would then get the WordPress critical error screen. I was only able to get the websites back up by disabling all plugins, and adding them back one by one to find the problem. It came back to Woocommerce.

    After this I downloaded the 7.8.2 version of Woocommerce and installed it on all of my websites which has temporarily resolved the issue, and now I have another issue that I think is from using the old version and it causing issues in the database.

    My question is – has anyone else had this issue or having this same issue and what did you do to resolve it? I run my own hosting server and though I am very confident in my setup, is it something that I may have missed installing or enabling? I need to get this resolved to update Woocommerce and get the sites back to working again.

    Here is my current setup:

    Almalinux 8
    PHP 8.1
    Latest version of WP
    Woocommerce 7.8.2
    Action Scheduler 3.6.1
    Woocommerce Status Log errors:

    2023-08-08T00:00:20+00:00 CRITICAL Uncaught RuntimeException: Unable to claim actions. Database error. in /public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php:938 Stack trace: #0 /public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php(799): ActionScheduler_DBStore->claim_actions() #1 /public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_QueueRunner.php(157): ActionScheduler_DBStore->stake_claim() #2 /public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_QueueRunner.php(136): ActionScheduler_QueueRunner->do_batch() #3 /public_html/wp-includes/class-wp-hook.php(308): ActionScheduler_QueueRunner->run() #4 /public_html/wp-includes/class-wp-hook.php(332): WP_Hook->apply_filters() #5 /public_html/wp-includes/plugin.php(565): WP_Hook->do_action() #6 /public_html/wp-cron.php(188): do_action_ref_array() #7 {main} thrown in /public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php on line 938

    If there is anything additional I need to check please let me know. I hope someone can help me resolve this as it seems to be a very serious issue.

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

    (@babylon1999)

    Hello @kevinstan,

    Sorry for the late reply!

    The team is already aware of this bug, it’s caused by a missing column in the database.

    To fix this, simply run this WP-CLI command to rebuild the database tables: wp action-scheduler fix-schema

    Please note, your hosting providers may not allow access to the WP-CLI so you might need to get in touch with them first

    Let us know if you have more questions. :?)

    Thread Starter kevinstan

    (@kevinstan)

    Is there a way to do this without using WP-CLI ?

    Saif

    (@babylon1999)

    Is there a way to do this without using WP-CLI ?

    Most merchants that are experiencing the same issue are reporting success with the command. :?)
    If you have access to the database and a reliable backup, you can try this workaround by adding the missing column manually: https://github.com/woocommerce/action-scheduler/issues/973#issuecomment-1663531246

    Let us know if you need more help!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Woocommerce 7.9.0 Action Scheduler Not Working Properly’ is closed to new replies.