Topic: MySQL compatibility load teams error
I have this error in bnetd.log when I start pvpgn but server works fine even with this message
[error] pvpgn::bnetd::sql_load_teams: error query db (query:"SELECT teamid, size, clienttag, lastgame, member1, member2, member3, member4, wins,losses, xp, level, rank FROM pvpgn_arrangedteam WHERE teamid > 0")
I don't know what affects but if I run following query in mysql I get this message
[Err] 1064 - 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 'FROM pvpgn_arrangedteam WHERE teamid > 0' at line 1
I don't have this error when I used mysql 5.6 before but I have it now after I am using mysql 8. Are there any compatibility issues with mysql version 8?
Added: 30.10.2019 19:33
found the problem, "rank" is reserved word in mysql 8
It's ok if I edit source src/bnetd/sql_common.cpp and instead I use backticks `rank` ?
SELECT teamid, size, clienttag, lastgame, member1, member2, member3, member4, wins,losses, xp, level, rank FROM pvpgn_arrangedteam WHERE teamid > 0