-
After updating the plugin to version 1.0.49, my website was showing database error. Somehow I have managed to retrieve my site using the previous backup files, I am afraid if updating the plugin could jeopardise my wedsite. Kindly advice a solution.
After retrieving an older version of my website my am getting the following error:
-
Im getting the following error:
WordPress database error: [Table ‘u565088716_ECR.wp_actionscheduler_actions’ doesn’t exist]
SELECT a.action_id FROM wp_actionscheduler_actions a WHERE a.hook=’action_scheduler/migration_hook’ AND a.status=’in-progress’ ORDER BY scheduled_date_gmt DESC LIMIT 1WordPress database error: [Table ‘u565088716_ECR.wp_actionscheduler_actions’ doesn’t exist]
SELECT a.action_id FROM wp_actionscheduler_actions a WHERE a.hook=’action_scheduler/migration_hook’ AND a.status=’pending’ ORDER BY scheduled_date_gmt ASC LIMIT 1WordPress database error: [Table ‘u565088716_ECR.wp_actionscheduler_actions’ doesn’t exist]
SELECT a.action_id FROM wp_actionscheduler_actions a WHERE a.hook=’action_scheduler/migration_hook’ AND a.status=’in-progress’ ORDER BY scheduled_date_gmt DESC LIMIT 1WordPress database error: [Table ‘u565088716_ECR.wp_actionscheduler_actions’ doesn’t exist]
SELECT a.action_id FROM wp_actionscheduler_actions a WHERE a.hook=’action_scheduler/migration_hook’ AND a.status=’pending’ ORDER BY scheduled_date_gmt ASC LIMIT 1WordPress database error: [Table ‘u565088716_ECR.wp_actionscheduler_groups’ doesn’t exist]
SELECT group_id FROM wp_actionscheduler_groups WHERE slug=’action-scheduler-migration’WordPress database error: [Table ‘u565088716_ECR.wp_actionscheduler_groups’ doesn’t exist]
SHOW FULL COLUMNS FROMwp_actionscheduler_groups
WordPress database error: [Table ‘u565088716_ECR.wp_actionscheduler_actions’ doesn’t exist]
SHOW FULL COLUMNS FROMwp_actionscheduler_actions
Fatal error: Uncaught RuntimeException: Error saving action: Error saving action: Table ‘u565088716_ECR.wp_actionscheduler_actions’ doesn’t exist in /home/u565088716/domains/electricalclassroom.com/public_html/wp-content/plugins/seo-by-rank-math/vendor/woocommerce/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php:44 Stack trace: #0 /home/u565088716/domains/electricalclassroom.com/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/u565088716/domains/electricalclassroom.com/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/u565088716/domains/electricalclassroom.com/public_html/wp-content/plugins/seo-by-rank-math/vendor/woocommerce/action-scheduler/classes/ActionS in /home/u565088716/domains/electricalclassroom.com/public_html/wp-content/plugins/seo-by-rank-math/vendor/woocommerce/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php on line 44There has been a critical error on your website.
Learn more about debugging in WordPress.
Hello,
Sorry for any inconvenience that might have been caused due to that.
It seems like new tables are not getting created in the Database or some old plugin has left an incorrect entry.
Please follow these steps to fix the issue:
1. Take a complete backup of your website
2. Install this plugin: https://wordpress.org/plugins/code-snippets/
3. Head over to the Snippets menu in the left sidebar and click Add New
add new snippet
4. Give that post any name and copy the below code in the Code fieldadd_action( 'init', function() { delete_option( 'schema-ActionScheduler_StoreSchema' ); } );
5. Select ‘Only run in administration area’ option and click the Save and Activate button
run only in admin area wordpress
6. Open WordPress Dashboard in a new window
7. Then deactivate recently created snippet from here
disable snippet
8. Then activate the Rank Math plugin again
9. Please disable the Code Snippets plugin if you are not going to use itHere’s a video screencast:
https://i.rankmath.com/79gPbvPlease clear all the cache, including the server after following the above process.
That should resolve the issue. Thank you.
- This reply was modified 4 years, 2 months ago by Jitendraa.
Thank you for your response. Issue solved.
Hello,
We are super happy that this resolved your issue.
If you do have another question in the future, please feel free to create a new forum topic, and it will be our pleasure to assist you again.
Thank you.
The ticket ‘Update1.0.49 bug’ is closed to new replies.