WordPress database error

  • Resolved marv2

    (@marv2)


    4 years ago

    Hi, I am getting this error using the latest version in WP debug:

    [18-Mar-2021 13:19:44 UTC] WordPress database error Table 'DDd_domain_com.wp_rank_math_analytics_gsc' doesn't exist for query SELECT SUM(impressions) AS impressions, SUM(clicks) AS clicks, AVG(position) AS position FROM wp_rank_math_analytics_gsc WHERE created BETWEEN '2021-02-08 00:00:01' AND '2021-03-15 23:59:59' LIMIT 0, 1 made by wp_dashboard, do_meta_boxes, RankMath\Admin\Admin->render_dashboard_widget, RankMath\Admin\Admin->do_action, do_action_ref_array('rank_math/dashboard/widget'), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Analytics\Analytics->dashboard_widget, RankMath\Analytics\Summary->get_widget, MyThemeShop\Database\Query_Builder->one, QM_DB->query
[18-Mar-2021 13:19:44 UTC] WordPress database error Table 'DDd_domain_com.wp_rank_math_analytics_gsc' doesn't exist for query SELECT SUM(impressions) AS impressions, SUM(clicks) AS clicks, AVG(position) AS position FROM wp_rank_math_analytics_gsc WHERE created BETWEEN '2021-01-03 00:00:01' AND '2021-02-07 23:59:59' LIMIT 0, 1 made by wp_dashboard, do_meta_boxes, RankMath\Admin\Admin->render_dashboard_widget, RankMath\Admin\Admin->do_action, do_action_ref_array('rank_math/dashboard/widget'), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Analytics\Analytics->dashboard_widget, RankMath\Analytics\Summary->get_widget, MyThemeShop\Database\Query_Builder->one, QM_DB->query
[18-Mar-2021 13:19:44 UTC] WordPress database error Table 'DDd_domain_com.wp_rank_math_analytics_gsc' doesn't exist for query SELECT ROUND(AVG(keywords),0) as keywords
			 FROM (
			    SELECT count(DISTINCT(query)) AS keywords
				FROM wp_rank_math_analytics_gsc
				WHERE created BETWEEN '2021-02-08 00:00:01' AND '2021-03-15 23:59:59'
			    GROUP BY created
			) as ks made by wp_dashboard, do_meta_boxes, RankMath\Admin\Admin->render_dashboard_widget, RankMath\Admin\Admin->do_action, do_action_ref_array('rank_math/dashboard/widget'), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Analytics\Analytics->dashboard_widget, RankMath\Analytics\Summary->get_widget, QM_DB->query
[18-Mar-2021 13:19:44 UTC] WordPress database error Table 'DDd_domain_com.wp_rank_math_analytics_gsc' doesn't exist for query SELECT ROUND(AVG(keywords),0) as keywords
			 FROM (
				 SELECT count(DISTINCT(query)) AS keywords
 				FROM wp_rank_math_analytics_gsc
 				WHERE created BETWEEN '2021-01-03 00:00:01' AND '2021-02-07 23:59:59'
 			    GROUP BY created
			) as ks made by wp_dashboard, do_meta_boxes, RankMath\Admin\Admin->render_dashboard_widget, RankMath\Admin\Admin->do_action, do_action_ref_array('rank_math/dashboard/widget'), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Analytics\Analytics->dashboard_widget, RankMath\Analytics\Summary->get_widget, QM_DB->query
Viewing 1 replies (of 1 total)
  • Plugin Author Rank Math SEO

    (@rankmath)

    Hello @marv2,

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

    Assuming you have the Analytics module turned on, can you please install the latest update and follow these steps?
    https://rankmath.com/kb/delete-old-analytics-data/

    Hope that helps. If not, please let us know and we will be more than happy to assist.

Viewing 1 replies (of 1 total)
  • The topic ‘WordPress database error’ is closed to new replies.