Skip to forum content

You are not logged in. Please login or register.


forums.pvpgn.pro → [EN] Tech Support → MySQL compatibility load teams error

Pages 1

You must login or register to post a reply

RSS topic feed

Posts: 1

1 (edited by Rengar 30.10.2019 20:42)

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

Posts: 1

Pages 1

You must login or register to post a reply

Who now at forum

Currently view post: 0 guests, 0 registered users

forums.pvpgn.pro → [EN] Tech Support → MySQL compatibility load teams error