Update1.0.49 bug

#92190
  • Resolved Osbert Joel
    Rank Math pro

    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:

Viewing 4 replies - 1 through 4 (of 4 total)
  • 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 1

    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=’pending’ ORDER BY scheduled_date_gmt ASC LIMIT 1

    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 1

    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=’pending’ ORDER BY scheduled_date_gmt ASC LIMIT 1

    WordPress 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 FROM wp_actionscheduler_groups

    WordPress database error: [Table ‘u565088716_ECR.wp_actionscheduler_actions’ doesn’t exist]
    SHOW FULL COLUMNS FROM wp_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 44

    There 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 field

    add_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 it

    Here’s a video screencast:
    https://i.rankmath.com/79gPbv

    Please 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, 1 month ago by Jitendraa.

    Thank you for your response. Issue solved.

    Sajid Khan
    Rank Math business

    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.

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

The ticket ‘Update1.0.49 bug’ is closed to new replies.