RT 6.0.0 db upgrade error (from 5.0.8)

Processing 5.9.6
Now populating database schema.
Processing 5.9.7
Now populating database schema.
[132011] [Wed Jun 11 14:26:41 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 /root/rt-6.0.0/sbin/…/lib/RT/Handle.pm line 556. (/root/rt-6.0.0/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 /root/rt-6.0.0/sbin/…/lib/RT/Handle.pm line 556.
make: *** [Makefile:396: upgrade-database] Error 11
[root@testtracker rt-6.0.0]#

RHEL 8 box

Anything I need to be checking?

Set($WebDomain, ‘testtracker.domain.edu’);
Set($WebPort, 443);
Set($DatabaseName, q{rt5});
Set( $rtname, ‘domain.edu’);
Set($Organization , “domain.edu”);

Set($WebExternalAuth , 1);
#Set($WebFallbackToInternalAuth , 1);
Set($WebFallbackToRTLogin, 1);
Set($WebExternalAuto , 1);
Set($WebRemoteUserAuth, 1);
Set($WebRemoteUserAutocreate, 1);
Set($WebRemoteUserContinuous, 1);
Set($UserAutocreateDefaultsOnLogin, {Privileged => 0});

#Set($AuthMethods, [‘LDAP’, ‘Internal’]);
Set($WebBaseURL , “https://testtracker.domain.edu:$WebPort”);
Set($RTAddressRegexp , ‘^testtracker@domain.edu$’);
Set($OldestTransactionsFirst, ‘0’);
Set($SimplifiedRecipients, 1);
Set($EnableReminders,0);
#Set( @Plugins, qw(RT::Authen::ExternalAuth) );
Set($HomePageRefreshInterval, ‘120’);
Set($HomepageComponents, [qw(QuickSearch QuickCreate MyAdminQueues MySupportQueues MyReminders RefreshHomepage Dashboards SavedSearches ExtPage MyCalendar Calendar CalendarWithSidebar)]);
Set($DefaultQueue, “General”);
Set($FriendlyFromLineFormat, “"from line here" <%s>”);
Set($AutocompleteOwners, 1);
Set($AutocompleteOwnersForSearch, 1);
Set($DropdownLimit, 150);

use MasonX::Profiler; # available on CPAN
Set(@MasonParameters, (preamble => 'my $p = MasonX::Profiler->new($m, $r);'));

@MailPlugins = qw(Auth::MailFrom);
Plugin(‘RT::Extension::TerminalTheme’);
Plugin(‘RTx::Calendar’);

What is your Mariadb version?

[root@testtracker etc]# mysql --version
mysql Ver 15.1 Distrib 10.3.39-MariaDB, for Linux (x86_64) using readline 5.1

  • MariaDB 10.6 or later with InnoDB support

Your version is too old

Ah, I see you are correct.


A supported SQL database

MySQL 8.0.31 or later with InnoDB support
MariaDB 10.6 or later with InnoDB support
Postgres 13 or later
Oracle 18c or later
SQLite 3.0 or later (for testing only, no upgrade path guaranteed)

I will upgrade and reattempt.

Thank you!