After updating woocommerce to version 4 FATAL ERROR

  • Resolved chrisbklein

    (@chrisbklein)


    4 years, 12 months ago

    When updating Woocommerce to 4.0 fatal error.

    WooCommerce database update
    WooCommerce is updating the database in the background. The database update process may take a little while, so please be patient. View progress →

    When I click on View progress I get the following.
    There has been a critical error on your website. Please check your site admin email inbox for instructions.

    After running WordPress repair I get the following.
    bavi_actionscheduler_logs: Table ‘baviator.bavi_actionscheduler_logs’ doesn’t exist.

    The bavi_actionscheduler_logs table is not okay. It is reporting the following error: Table ‘baviator.bavi_actionscheduler_logs’ doesn’t exist. WordPress will attempt to repair this table…
    Failed to repair the bavi_actionscheduler_logs table. Error: Table ‘baviator.bavi_actionscheduler_logs’ doesn’t exist

    Any idea how I can fix this?

    Chris

    PS:
    ERROR LOG
    020-03-13T01:26:34+00:00 CRITICAL Uncaught InvalidArgumentException: Invalid action ID. No status found. in /volume1/web/baviator/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_wpPostStore.php:740
    Stack trace:
    #0 /volume1/web/baviator/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_HybridStore.php(326): ActionScheduler_wpPostStore->get_status(‘110’)
    #1 /volume1/web/baviator/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ListTable.php(533): ActionScheduler_HybridStore->get_status(‘110’)
    #2 /volume1/web/baviator/wp-content/plugins/woocommerce/packages/action-scheduler/classes/abstracts/ActionScheduler_Abstract_ListTable.php(659): ActionScheduler_ListTable->prepare_items()
    #3 /volume1/web/baviator/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_AdminView.php(94): ActionScheduler_Abstract_ListTable->display_page()
    #4 /volume1/web/baviator/wp-includes/class-wp-hook.php(288): ActionScheduler_A in /volume1/web/baviator/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_wpPostStore.php on line 740

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

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

  • I was struggling all day with this. I decided to just install my site backup from yesterday. I am working fine now. I suggest you role it back and wait for the developers to fix this problem.

    I am facing non-responsive error with my site after installing 4.0.0, how can i downgrade woocommerce version?

    Have the same issue – Anyone found an answer to this yet?

    Same issue after updating to 4.0. Log full of errors for missing some tables

    Same issue here after updating to 4.0

    Here’s how I fixed the issue today:

    1) I manually deleted the actionscheduler tables (if they exist)

    2) I installed the Action Scheduler plugin downloaded from Github and activated it (https://github.com/woocommerce/action-scheduler)

    3) In the admin I went to Woocommerce > Status > Scheduled Actions and received a notice saying the Action Scheduler tables were being re-created. I then disabled the Action Scheduler plugin.

    4) I went to Woocommerce > Status > Tools and clicked on Update Database

    Now when I go to Woocommerce > Status > Scheduled Actions there are no errors, and the actions there have a status of Complete

    @1stwebdesigns

    Thanks for your solution, it’s working for me like a charm.

    Thank you so much again.

    Plugin Support Yuki K a11n.

    (@yukikatayama)

    Automattic Happiness Engineer

    @1stwebdesigns thanks for providing that fix. This is a known issue and will be fixed in WC 4.0.1. In the meantime, uploading the stand alone Action Scheduler plugin version 3.1.3 has the fix. If you site is otherwise working as normal, you are welcome to wait until the WC 4.0.1 release which should be out soon.

    My issue is with the woocommerce database update on March 14, 2020. It’s not a fatal error issue, rather after updating the database which seemed to be an automatic request while in the backed of the woocommerce plugin, the website is now having display issues.

    The text in the Site Search bar overlaps after a search is performed. Same issue in various places on the website that have to do with woocommerce. I am using Elementor page builder and any pages that have a product widgets are now messed up as well because those pages are not longer editable or accessible. I get the message page content does not exist. Or if I am able to open a page, the product widgets within the page are all cropped, so you only see a portion of the widget.

    I have spent days of trial and error, restoring the site from Sitegrounds and restoring parts of the website to finally narrow down that it is the wordpress database that has gotten messed up right after the database update by woocommerce. Unfortunately, if I restore the site back to the March 13 backup, before the woocommere database update, it fixes the problem, but I’ve got 5 days of manual edits to make.

    Anyone have a simple solution?

    Meanwhile I will keep trying to fix this.

    Plugin Support Yuki K a11n.

    (@yukikatayama)

    Automattic Happiness Engineer

    hi @parhamm,

    As your inquiry is a different issue, please open a new thread.

    In the meantime, I’d recommend doing a theme and plugin conflict test.

    After many days of wrangling with this; I stumbled on this post. Thank you so much – it absolutely worked for me!

Viewing 11 replies - 1 through 11 (of 11 total)
  • The topic ‘After updating woocommerce to version 4 FATAL ERROR’ is closed to new replies.