Action Scheduler causes critical error in WC 4.0

  • Resolved volkerforster

    (@volkerforster)


    4 years, 8 months ago

    We run WC 4.0 on a staging site to make sure everything works fine, but hey, of course we didn’t try every single of the 10 million functions since this is pretty impossible…

    24 hours after updating, it still says “WooCommerce is updating the database in the background.” When checking all it says under the tab “Scheduled Actions” is “There has been a critical error on your website.”

    This is the information sent to admin:

    WordPress version 5.3.2
    Current theme: Envo Storefront (version 1.0.3) Current plugin: WooCommerce (version 4.0.0) PHP version 7.2.28

    Error Details
    =============
    An error of type E_ERROR was caused in line 740 of the file /home/univer73/public_html/universalsolder/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_wpPostStore.php. Error message: Uncaught InvalidArgumentException: Invalid action ID. No status found. in /home/univer73/public_html/universalsolder/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_wpPostStore.php:740
    Stack trace:
    #0 /home/univer73/public_html/universalsolder/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_HybridStore.php(326): ActionScheduler_wpPostStore->get_status(‘778’)
    #1 /home/univer73/public_html/universalsolder/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ListTable.php(533): ActionScheduler_HybridStore->get_status(‘778’)
    #2 /home/univer73/public_html/universalsolder/wp-content/plugins/woocommerce/packages/action-scheduler/classes/abstracts/ActionScheduler_Abstract_ListTable.php(659): ActionScheduler_ListTable->prepare_items()
    #3 /home/univer73/public_html/universalsolder/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_AdminView.php(94): ActionScheduler_Abstract

    How can this be fixed?

    Do we need to roll back to the last WC version and waiting for the next update of WC 4.0?

    Thank you.

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

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support AW a11n

    (@slash1andy)

    Automattic Happiness Engineer

    Copying from your other thread, so I can close that one.

    Sorry but it says “you can not reply to this topic” to my OWN topic, so I need to start a new one?!

    I found in the debug.log error messages regarding the action scheduler starting on March 6th.

    I uploaded the debug.log file to Google drive (zipped).

    https://drive.google.com/open?id=1Ejf-VzlucyZYMCpc7RW-uQHH8LEoBiNg

    I can’t see anything what wouldn’t work as expected in the store, but I will restore the last backup now from the time before updating to 4.0 to avoid issues with the database not being updated to the newest version.

    Any help appreciated.

    So the error message you are sending is one that I have seen in a couple cases so far.

    The ID for the action causes it to get stuck for some reason. Most often I’ve seen it set to id of 1, but in your case it’s 778.

    When I saw this, I would set that number to be something really high (30000 in my case), and then it would run and auto increment from there. You need to do this in the action scheduler actions table in your WordPress database.

    Hopefully that helps! Have a great one!

    Thread Starter volkerforster

    (@volkerforster)

    Thank you.

    I set the ID to 25000-30000 for the 3 tasks in the database, but I am not sure how this would be helpful with the problem.

    But at least I can open the tab “Scheduled Actions” without getting an error message right away. The table with the scheduled actions is empty, but it says 3 actions would be queued. Doesn’t really makes sense. If you would have finally added a function to upload an attachment without begging for getting it enabled, I would have liked to attach a screenshot. But you obviously feel saver by not allowing users to upload a picture… however.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Action Scheduler causes critical error in WC 4.0’ is closed to new replies.