An error of type E_ERROR was caused in line 44

  • Resolved skyhristov

    (@skyhristov)


    3 years, 12 months ago

    Hi everyone! It’s been a while now since I’ve been trying to debug a recent problem with the WooCommerce plugin that came up on my website which went live recently. The problem happens when I try to activate WooCommerce. Before I post the error I just want to mention that I’ve done a VERY good amount of googling, I spoke to GoDaddy to make sure that it’s not a problem on their side and although they were very helpful, it indeed was out of their hands. Then I started disabling all Plugins I have and re-enabling one by one and as such I ended up disabling every single one. Ultimately, WooCommerce was the only one I left activated, it was the one causing the problem without any other plugin being in conflict with it. That being said here is what I get when I try to Activate WooCommerce: An error of type E_ERROR was caused in line 44 of the file /var/www/wp-content/plugins/woocommerce/packages/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php. Error message: Uncaught RuntimeException: Error saving action: Error saving action: Table 'ozx644101486711.wp_3ft6atbc0k_actionscheduler_actions' doesn't exist in /var/www/wp-content/plugins/woocommerce/packages/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php:44 Stack trace: #0 /var/www/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_HybridStore.php(242): ActionScheduler_DBStoreMigrator->save_action(Object(ActionScheduler_Action), NULL) #1 /var/www/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(177): ActionScheduler_HybridStore->save_action(Object(ActionScheduler_Action)) #2 /var/www/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(84): ActionScheduler_ActionFactory->store(Object(ActionScheduler_Action)) #3 /var/www/wp-content/plugins/woocommerce/packages/action-scheduler/functions.php(36): ActionScheduler_ActionFactory->single('action_schedule...', Array,

    My last guess ought to be that the plugin doesn’t have ALTER or CREATE capabilities granted but this is a really rough guess. When I first developed my Website, it was on Laragon (Local Virtual Environment for those who might not know) and all was well there. Any support is much appreciated!

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

  • This issue is documented on Action Scheduler github page and related to an internal DB migration and missing table.

    The is a solution in the issue thread

    https://github.com/woocommerce/action-scheduler/issues/631

    In most of the single installations, all the tables were present, but for some reason, value for this option schema-ActionScheduler_StoreSchema was not updating to the latest AS version, so we asked our users to use this onetime code:

    add_action( 'init', function() { delete_option( 'schema-ActionScheduler_StoreSchema' ); } );

    You can but this snippet in your theme’s functions.php, visit the site, and delete it when the error has gone

    Thread Starter skyhristov

    (@skyhristov)

    Thank you very much @alanfuller! That indeed solved the problem. In all honesty, I did not consider investigating the ActionScheduler Github page directly. I thought it was a straight WooCommerce problem. I will try to be more curious in the future!

    Yes it is not obvious that ActionScheduler is a separate module as they put in in /packages rather than the more traditional /vendors.

    I have a slight head start with these things having built plugins that are not woo related that use ActionScheduler package

    • This reply was modified 3 years, 12 months ago by Alan Fuller.
Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘An error of type E_ERROR was caused in line 44’ is closed to new replies.