Upgrade to 4.3.0 causing errors

  • Resolved whcp10

    (@whcp10)


    5 years, 10 months ago

    Hi all

    Following auto update to Woocommerce version 4.3.0, a customer’s site back end is failing to load and the auto recovery option being commenced. Rolling back to 4.2.2 did work for a while, but despite trying to block auto updates using plugins, the site keeps encountering the error after a 4.3.0 update. Now, restoring backups or rolling back to 4.2.2 is not working either so I have had to disable Woocommerce to get the front and back end working, but without Woocommerce functionality. I was on php 7.1 but upgraded to 7.4, linux server with mysql 10.3.20-MariaDB

    Is this something that can be easily rectified with a database repair or similar?

    Many thanks

    The error message was:
    An error of type E_ERROR was caused in line 75 of the file /home/sitename/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php. Error message: Uncaught RuntimeException: Error saving action: Table ‘sitename_wp818.wpdr_actionscheduler_actions’ doesn’t exist in /home/sitename/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php:75 Stack trace: #0 /home/sitename/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(177): ActionScheduler_DBStore->save_action(Object(ActionScheduler_Action)) #1 /home/sitename/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(105): ActionScheduler_ActionFactory->store(Object(ActionScheduler_Action)) #2 /home/sitename/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/functions.php(54): ActionScheduler_ActionFactory->recurring(‘woocommerce_cle…’, Array, false, 86400, ”) #3 /home/sitename/public_html/wp-content/plugins/woocommerce/packages/woocommerce-blocks/src/Installer.php(129): as_schedule_re

Viewing 5 replies - 1 through 5 (of 5 total)
  • Phil

    (@fullysupportedphil)

    Automattic Happiness Engineer

    5 years, 10 months ago

    It looks like the required tables in your database for Action Scheduler don’t exist.

    Can you please try installing the dedicated Action Scheduler from here:
    https://github.com/woocommerce/action-scheduler/releases/tag/3.1.6

    Once you do, try going to WooCommerce > Status > Tools > Scheduled Actions. You’ll likely see a notice that the tables are scheduled for creation.

    Once the creation of the tables has finished, that should resolve the above error.

    Thread Starter whcp10

    (@whcp10)

    5 years, 10 months ago

    Thank you for the swift response Phil, much appreciated.

    So I downloaded the zip Action Scheduler 3.1.6 to Mac, compressed into zip again and uploaded as a plugin from the site… which promptly went into recovery mode with the following error on activation. A table that it is expecting to find is not there? Thanks so much for the assistance:

    An error of type E_ERROR was caused in line 44 of the file /home/sitename/public_html/wp-content/plugins/action-scheduler-3.1.6/classes/migration/ActionScheduler_DBStoreMigrator.php. Error message: Uncaught RuntimeException: Error saving action: Error saving action: Table ‘sitetable_wp818.wpdr_actionscheduler_actions’ doesn’t exist in /home/sitename/public_html/wp-content/plugins/action-scheduler-3.1.6/classes/migration/ActionScheduler_DBStoreMigrator.php:44 Stack trace: #0 /home/sitename/public_html/wp-content/plugins/action-scheduler-3.1.6/classes/data-stores/ActionScheduler_HybridStore.php(242): ActionScheduler_DBStoreMigrator->save_action(Object(ActionScheduler_Action), NULL) #1 /home/sitename/public_html/wp-content/plugins/action-scheduler-3.1.6/classes/ActionScheduler_ActionFactory.php(177): ActionScheduler_HybridStore->save_action(Object(ActionScheduler_Action)) #2 /home/sitename/public_html/wp-content/plugins/action-scheduler-3.1.6/classes/ActionScheduler_ActionFactory.php(84): ActionScheduler_ActionFactory->store(Object(ActionScheduler_Action)) #3 /home/sitename/public_html/wp-content/plugins/action-scheduler-3.1.6/functions.php(36): ActionScheduler_ActionFactory->s

    Volume 1

    (@ahuggup86)

    5 years, 10 months ago

    I’m receiving the same error. This has been an issue for at least a week now for me. This post and responsive was the last hope I thought that would have helped. I installed the action scheduler plugin and its the same thing. It now throws critical error. I disabled my plugins directory to get back into my “dashboard” and then rename the plugin directory back to original. I am stuck and I can’t get a functioning shop up with this.

    Phil

    (@fullysupportedphil)

    Automattic Happiness Engineer

    5 years, 10 months ago

    @whcp10 I’m sorry to hear that didn’t help.

    It sounds like something is preventing these tables from being created. That could be a permission or configuration issue on your site. I can’t say for certain simply from these posts.

    The two recommendations I can give on here to possible help would be:

    – Remove WooCommerce by FTP and then reinstall

    or

    – Have a developer manually create the missing tables

    With either option you will want to make sure you have a full file and database backup first.

    Running that type of database query is something that should be done by someone comfortable and knowledgable of WordPress and WooCommerce database structure. Even in those situations, it’s important to remember that a full site and database backup should be done first.

    Due to the unique nature of that type of query, I’m not able to provide a query for you. However, a skilled developer shouldn’t have an issue.

    If you need to find a developer, I recommend checking sites like http://www.codeabe.io.

    Plugin Support Tseten a11n

    (@tibetanitech)

    5 years, 9 months ago

    We haven’t heard back from you in a while, so I’m going to mark this as resolved – if you have any further questions, you can start a new thread.

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

The topic ‘Upgrade to 4.3.0 causing errors’ is closed to new replies.