Support » Plugin: Rank Math SEO - Best SEO Plugin for WordPress » Activating Rank Math crashed my site

  • Resolved aezzell2020

    (@aezzell2020)


    The site is just a Managed WordPress staging site; hence the weird URL. And the problem I had is no longer visible, because the problem was that the site crashed when I activated Rank Math.It ran again when I disabled all the plugins, then failed again when I activated Rank Math.

    According to the admin interface, I am running WP 5.6
    According to GoDaddy, the staging site is still on WP 5.5.3 (but the production site is listed as 5.6)

    PHP version 7.3
    Theme is a child of Charitas Lite

    The following other plugins are installed
    Admin Columns
    Advanced Custom Fields (inactive)
    Charitas Lite
    CoBlocks
    Customizer Export/Import (inactive)
    Jetpack by WordPress.com
    Simple History
    Sucuri Security (free version; inactive)
    UpdraftPlus – Backup/Restore
    Yoast Duplicate Post

    Anyone have an idea why Rank Math would crash the site? I don’t recall if there was an exact server error number, but it was one of those “Oh &#@)*!” moments.

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

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

    (@rankmath)

    Hello @aezzell2020

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

    Can you please try following this troubleshooting guide and see if that helps?
    https://rankmath.com/kb/fatal-error-after-1-0-49-update/

    Looking forward to helping you.

    Thread Starter aezzell2020

    (@aezzell2020)

    The article you linked to specifically mentions this error:

    Fatal error: Uncaught RuntimeException: Error saving action: Error saving action: Table ‘dbname.prefix_wp8o_actionscheduler_actions’ doesn’t exist in /…/wp-content/plugins/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php:44

    Unfortunately, I have no idea what error caused the crash, so I hesitate to try to fix something that might not be broken.

    But I don’t have an Action Scheduler plugin installed, and it appears that the error message the article references is related to that.

    Or perhaps I’m missing something.

    Plugin Author Rank Math

    (@rankmath)

    Hello @aezzell2020

    Please try installing that plugin and see if that helps.

    Looking forward to helping you. Thank you.

    Thread Starter aezzell2020

    (@aezzell2020)

    I’m not really keen on installing a plugin just to see if it fixes a problem that we have no actual evidence is related to the plugin.

    So I turned on DEBUG and did the following
    * Disabled all plugins
    * Changed the theme to Twenty Twenty
    * Installed Rank Math

    All was fine. Then I activated Rank Math and generated the following error message:

    *****************
    WordPress database error: [Table ‘rxk543685075141.wp_3mts9mxb6a_actionscheduler_actions’ doesn’t exist]
    SELECT a.action_id FROM wp_3mts9mxb6a_actionscheduler_actions a WHERE a.hook=’action_scheduler/migration_hook’ AND a.status=’in-progress’ ORDER BY scheduled_date_gmt DESC LIMIT 1

    WordPress database error: [Table ‘rxk543685075141.wp_3mts9mxb6a_actionscheduler_actions’ doesn’t exist]
    SELECT a.action_id FROM wp_3mts9mxb6a_actionscheduler_actions a WHERE a.hook=’action_scheduler/migration_hook’ AND a.status=’pending’ ORDER BY scheduled_date_gmt ASC LIMIT 1

    WordPress database error: [Table ‘rxk543685075141.wp_3mts9mxb6a_actionscheduler_actions’ doesn’t exist]
    SELECT a.action_id FROM wp_3mts9mxb6a_actionscheduler_actions a WHERE a.hook=’action_scheduler/migration_hook’ AND a.status=’in-progress’ ORDER BY scheduled_date_gmt DESC LIMIT 1

    WordPress database error: [Table ‘rxk543685075141.wp_3mts9mxb6a_actionscheduler_actions’ doesn’t exist]
    SELECT a.action_id FROM wp_3mts9mxb6a_actionscheduler_actions a WHERE a.hook=’action_scheduler/migration_hook’ AND a.status=’pending’ ORDER BY scheduled_date_gmt ASC LIMIT 1

    WordPress database error: [Table ‘rxk543685075141.wp_3mts9mxb6a_actionscheduler_groups’ doesn’t exist]
    SELECT group_id FROM wp_3mts9mxb6a_actionscheduler_groups WHERE slug=’action-scheduler-migration’

    WordPress database error: [Table ‘rxk543685075141.wp_3mts9mxb6a_actionscheduler_groups’ doesn’t exist]
    SHOW FULL COLUMNS FROM wp_3mts9mxb6a_actionscheduler_groups

    WordPress database error: [Table ‘rxk543685075141.wp_3mts9mxb6a_actionscheduler_actions’ doesn’t exist]
    SHOW FULL COLUMNS FROM wp_3mts9mxb6a_actionscheduler_actions

    Fatal error: Uncaught RuntimeException: Error saving action: Error saving action: Table ‘rxk543685075141.wp_3mts9mxb6a_actionscheduler_actions’ doesn’t exist in /var/www/wp-content/plugins/seo-by-rank-math/vendor/woocommerce/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php:44 Stack trace: #0 /var/www/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 /var/www/wp-content/plugins/seo-by-rank-math/vendor/woocommerce/action-scheduler/classes/ActionScheduler_ActionFactory.php(177): ActionScheduler_HybridStore->save_action(Object(ActionScheduler_Action)) #2 /var/www/wp-content/plugins/seo-by-rank-math/vendor/woocommerce/action-scheduler/classes/ActionScheduler_ActionFactory.php(84): ActionScheduler_ActionFactory->store(Object(ActionScheduler_Action)) #3 /var/www/wp-content/plugins/seo-by-rank-math/vendor/woocommerce/action-scheduler/functions.p in /var/www/wp-content/plugins/seo-by-rank-math/vendor/woocommerce/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php on line 44

    There has been a critical error on this website. Please check your site admin email inbox for instructions.

    Learn more about debugging in WordPress.

    ***************

    So… is it the case the the Action Scheduler plugin is REQUIRED to run Rank Math? If that’s true, why doesn’t either the Rank Math plugin check for the presence of Action Scheduler or the documentation make it clear?

    Plugin Author Rank Math

    (@rankmath)

    Hello @aezzell2020

    Yes, please follow this guide to fix the issue:
    https://rankmath.com/kb/fatal-error-after-1-0-49-update/

    The issue is with the 3rd party library we use that is developed by WooCommerce.

    The issue is opened with their GH repo and we are waiting for a solution/fix:
    https://github.com/woocommerce/action-scheduler/issues/631

    The Action Scheduler is really good when it comes to cron jobs without straining the servers.

    We can not automate the fixing as there are several other plugins that utilize this library.

    This is most likely caused by some of your older plugins that did not remove the Action Scheduler’s tables when removing/upgrading itself and now when the Rank Math plugin is trying to create new custom tables, the process is failing. It could also be because of a conflict with one of the plugins or the theme you are using.

    Hope that helps.

    Thread Starter aezzell2020

    (@aezzell2020)

    “This is most likely caused by some of your older plugins that did not remove the Action Scheduler’s tables when removing/upgrading itself and now when the Rank Math plugin is trying to create new custom tables, the process is failing. It could also be because of a conflict with one of the plugins or the theme you are using.”

    This site used to have WooCommerce installed, but no longer does. And the site was coded by a company (an actual company that gets paid to do this stuff) that hard-coded content (content that gets updated at least yearly) into a template!!! They created a template for every main page on the website.

    So who knows what other crap they left in place.

    That being said, I don’t see any Action Scheduler tables in the database. There are, however, WooCommerce tables that shouldn’t be there because WooCommerce was removed from the staging site.

    Is there a plugin that you recommend to clean up databases? Seems to me that I’ve seen something like that.

    Plugin Author Rank Math

    (@rankmath)

    Hello @aezzell2020

    Maybe you can try the following plugin:
    https://wordpress.org/plugins/wp-optimize/

    But please do take a complete backup of your website.

    Hope that helps. Thank you.

    Thread Starter aezzell2020

    (@aezzell2020)

    Actually, I just installed and ran WP-Sweep, after doing some research on optimization plugins (and after backing everything up 😉

    That did not, however, remove the WooCommerce tables from the database. I also noticed that there are still some Rank Math tables in the database, even though I have deleted the plugin.

    Off to look up how to remove unused tables from database without breaking everything…

    Plugin Author Rank Math

    (@rankmath)

    Hello @aezzell2020

    For removing all the data related to Rank Math, please use the following filter and then delete the plugin:
    https://rankmath.com/kb/filters-hooks-api-developer/#clear-rm-data

    Hope that helps. Thank you.

    Thread Starter aezzell2020

    (@aezzell2020)

    OK – I ran WP-Sweep. Then I went into phpMyAdmin and waded through the tables, deleting everything that was left over from previously-deleted plugins (including Rank Math). Went from 81 tables to 15.

    I verified that the site was still functioning, then reinstalled Rank Math. When I activated it, the same errors crashed the site.

    I may experiment with Rank Math some other time. or some other site, but it’s clearly not working for this site, and I’m not inclined to install another plugin that I don’t need just to get this one working, when there are other options.

    Thank you for your help!

    • This reply was modified 4 months, 4 weeks ago by aezzell2020.
    Plugin Author Rank Math

    (@rankmath)

    Hello @aezzell2020

    Sorry to hear that.

    That plugin won’t be activated.

    You just need to install it, activate and it will auto-deactivate after creating the tables.

    You can safely delete that plugin after that and install the Rank Math plugin.

    Please let us know if that helps. Thank you.

    Thread Starter aezzell2020

    (@aezzell2020)

    Another bit of data:

    I just installed and activated WPForms Lite – I got similar error messages about action scheduler.

    Caldera Forms installed and activated just fine.

    Thread Starter aezzell2020

    (@aezzell2020)

    I finally broke down and did what you told me to do in the first place, downloaded and installed the Repair Action Scheduler plug, activated it, and now I have installed and activated Rank Math without crashing the site.

    Feel free to say, “I TOLD YOU SO!!!!!”

    Plugin Author Rank Math

    (@rankmath)

    Hello @aezzell2020

    Glad that helped, and sorry for the unwanted trouble.

    You can safely delete the Repair Action Scheduler plugin.

    If it isn’t too much to ask for – would you mind leaving us a review here?
    https://wordpress.org/support/plugin/seo-by-rank-math/reviews/#new-post

    It only takes a couple of minutes but helps us tremendously.

    It would mean so much to us and would go a really long way.

    Thank you.​​

Viewing 14 replies - 1 through 14 (of 14 total)
  • You must be logged in to reply to this topic.