Trying to install the latest RT on Ububtu with Mysq8 as the database. I kep getting the following error when initializing the database (either via web console OR commendline:
Stack:
[/opt/rt4/sbin/…/lib/RT/Handle.pm:552]
[/opt/rt4/share/html/Install/Initialize.html:112]
[/opt/rt4/share/html/Install/autohandler:60] (/opt/rt4/sbin/…/lib/RT/Interface/Web/Handler.pm:208)
[219626] [Tue Dec 18 18:53:47 2018] [warning]: Issuing rollback() due to DESTROY without explicit disconnect() of DBD::mysql::db handle dbname=rt4;host=localhost at /usr/local/share/perl/5.26.1/DBIx/SearchBuilder/Handle.pm line 331. (/usr/local/share/perl/5.26.1/DBIx/SearchBuilder/Handle.pm:331)
[219626] [Tue Dec 18 18:53:47 2018] [error]: 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 /opt/rt4/sbin/…/lib/RT/Handle.pm line 552.