• Resolved Mick Levin

    (@mick-levin)


    After most recent update (1.0.49), site does not open anymore, both front end and back end.

    Error log contains this:

    Fatal error: Uncaught RuntimeException: Error saving action: Error saving action: Table ‘wp_actionscheduler_actions’ doesn’t exist in /home/client/public_html/wp-content/plugins/seo-by-rank-math/vendor/woocommerce/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php:44

    Stack trace:

    #0 /home/client/public_html/wp-content/plugins/seo-by-rank-math/vendor/woocommerce/action-scheduler/classes/data-stores/ActionScheduler_HybridStore.php(242): ActionScheduler_DBStoreMigrator->save_action(Object(ActionScheduler_Action), NULL)
    #1 /home/client/public_html/wp-content/plugins/seo-by-rank-math/vendor/woocommerce/action-scheduler/classes/ActionScheduler_ActionFactory.php(177): ActionScheduler_HybridStore->save_action(Object(ActionScheduler_Action))
    #2 /home/client/public_html/wp-content/plugins/seo-by-rank-math/vendor/woocommerce/action-scheduler/classes/ActionScheduler_ActionFactory.php(105): ActionScheduler_ActionFactory->store(Object(ActionScheduler_Action))
    #3 /home/client/public_ht in /home3/windros9/public_html/wp-content/plugins/seo-by-rank-math/vendor/woocommerce/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php on line 44

    Have to deactivate it via FTP to let the site go πŸ™

Viewing 10 replies - 1 through 10 (of 10 total)
  • Plugin Author Rank Math SEO

    (@rankmath)

    Hello

    Thank you for contacting the support and sorry for any inconvenience that might have been caused due to that.

    Please follow these instructions:
    https://support.rankmath.com/ticket/fatal-error-29/?view=all#post-91637

    Looking forward to helping you.

    Thread Starter Mick Levin

    (@mick-levin)

    Thank you but that was not really an acceptable solution. Please add that code into next version of your plugin and push it.

    I can not do that manual procedure on so many of clients’ websites I support.

    Looking forward for your plugin to work around this all by itself.

    Jill Caren

    (@jcarenoptonlinenet)

    This answer is 100% UNACCEPTABLE. Sites are crashing because of this and you want us to do all the work to fix it? Like Mick mentioned – you should address it ASAP and update the plugin immediately.

    Jill Caren

    (@jcarenoptonlinenet)

    And to top it off I cannot even rollback? Fantastic! I will be removing RankMath immediately. This is not OK!

    WP Rollback
    Please select which plugin version you would like to rollback to from the releases listed below. You currently have version 1.0.49 installed of Rank Math SEO.

    It appears there are no version to select. This is likely due to the plugin author not using tags for their versions and only committing new releases to the repository trunk.

    Plugin Author Rank Math SEO

    (@rankmath)

    Hello @mick-levin

    We are still trying to find an optimal way to add the fix in the plugin. Unfortunately, the fix is not an easy one, or else we would have added it to the plugin already. We are equally concerned about the issue that you guys are facing and that’s why the support team was readily available even during the weekend.

    Out of over 500,000 active installations, this issue is happening on only a handlful of installations. This is typically due to custom database tables not being created properly or where previously WooCommerce or some plugin that uses/used Action Scheduler library from WooCommerce was removed incorrectly. Not by the user, but the plugin’s code left the tables after uninstallation that now need to be removed.

    If we add the provided fix in the plugin, that might break things for all the other websites where WooCommerce is actively installed and working fine.

    On the same installation, if you try to activate WooComemrce, it will also generate the same error.

    With thats said, we are working on seeing how it could be fixed without affecting all the sites.

    We seek your understanding and patience in this matter and again, sorry for the inconevienice that might have been caused due to this.

    Hello @jcarenoptonlinenet

    Sorry for the issue you are facing.

    You can either add the following fix:
    https://support.rankmath.com/ticket/fatal-error-29/?view=all#post-91637

    or download the older version from here:
    https://downloads.wp.xz.cn/plugin/seo-by-rank-math.1.0.48.2.zip
    https://i.rankmath.com/jt5D2z

    Hope that helps.

    Thread Starter Mick Levin

    (@mick-levin)

    Hi team,

    I understand that the problem exists in the 3rd party code from Automatic and that you should not tamper with that code, but rather escalate it to them.

    But since you including that code into version 1.0.49 (vendor/woocommerce was not included into previous version) does negatively impact some of your users, then maybe you could do something about it now?

    E.g. check if the table $wpdb->actionscheduler_actions exists, before executing (including or requiring) that whole vendor code? Or do more smart checks, like

    IF table ‘$wpdb->actionscheduler_actions’ DOES NOT EXIST
    AND option ‘schema-ActionScheduler_StoreSchema’ DOES EXIST
    THEN
    DELETE option ‘schema-ActionScheduler_StoreSchema’
    END

    You did identify that these are 2 conditions are causing the fatal crash (right?). So maybe do that.

    Or at least release that as a quick fix-plugin, if you do not want to bloat your own code.

    Thank you.

    Plugin Author Rank Math SEO

    (@rankmath)

    Hello @mick-levin

    Thank you for your understanding and input.

    This issue is caused by a third-party library included in Rank Math. We have contacted its authors and we’re working together to find a solution for this.

    In the meantime, you have the following options:

    Before doing any action, we recommend taking a backup of your database.

    A. Turn off the Analytics module in Rank Math. That should stop the records from getting added to the table. You can also empty (truncate) those actionscheduler tables to free up space.

    B. You can try our Repair Action Scheduler plugin that can fix this issue automatically on most sites: https://github.com/rankmath/_repair-action-scheduler On the Github page we linked, click on the green “Code” button and then on “Download ZIP”. Then upload that zip file to your site on this admin page: Plugins > Add New > Upload Plugin. Once you activate the plugin, it should do its thing and then deactivate itself automatically. Then you should be able to use Rank Math without any issue.
    https://i.rankmath.com/tH8ACK

    Also, we are pro-actively available on our website’s forums for any support queries. Feel free to reach out there if there’s anything urgent.

    Hope that helps. Thank you.

    Thread Starter Mick Levin

    (@mick-levin)

    Thank you for the option B. Will try it.

    And the option A won’t work, since Analytics mode did not exist in previous version, while new version enables it automatically. Dead loop.

    Maybe your emergency plugin also could do some update_option to make Analytics mode “already” disabled, ahead of 1.0.49 update?

    Sincerely,
    Mick

    Thread Starter Mick Levin

    (@mick-levin)

    Thank you team, the option B worked.

    FYI: got this message upon activation:

    The Repair Action Scheduler process is complete. The following actions have been performed:

    Created table: actionscheduler_actions
    Created table: actionscheduler_claims
    Created table: actionscheduler_groups
    Created table: actionscheduler_logs

    The Repair Action Scheduler plugin has been automatically deactivated.

    Plugin Author Rank Math SEO

    (@rankmath)

    Hello @mick-levin

    Glad that helped.

    We have created a KB on our website explaining the steps:
    https://rankmath.com/kb/fatal-error-after-1-0-49-update/

    Apprecaite your patience and understanding in this matter.

    Thank you.

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

The topic ‘WordPress crash after update 1.0.49’ is closed to new replies.