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!
.
Auwal
Active member
GSP
Active member
- Oct 13, 2020
- 151
- 100
- 43
GSP
Active member
- Oct 13, 2020
- 151
- 100
- 43
hey bro, could please tell me how to run the correct SQL code or how to create a tables manually?
or if you have the table please send to me
@flanger69 please
Last edited:
- Mar 22, 2020
- 460
- 245
- 43
Auwal
Active member
GSP
Active member
- Oct 13, 2020
- 151
- 100
- 43
Yeah bro I tried but still not getting, may be they rectify it next update hope next update will solve this problem
Airsky
Member
- Sep 14, 2020
- 58
- 43
- 18
have you try to make table name same as your table name?
example: your table first name: wxx_
so change table name in first line for wp_rank_math_analytics_gsc and wp_rank_math_analytics_objects .
CREATE TABLE wxx_rank_math_analytics_gsc (
id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
created TIMESTAMP NOT NULL,
.....
)
flanger69
Active member
- Oct 3, 2019
- 266
- 88
- 28
CREATE TABLE xxx_rank_math_analytics_gsc (
id BIGINT (20) UNSIGNED NOT NULL AUTO_INCREMENT,
created TIMESTAMP NOT NULL,
query VARCHAR (1000) NOT NULL,
page VARCHAR (500) NOT NULL,
clicks MEDIUMINT (6) NOT NULL,
impressions MEDIUMINT (6) NOT NULL,
DOUBLE NOT NULL position,
ctr DOUBLE NOT NULL,
PRIMARY KEY (id),
INDEX analytics_query (query (190)),
INDEX analytics_page (page (190)),
INDEX clicks (clicks),
INDEX position (position)
)
MySQL replied: Documentation
# 1064 - Syntax error near 'position (position)
) 'on line 14
how to correct this error?
id BIGINT (20) UNSIGNED NOT NULL AUTO_INCREMENT,
created TIMESTAMP NOT NULL,
query VARCHAR (1000) NOT NULL,
page VARCHAR (500) NOT NULL,
clicks MEDIUMINT (6) NOT NULL,
impressions MEDIUMINT (6) NOT NULL,
DOUBLE NOT NULL position,
ctr DOUBLE NOT NULL,
PRIMARY KEY (id),
INDEX analytics_query (query (190)),
INDEX analytics_page (page (190)),
INDEX clicks (clicks),
INDEX position (position)
)
MySQL replied: Documentation
# 1064 - Syntax error near 'position (position)
) 'on line 14
how to correct this error?
When entering the Site Analytics tab, this pop-up window will appear below and will not allow you to click on this tab!
GSP
Active member
- Oct 13, 2020
- 151
- 100
- 43
Yeah bro, I copy and paste it and it was created but still not showing the analytics
GSP
Active member
- Oct 13, 2020
- 151
- 100
- 43
Finally its worked, Guys who are all facing this issue please do the steps mentioned below and also click the Update data manually button it will take around 15mins to complete and it show overall optimization completely and also all problem solved even site wide analysis also working. All working perfectly. Thanks to @flanger69 @Tomz @NullMaster
flanger69
Active member
- Oct 3, 2019
- 266
- 88
- 28
Very welcome man!!!!
Finally its worked, Guys who are all facing this issue please do the steps mentioned below and also click the Update data manually button it will take around 15mins to complete and it show overall optimization completely and also all problem solved even site wide analysis also working. All working perfectly. Thanks to @flanger69 @Tomz @NullMaster
flashroiem
Member
- Aug 3, 2018
- 139
- 78
- 28
@flanger69 Tried and installed only one of the database missed. Do you have any idea why is giving issues?
Attachments
Similar threads
