Upgrade from 5.0.7 to 6.0.1 fails on DB

Hi,

Im trying to upgrade from RT 5.0.7 to 6.0.1 but when I run make upgrade-database it fails with this error:

Processing 5.9.7
WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version.
Now populating database schema.
[7732] [Thu Sep 25 06:36:54 2025] [critical]: DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'COLUMN Queue To ObjectId' at line 1 at /home/itserv/rt-6.0.1/sbin/../lib/RT/Handle.pm line 556. (/home/itserv/rt-6.0.1/sbin/../lib/RT.pm:409)
DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'COLUMN Queue To ObjectId' at line 1 at /home/itserv/rt-6.0.1/sbin/../lib/RT/Handle.pm line 556.
make: *** [Makefile:396: upgrade-database] Error 9

Some system info: Ubuntu 20.04, MariaDB Ver 15.1 Distrib 10.3.39-MariaDB

./configure has –with-db-type=MariaDB included.

Does anyone have a clue here?

Thanks,

Magnus Olsson

MariaDB 10.6 or later with InnoDB support

From the README, It looks like your Mariadb is too old