powered by Jive Software

Openfire has a conflict with the reserved word 'rank' in MySQL 8.0.2


#1

Hi,

I installed Openfire with a MySQL 8.0.2 database, I try to create a Roster Group and I recieve an error:

org.jivesoftware.openfire.roster.DefaultRosterItemProvider - 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 'rank, groupName) VALUES (7, 0, 'Friends')' at line 1

This error is produced by an SQL statement in a constant field inside org.jivesoftware.openfire.roster.DefaultRosterItemProvider because the table ofRosterGroups in the Openfire database schema has a column named rank that is a reserved word in MySQL 8.0.

Any SQL statement that use the rank column without backquotes will fail when it is excecuted in a MySQL 8.0 server.

Thanks in advance!


#2

https://issues.igniterealtime.org/browse/OF-1630