Problem upgrading RT 4.4.7 → 5.0.8: missing column lookuptype

RT Users
1

Hello everyone,

I’m currently upgrading our RT 4.4.7 instance to version 5.0.8.
When running the database upgrade (rt-setup-database --action upgrade), I encounter the following error:
Processing 4.5.5
[2188] [Fri Sep 5 18:47:47 2025] [warning]: DBD::mysql::st execute failed: Unknown column ‘lookuptype’ in ‘SELECT’ at /usr/local/share/perl/5.36.0/DBIx/SearchBuilder/Handle.pm line 634. (/usr/local/share/perl/5.36.0/DBIx/SearchBuilder/Handle.pm:634)
[2188] [Fri Sep 5 18:47:47 2025] [warning]: RT::Handle=HASH(0x55d3a4bf7cf8) couldn’t execute the query ‘SELECT lookuptype FROM CustomRoles WHERE id = ?’ at /usr/local/share/perl/5.36.0/DBIx/SearchBuilder/Handle.pm line 647.
DBIx::SearchBuilder::Handle::SimpleQuery(RT::Handle=HASH(0x55d3a4bf7cf8), “SELECT lookuptype FROM CustomRoles WHERE id = ?”, 1) called at /srv/www/customer/rt/data/rt-5.0.8/sbin/../lib/RT/Handle.pm line 3313
…
Now inserting data.
Processing 4.5.6
Now inserting data.
Processing 4.5.7
…etc

It seems the upgrade script is trying to select the column lookuptype from the CustomRoles table, but that column doesn’t exist in my current schema.

Has anyone seen this before, or is there perhaps a missing step between 4.4.7 and 5.0.8 that I need to apply manually?

Environment:

  • OS: Debian 12

  • Database: MariaDB 10.11.13

  • Source RT version: 4.4.7

  • Target RT version: 5.0.8

Any hints would be greatly appreciated.

Best regards,
René

2

Here are some 4-5 upgrade notes from a previous co-worker

This column needs to be added to the table or the automatic upgrade process fails with a missing column error.

psql -U postgres -p 5433 -d rt504_prod -c ‘ALTER TABLE customroles ADD COLUMN lookuptype VARCHAR(255);’
psql -U postgres -p 5433 -d rt504_prod -c “UPDATE customroles SET lookuptype=‘RT::Queue-RT::Ticket’;”