DB error

#142694
  • Resolved Alex C.

    3 years, 11 months ago

    Rank Math free

    Hello, this is about the free Rank Math SEO WP plugin. I’m getting a now recurring entry in debug.log:

    WordPress database error Table 'www-mywebsite-wp-Tm6qKxT9.wp_eb51a9edfd_rank_math_analytics_ga' doesn't exist for query SELECT COUNT(id) FROM wp_eb51a9edfd_rank_math_analytics_ga LIMIT 0, 1 made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, CMB2_Bootstrap_270->include_cmb, cmb2_bootstrap, do_action('cmb2_admin_init'), WP_Hook->do_action, WP_Hook->apply_filters, RankMathAdminOptions->register_option_page, include('/plugins/seo-by-rank-math/includes/modules/analytics/views/options.php'), RankMathAnalyticsDB::info, RankMathAnalyticsDB::get_total_rows, MyThemeShopDatabaseQuery_Builder->getVar, MyThemeShopDatabaseQuery_Builder->one

    The environment is Linux/digitalocean. Not sure why it happened, but please advise on how to fix it.

    This is the same issue as here.

    Thanks.

Viewing 10 replies - 16 through 25 (of 25 total)
1 2
  • Uzair

    3 years, 10 months ago

    Hello,

    I can see all tables created correctly from the WP Admin area but for some reason, the rank_math_analytics_ga table was not created. I logged in via wp-phpMyAdmin and created the missing table. Please check now and you should not longer be getting error logs from here on out.

    Hope that helps and please do not hesitate to let us know if you need our assistance with anything else.

    Alex C.

    3 years, 10 months ago

    Rank Math free

    can see all tables created correctly from the WP Admin area but for some reason, the rank_math_analytics_ga table was not created. I logged in via wp-phpMyAdmin and created the missing table.

    Hello, Uzair, thanks for re-checking. I see the missing table now.

    However, by just recreating the table manually, think we’re just glossing over an underlying issue with the RM code that the devs would perhaps have liked to fix. If the RM UI is saying “all tables are good”, but the back-end has still missing tables, that’s a bug right there that you guys are now missing the opportunity to fix.

    Febby

    3 years, 10 months ago

    Rank Math free

    Hello,

    Thank you for your valuable input.

    We’ve just released new updates for both Rank Math plugins which fix many issues/bugs and added many improvements as well.

    You can check out our full changelog here:
    https://rankmath.com/changelog/

    If you encounter any more issues please let us know and we’ll be more than happy to help you.

    Admin TRC

    3 years, 10 months ago

    Rank Math free

    Hi Support

    I am having the same issue with the missing table warning and have done everything you suggested in this thread and updated to your latest version.
    Still exactly the same
    Does this table need to be there even? (as your report shows Rank Math status seems to be fine).

    Cheers

    Alex C.

    3 years, 10 months ago

    Rank Math free

    Hey TRC,
    See few posts above. They just created that table manually at my DB and called it a day.

    Admin TRC

    3 years, 10 months ago

    Rank Math free

    Hi Alex

    Thanks
    Yes, they don’t seem to want to fix the root cause!
    Their latest version does not add the table on any of my other sites either.

    Do you happen to have the table format of columns and structure from phpMyAdmin that I could use to create the correct table structure please?

    Cheers

    Alex C.

    3 years, 10 months ago

    Rank Math free

    Sure, please refer here.

    Now suppose the devs have made too many changes, and trying to debug the issue with the old codebase isn’t meaningful anymore.

    Admin TRC

    3 years, 10 months ago

    Rank Math free

    Hi Alex

    Thanks very much.
    That seems to have fixed it and I now have the table ok.

    Cheers

    Uzair

    3 years, 10 months ago

    Hello,

    We have fixed this issue internally but the change is dependent on some other changes that are yet to be made to the plugin.

    Rest assured, we are on top of this and we will be releasing an update with a fix very soon.

    Thank you for your patience in the meantime.

    Rank Math

    3 years, 10 months ago

    Hello,

    Appreciate your patience.

    We have released a new update. You can check the changelog here:
    https://rankmath.com/changelog/

    Your issue should be fixed.

    If not, please let us know so we can assist you further.

    Thank you.

Viewing 10 replies - 16 through 25 (of 25 total)
1 2

You must be logged in to reply to this ticket.