Errors in the logs of my site. - Support

Resolved

Rank Math free

I use the free version of the Rank Math SEO plugin on my website.
I noticed that there were errors in the logs of my site:

[28-Dec-2020 21:11:50 UTC] WordPress database error Table 'boatexd_expo.wp_rank_math_analytics_gsc' doesn't exist for query SELECT DISTINCT DATE_FORMAT( created,'%Y-%m-%d') as date, SUM(impressions) AS impressions, SUM(clicks) AS clicks, AVG(position) AS position, AVG(ctr) AS ctr FROM wp_rank_math_analytics_gsc WHERE created BETWEEN '2020-11-20 00:00:01' AND '2020-12-25 23:59:59' GROUP BY WEEK(created) ORDER BY created 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\Analytics\Rest->get_dashboard, RankMath\Analytics\Summary->get_analytics_summary, RankMath\Analytics\Summary->get_keywords_summary, RankMath\Analytics\Summary->get_analytics_summary_graph, MyThemeShop\Database\Query_Builder->get
[28-Dec-2020 21:11:50 UTC] WordPress database error Table 'boatexd_expo.wp_rank_math_analytics_gsc' doesn't exist for query SELECT DATE_FORMAT( created, '%Y-%m-%d') as date, ROUND(AVG(keywords),0) as keywords
			 FROM (
			    SELECT created, count(DISTINCT(query)) AS keywords
				FROM wp_rank_math_analytics_gsc
				WHERE created BETWEEN '2020-11-20 00:00:01' AND '2020-12-25 23:59:59'
			    GROUP BY created
			) as ka
			GROUP BY WEEK(created) 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\Analytics\Rest->get_dashboard, RankMath\Analytics\Summary->get_analytics_summary, RankMath\Analytics\Summary->get_keywords_summary, RankMath\Analytics\Summary->get_analytics_summary_graph
[28-Dec-2020 21:11:50 UTC] WordPress database error Table 'boatexd_expo.wp_rank_math_analytics_gsc' doesn't exist for query SELECT DISTINCT DATE_FORMAT( created,'%Y-%m-%d') as date, SUM(impressions) AS impressions, SUM(clicks) AS clicks, AVG(position) AS position, AVG(ctr) AS ctr FROM wp_rank_math_analytics_gsc WHERE created BETWEEN '2020-11-20 00:00:01' AND '2020-12-25 23:59:59' GROUP BY WEEK(created) ORDER BY created 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\Analytics\Rest->get_dashboard, RankMath\Analytics\Summary->get_analytics_summary, RankMath\Analytics\Summary->get_analytics_summary_graph, MyThemeShop\Database\Query_Builder->get
[28-Dec-2020 21:11:50 UTC] WordPress database error Table 'boatexd_expo.wp_rank_math_analytics_gsc' doesn't exist for query SELECT DATE_FORMAT( created, '%Y-%m-%d') as date, ROUND(AVG(keywords),0) as keywords
			 FROM (
			    SELECT created, count(DISTINCT(query)) AS keywords
				FROM wp_rank_math_analytics_gsc
				WHERE created BETWEEN '2020-11-20 00:00:01' AND '2020-12-25 23:59:59'
			    GROUP BY created
			) as ka
			GROUP BY WEEK(created) 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\Analytics\Rest->get_dashboard, RankMath\Analytics\Summary->get_analytics_summary, RankMath\Analytics\Summary->get_analytics_summary_graph
