Fatal Error on Woocommerce after migration

  • Resolved johndalt

    (@johndalt)


    2 years, 9 months ago

    Hi there,

    I have a WooCommerce site and I need to migrate a clone of it to a subdomain in order to serve a specific country (India).

    I used Prime Mover for the migration and it went well, everything was working and I deactivated the non-applicable plugins. However, after a while the site crashed with a “Fatal error: Uncaught RuntimeException: Error saving action: Error saving action: INSERT command denied to user ‘xxx’@’xxx’ for table ‘wp_actionscheduler_actions'”, and highlighting the line “store(Object(ActionScheduler_Action)) in xxx/wp-content/plugins/woocommerce/packages/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php on line 44”

    This seems related to WooCommerce and any help will be appreciated. Should I ask for help on Prime Mover also?

    Thanks in advance,
    John

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

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

  • Hello,

    Can you still access to /wp-admin? If yes, can you navigate to WooCommerce > Status > Tools, and verify base database tables to see if that helps?

    Link to image: https://snipboard.io/4acOvz.jpg

    If you need us to take a closer look at your issue, 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.

    Thread Starter johndalt

    (@johndalt)

    Hi,

    Thanks for the response. Unfortunately, I do not have access to WooCommerce at all. I mean, the /wp-admin area works only when WooCommerce is de-activated. I have to rename its folder via FTP in order to de-activate it. So, I cannot “verify base database tables”, nor post a System Status.

    I read in another thread is Support about deactivating all plugins, and installing the action-scheduler plugin and I tried it. The same result, as soon as I activate it everything crashes.

    I also tried emptying the relevant DB tables and making sure their structure is intact. No results either. It seems like the activation of WooCommerce is causing this (if I may say so). WC being present but not active causes no problems.

    Hope the above makes sense. Any other ideas?
    Thanks,
    John

    Mirko P.

    (@rainfallnixfig)

    Hi @johndalt,

    Can you go to your WordPress dashboard ➛ Settings ➛ General and check if your WordPress Address (URL) and Site Address (URL) have been changed to reflect your subdomain?

    Then, can you disable all plugins and manually reinstall WooCommerce? Rename the current woocommerce folder in /wp-content/plugins/ and follow this guide to upload a fresh copy.

    Let us know how it goes.

    Thread Starter johndalt

    (@johndalt)

    Hi again,

    Thanks for the reply and apologies for the late update.

    I did as advised without success. Since I made no progress in fixing the problem, I ended up starting from scratch with a clean migration and the problem did not reappear.

    I guess this makes the thread closed. Thanks for your time,
    John

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Fatal Error on Woocommerce after migration’ is closed to new replies.