Site crashed after plugin update

  • Resolved mikolajek

    (@mikolajek)


    4 years, 9 months ago

    I’ve just updated WP Mail SMTP to 2.1.1 version and my site wouldn’t load. I’ve got the automated WP email with the following error details:

    An error of type E_ERROR was caused in line 44 of the file .../wp-content/plugins/wp-mail-smtp/vendor/woocommerce/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php. Error message: Uncaught RuntimeException: Error saving action: Error saving action: Table 'db100044355.wp_actionscheduler_actions' doesn't exist in .../wp-content/plugins/wp-mail-smtp/vendor/woocommerce/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php:44
Stack trace:
#0 .../wp-content/plugins/wp-mail-smtp/vendor/woocommerce/action-scheduler/classes/data-stores/ActionScheduler_HybridStore.php(242): ActionScheduler_DBStoreMigrator->save_action(Object(ActionScheduler_Action), NULL)
#1 .../wp-content/plugins/wp-mail-smtp/vendor/woocommerce/action-scheduler/classes/ActionScheduler_ActionFactory.php(177): ActionScheduler_HybridStore->save_action(Object(ActionScheduler_Action))
#2 .../wp-content/plugins/wp-mail-smtp/vendor/woocommerce/action-scheduler/classes/ActionScheduler_ActionFactory.php(84): ActionScheduler_ActionFactory->store(Object(ActionScheduler_Action))
#3 .../wp-content/plugins/wp-mail-smtp/vendor/woocommerce/action-scheduler/functions.php(36): ActionS

    I’ve renamed the plugin folder and the site is up. I’d like to fully recover though. Anyone can help please?

    • This topic was modified 4 years, 9 months ago by mikolajek.
Viewing 12 replies - 1 through 12 (of 12 total)

  • @mikolajek,

    Bingo! We’re having the same issue with V2.1.1. Reported in another post. Let’s hope our WP Moderators won’t delete my post as it confirms the issue lies with the plugin, not the users.

    Cheers!

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    @jetxpert You’ve been asked many times not to “me, too” on posts. I’ll give you this one, but please stop with the “I have the same problem” posts. If you have a problem, open a topic. If you have a solution, post it. But not “me, too.”. Thank you.

    [personal note to moderators redacted]

    @mikolajek,

    Click here for similar issue and potential solution.

    Cheers!

    Thread Starter mikolajek

    (@mikolajek)

    Thanks @jetxpert! However in my case, I can’t bring up the site at all with the plugin active. I’ve restored the prior plugin version from my backup, but I have no clue how to proceed.

    I’d appreciate the developer to comment on the error message. I haven’t deleted any table in the database, so possibly they have not been created at all during the update. But why? And how should I proceed to have a working solution?

    Plugin Author Gregor Capuder

    (@capuderg)

    Hi @mikolajek,

    I’m sorry you had bad experience with our plugin.

    Some WP sites fail to create the database tables needed and so we prepared this troubleshooting article that should help you out. Please read it and follow the steps. Since you already have access to your WP dashboard with the backup you restored, you can skip step #1 and some parts of step #4.

    Please let us know how it goes.

    Take care!

    Thread Starter mikolajek

    (@mikolajek)

    Thank you, @capuderg for the article! I’ve followed its advice but unfortunately with no luck. Effectively, I sought support from my hosting company. Now I’m puzzled as they confirmed the site functions correctly and all privileges on the database are as needed. Somehow the plugin (inc. the other one mentioned in the troubleshooting note) refuses to create tables. It looks then it’s an isolated case, specific for my site. I’ll need to seek some qualified WP magician help.

    Plugin Author Gregor Capuder

    (@capuderg)

    Hi @mikolajek,

    there must be something causing this issue, the database must not like something and refuses to create the DB tables.

    Could you please contact your hosting support and ask them, if they can enable Database logs for your site, so you could see any failed queries if they come into the DB. Once that is enabled try the steps suggested in the article above again and view the DB logs. There should be something about wp_actionscheduler_actions table…

    Let us know how it goes.

    Take care!

    Hi @mikolajek,

    In case it helps, we wrote an article to fix the issue with Action Scheduler missing database tables: https://wpmailsmtp.com/docs/how-to-troubleshoot-action-scheduler-issues-wp-mail-smtp-2-1-1/

    I hope that helps!

    Thread Starter mikolajek

    (@mikolajek)

    Thank you, @sanzeeb3! It looks I have some database issue with my provider. They claim my WP instance has all the necessary rights to create/update tables, but it’s clearly not true, as those tables needed here cannot be created. I hope they will resolve it, as it seems not to be the plugin issue.

    Hi @sanzeeb3
    I tried to follow the different steps of your useful article but when we tried to activate Action Scheduler Plugin, our website crashed again.

    The error messages mentionned the actionscheduler tables

    Could you please help us ?
    Thanks !

    Hi @laurentpicq,

    Thanks for the details! The issue is possibly because of some unusual database configuration. Please contact your web host with the error details. They might be able to help with the issue of creating database tables.

    I hope this helps!

    @sanzeeb3

    My lead developper resolved this critical issue. It was due to the Action Scheduler plugin that was not on my website and it was mandatory to use your plugin. We had to install, activate Action Scheduler plugin and create the needed tables manually.

    • This reply was modified 4 years, 8 months ago by laurentpicq.
Viewing 12 replies - 1 through 12 (of 12 total)
  • The topic ‘Site crashed after plugin update’ is closed to new replies.