It looks like RT 5.0.1 can’t be installed to Ubuntu 20 LTS due to the fact that the mysql server version is 8 and Groups is a reserved word in its SQL syntax. Has anyone managed to work around this without downgrading mysql? Are there any plans to sort out the issue by the developers of RT?
Excerpt of the error message:
DBD::mysql::st execute failed: 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 (
id INTEGER NOT NULL AUTO_INCREMENT,
Name varchar(200) NULL ,
De’ at line 1 at /some/path/src/rt-5.0.1/sbin/…/lib/RT/Handle.pm line 551.
make[1]: *** [Makefile:390: initialize-database] Error 9