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!