database error - Support

Resolved

CH1800

Rank Math free

Hi folks,

I recently moved an existing site from Yoast to Rankmath and I’m constantly getting similar errors when editing/saving pages or posts:

WordPress database error Table 'beebee_wp163.wpwv_rank_math_analytics_objects' doesn't exist for query SHOW FULL COLUMNS FROMwpwv_rank_math_analytics_objectsmade by edit_post, wp_update_post, wp_insert_post, do_action('save_post'), WP_Hook->do_action, WP_Hook->apply_filters, RankMathAnalyticsWatcher->update_post_info, RankMathAnalyticsDB::update_object, RankMathAnalyticsDB::add_object, MyThemeShopDatabaseQuery_Builder->insert

Is there something I can do about that?

Thanks!

Costa

PS: In fact right after posting this above I tried to save Rankmath settings again to see whether something changes and I got those in addition:

[30-Oct-2021 00:04:40 UTC] WordPress database error Table 'beebee_wp163.wpwv_rank_math_analytics_gsc' doesn't exist for query SELECT COUNT(DISTINCT(created)) AS days FROM wpwv_rank_math_analytics_gsc 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_290->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, MyThemeShopDatabaseQuery_Builder->getVar, MyThemeShopDatabaseQuery_Builder->one
[30-Oct-2021 00:04:40 UTC] WordPress database error Table 'beebee_wp163.wpwv_rank_math_analytics_gsc' doesn't exist for query SELECT COUNT(id) FROM wpwv_rank_math_analytics_gsc 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_290->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, MyThemeShopDatabaseQuery_Builder->getVar, MyThemeShopDatabaseQuery_Builder->one
[30-Oct-2021 00:04:40 UTC] WordPress database error Table 'beebee_wp163.wpwv_rank_math_analytics_gsc' doesn't exist for query SELECT COUNT(DISTINCT(created)) AS days FROM wpwv_rank_math_analytics_gsc 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_290->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, MyThemeShopDatabaseQuery_Builder->getVar, MyThemeShopDatabaseQuery_Builder->one
[30-Oct-2021 00:04:40 UTC] WordPress database error Table 'beebee_wp163.wpwv_rank_math_analytics_gsc' doesn't exist for query SELECT COUNT(id) FROM wpwv_rank_math_analytics_gsc 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_290->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, MyThemeShopDatabaseQuery_Builder->getVar, MyThemeShopDatabaseQuery_Builder->one

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

Tammy
3 years ago

Rank Math business

Hello,

Thank you for contacting Rank Math today, and we apologize for any inconvenience this may have caused.

From the error log, it seems that the database table for Analytics was not created for some reason. In this case, please head over to Rank Math > Status & Tools > Database Tools > Re-create Tables and click theRe-create Tables button

Please note that some options are only available when you enable the Advanced Mode in Rank Math. If it’s not showing, you must have chosen to use the Easy Mode. Please follow the steps in this link to switch to Advanced Mode:
https://rankmath.com/kb/advanced-mode/

Once done, clear your website’s cache and check again.

I hope this information is helpful, and please do not hesitate to contact us if you require any additional support.

Thank you.

CH1800
3 years ago

Rank Math free

Many thanks Tammy,

I did this right before your reply and updated my previous post in sensitive data section because I was not able to do so in main text and it seems to work fine again.

We had some memory issues at the host yesterday and it might be that the DB was hit somehow.

Thanks again and will get back here if the issues re-appears.

Jaideep Asrani
3 years ago

Hello,

We are glad that your issue is resolved.

Please feel free to reach out to us again in case you need any other assistance.

We are here to help.

Thank you.

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

The ticket ‘database error’ is closed to new replies.