WordPress database error Table ‘dbname.wp_rank_math_analytics_objects’ doesn’

#97201
  • Resolved Koolpal
    Rank Math free

    Hi,

    I am getting the below recurring error in my local install debug.log

    [28-Oct-2020 09:22:08 UTC] WordPress database error Table ‘dbname.wp_rank_math_analytics_objects’ doesn’t exist for query SHOW FULL COLUMNS FROM wp_rank_math_analytics_objects made by edit_post, wp_update_post, wp_insert_post, do_action(‘save_post’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Analytics\Watcher->update_post_info, RankMath\Analytics\DB::update_object, RankMath\Analytics\DB::add_object, MyThemeShop\Database\Query_Builder->insert

    I have followed the steps as mentioned by you here: https://rankmath.com/kb/fatal-error-after-1-0-49-update/ however there is no change.

    As also pointed by someone else here : https://support.rankmath.com/ticket/repeated-errors-with-delete-query/#post-95408 there seems to be some mismatch in wp_rank_math_analytics_objects table vs _repair-action-scheduler script issue being pointed out as a solution.

    Can someone please check properly and then offer a solution?

    Thanks.

Viewing 9 replies - 1 through 9 (of 9 total)
  • Jitendraa
    Rank Math pro

    Hello,

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

    We might need to take a closer look at the settings. Please edit the first post on this ticket and include your WordPress logins in the designated Sensitive Data section.
    Sensitive Data Section

    It is completely secure and only our support staff has access to that section. If you want, you can use the below plugin to generate a temporary login URL to your website and share that with us instead:

    https://wordpress.org/plugins/temporary-login-without-password/

    You can use the above plugin in conjunction with the WP Security Audit Log to monitor what changes our staff might make on your website (if any):

    https://wordpress.org/plugins/wp-security-audit-log/

    Looking forward to helping you. Thank you.​​​​

    Koolpal
    Rank Math free

    Hi,

    Thanks for replying. As I mentioned, this is on my local install. I cannot share access.

    Koolpal
    Rank Math free

    Hi,

    Any update on this?

    Koolpal
    Rank Math free

    I found that version 1.0.50.1 was unusable for me due to the above error and I had to rollback to Version 1.0.48.2

    Even with Version 1.0.48.2. I get an error in my local install debug.log

    [29-Oct-2020 10:15:09 UTC] PHP Fatal error:  Uncaught Error: Class 'ActionScheduler_Lock' not found in [path]\wp-content\plugins\seo-by-rank-math\vendor\woocommerce\action-scheduler\classes\abstracts\ActionScheduler.php:29
    Stack trace:
    #0 [path]\wp-content\plugins\seo-by-rank-math\vendor\woocommerce\action-scheduler\classes\ActionScheduler_QueueRunner.php(103): ActionScheduler::lock()
    #1 [path]\wp-includes\class-wp-hook.php(287): ActionScheduler_QueueRunner->maybe_dispatch_async_request('')
    #2 [path]\wp-includes\class-wp-hook.php(311): WP_Hook->apply_filters(NULL, Array)
    #3 [path]\wp-includes\plugin.php(478): WP_Hook->do_action(Array)
    #4 [path]\wp-includes\load.php(1007): do_action('shutdown')
    #5 [internal function]: shutdown_action_hook()
    #6 {main}
      thrown in [path]\wp-content\plugins\seo-by-rank-math\vendor\woocommerce\action-scheduler\classes\abstracts\ActionScheduler.php on line 29

    This is EVEN AFTER adding the below snippet to functions.php

    add_action( 'init', function() { delete_option( 'schema-ActionScheduler_StoreSchema' ); } );

    Can someone please take a look at this issue and fix it? without adding new “improvements”??

    Michael Davis
    Rank Math pro

    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.

    1. Please follow these steps to fix the issue:
    https://rankmath.com/kb/fatal-error-after-1-0-49-update/

    2. Please follow only the first 2 steps and clear your caches. The following steps mentioned in the article are for advanced users.

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

    Please clear all the cache, including the server after following the above process.

    That should resolve the issue. Thank you.

    Hello @yourkoolpal,

    Have you tried my suggestions from the ticket you linked to in your first post? They seem to apply for your case, too.

    Basically, to fix this we’d either need access to the PhpMyAdmin on your server, or you need to make the necessary changes in the database yourself, by following my instructions in the other ticket.

    Hope that helps.

    Koolpal
    Rank Math free

    Actually guys, all I required to do was turn OFF Analytics Module and these errors went away.

    It would have been great if you had given this simple suggestion instead of such complex steps.

    Thanks

    Jitendraa
    Rank Math pro

    Hello,

    Thank you for letting us know that. We have noted this and will try to improve this in the coming days.

    Thank you.

    Koolpal
    Rank Math free

    All the best! For now I have deactivated RM and deleted it!
    Thanks

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

The ticket ‘WordPress database error Table ‘dbname.wp_rank_math_analytics_objects’ doesn’’ is closed to new replies.