[28-Dec-2020 21:11:50 UTC] WordPress database error Table 'boatexd_expo.wp_rank_math_analytics_gsc' doesn't exist for query SELECT query, ROUND( AVG(position), 0 ) as position FROM wp_rank_math_analytics_gsc WHERE created BETWEEN '2020-11-20 00:00:01' AND '2020-12-25 23:59:59' GROUP BY query 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\Analytics\Rest->get_keywords_overview, RankMath\Analytics\Keywords->get_top_keywords
[28-Dec-2020 21:11:50 UTC] WordPress database error Table 'boatexd_expo.wp_rank_math_analytics_gsc' doesn't exist for query SELECT query, ROUND( AVG(position), 0 ) as position FROM wp_rank_math_analytics_gsc WHERE created BETWEEN '2020-10-15 00:00:01' AND '2020-11-19 23:59:59' GROUP BY query 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\Analytics\Rest->get_keywords_overview, RankMath\Analytics\Keywords->get_top_keywords
[28-Dec-2020 21:11:50 UTC] WordPress database error Table 'boatexd_expo.wp_rank_math_analytics_objects' doesn't exist for query SELECT COUNT(object_id) AS count FROM wp_rank_math_analytics_objects WHERE is_indexable = 1 AND seo_score BETWEEN 81 AND 100 LIMIT 0, 1 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\Analytics\Rest->get_dashboard, RankMath\Analytics\Summary->get_optimization_summary, MyThemeShop\Database\Query_Builder->getVar, MyThemeShop\Database\Query_Builder->one
[28-Dec-2020 21:11:50 UTC] WordPress database error Table 'boatexd_expo.wp_rank_math_analytics_objects' doesn't exist for query SELECT COUNT(object_id) AS count FROM wp_rank_math_analytics_objects WHERE is_indexable = 1 AND seo_score BETWEEN 51 AND 80 LIMIT 0, 1 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\Analytics\Rest->get_dashboard, RankMath\Analytics\Summary->get_optimization_summary, MyThemeShop\Database\Query_Builder->getVar, MyThemeShop\Database\Query_Builder->one
[28-Dec-2020 21:11:50 UTC] WordPress database error Table 'boatexd_expo.wp_rank_math_analytics_objects' doesn't exist for query SELECT COUNT(object_id) AS count FROM wp_rank_math_analytics_objects WHERE is_indexable = 1 AND seo_score BETWEEN 1 AND 50 LIMIT 0, 1 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\Analytics\Rest->get_dashboard, RankMath\Analytics\Summary->get_optimization_summary, MyThemeShop\Database\Query_Builder->getVar, MyThemeShop\Database\Query_Builder->one
[28-Dec-2020 21:11:50 UTC] WordPress database error Table 'boatexd_expo.wp_rank_math_analytics_objects' doesn't exist for query SELECT COUNT(object_id) AS count FROM wp_rank_math_analytics_objects WHERE is_indexable = 1 AND seo_score = 0 LIMIT 0, 1 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\Analytics\Rest->get_dashboard, RankMath\Analytics\Summary->get_optimization_summary, MyThemeShop\Database\Query_Builder->getVar, MyThemeShop\Database\Query_Builder->one
[28-Dec-2020 21:11:50 UTC] WordPress database error Table 'boatexd_expo.wp_rank_math_analytics_objects' doesn't exist for query SELECT COUNT(object_id) AS total, SUM(seo_score) AS score FROM wp_rank_math_analytics_objects LIMIT 0, 1 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\Analytics\Rest->get_dashboard, RankMath\Analytics\Summary->get_optimization_summary, MyThemeShop\Database\Query_Builder->one
[28-Dec-2020 21:11:50 UTC] PHP Warning:  Creating default object from empty value in /home/boatexd/public_html/wp-content/plugins/seo-by-rank-math/includes/modules/analytics/class-summary.php on line 151

Tell me, what could it be?
Maybe this is due to the fact that I am using the free version of the plugin?

Thanks in advance!
Sincerely, Aleksandr.

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

Reinelle
4 years ago

Hello,

Thank you for contacting Rank Math and bringing your concern to our attention. I’m sorry for the delay and for any inconvenience this issue may have caused you.

This error doesn’t appear due to using the free version. Please follow these steps:

1. Update to the latest version of Rank Math Free

2. Ensure that the Advanced Mode is selected:

3. Re-create tables by clicking WP Dashboard > Rank Math > Status & Tools > Database Tools and click the Re-create database Table button.

I hope that helps. Thank you, and looking forward to your update.

Panchenkoprog
4 years ago

Rank Math free

Thanks, it worked.

Rank Math
4 years ago

Hello,

We are super happy that this resolved your issue. If you have any other questions in the future, know that we are here to help you.

If you don’t mind me asking, could you please leave us a review (if you haven’t already) on https://wordpress.org/support/plugin/seo-by-rank-math/reviews/#new-post about your overall experience with Rank Math? We appreciate your time and patience.

If you do have another question in the future, please feel free to create a new forum topic, and it will be our pleasure to assist you again.

Thank you.

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

The ticket ‘Errors in the logs of my site.’ is closed to new replies.