die2mrw007
Senior Developer
The support thread is almost 4 months back... As far as the versions are out, there are various new updates released in these 4 months period.
Rank Math Pro - BEST WordPress SEO Tool v3.0.86
- Thread starter MrSam_1
- Start date
-
Welcome to Original Babiato! All Resource are Free and No downloading Limit.. Join Our Official Telegram Channel For updates Bypass All the resource restrictions/Password/Key? Read here! Read Before submitting Resource Read here! Support Our Work By Donating Click here!
- Oct 16, 2019
- 373
- 189
- 43
You are correct. Will test out a few more fixes and see what happens. Been struggling with this issue for few days now
the weird part is that it works fine on some product pages but then glitches on other product pages.
die2mrw007
Senior Developer
Why not try posting a support ticket in rankmath forum for them to look into it? As far as your concern is within the free version aspect, you can definitely ask for them to look into it.You are correct. Will test out a few more fixes and see what happens. Been struggling with this issue for few days now
Someone help??its just allow add 5 keywords
GSP
Active member
- Oct 13, 2020
- 151
- 100
- 43
This will help you @mordayan
Keywords limit - Support - Rank Math
I am using All In SEO pack Premium, I liked your Rank Math and it's user-interface this is so easy and great and want to use it for my website. Please clear
support.rankmath.com
Last edited:
i have one doubt im using Rankmath free version install Wordpress plugin page, then I install pro version . its works ? or Install free and pro version on babiato file. which method better for work. Please any one have answer to me...........
jaihojaihind
Active member
It is very subjective. For me, the nulled free and pro version works well. But some have reported that it doesn't work for them. So I would suggest to try out both and see it for yourself.
GSP
Active member
- Oct 13, 2020
- 151
- 100
- 43
First install the free version from wordpress then install pro version from babiato
GSP
Active member
- Oct 13, 2020
- 151
- 100
- 43
die2mrw007
Senior Developer
I would advice you to install free version, setup everything in it including Search analysis option, and then install the pro nulled from here and it should work fine.
die2mrw007
Senior Developer
You dont need schema plugins as rank math already has an effective schema system in its pro version and it better handles the schema type for search engines.
DennyYT
New member
- Nov 24, 2020
- 8
- 0
- 1
Hello, I'm in big problem for installing, I'm already using rank math SEO plugin Official Free version from wordpress.org and i have did all setups and running for 2 months already, When i want it to make it pro so i downloaded this nulled version and after seeing two .zip files inside the downloaded file then i'm so much confused how to install it. please someone tell me step by step properly to me. PLEASE HELP ME!!!
GSP
Active member
- Oct 13, 2020
- 151
- 100
- 43
Yes, there are two zip files one is rankmath free nulled and rankmath pro nulled plugins. First upload the rankmath pro nulled plugin from your wordpress and check whether it is working or not. If it's not working just upload the rankmath pro free nulled plugin and then upload rankmath pro nulled plugin. I think this will help you @DennyYT ☺
[02-Dec-2020 18:49:29 UTC] WordPress database error Table 'databasename.user_rank_math_analytics_gsc' doesn't exist for query SELECT query, ROUND( AVG(position), 0 ) as position FROM user_rank_math_analytics_gsc WHERE created BETWEEN '2020-05-25 00:00:01' AND '2020-11-29 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, RankMath\Analytics\Rest->get_keywords_overview, RankMath\Analytics\Keywords->get_top_keywords
[02-Dec-2020 18:49:29 UTC] WordPress database error Table 'databasename.user_rank_math_analytics_gsc' doesn't exist for query SELECT query, ROUND( AVG(position), 0 ) as position FROM user_rank_math_analytics_gsc WHERE created BETWEEN '2019-11-18 00:00:01' AND '2020-05-24 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, RankMath\Analytics\Rest->get_keywords_overview, RankMath\Analytics\Keywords->get_top_keywords
[02-Dec-2020 18:49:29 UTC] WordPress database error Table 'databasename.user_rank_math_analytics_gsc' doesn't exist for query SELECT AVG(ctr) AS ctr FROM user_rank_math_analytics_gsc WHERE created BETWEEN '2020-05-25 00:00:01' AND '2020-11-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, RankMath\Analytics\Rest->get_keywords_overview, RankMath\Analytics\Keywords->get_top_keywords, MyThemeShop\Database\Query_Builder->getVar, MyThemeShop\Database\Query_Builder->one
[02-Dec-2020 18:49:29 UTC] WordPress database error Table 'databasename.user_rank_math_analytics_gsc' doesn't exist for query SELECT AVG(ctr) AS ctr FROM user_rank_math_analytics_gsc WHERE created BETWEEN '2019-11-18 00:00:01' AND '2020-05-24 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, RankMath\Analytics\Rest->get_keywords_overview, RankMath\Analytics\Keywords->get_top_keywords, MyThemeShop\Database\Query_Builder->getVar, MyThemeShop\Database\Query_Builder->one
[02-Dec-2020 18:49:29 UTC] WordPress database error Table 'databasename.user_rank_math_analytics_gsc' doesn't exist for query SELECT
t1.page as page, t1.clicks, t1.impressions, ROUND( t1.position, 0 ) as position, t1.ctr,
COALESCE( t1.clicks - t2.clicks, 0 ) as diffClicks,
COALESCE( t1.impressions - t2.impressions, 0 ) as diffImpressions,
COALESCE( ROUND( t1.position - t2.position, 0 ), 0 ) as diffPosition,
COALESCE( t1.ctr - t2.ctr, 0 ) as diffCtr
FROM
( SELECT page, SUM( clicks ) as clicks, SUM(impressions) as impressions, AVG(position) as position, AVG(ctr) as ctr FROM user_rank_math_analytics_gsc WHERE clicks > 0 AND created BETWEEN '2020-05-25 00:00:01' AND '2020-11-29 23:59:59' GROUP BY page) as t1
LEFT JOIN
( SELECT page, SUM( clicks ) as clicks, SUM(impressions) as impressions, AVG(position) as position, AVG(ctr) as ctr FROM user_rank_math_analytics_gsc WHERE clicks > 0 AND created BETWEEN '2019-11-18 00:00:01' AND '2020-05-24 23:59:59' GROUP BY page) as t2
ON t1.page = t2.page
WHERE COALESCE( ROUND( t1.position - t2.position, 0 ), 0 ) > 0
ORDER BY diffPosition DESC
LIMIT 5 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, RankMathPro\Analytics\Rest->get_posts_overview, RankMathPro\Analytics\Posts->get_winning_posts, RankMath\Analytics\Stats->get_analytics_data
[02-Dec-2020 18:49:29 UTC] WordPress database error Table 'databasename.user_rank_math_analytics_gsc' doesn't exist for query SELECT
page, DATE_FORMAT( created,'%Y-%m-%d') as date, ROUND( AVG(position), 0 ) as position
FROM
user_rank_math_analytics_gsc
WHERE clicks > 0 AND page IN ('') AND created BETWEEN '2020-05-25 00:00:01' AND '2020-11-29 23:59:59'
GROUP BY page, MONTH(created)
ORDER BY created ASC 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, RankMathPro\Analytics\Rest->get_posts_overview, RankMathPro\Analytics\Posts->get_winning_posts, RankMathPro\Analytics\Posts->get_graph_data_for_pages
[02-Dec-2020 18:49:29 UTC] WordPress database error Table 'databasename.user_rank_math_analytics_gsc' doesn't exist for query SELECT DATE_FORMAT( created,'%Y-%m-%d') as date, COUNT(query) as total
FROM user_rank_math_analytics_gsc
WHERE clicks > 0 AND position BETWEEN 1 AND 3 AND created BETWEEN '2020-05-25 00:00:01' AND '2020-11-29 23:59:59'
GROUP BY created
ORDER BY created ASC 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, RankMath\Analytics\Rest->get_keywords_overview, RankMath\Analytics\Keywords->get_top_position_graph, RankMath\Analytics\Keywords->get_postion_graph_data
[02-Dec-2020 18:49:29 UTC] WordPress database error Table 'databasename.user_rank_math_analytics_gsc' doesn't exist for query SELECT DATE_FORMAT( created,'%Y-%m-%d') as date, COUNT(query) as total
FROM user_rank_math_analytics_gsc
WHERE clicks > 0 AND position BETWEEN 4 AND 10 AND created BETWEEN '2020-05-25 00:00:01' AND '2020-11-29 23:59:59'
GROUP BY created
ORDER BY created ASC 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, RankMath\Analytics\Rest->get_keywords_overview, RankMath\Analytics\Keywords->get_top_position_graph, RankMath\Analytics\Keywords->get_postion_graph_data
[02-Dec-2020 18:49:29 UTC] WordPress database error Table 'databasename.user_rank_math_analytics_gsc' doesn't exist for query SELECT DATE_FORMAT( created,'%Y-%m-%d') as date, COUNT(query) as total
FROM user_rank_math_analytics_gsc
WHERE clicks > 0 AND position BETWEEN 11 AND 50 AND created BETWEEN '2020-05-25 00:00:01' AND '2020-11-29 23:59:59'
GROUP BY created
ORDER BY created ASC 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, RankMath\Analytics\Rest->get_keywords_overview, RankMath\Analytics\Keywords->get_top_position_graph, RankMath\Analytics\Keywords->get_postion_graph_data
[02-Dec-2020 18:49:29 UTC] WordPress database error Table 'databasename.user_rank_math_analytics_gsc' doesn't exist for query SELECT DATE_FORMAT( created,'%Y-%m-%d') as date, COUNT(query) as total
FROM user_rank_math_analytics_gsc
WHERE clicks > 0 AND position BETWEEN 51 AND 100 AND created BETWEEN '2020-05-25 00:00:01' AND '2020-11-29 23:59:59'
ORDER BY diffPosition DESC
LIMIT 100000 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, RankMathPro\Analytics\Rest->get_tracked_keywords, RankMathPro\Analytics\Keywords->get_tracked_keywords, RankMath\Analytics\Stats->get_analytics_data
[02-Dec-2020 18:51:38 UTC] WordPress database error Table 'databasename.user_rank_math_analytics_gsc' doesn't exist for query SELECT
query, DATE_FORMAT( created,'%Y-%m-%d') as date, ROUND( AVG(position), 0 ) as position
FROM
user_rank_math_analytics_gsc
WHERE clicks > 0 AND query IN ('') AND created BETWEEN '2020-05-25 00:00:01' AND '2020-11-29 23:59:59'
GROUP BY query, MONTH(created)
ORDER BY created ASC 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, RankMathPro\Analytics\Rest->get_tracked_keywords, RankMathPro\Analytics\Keywords->get_tracked_keywords, RankMathPro\Analytics\Keywords->get_graph_data_for_keywords
[02-Dec-2020 18:53:21 UTC] WordPress database error Table 'databasename.user_rank_math_analytics_gsc' doesn't exist for query SELECT
t1.query as query, t1.clicks, t1.impressions, ROUND( t1.position, 0 ) as position, t1.ctr,
COALESCE( t1.clicks - t2.clicks, 0 ) as diffClicks,
COALESCE( t1.impressions - t2.impressions, 0 ) as diffImpressions,
COALESCE( ROUND( t1.position - t2.position, 0 ), 0 ) as diffPosition,
COALESCE( t1.ctr - t2.ctr, 0 ) as diffCtr
FROM
( SELECT query, SUM( clicks ) as clicks, SUM(impressions) as impressions, AVG(position) as position, AVG(ctr) as ctr FROM user_rank_math_analytics_gsc WHERE clicks > 0 AND created BETWEEN '2020-05-25 00:00:01' AND '2020-11-29 23:59:59' AND query IN ( SELECT keyword from user_rank_math_analytics_keyword_manager ) GROUP BY query) as t1
LEFT JOIN
( SELECT query, SUM( clicks ) as clicks, SUM(impressions) as impressions, AVG(position) as position, AVG(ctr) as ctr FROM user_rank_math_analytics_gsc WHERE clicks > 0 AND created BETWEEN '2019-11-18 00:00:01' AND '2020-05-24 23:59:59' AND query IN ( SELECT keyword from user_rank_math_analytics_keyword_manager ) GROUP BY query) as t2
ON t1.query = t2.query
ORDER BY diffPosition DESC
LIMIT 100000 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, RankMathPro\Analytics\Rest->get_tracked_keywords, RankMathPro\Analytics\Keywords->get_tracked_keywords, RankMath\Analytics\Stats->get_analytics_data
[02-Dec-2020 18:53:21 UTC] WordPress database error Table 'databasename.user_rank_math_analytics_gsc' doesn't exist for query SELECT
query, DATE_FORMAT( created,'%Y-%m-%d') as date, ROUND( AVG(position), 0 ) as position
FROM
user_rank_math_analytics_gsc
WHERE clicks > 0 AND query IN ('') AND created BETWEEN '2020-05-25 00:00:01' AND '2020-11-29 23:59:59'
GROUP BY query, MONTH(created)
ORDER BY created ASC 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, RankMathPro\Analytics\Rest->get_tracked_keywords, RankMathPro\Analytics\Keywords->get_tracked_keywords, RankMathPro\Analytics\Keywords->get_graph_data_for_keywords
[02-Dec-2020 18:53:27 UTC] WordPress database error Table 'databasename.user_rank_math_analytics_gsc' doesn't exist for query SELECT DISTINCT g.page
FROM user_rank_math_analytics_gsc as g
WHERE g.query = 'imagify nulled' AND g.created BETWEEN '2020-05-25 00:00:01' AND '2020-11-29 23:59:59'
ORDER BY g.created DESC
LIMIT 5 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, RankMathPro\Analytics\Keywords->get_keyword_pages
[02-Dec-2020 18:53:27 UTC] WordPress database error Table 'databasename.user_rank_math_analytics_gsc' doesn't exist for query SELECT
t1.page as page, t1.clicks, t1.impressions, ROUND( t1.position, 0 ) as position, t1.ctr,
COALESCE( t1.clicks - t2.clicks, 0 ) as diffClicks,
COALESCE( t1.impressions - t2.impressions, 0 ) as diffImpressions,
COALESCE( ROUND( t1.position - t2.position, 0 ), 0 ) as diffPosition,
COALESCE( t1.ctr - t2.ctr, 0 ) as diffCtr
FROM
( SELECT page, SUM( clicks ) as clicks, SUM(impressions) as impressions, AVG(position) as position, AVG(ctr) as ctr FROM user_rank_math_analytics_gsc WHERE clicks > 0 AND created BETWEEN '2020-05-25 00:00:01' AND '2020-11-29 23:59:59' AND page IN ('') GROUP BY page) as t1
LEFT JOIN
( SELECT page, SUM( clicks ) as clicks, SUM(impressions) as impressions, AVG(position) as position, AVG(ctr) as ctr FROM user_rank_math_analytics_gsc WHERE clicks > 0 AND created BETWEEN '2019-11-18 00:00:01' AND '2020-05-24 23:59:59' AND page IN ('') GROUP BY page) as t2
ON t1.page = t2.page
ORDER BY diffPosition DESC
LIMIT 5 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, RankMathPro\Analytics\Keywords->get_keyword_pages, RankMath\Analytics\Stats->get_analytics_data
[02-Dec-2020 18:53:34 UTC] WordPress database error Table 'databasename.user_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 user_rank_math_analytics_gsc WHERE created BETWEEN '2020-05-25 00:00:01' AND '2020-11-29 23:59:59' AND clicks > 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, RankMath\Analytics\Rest->get_dashboard, RankMath\Analytics\Summary->get_analytics_summary, MyThemeShop\Database\Query_Builder->one
[02-Dec-2020 18:53:34 UTC] WordPress database error Table 'databasename.user_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 user_rank_math_analytics_gsc WHERE created BETWEEN '2019-11-18 00:00:01' AND '2020-05-24 23:59:59' AND clicks > 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, RankMath\Analytics\Rest->get_dashboard, RankMath\Analytics\Summary->get_analytics_summary, MyThemeShop\Database\Query_Builder->one
[02-Dec-2020 18:53:34 UTC] PHP Warning: Creating default object from empty value in /home3/youdfolder/yourdomain.com/wp-content/plugins/seo-by-rank-math/includes/modules/analytics/class-summary.php on line 189
[02-Dec-2020 18:53:34 UTC] WordPress database error Table 'databasename.user_rank_math_analytics_gsc' doesn't exist for query SELECT ROUND(AVG(keywords),0) as keywords, SUM(impressions) AS impressions, SUM(clicks) AS clicks, AVG(ctr) AS ctr, AVG(position) AS position
FROM (
SELECT count(DISTINCT(query)) AS keywords, SUM(impressions) AS impressions, SUM(clicks) AS clicks, AVG(ctr) AS ctr, AVG(position) AS position
FROM user_rank_math_analytics_gsc
WHERE clicks > 0 AND created BETWEEN '2020-05-25 00:00:01' AND '2020-11-29 23:59:59'
GROUP BY created
) as ks 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, RankMath\Analytics\Rest->get_dashboard, RankMath\Analytics\Summary->get_analytics_summary, RankMath\Analytics\Summary->get_keywords_summary
[02-Dec-2020 18:53:34 UTC] WordPress database error Table 'databasename.user_rank_math_analytics_gsc' doesn't exist for query SELECT ROUND(AVG(keywords),0) as keywords, SUM(impressions) AS impressions, SUM(clicks) AS clicks, AVG(ctr) AS ctr, AVG(position) AS position
FROM (
SELECT count(DISTINCT(query)) AS keywords, SUM(impressions) AS impressions, SUM(clicks) AS clicks, AVG(ctr) AS ctr, AVG(position) AS position
FROM user_rank_math_analytics_gsc
WHERE clicks > 0 AND created BETWEEN '2019-11-18 00:00:01' AND '2020-05-24 23:59:59'
GROUP BY created
) as ks 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, RankMath\Analytics\Rest->get_dashboard, RankMath\Analytics\Summary->get_analytics_summary, RankMath\Analytics\Summary->get_keywords_summary
[02-Dec-2020 18:53:34 UTC] WordPress database error Table 'databasename.user_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 user_rank_math_analytics_gsc WHERE created BETWEEN '2020-05-25 00:00:01' AND '2020-11-29 23:59:59' AND clicks > 0 GROUP BY MONTH(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, 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
[02-Dec-2020 18:53:34 UTC] WordPress database error Table 'databasename.user_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 user_rank_math_analytics_gsc
WHERE clicks > 0 AND created BETWEEN '2020-05-25 00:00:01' AND '2020-11-29 23:59:59'
GROUP BY created
) as ka
GROUP BY MONTH(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, RankMath\Analytics\Rest->get_dashboard, RankMath\Analytics\Summary->get_analytics_summary, RankMath\Analytics\Summary->get_keywords_summary, RankMath\Analytics\Summary->get_analytics_summary_graph
[02-Dec-2020 18:53:34 UTC] WordPress database error Table 'databasename.user_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 user_rank_math_analytics_gsc WHERE created BETWEEN '2020-05-25 00:00:01' AND '2020-11-29 23:59:59' AND clicks > 0 GROUP BY MONTH(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, RankMath\Analytics\Rest->get_dashboard, RankMath\Analytics\Summary->get_analytics_summary, RankMath\Analytics\Summary->get_analytics_summary_graph, MyThemeShop\Database\Query_Builder->get
[02-Dec-2020 18:53:34 UTC] WordPress database error Table 'databasename.user_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 user_rank_math_analytics_gsc
WHERE clicks > 0 AND created BETWEEN '2020-05-25 00:00:01' AND '2020-11-29 23:59:59'
GROUP BY created
) as ka
GROUP BY MONTH(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, RankMath\Analytics\Rest->get_dashboard, RankMath\Analytics\Summary->get_analytics_summary, RankMath\Analytics\Summary->get_analytics_summary_graph
[02-Dec-2020 18:53:34 UTC] WordPress database error Table 'databasename.user_rank_math_analytics_objects' doesn't exist for query SELECT COUNT(object_id) AS count FROM user_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, RankMath\Analytics\Rest->get_dashboard, RankMath\Analytics\Summary->get_optimization_summary, MyThemeShop\Database\Query_Builder->getVar, MyThemeShop\Database\Query_Builder->one
[02-Dec-2020 18:53:34 UTC] WordPress database error Table 'databasename.user_rank_math_analytics_objects' doesn't exist for query SELECT COUNT(object_id) AS count FROM user_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, RankMath\Analytics\Rest->get_dashboard, RankMath\Analytics\Summary->get_optimization_summary, MyThemeShop\Database\Query_Builder->getVar, MyThemeShop\Database\Query_Builder->one
[02-Dec-2020 18:53:34 UTC] WordPress database error Table 'databasename.user_rank_math_analytics_objects' doesn't exist for query SELECT COUNT(object_id) AS count FROM user_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, RankMath\Analytics\Rest->get_dashboard, RankMath\Analytics\Summary->get_optimization_summary, MyThemeShop\Database\Query_Builder->getVar, MyThemeShop\Database\Query_Builder->one
[02-Dec-2020 18:53:34 UTC] WordPress database error Table 'databasename.user_rank_math_analytics_objects' doesn't exist for query SELECT COUNT(object_id) AS count FROM user_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, RankMath\Analytics\Rest->get_dashboard, RankMath\Analytics\Summary->get_optimization_summary, MyThemeShop\Database\Query_Builder->getVar, MyThemeShop\Database\Query_Builder->one
[02-Dec-2020 18:53:34 UTC] WordPress database error Table 'databasename.user_rank_math_analytics_objects' doesn't exist for query SELECT COUNT(object_id) AS total, SUM(seo_score) AS score FROM user_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, RankMath\Analytics\Rest->get_dashboard, RankMath\Analytics\Summary->get_optimization_summary, MyThemeShop\Database\Query_Builder->one
[02-Dec-2020 18:53:34 UTC] PHP Warning: Creating default object from empty value in /home3/youdfolder/yourdomain.com/wp-content/plugins/seo-by-rank-math/includes/modules/analytics/class-summary.php on line 153
[02-Dec-2020 18:53:41 UTC] WordPress database error Table 'databasename.user_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 user_rank_math_analytics_gsc WHERE created BETWEEN '2020-08-25 00:00:01' AND '2020-11-29 23:59:59' AND clicks > 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, RankMath\Analytics\Rest->get_dashboard, RankMath\Analytics\Summary->get_analytics_summary, MyThemeShop\Database\Query_Builder->one
[02-Dec-2020 18:53:41 UTC] WordPress database error Table 'databasename.user_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 user_rank_math_analytics_gsc WHERE created BETWEEN '2020-05-20 00:00:01' AND '2020-08-24 23:59:59' AND clicks > 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, RankMath\Analytics\Rest->get_dashboard, RankMath\Analytics\Summary->get_analytics_summary, MyThemeShop\Database\Query_Builder->one
[02-Dec-2020 18:53:41 UTC] PHP Warning: Creating default object from empty value in /home3/youdfolder/yourdomain.com/wp-content/plugins/seo-by-rank-math/includes/modules/analytics/class-summary.php on line 189
[02-Dec-2020 18:53:41 UTC] WordPress database error Table 'databasename.user_rank_math_analytics_gsc' doesn't exist for query SELECT ROUND(AVG(keywords),0) as keywords, SUM(impressions) AS impressions, SUM(clicks) AS clicks, AVG(ctr) AS ctr, AVG(position) AS position
FROM (
SELECT count(DISTINCT(query)) AS keywords, SUM(impressions) AS impressions, SUM(clicks) AS clicks, AVG(ctr) AS ctr, AVG(position) AS position
FROM user_rank_math_analytics_gsc
WHERE clicks > 0 AND created BETWEEN '2020-08-25 00:00:01' AND '2020-11-29 23:59:59'
GROUP BY created
) as ks 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, RankMath\Analytics\Rest->get_dashboard, RankMath\Analytics\Summary->get_analytics_summary, RankMath\Analytics\Summary->get_keywords_summary
[02-Dec-2020 18:53:41 UTC] WordPress database error Table 'databasename.user_rank_math_analytics_gsc' doesn't exist for query SELECT ROUND(AVG(keywords),0) as keywords, SUM(impressions) AS impressions, SUM(clicks) AS clicks, AVG(ctr) AS ctr, AVG(position) AS position
FROM (
SELECT count(DISTINCT(query)) AS keywords, SUM(impressions) AS impressions, SUM(clicks) AS clicks, AVG(ctr) AS ctr, AVG(position) AS position
FROM user_rank_math_analytics_gsc
WHERE clicks > 0 AND created BETWEEN '2020-05-20 00:00:01' AND '2020-08-24 23:59:59'
GROUP BY created
) as ks 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, RankMath\Analytics\Rest->get_dashboard, RankMath\Analytics\Summary->get_analytics_summary, RankMath\Analytics\Summary->get_keywords_summary
[02-Dec-2020 18:53:41 UTC] WordPress database error Table 'databasename.user_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 user_rank_math_analytics_gsc WHERE created BETWEEN '2020-08-25 00:00:01' AND '2020-11-29 23:59:59' AND clicks > 0 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, 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
[02-Dec-2020 18:53:41 UTC] WordPress database error Table 'databasename.user_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 user_rank_math_analytics_gsc
WHERE clicks > 0 AND created BETWEEN '2020-08-25 00:00:01' AND '2020-11-29 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, RankMath\Analytics\Rest->get_dashboard, RankMath\Analytics\Summary->get_analytics_summary, RankMath\Analytics\Summary->get_keywords_summary, RankMath\Analytics\Summary->get_analytics_summary_graph
[02-Dec-2020 18:53:41 UTC] WordPress database error Table 'databasename.user_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 user_rank_math_analytics_gsc WHERE created BETWEEN '2020-08-25 00:00:01' AND '2020-11-29 23:59:59' AND clicks > 0 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, RankMath\Analytics\Rest->get_dashboard, RankMath\Analytics\Summary->get_analytics_summary, RankMath\Analytics\Summary->get_analytics_summary_graph, MyThemeShop\Database\Query_Builder->get
[02-Dec-2020 18:53:41 UTC] WordPress database error Table 'databasename.user_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 user_rank_math_analytics_gsc
WHERE clicks > 0 AND created BETWEEN '2020-08-25 00:00:01' AND '2020-11-29 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, RankMath\Analytics\Rest->get_dashboard, RankMath\Analytics\Summary->get_analytics_summary, RankMath\Analytics\Summary->get_analytics_summary_graph
[02-Dec-2020 18:49:29 UTC] WordPress database error Table 'databasename.user_rank_math_analytics_gsc' doesn't exist for query SELECT query, ROUND( AVG(position), 0 ) as position FROM user_rank_math_analytics_gsc WHERE created BETWEEN '2019-11-18 00:00:01' AND '2020-05-24 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, RankMath\Analytics\Rest->get_keywords_overview, RankMath\Analytics\Keywords->get_top_keywords
[02-Dec-2020 18:49:29 UTC] WordPress database error Table 'databasename.user_rank_math_analytics_gsc' doesn't exist for query SELECT AVG(ctr) AS ctr FROM user_rank_math_analytics_gsc WHERE created BETWEEN '2020-05-25 00:00:01' AND '2020-11-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, RankMath\Analytics\Rest->get_keywords_overview, RankMath\Analytics\Keywords->get_top_keywords, MyThemeShop\Database\Query_Builder->getVar, MyThemeShop\Database\Query_Builder->one
[02-Dec-2020 18:49:29 UTC] WordPress database error Table 'databasename.user_rank_math_analytics_gsc' doesn't exist for query SELECT AVG(ctr) AS ctr FROM user_rank_math_analytics_gsc WHERE created BETWEEN '2019-11-18 00:00:01' AND '2020-05-24 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, RankMath\Analytics\Rest->get_keywords_overview, RankMath\Analytics\Keywords->get_top_keywords, MyThemeShop\Database\Query_Builder->getVar, MyThemeShop\Database\Query_Builder->one
[02-Dec-2020 18:49:29 UTC] WordPress database error Table 'databasename.user_rank_math_analytics_gsc' doesn't exist for query SELECT
t1.page as page, t1.clicks, t1.impressions, ROUND( t1.position, 0 ) as position, t1.ctr,
COALESCE( t1.clicks - t2.clicks, 0 ) as diffClicks,
COALESCE( t1.impressions - t2.impressions, 0 ) as diffImpressions,
COALESCE( ROUND( t1.position - t2.position, 0 ), 0 ) as diffPosition,
COALESCE( t1.ctr - t2.ctr, 0 ) as diffCtr
FROM
( SELECT page, SUM( clicks ) as clicks, SUM(impressions) as impressions, AVG(position) as position, AVG(ctr) as ctr FROM user_rank_math_analytics_gsc WHERE clicks > 0 AND created BETWEEN '2020-05-25 00:00:01' AND '2020-11-29 23:59:59' GROUP BY page) as t1
LEFT JOIN
( SELECT page, SUM( clicks ) as clicks, SUM(impressions) as impressions, AVG(position) as position, AVG(ctr) as ctr FROM user_rank_math_analytics_gsc WHERE clicks > 0 AND created BETWEEN '2019-11-18 00:00:01' AND '2020-05-24 23:59:59' GROUP BY page) as t2
ON t1.page = t2.page
WHERE COALESCE( ROUND( t1.position - t2.position, 0 ), 0 ) > 0
ORDER BY diffPosition DESC
LIMIT 5 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, RankMathPro\Analytics\Rest->get_posts_overview, RankMathPro\Analytics\Posts->get_winning_posts, RankMath\Analytics\Stats->get_analytics_data
[02-Dec-2020 18:49:29 UTC] WordPress database error Table 'databasename.user_rank_math_analytics_gsc' doesn't exist for query SELECT
page, DATE_FORMAT( created,'%Y-%m-%d') as date, ROUND( AVG(position), 0 ) as position
FROM
user_rank_math_analytics_gsc
WHERE clicks > 0 AND page IN ('') AND created BETWEEN '2020-05-25 00:00:01' AND '2020-11-29 23:59:59'
GROUP BY page, MONTH(created)
ORDER BY created ASC 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, RankMathPro\Analytics\Rest->get_posts_overview, RankMathPro\Analytics\Posts->get_winning_posts, RankMathPro\Analytics\Posts->get_graph_data_for_pages
[02-Dec-2020 18:49:29 UTC] WordPress database error Table 'databasename.user_rank_math_analytics_gsc' doesn't exist for query SELECT DATE_FORMAT( created,'%Y-%m-%d') as date, COUNT(query) as total
FROM user_rank_math_analytics_gsc
WHERE clicks > 0 AND position BETWEEN 1 AND 3 AND created BETWEEN '2020-05-25 00:00:01' AND '2020-11-29 23:59:59'
GROUP BY created
ORDER BY created ASC 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, RankMath\Analytics\Rest->get_keywords_overview, RankMath\Analytics\Keywords->get_top_position_graph, RankMath\Analytics\Keywords->get_postion_graph_data
[02-Dec-2020 18:49:29 UTC] WordPress database error Table 'databasename.user_rank_math_analytics_gsc' doesn't exist for query SELECT DATE_FORMAT( created,'%Y-%m-%d') as date, COUNT(query) as total
FROM user_rank_math_analytics_gsc
WHERE clicks > 0 AND position BETWEEN 4 AND 10 AND created BETWEEN '2020-05-25 00:00:01' AND '2020-11-29 23:59:59'
GROUP BY created
ORDER BY created ASC 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, RankMath\Analytics\Rest->get_keywords_overview, RankMath\Analytics\Keywords->get_top_position_graph, RankMath\Analytics\Keywords->get_postion_graph_data
[02-Dec-2020 18:49:29 UTC] WordPress database error Table 'databasename.user_rank_math_analytics_gsc' doesn't exist for query SELECT DATE_FORMAT( created,'%Y-%m-%d') as date, COUNT(query) as total
FROM user_rank_math_analytics_gsc
WHERE clicks > 0 AND position BETWEEN 11 AND 50 AND created BETWEEN '2020-05-25 00:00:01' AND '2020-11-29 23:59:59'
GROUP BY created
ORDER BY created ASC 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, RankMath\Analytics\Rest->get_keywords_overview, RankMath\Analytics\Keywords->get_top_position_graph, RankMath\Analytics\Keywords->get_postion_graph_data
[02-Dec-2020 18:49:29 UTC] WordPress database error Table 'databasename.user_rank_math_analytics_gsc' doesn't exist for query SELECT DATE_FORMAT( created,'%Y-%m-%d') as date, COUNT(query) as total
FROM user_rank_math_analytics_gsc
WHERE clicks > 0 AND position BETWEEN 51 AND 100 AND created BETWEEN '2020-05-25 00:00:01' AND '2020-11-29 23:59:59'
ORDER BY diffPosition DESC
LIMIT 100000 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, RankMathPro\Analytics\Rest->get_tracked_keywords, RankMathPro\Analytics\Keywords->get_tracked_keywords, RankMath\Analytics\Stats->get_analytics_data
[02-Dec-2020 18:51:38 UTC] WordPress database error Table 'databasename.user_rank_math_analytics_gsc' doesn't exist for query SELECT
query, DATE_FORMAT( created,'%Y-%m-%d') as date, ROUND( AVG(position), 0 ) as position
FROM
user_rank_math_analytics_gsc
WHERE clicks > 0 AND query IN ('') AND created BETWEEN '2020-05-25 00:00:01' AND '2020-11-29 23:59:59'
GROUP BY query, MONTH(created)
ORDER BY created ASC 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, RankMathPro\Analytics\Rest->get_tracked_keywords, RankMathPro\Analytics\Keywords->get_tracked_keywords, RankMathPro\Analytics\Keywords->get_graph_data_for_keywords
[02-Dec-2020 18:53:21 UTC] WordPress database error Table 'databasename.user_rank_math_analytics_gsc' doesn't exist for query SELECT
t1.query as query, t1.clicks, t1.impressions, ROUND( t1.position, 0 ) as position, t1.ctr,
COALESCE( t1.clicks - t2.clicks, 0 ) as diffClicks,
COALESCE( t1.impressions - t2.impressions, 0 ) as diffImpressions,
COALESCE( ROUND( t1.position - t2.position, 0 ), 0 ) as diffPosition,
COALESCE( t1.ctr - t2.ctr, 0 ) as diffCtr
FROM
( SELECT query, SUM( clicks ) as clicks, SUM(impressions) as impressions, AVG(position) as position, AVG(ctr) as ctr FROM user_rank_math_analytics_gsc WHERE clicks > 0 AND created BETWEEN '2020-05-25 00:00:01' AND '2020-11-29 23:59:59' AND query IN ( SELECT keyword from user_rank_math_analytics_keyword_manager ) GROUP BY query) as t1
LEFT JOIN
( SELECT query, SUM( clicks ) as clicks, SUM(impressions) as impressions, AVG(position) as position, AVG(ctr) as ctr FROM user_rank_math_analytics_gsc WHERE clicks > 0 AND created BETWEEN '2019-11-18 00:00:01' AND '2020-05-24 23:59:59' AND query IN ( SELECT keyword from user_rank_math_analytics_keyword_manager ) GROUP BY query) as t2
ON t1.query = t2.query
ORDER BY diffPosition DESC
LIMIT 100000 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, RankMathPro\Analytics\Rest->get_tracked_keywords, RankMathPro\Analytics\Keywords->get_tracked_keywords, RankMath\Analytics\Stats->get_analytics_data
[02-Dec-2020 18:53:21 UTC] WordPress database error Table 'databasename.user_rank_math_analytics_gsc' doesn't exist for query SELECT
query, DATE_FORMAT( created,'%Y-%m-%d') as date, ROUND( AVG(position), 0 ) as position
FROM
user_rank_math_analytics_gsc
WHERE clicks > 0 AND query IN ('') AND created BETWEEN '2020-05-25 00:00:01' AND '2020-11-29 23:59:59'
GROUP BY query, MONTH(created)
ORDER BY created ASC 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, RankMathPro\Analytics\Rest->get_tracked_keywords, RankMathPro\Analytics\Keywords->get_tracked_keywords, RankMathPro\Analytics\Keywords->get_graph_data_for_keywords
[02-Dec-2020 18:53:27 UTC] WordPress database error Table 'databasename.user_rank_math_analytics_gsc' doesn't exist for query SELECT DISTINCT g.page
FROM user_rank_math_analytics_gsc as g
WHERE g.query = 'imagify nulled' AND g.created BETWEEN '2020-05-25 00:00:01' AND '2020-11-29 23:59:59'
ORDER BY g.created DESC
LIMIT 5 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, RankMathPro\Analytics\Keywords->get_keyword_pages
[02-Dec-2020 18:53:27 UTC] WordPress database error Table 'databasename.user_rank_math_analytics_gsc' doesn't exist for query SELECT
t1.page as page, t1.clicks, t1.impressions, ROUND( t1.position, 0 ) as position, t1.ctr,
COALESCE( t1.clicks - t2.clicks, 0 ) as diffClicks,
COALESCE( t1.impressions - t2.impressions, 0 ) as diffImpressions,
COALESCE( ROUND( t1.position - t2.position, 0 ), 0 ) as diffPosition,
COALESCE( t1.ctr - t2.ctr, 0 ) as diffCtr
FROM
( SELECT page, SUM( clicks ) as clicks, SUM(impressions) as impressions, AVG(position) as position, AVG(ctr) as ctr FROM user_rank_math_analytics_gsc WHERE clicks > 0 AND created BETWEEN '2020-05-25 00:00:01' AND '2020-11-29 23:59:59' AND page IN ('') GROUP BY page) as t1
LEFT JOIN
( SELECT page, SUM( clicks ) as clicks, SUM(impressions) as impressions, AVG(position) as position, AVG(ctr) as ctr FROM user_rank_math_analytics_gsc WHERE clicks > 0 AND created BETWEEN '2019-11-18 00:00:01' AND '2020-05-24 23:59:59' AND page IN ('') GROUP BY page) as t2
ON t1.page = t2.page
ORDER BY diffPosition DESC
LIMIT 5 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, RankMathPro\Analytics\Keywords->get_keyword_pages, RankMath\Analytics\Stats->get_analytics_data
[02-Dec-2020 18:53:34 UTC] WordPress database error Table 'databasename.user_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 user_rank_math_analytics_gsc WHERE created BETWEEN '2020-05-25 00:00:01' AND '2020-11-29 23:59:59' AND clicks > 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, RankMath\Analytics\Rest->get_dashboard, RankMath\Analytics\Summary->get_analytics_summary, MyThemeShop\Database\Query_Builder->one
[02-Dec-2020 18:53:34 UTC] WordPress database error Table 'databasename.user_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 user_rank_math_analytics_gsc WHERE created BETWEEN '2019-11-18 00:00:01' AND '2020-05-24 23:59:59' AND clicks > 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, RankMath\Analytics\Rest->get_dashboard, RankMath\Analytics\Summary->get_analytics_summary, MyThemeShop\Database\Query_Builder->one
[02-Dec-2020 18:53:34 UTC] PHP Warning: Creating default object from empty value in /home3/youdfolder/yourdomain.com/wp-content/plugins/seo-by-rank-math/includes/modules/analytics/class-summary.php on line 189
[02-Dec-2020 18:53:34 UTC] WordPress database error Table 'databasename.user_rank_math_analytics_gsc' doesn't exist for query SELECT ROUND(AVG(keywords),0) as keywords, SUM(impressions) AS impressions, SUM(clicks) AS clicks, AVG(ctr) AS ctr, AVG(position) AS position
FROM (
SELECT count(DISTINCT(query)) AS keywords, SUM(impressions) AS impressions, SUM(clicks) AS clicks, AVG(ctr) AS ctr, AVG(position) AS position
FROM user_rank_math_analytics_gsc
WHERE clicks > 0 AND created BETWEEN '2020-05-25 00:00:01' AND '2020-11-29 23:59:59'
GROUP BY created
) as ks 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, RankMath\Analytics\Rest->get_dashboard, RankMath\Analytics\Summary->get_analytics_summary, RankMath\Analytics\Summary->get_keywords_summary
[02-Dec-2020 18:53:34 UTC] WordPress database error Table 'databasename.user_rank_math_analytics_gsc' doesn't exist for query SELECT ROUND(AVG(keywords),0) as keywords, SUM(impressions) AS impressions, SUM(clicks) AS clicks, AVG(ctr) AS ctr, AVG(position) AS position
FROM (
SELECT count(DISTINCT(query)) AS keywords, SUM(impressions) AS impressions, SUM(clicks) AS clicks, AVG(ctr) AS ctr, AVG(position) AS position
FROM user_rank_math_analytics_gsc
WHERE clicks > 0 AND created BETWEEN '2019-11-18 00:00:01' AND '2020-05-24 23:59:59'
GROUP BY created
) as ks 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, RankMath\Analytics\Rest->get_dashboard, RankMath\Analytics\Summary->get_analytics_summary, RankMath\Analytics\Summary->get_keywords_summary
[02-Dec-2020 18:53:34 UTC] WordPress database error Table 'databasename.user_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 user_rank_math_analytics_gsc WHERE created BETWEEN '2020-05-25 00:00:01' AND '2020-11-29 23:59:59' AND clicks > 0 GROUP BY MONTH(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, 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
[02-Dec-2020 18:53:34 UTC] WordPress database error Table 'databasename.user_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 user_rank_math_analytics_gsc
WHERE clicks > 0 AND created BETWEEN '2020-05-25 00:00:01' AND '2020-11-29 23:59:59'
GROUP BY created
) as ka
GROUP BY MONTH(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, RankMath\Analytics\Rest->get_dashboard, RankMath\Analytics\Summary->get_analytics_summary, RankMath\Analytics\Summary->get_keywords_summary, RankMath\Analytics\Summary->get_analytics_summary_graph
[02-Dec-2020 18:53:34 UTC] WordPress database error Table 'databasename.user_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 user_rank_math_analytics_gsc WHERE created BETWEEN '2020-05-25 00:00:01' AND '2020-11-29 23:59:59' AND clicks > 0 GROUP BY MONTH(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, RankMath\Analytics\Rest->get_dashboard, RankMath\Analytics\Summary->get_analytics_summary, RankMath\Analytics\Summary->get_analytics_summary_graph, MyThemeShop\Database\Query_Builder->get
[02-Dec-2020 18:53:34 UTC] WordPress database error Table 'databasename.user_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 user_rank_math_analytics_gsc
WHERE clicks > 0 AND created BETWEEN '2020-05-25 00:00:01' AND '2020-11-29 23:59:59'
GROUP BY created
) as ka
GROUP BY MONTH(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, RankMath\Analytics\Rest->get_dashboard, RankMath\Analytics\Summary->get_analytics_summary, RankMath\Analytics\Summary->get_analytics_summary_graph
[02-Dec-2020 18:53:34 UTC] WordPress database error Table 'databasename.user_rank_math_analytics_objects' doesn't exist for query SELECT COUNT(object_id) AS count FROM user_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, RankMath\Analytics\Rest->get_dashboard, RankMath\Analytics\Summary->get_optimization_summary, MyThemeShop\Database\Query_Builder->getVar, MyThemeShop\Database\Query_Builder->one
[02-Dec-2020 18:53:34 UTC] WordPress database error Table 'databasename.user_rank_math_analytics_objects' doesn't exist for query SELECT COUNT(object_id) AS count FROM user_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, RankMath\Analytics\Rest->get_dashboard, RankMath\Analytics\Summary->get_optimization_summary, MyThemeShop\Database\Query_Builder->getVar, MyThemeShop\Database\Query_Builder->one
[02-Dec-2020 18:53:34 UTC] WordPress database error Table 'databasename.user_rank_math_analytics_objects' doesn't exist for query SELECT COUNT(object_id) AS count FROM user_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, RankMath\Analytics\Rest->get_dashboard, RankMath\Analytics\Summary->get_optimization_summary, MyThemeShop\Database\Query_Builder->getVar, MyThemeShop\Database\Query_Builder->one
[02-Dec-2020 18:53:34 UTC] WordPress database error Table 'databasename.user_rank_math_analytics_objects' doesn't exist for query SELECT COUNT(object_id) AS count FROM user_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, RankMath\Analytics\Rest->get_dashboard, RankMath\Analytics\Summary->get_optimization_summary, MyThemeShop\Database\Query_Builder->getVar, MyThemeShop\Database\Query_Builder->one
[02-Dec-2020 18:53:34 UTC] WordPress database error Table 'databasename.user_rank_math_analytics_objects' doesn't exist for query SELECT COUNT(object_id) AS total, SUM(seo_score) AS score FROM user_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, RankMath\Analytics\Rest->get_dashboard, RankMath\Analytics\Summary->get_optimization_summary, MyThemeShop\Database\Query_Builder->one
[02-Dec-2020 18:53:34 UTC] PHP Warning: Creating default object from empty value in /home3/youdfolder/yourdomain.com/wp-content/plugins/seo-by-rank-math/includes/modules/analytics/class-summary.php on line 153
[02-Dec-2020 18:53:41 UTC] WordPress database error Table 'databasename.user_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 user_rank_math_analytics_gsc WHERE created BETWEEN '2020-08-25 00:00:01' AND '2020-11-29 23:59:59' AND clicks > 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, RankMath\Analytics\Rest->get_dashboard, RankMath\Analytics\Summary->get_analytics_summary, MyThemeShop\Database\Query_Builder->one
[02-Dec-2020 18:53:41 UTC] WordPress database error Table 'databasename.user_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 user_rank_math_analytics_gsc WHERE created BETWEEN '2020-05-20 00:00:01' AND '2020-08-24 23:59:59' AND clicks > 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, RankMath\Analytics\Rest->get_dashboard, RankMath\Analytics\Summary->get_analytics_summary, MyThemeShop\Database\Query_Builder->one
[02-Dec-2020 18:53:41 UTC] PHP Warning: Creating default object from empty value in /home3/youdfolder/yourdomain.com/wp-content/plugins/seo-by-rank-math/includes/modules/analytics/class-summary.php on line 189
[02-Dec-2020 18:53:41 UTC] WordPress database error Table 'databasename.user_rank_math_analytics_gsc' doesn't exist for query SELECT ROUND(AVG(keywords),0) as keywords, SUM(impressions) AS impressions, SUM(clicks) AS clicks, AVG(ctr) AS ctr, AVG(position) AS position
FROM (
SELECT count(DISTINCT(query)) AS keywords, SUM(impressions) AS impressions, SUM(clicks) AS clicks, AVG(ctr) AS ctr, AVG(position) AS position
FROM user_rank_math_analytics_gsc
WHERE clicks > 0 AND created BETWEEN '2020-08-25 00:00:01' AND '2020-11-29 23:59:59'
GROUP BY created
) as ks 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, RankMath\Analytics\Rest->get_dashboard, RankMath\Analytics\Summary->get_analytics_summary, RankMath\Analytics\Summary->get_keywords_summary
[02-Dec-2020 18:53:41 UTC] WordPress database error Table 'databasename.user_rank_math_analytics_gsc' doesn't exist for query SELECT ROUND(AVG(keywords),0) as keywords, SUM(impressions) AS impressions, SUM(clicks) AS clicks, AVG(ctr) AS ctr, AVG(position) AS position
FROM (
SELECT count(DISTINCT(query)) AS keywords, SUM(impressions) AS impressions, SUM(clicks) AS clicks, AVG(ctr) AS ctr, AVG(position) AS position
FROM user_rank_math_analytics_gsc
WHERE clicks > 0 AND created BETWEEN '2020-05-20 00:00:01' AND '2020-08-24 23:59:59'
GROUP BY created
) as ks 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, RankMath\Analytics\Rest->get_dashboard, RankMath\Analytics\Summary->get_analytics_summary, RankMath\Analytics\Summary->get_keywords_summary
[02-Dec-2020 18:53:41 UTC] WordPress database error Table 'databasename.user_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 user_rank_math_analytics_gsc WHERE created BETWEEN '2020-08-25 00:00:01' AND '2020-11-29 23:59:59' AND clicks > 0 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, 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
[02-Dec-2020 18:53:41 UTC] WordPress database error Table 'databasename.user_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 user_rank_math_analytics_gsc
WHERE clicks > 0 AND created BETWEEN '2020-08-25 00:00:01' AND '2020-11-29 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, RankMath\Analytics\Rest->get_dashboard, RankMath\Analytics\Summary->get_analytics_summary, RankMath\Analytics\Summary->get_keywords_summary, RankMath\Analytics\Summary->get_analytics_summary_graph
[02-Dec-2020 18:53:41 UTC] WordPress database error Table 'databasename.user_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 user_rank_math_analytics_gsc WHERE created BETWEEN '2020-08-25 00:00:01' AND '2020-11-29 23:59:59' AND clicks > 0 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, RankMath\Analytics\Rest->get_dashboard, RankMath\Analytics\Summary->get_analytics_summary, RankMath\Analytics\Summary->get_analytics_summary_graph, MyThemeShop\Database\Query_Builder->get
[02-Dec-2020 18:53:41 UTC] WordPress database error Table 'databasename.user_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 user_rank_math_analytics_gsc
WHERE clicks > 0 AND created BETWEEN '2020-08-25 00:00:01' AND '2020-11-29 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, RankMath\Analytics\Rest->get_dashboard, RankMath\Analytics\Summary->get_analytics_summary, RankMath\Analytics\Summary->get_analytics_summary_graph
I am missing below 2 database
So How can solve it?????
| Database Table: Google Search Console | Doesn't exists |
| Database Table: Flat Posts | Doesn't exists |
So How can solve it?????
die2mrw007
Senior Developer
Navigate to Rankmath > Status & Tools > Database Tools
and click on 5th option "Re-create database Table"
Similar threads
