Can’t Activate – Fatal Error

  • Resolved ewyattr

    (@ewyattr)


    3 years, 2 months ago

    HI, I’m trying to activate the woocommerce plugin to a new wordpress website, but whenever I do, I get this failure message:
    ”
    Plugin could not be activated because it triggered a fatal error.
    Fatal error: Uncaught mysqli_sql_exception: Table 'magicmo1_wp200.wpdl_actionscheduler_actions' doesn't exist in /home/magicmo1/public_html/wp-includes/wp-db.php:2056 Stack trace: #0 /home/magicmo1/public_html/wp-includes/wp-db.php(2056): mysqli_query() #1 /home/magicmo1/public_html/wp-includes/wp-db.php(1945): wpdb->_do_query() #2 /home/magicmo1/public_html/wp-includes/wp-db.php(2695): wpdb->query() #3 /home/magicmo1/public_html/wp-admin/includes/upgrade.php(2749): wpdb->get_results() #4 /home/magicmo1/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/abstracts/ActionScheduler_Abstract_Schema.php(135): dbDelta() #5 /home/magicmo1/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/abstracts/ActionScheduler_Abstract_Schema.php(63): ActionScheduler_Abstract_Schema->update_table() #6 /home/magicmo1/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php(36): ActionScheduler_Abstract_Schema->register_tables() #7 /home/magicmo1/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_HybridStore.php(57): ActionScheduler_DBStore->init() #8 /home/magicmo1/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/abstracts/ActionScheduler.php(158): ActionScheduler_HybridStore->init() #9 /home/magicmo1/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/action-scheduler.php(55): ActionScheduler::init() #10 /home/magicmo1/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/action-scheduler.php(61): action_scheduler_initialize_3_dot_4_dot_0() #11 /home/magicmo1/public_html/wp-content/plugins/woocommerce/includes/class-woocommerce.php(509): include_once('/home/magicmo1/...') #12 /home/magicmo1/public_html/wp-content/plugins/woocommerce/includes/class-woocommerce.php(172): WooCommerce->includes() #13 /home/magicmo1/public_html/wp-content/plugins/woocommerce/includes/class-woocommerce.php(131): WooCommerce->__construct() #14 /home/magicmo1/public_html/wp-content/plugins/woocommerce/woocommerce.php(47): WooCommerce::instance() #15 /home/magicmo1/public_html/wp-content/plugins/woocommerce/woocommerce.php(62): WC() #16 /home/magicmo1/public_html/wp-admin/includes/plugin.php(2286): include_once('/home/magicmo1/...') #17 /home/magicmo1/public_html/wp-admin/plugins.php(191): plugin_sandbox_scrape() #18 {main} thrown in /home/magicmo1/public_html/wp-includes/wp-db.php on line 2056
    ”
    I already did a troubleshoot with my hosting purveyor and we concluded it was a plugin error. Please help.

    • This topic was modified 3 years, 2 months ago by ewyattr.

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

Viewing 5 replies - 1 through 5 (of 5 total)
  • Mirko P.

    (@rainfallnixfig)

    Hi @ewyattr,

    The fatal error is about a missing table magicmo1_wp200.wpdl_actionscheduler_actions and therefore WooCommerce core will not be able to install properly.

    The default prefix is wp_actionscheduler_actions so I guess you changed the table prefix. Which versions of PHP and MySQL database are you running?

    Could you please share a copy of your site’s System Status? You can find it via WooCommerce > Status. Select “Get system report” and then “Copy for support”. Once you’ve done that, paste it here in your response.

    Thanks.

    Thread Starter ewyattr

    (@ewyattr)

    Hi, Mirko:

    Thank you for your reply. As I mentioned originally, its a brand new wordpress website, so I haven’t changed anything about wordpress or woocommerce (I wouldn’t even know how or where to change a table prefix, I have no idea how this happened). I used Softaculous from my cPanel to install wordpress, I installed the woocommerce plugin, tried to activate it and received the aforementioned error. Here’s what versions I have:
    PHP Version 7.4.27
    MySQL Version 10.3.32-MariaDB-log-cll-lve

    I can’t share a copy of my site’s System Status as I can’t even activate the woocommerce plugin, hence, here is no “Woocommerce>status”.

    Thank you, once again.

    Mirko P.

    (@rainfallnixfig)

    Hi @ewyattr,

    Thanks for sharing your PHP and MySQL versions.

    Do you notice any improvement if you change the PHP version? This can be done by accessing the cPanel of contacting your host.

    Can you also try to upload WooCommerce via FTP under the /wp-content/plugins/ directory? You can download the plugin from this URL. Then, enable the plugin and check if it’s working.

    Take a look at the Site Health Status as well. You’ll find it under Tools > Site Health and see if there are any pointers there.

    One more thing you could do is enable debug logging in WordPress:

    Debugging in WordPress

    Let us know how that goes.

    Cheers.

    • This reply was modified 3 years, 2 months ago by Mirko P..
    Thread Starter ewyattr

    (@ewyattr)

    Hi!
    I finally resolved the issue, thank you for your support. All I needed to do was change the PHP version (it was at 8.1 and I changed it to 8.0).

    That sounds great – thanks for letting us know!

    I’ll mark this thread as resolved now. In case you have any further questions, I recommend creating a new thread. Thank you.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Can’t Activate – Fatal Error’ is closed to new replies.