Dear
Recently i am switch to rankmath plugins.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........... ? I don't understand, what happen?
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)
Recently i am switch to rankmath plugins.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........... ? I don't understand, what happen?
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)
