Errors in the logs of my site.

#126813
  • Resolved Panchenkoprog
    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)
  • 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:
    advanced mode

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

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

    Thanks, it worked.

    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.