Table ‘db.wp_rank_math_analytics_ga’ doesn’t exist

Resolved Nazar Hotsa
(@bugnumber9)

5 years, 4 months ago

Hello,

I’m seeing the following error in the logs every now and then:

WordPress database error Table 'db.wp_rank_math_analytics_ga' doesn't exist for query SELECT COUNT(id) FROM wp_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, RankMath\Admin\Options->register_option_page, include('/plugins/seo-by-rank-math/includes/modules/analytics/views/options.php'), RankMath\Analytics\DB::info, RankMath\Analytics\DB::get_total_rows, MyThemeShop\Database\Query_Builder->getVar, MyThemeShop\Database\Query_Builder->one, QM_DB->query

Indeed, there’s no wp_rank_math_analytics_ga table in the database. I also used “Re-create Missing Database Tables” tool, but it didn’t create that table.
Any idea what and where is wrong?

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

Plugin Author Rank Math SEO
(@rankmath)

5 years, 4 months ago

Hello @bugnumber9,

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

Assuming you are using the latest version of all the plugins, themes & WordPress, can you please confirm with your hosting provider if the user has the admin privileges to create tables?

Looking forward to helping you.

Thread Starter Nazar Hotsa
(@bugnumber9)

5 years, 4 months ago

Yep, everything is up to date. And yes, DB user can create tables.

Thread Starter Nazar Hotsa
(@bugnumber9)

5 years, 4 months ago

Hey @rankmath,

I’ve been looking around in plugin code and found the following.

1. There’s a function rank_math_1_0_50_delete_analytic_tables() that drops the table rank_math_analytics_ga

2. The function create_tables() which is fired in Installer class has no mention of rank_math_analytics_ga table.

Both finding above make me think that rank_math_analytics_ga is a legacy table and shouldn’t be used.

However, this table is being used in several functions of DB class and is also mentioned in System_Status class.

So yeah, something is definitely wrong here 🙂 Even given one simple thing: there’s no create table statement for rank_math_analytics_ga table anywhere in plugin code.

Thanks

Plugin Author Rank Math SEO
(@rankmath)

5 years, 4 months ago

Hi @bugnumber9

Thank you for looking into this. It seems that you’re right, the rank_math_analytics_ga table shouldn’t be used in the code. We will investigate this on our end and possibly fix it in an upcoming update.

Thanks again for bringing this issue to our attention. If there’s anything else, please let us know.

skiluk
(@skiluk)

5 years, 4 months ago

I am experiencing this same issue. Any update?

WordPress database error Table ‘db.wp_rank_math_analytics_ga’ doesn’t exist for query SELECT COUNT(id) FROM wp_rank_math_analytics_ga LIMIT 0, 1 /* From [/wp-admin/admin-ajax.php] in [/wp-content/plugins/seo-by-rank-math/vendor/mythemeshop/wordpress-helpers/src/database/class-query-builder.php:104] */ 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, RankMath\\Admin\\Options->register_option_page, include(‘/plugins/seo-by-rank-math/includes/modules/analytics/views/options.php’), RankMath\\Analytics\\DB::info, RankMath\\Analytics\\DB::get_total_rows, MyThemeShop\\Database\\Query_Builder->getVar, MyThemeShop\\Database\\Query_Builder->one

Plugin Author Rank Math SEO
(@rankmath)

5 years, 4 months ago

Hello @skiluk

While we look into it, can you please try to generate the tables manually by following this video screencast?
https://i.rankmath.com/pL4ZQq

and please check after a few minutes if you are still seeing the error.

Looking forward to helping you. Thank you.

skiluk
(@skiluk)

5 years, 4 months ago

Hi, still have the same issue. The table it is looking for is ‘wp_rank_math_analytics_ga’

Plugin Author Rank Math SEO
(@rankmath)

5 years, 4 months ago

Hello @skiluk

We have fixed the issue internally and an update will be released soon.

As soon as the update is released, we will let you know.

In the meantime, if there’s anything else we can help you with, please let us know.

We are here to assist. Thank you.

Plugin Author Rank Math SEO
(@rankmath)

5 years, 3 months ago

Hello @bugnumber9 & @skiluk

Thank you for your patience.

We have released, 1.0.58

That should remove the warning. Hope that helps. If there’s anything else we can help you with, please let us know. We are here to assist.

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

The topic ‘Table ‘db.wp_rank_math_analytics_ga’ doesn’t exist’ is closed to new replies.