Rankmath Plugins pro

wp assign

Member
Banned User
Dec 27, 2019
126
24
18
Dhaka, Bangladesh
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)
 

Attachments

  • dash.jpg
    dash.jpg
    86.5 KB · Views: 8
  • jey.jpg
    jey.jpg
    76.5 KB · Views: 11

MrSam_1

Well-known member
Administrative
Trusted Seller
Dec 1, 2018
24,129
27,390
120
Post this in the relevant resource no need for a separate thread.
 

About us

  • Our community has been around for many years and pride ourselves on offering unbiased, critical discussion among people of all different backgrounds. We are working every day to make sure our community is one of the best.

Quick Navigation

User Menu