ZumbaCafew 1 Posted November 9, 2020 Author Share Posted November 9, 2020 (edited) 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 Link to comment Share on other sites More sharing options...
Honorable Member Distraught 5950 Posted November 11, 2020 Honorable Member Share Posted November 11, 2020 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. 1 Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now