Using AnniRuru Weekly_MVP_Reward_1.0r script,
its working fine on mysql server (windows) but not working on CentOs mysql server.
below error showing while creating tables
"rank" is not valid at this position, expecting an identifier.
its working fine on mysql server (windows) but not working on CentOs mysql server.
below error showing while creating tables
"rank" is not valid at this position, expecting an identifier.
Code:
/*
create table mvp_rank (
char_id int(11) primary key,
name varchar(23) default '',
mvp_kills int(11) default 0,
key (mvp_kills)
) engine = innodb;
create table mvp_rank_archive (
weekindex int(11),
rank tinyint(4) unsigned,
char_id int(11) unsigned default 0,
name varchar(23) default '',
points int(11) unsigned not null,
key (weekindex)
) engine = myisam;
create table mvp_rank_reward (
char_id int(11),
weekindex int(11),
rank tinyint(4) unsigned,
key (char_id)
) engine = innodb;
*/