design1online / WTF-Adventure

WTF?! Adventure is a massively online 2D MMORPG with WTF?! twists.
https://design1online.github.io/WTF-Adventure/
Other
96 stars 37 forks source link

"player_data" rank is a withheld word in MySql 8.x #98

Closed T-R-I-X closed 11 months ago

T-R-I-X commented 1 year ago

code: 'ER_PARSE_ERROR', errno: 1064, sqlMessage: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rank int,ban int(64),mute varchar(64),membership varchar(64),lastLogin varchar(6' at line 1", sqlState: '42000', index: 0, sql: 'CREATE TABLE player_data (username varchar(64),password varchar(64),email varchar(64),x int,y int,experience int,kind int,rights int,poisoned tinyint,hitPoints int,mana int,pvpKills int,pvpDeaths int,rank int,ban int(64),mute varchar(64),membership varchar(64),lastLogin varchar(64),guild varchar(64),lastWarp varchar(64),PRIMARY KEY(username))'

image

changing rank to anything else and the error won't appear.