Mysql56 to Mysql8

[ZumbaCafew 1]

Hello,

now I'm encountering a problem while creating a character. I go back to the empire selection and as a mistake I have this: 

 

SYSERR: Nov  9 19:42:33 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: 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 'iq`, `job`, `voice`, `dir`, `x`, `y`, `z`, `hp`, `mp`, `random_hp`, `random_sp`,' at line 1
query: INSERT INTO player (`id`, `account_id`, `name`, `level`, `st`, `ht`, `dx, `iq`, `job`, `voice`, `dir`, `x`, `y`, `z`, `hp`, `mp`, `random_hp`, `random_sp`, `stat_point`, `stamina`, `part_base`, `part_main`, `part_hair`, `part_acce`, `gold`, `cheque`, `gem`, `pin`, `playtime`, `skill_level`, `quickslot`) VALUES (0, 1, 'Pumba', 1, 6, 4, 3, 3, 0, 0, 0, 963541, 278088, 0, 760, 260, 0, 0, 0, 800, 1, 1, 0, 0, 0, 0, 0, '1234', 0, '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\
SYSERR: Nov  9 19:42:33 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: 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 '1=0 WHERE `id`=1' at line 1
query: UPDATE player_index SET `pid`1=0 WHERE `id`=1

 

Thank you

Edited November 9, 2020 by ZumbaCafew

[Distraught 5688]

Actually I still use mysql5.7 because it has better performance than mysql8 but less security. Normally the mysql server is not reachable from the outside so security is not really the thing.