During mangosd startup I noticed the following sql error in the log:
2018-09-23 20:57:23 ERROR:SQL: SELECT group_instance.leaderGuid, instance FROM group_instance LEFT JOIN characters ON group_instance.leaderGuid = characters.guid LEFT JOIN groups ON group_instance.leaderGuid = groups.leaderGuid WHERE characters.guid IS NULL OR groups.leaderGuid IS NULL
2018-09-23 20:57:23 ERROR: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 'groups ON group_instance.leaderGuid = groups.leaderGuid WHERE characters.guid IS' at line 1
I am runnig on MySQL 8.0.
It seems like the table name "groups" is a reserved word in MySQL 8.0 so the query fails.
https://forums.mysql.com/read.php?101,665004,665004
( 'GROUPS', 'Reserved', 'added in 8.0' ),
EDIT:
Seeing the a similar issue here:
2018-09-23 20:57:24 Loading Spell Chain Data...
2018-09-23 20:57:24 ERROR:SQL: SELECT spell_id, prev_spell, first_spell, rank, req_spell FROM spell_chain
2018-09-23 20:57:24 ERROR: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 ', req_spell FROM spell_chain' at line 1
The word "rank" is also reserved in MySQL 8.0
( 'RANK', 'Reserved', 'added in 8.0' ),
This query seems to work if you use an alias for the table name
SELECT spell_id, prev_spell, first_spell, sc.rank, req_spell FROM spell_chain as sc
Recommended Comments
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now