-
Hi,
I am getting the following errors in my PHP Error Log file which is being caused by Rank Math Free plugin. Please can you let me know what I need to do to fix this?
[05-Oct-2025 08:11:39 UTC] WordPress database error Table ‘dbbll4pociycwa.gei_rank_math_analytics_gsc’ doesn’t exist for query SELECT SUM(impressions) AS impressions, SUM(clicks) AS clicks, AVG(position) AS position FROM gei_rank_math_analytics_gsc WHERE created BETWEEN ‘2025-08-30 00:00:00’ AND ‘2025-10-02 23:59:59’ made by require(‘wp-blog-header.php’), wp, WP->main, WP->parse_request, do_action_ref_array(‘parse_request’), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, RankMath\Rest\Admin->dashboard_widget_items, RankMath\Rest\Admin->do_action, do_action_ref_array(‘rank_math/dashboard/widget’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Analytics\Analytics_Common->dashboard_widget, RankMath\Analytics\Analytics_Common->get_dashboard_widget_items, RankMath\Analytics\Summary->get_widget, RankMath\Admin\Database\Query_Builder->one, RankMath\Admin\Database\Query_Builder->get_row, RankMath\Admin\Database\Query_Builder->run
[05-Oct-2025 08:11:39 UTC] WordPress database error Table ‘dbbll4pociycwa.gei_rank_math_analytics_gsc’ doesn’t exist for query SELECT SUM(impressions) AS impressions, SUM(clicks) AS clicks, AVG(position) AS position FROM gei_rank_math_analytics_gsc WHERE created BETWEEN ‘2025-07-27 00:00:00’ AND ‘2025-08-29 23:59:59’ made by require(‘wp-blog-header.php’), wp, WP->main, WP->parse_request, do_action_ref_array(‘parse_request’), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, RankMath\Rest\Admin->dashboard_widget_items, RankMath\Rest\Admin->do_action, do_action_ref_array(‘rank_math/dashboard/widget’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Analytics\Analytics_Common->dashboard_widget, RankMath\Analytics\Analytics_Common->get_dashboard_widget_items, RankMath\Analytics\Summary->get_widget, RankMath\Admin\Database\Query_Builder->one, RankMath\Admin\Database\Query_Builder->get_row, RankMath\Admin\Database\Query_Builder->run
[05-Oct-2025 08:11:39 UTC] WordPress database error Table ‘dbbll4pociycwa.gei_rank_math_analytics_gsc’ doesn’t exist for query SELECT NULLIF(COUNT(DISTINCT(query)), 0)
FROM gei_rank_math_analytics_gsc
WHERE created BETWEEN ‘2025-08-30 00:00:00’ AND ‘2025-10-02 23:59:59’ made by require(‘wp-blog-header.php’), wp, WP->main, WP->parse_request, do_action_ref_array(‘parse_request’), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, RankMath\Rest\Admin->dashboard_widget_items, RankMath\Rest\Admin->do_action, do_action_ref_array(‘rank_math/dashboard/widget’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Analytics\Analytics_Common->dashboard_widget, RankMath\Analytics\Analytics_Common->get_dashboard_widget_items, RankMath\Analytics\Summary->get_widget, RankMath\Analytics\Summary->get_keywords_summary, RankMath\Helpers\DB::get_var, RankMath\Admin\Database\Query_Builder->get_var, RankMath\Admin\Database\Query_Builder->run
[05-Oct-2025 08:11:39 UTC] WordPress database error Table ‘dbbll4pociycwa.gei_rank_math_analytics_gsc’ doesn’t exist for query SELECT NULLIF(COUNT(DISTINCT(query)), 0)
FROM gei_rank_math_analytics_gsc
WHERE created BETWEEN ‘2025-07-27 00:00:00’ AND ‘2025-08-29 23:59:59’ made by require(‘wp-blog-header.php’), wp, WP->main, WP->parse_request, do_action_ref_array(‘parse_request’), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, RankMath\Rest\Admin->dashboard_widget_items, RankMath\Rest\Admin->do_action, do_action_ref_array(‘rank_math/dashboard/widget’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Analytics\Analytics_Common->dashboard_widget, RankMath\Analytics\Analytics_Common->get_dashboard_widget_items, RankMath\Analytics\Summary->get_widget, RankMath\Analytics\Summary->get_keywords_summary, RankMath\Helpers\DB::get_var, RankMath\Admin\Database\Query_Builder->get_var, RankMath\Admin\Database\Query_Builder->runThanks
Simon
-
Hello,
We apologize for the issue you are facing with the Rank Math plugin. The errors you are seeing in your PHP Error Log indicate that the database table
gei_rank_math_analytics_gscis missing. This is likely due to a database collation issue or the table not being created properly during the installation or update of the plugin.To resolve this issue, please follow these steps:
-
Check for Missing Database Tables:
- Go to Rank Math SEO → Status & Tools → Database Tools in your WordPress dashboard.
- Look for the option Re-create Missing Database Tables and click on it. This will create any missing tables, including the one causing the error.
-
Backup Your Database: Before making any changes, it’s always a good idea to back up your database to prevent any data loss.
-
Clear Cache: After re-creating the tables, clear any cache on your site, including server-side cache if applicable.
Please note that if you had previously tracked keywords, they may not be available after re-creating the tables, and you will need to add them again to track their performance.
If these steps do not resolve the issue, please reply to this ticket with your site URL so that a human agent can assist you further.
Thank you for bringing this to our attention, and we hope this helps resolve your issue!
Sources:
Resolving Rank Math Analytics Related Issues » Rank Math -
You must be logged in to reply to this ticket.