Replies: 1
[01-Sep-2023 13:07:31 UTC] WordPress database error Table ‘swaadsan_wp673.wpk0_rank_math_analytics_gsc’ doesn’t exist for query SELECT MAX(DATE(created)) as date, CASE WHEN created BETWEEN ‘2023-07-30 00:00:00’ AND ‘2023-08-04 23:59:59’ THEN ‘range1’ WHEN created BETWEEN ‘2023-08-05 00:00:00’ AND ‘2023-08-10 23:59:59’ THEN ‘range2’ WHEN created BETWEEN ‘2023-08-11 00:00:00’ AND ‘2023-08-16 23:59:59’ THEN ‘range3’ WHEN created BETWEEN ‘2023-08-17 00:00:00’ AND ‘2023-08-22 23:59:59’ THEN ‘range4’ WHEN created BETWEEN ‘2023-08-23 00:00:00’ AND ‘2023-08-29 23:59:59’ THEN ‘range5’ ELSE ‘none’ END AS ‘range_group’ FROM wpk0_rank_math_analytics_gsc WHERE created BETWEEN ‘2023-07-27 00:00:00’ AND ‘2023-08-29 23:59:59’ GROUP BY range_group 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_position_graph [01-Sep-2023 13:07:31 UTC] WordPress database error Table ‘swaadsan_wp673.wpk0_rank_math_analytics_gsc’ doesn’t exist for query SELECT COUNT(DISTINCT(page)) AS posts, SUM(impressions) AS impressions, SUM(clicks) AS clicks, AVG(position) AS position, AVG(ctr) AS ctr FROM wpk0_rank_math_analytics_gsc WHERE created BETWEEN ‘2023-07-27 00:00:00’ AND ‘2023-08-29 23:59:59’ 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_analytics_summary, MyThemeShop\Database\Query_Builder->one [01-Sep-2023 13:07:31 UTC] PHP Fatal error: Uncaught Error: Attempt to assign property “clicks” on null in /home1/swaadsan/public_html/wp-content/plugins/seo-by-rank-math/includes/modules/analytics/class-summary.php:226 Stack trace: #0 /home1/swaadsan/public_html/wp-content/plugins/seo-by-rank-math/includes/modules/analytics/rest/class-rest.php(162): RankMath\Analytics\Summary->get_analytics_summary() #1 /home1/swaadsan/public_html/wp-includes/rest-api/class-wp-rest-server.php(1188): RankMath\Analytics\Rest->get_dashboard(Object(WP_REST_Request)) #2 /home1/swaadsan/public_html/wp-includes/rest-api/class-wp-rest-server.php(1035): WP_REST_Server->respond_to_request(Object(WP_REST_Request), ‘/rankmath/v1/an…’, Array, NULL) #3 /home1/swaadsan/public_html/wp-includes/rest-api/class-wp-rest-server.php(447): WP_REST_Server->dispatch(Object(WP_REST_Request)) #4 /home1/swaadsan/public_html/wp-includes/rest-api.php(418): WP_REST_Server->serve_request(‘/rankmath/v1/an…’) #5 /home1/swaadsan/public_html/wp-includes/class-wp-hook.php(310): rest_api_loaded(Object(WP)) #6 /home1/swaadsan/public_html/wp-includes/class-wp-hook.php(334): WP_Hook->apply_filters(”, Array) #7 /home1/swaadsan/public_html/wp-includes/plugin.php(565): WP_Hook->do_action(Array) #8 /home1/swaadsan/public_html/wp-includes/class-wp.php(398): do_action_ref_array(‘parse_request’, Array) #9 /home1/swaadsan/public_html/wp-includes/class-wp.php(779): WP->parse_request(”) #10 /home1/swaadsan/public_html/wp-includes/functions.php(1335): WP->main(”) #11 /home1/swaadsan/public_html/wp-blog-header.php(16): wp() #12 /home1/swaadsan/public_html/index.php(17): require(‘/home1/swaadsan…’) #13 {main} thrown in /home1/swaadsan/public_html/wp-content/plugins/seo-by-rank-math/includes/modules/analytics/class-summary.php on line 226