- edited description
MySQL 8.0+ syntax error, because he has new Reserved words
Issue #296
resolved
Last version with Java10 and MySQL8 support, has problem with SQL, because MySQL 8.0+ has new Reserved words like rank and more other, which used as column name in L2JServer
Some error in GS load:
Caused by: java.sql.SQLException: 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 ',party FROM clan_privs WHERE clan_id=268486851' at line 1 Query is: SELECT privs,rank,party FROM clan_privs WHERE clan_id=?, parameters [268486851]
Need use escape for column name in SQL or replace all new reserved words in db
Fix it pls!
Comments (6)
-
reporter -
reporter - edited description
-
reporter - edited description
-
reporter - edited description
-
-
assigned issue to
-
assigned issue to
-
- changed status to resolved
- Log in to comment