MySQL 8.0+ syntax error, because he has new Reserved words

Issue #296 resolved
UchihaSV created an issue

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: GS error mysql.jpg

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)

  1. Log in to comment