WooCommerce / Action Scheduler

  • relearningonlinewoo · Member ·

    Hello everybody,

    I’m encountering a fatal error when trying to install either of WooCommerce and/or Action Scheduler plugins.
    The problem obviously is a missing db table. The strange thing is that for me it seems that the tables should have been created by either of the plugins during installation/activation.

    Research shows that there are several other plugins showing the same (or equal) problem. Though, no solution (such as deleting option values) worked for me.
    I’ve enabled debugging and checked the plugin files, but couldn’t find the needed created-statements for the missing tables. So I’m not able to add them manually.

    Here is the stack trace of the plugin-activation error:

    Fatal error: Uncaught mysqli_sql_exception: Table ‘dbs1923863.fm0h4ofic9actionscheduler_actions’ doesn’t exist in /homepages/34/d829690846/htdocs/clickandbuilds/WordPress/MyCMS2/wp-includes/wp-db.php:2056
    Stack trace:
    #0 /homepages/34/d829690846/htdocs/clickandbuilds/WordPress/MyCMS2/wp-includes/wp-db.php(2056): mysqli_query(Object(mysqli), ‘DESCRIBE fm0h4o…’)
    #1 /homepages/34/d829690846/htdocs/clickandbuilds/WordPress/MyCMS2/wp-includes/wp-db.php(1945): wpdb->_do_query(‘DESCRIBE fm0h4o…’)
    #2 /homepages/34/d829690846/htdocs/clickandbuilds/WordPress/MyCMS2/wp-includes/wp-db.php(2695): wpdb->query(‘DESCRIBE fm0h4o…’)
    #3 /homepages/34/d829690846/htdocs/clickandbuilds/WordPress/MyCMS2/wp-admin/includes/upgrade.php(2749): wpdb->get_results(‘DESCRIBE fm0h4o…’)
    #4 /homepages/34/d829690846/htdocs/clickandbuilds/WordPress/MyCMS2/wp-content/plugins/woocommerce/packages/action-scheduler/classes/abstracts/ActionScheduler_Abstract_Schema.php(135): dbDelta(Array)
    #5 /homepages/34/d829690846/htdocs/clickandbuilds/WordPress/MyCMS2/wp-content/plugins/woocommerce/packages/action-scheduler/classes/abstracts/ActionScheduler_Abstract_Schema.php(63): ActionScheduler_Abstract_Schema->update_table(‘actionscheduler…’)
    #6 /homepages/34/d829690846/htdocs/clickandbuilds/WordPress/MyCMS2/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php(36): ActionScheduler_Abstract_Schema->register_tables()
    #7 /homepages/34/d829690846/htdocs/clickandbuilds/WordPress/MyCMS2/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_HybridStore.php(57): ActionScheduler_DBStore->init()
    #8 /homepages/34/d829690846/htdocs/clickandbuilds/WordPress/MyCMS2/wp-content/plugins/woocommerce/packages/action-scheduler/classes/abstracts/ActionScheduler.php(158): ActionScheduler_HybridStore->init()
    #9 /homepages/34/d829690846/htdocs/clickandbuilds/WordPress/MyCMS2/wp-content/plugins/woocommerce/packages/action-scheduler/action-scheduler.php(55): ActionScheduler::init(‘/homepages/34/d…’)
    #10 /homepages/34/d829690846/htdocs/clickandbuilds/WordPress/MyCMS2/wp-content/plugins/woocommerce/packages/action-scheduler/action-scheduler.php(61): action_scheduler_initialize_3_dot_4_dot_0()
    #11 /homepages/34/d829690846/htdocs/clickandbuilds/WordPress/MyCMS2/wp-content/plugins/woocommerce/includes/class-woocommerce.php(509): include_once(‘/homepages/34/d…’)
    #12 /homepages/34/d829690846/htdocs/clickandbuilds/WordPress/MyCMS2/wp-content/plugins/woocommerce/includes/class-woocommerce.php(172): WooCommerce->includes()
    #13 /homepages/34/d829690846/htdocs/clickandbuilds/WordPress/MyCMS2/wp-content/plugins/woocommerce/includes/class-woocommerce.php(131): WooCommerce->__construct()
    #14 /homepages/34/d829690846/htdocs/clickandbuilds/WordPress/MyCMS2/wp-content/plugins/woocommerce/woocommerce.php(47): WooCommerce::instance()
    #15 /homepages/34/d829690846/htdocs/clickandbuilds/WordPress/MyCMS2/wp-content/plugins/woocommerce/woocommerce.php(62): WC()
    #16 /homepages/34/d829690846/htdocs/clickandbuilds/WordPress/MyCMS2/wp-admin/includes/plugin.php(2286): include_once(‘/homepages/34/d…’)
    #17 /homepages/34/d829690846/htdocs/clickandbuilds/WordPress/MyCMS2/wp-admin/plugins.php(191): plugin_sandbox_scrape(‘woocommerce/woo…’)
    #18 {main} thrown in /homepages/34/d829690846/htdocs/clickandbuilds/WordPress/MyCMS2/wp-includes/wp-db.php on line 2056

    Thanks a lot in advance!

    Cheers
    Gabriel

    I don’t have a site with WordPress.com yet

  • staff-heroponriki · Staff ·

    You’re posting in the free support forums for sites hosted at WordPress.com.

    Since this sounds like a WooCommerce issue, please contact WooCommerce Support about this via https://woocommerce.com/my-account/create-a-ticket/ if you have any of their paid WooCommerce products, or https://wordpress.org/support/plugin/woocommerce/ if you do not.

    Thanks!

  • relearningonlinewoo · Member ·

    Hello again,

    I solved the issue doing the following:

    • switched back (from PHP 8.1) to PHP 7.4
    • disabled WP-cache with define('WP_CACHE', false);
    • deleted WooCommerce and Action Scheduler plugins via WP-plugin page
    • downloaded Action Scheduler via link of the comment, installed and activated it. No errors now.
    • installed and activated WooCommerce via WP-plugin listing (no manual download etc.). No errors now.

    Cheers
    Gabriel

  • staff-heroponriki · Staff ·

    Hi Gabriel: Thanks for that update and for posting how you solved the problem. Hopefully this helps someone else in the future!

    Cheers!

  • The topic ‘WooCommerce / Action Scheduler’ is closed to new replies.