Upgrading database from 5.0.8 to 6.0.1 Error

RT Users
1

I am having an issue upgrading the database from 5.0.8 to 6.0.1:

Proceed [y/N]:y
Processing 5.9.0
Now inserting data.
Processing 5.9.1
Now inserting data.
Processing 5.9.2
Now populating database schema.
[105860] [Thu Aug 14 18:43:07 2025] [critical]: DBD::mysql::st execute failed: Duplicate column name ‘TimeWorker’ at /TMP/rt-6.0.1/sbin/…/lib/RT/Handle.pm line 556. (/TMP/rt-6.0.1/sbin/…/lib/RT.pm:409)
DBD::mysql::st execute failed: Duplicate column name ‘TimeWorker’ at /TMP/rt-6.0.1/sbin/…/lib/RT/Handle.pm line 556.
make: *** [Makefile:396: upgrade-database] Error 255

Have anybody experience this issue.

Thanks,

AE

2

Not sure how you’d of injected the column already, but if it matches:

ALTER TABLE Transactions ADD COLUMN TimeWorker integer NOT NULL DEFAULT 0;
ALTER TABLE Transactions ADD COLUMN TimeWorkedDate DATE NULL;
UPDATE Transactions SET TimeWorker = Creator WHERE TimeTaken != 0;

Then you’re fine to skip 5.9.2 schema changes

3

Progress then I got this:

Proceed [y/N]:y
Processing 5.9.3
Now inserting data.
Processing 5.9.4
Now populating database schema.
[112273] [Thu Aug 14 20:31:18 2025] [critical]: DBD::mysql::st execute failed: Table ‘SavedSearches’ alr
eady exists at /TMP/rt-6.0.1/sbin/…/lib/RT/Handle.pm line 556. (/TMP/rt-6.0.1/sbin/…/lib/RT.pm:409)
DBD::mysql::st execute failed: Table ‘SavedSearches’ already exists at /TMP/rt-6.0.1/sbin/…/lib/RT/Hand
le.pm line 556.
make: *** [Makefile:396: upgrade-database] Error 255

4

have you done this upgrade already? Since these tables already exist

5

Were you using RT:Extension:TimeTracker under 5?

It’s been added to core for 6 so you need to remove it from your plugins
list and skip 5.92 update since that would have been done when the
extension was installed.

Jeff

6

Yes. Should I dropdb and start over?

7

I fixed it by setting up the dashboard to HomePage. Al is well!

Thank you very much for your help!

Adil

8

Skipping to 5.9.4 worked! But after signing in I get: Unable to load selected dashboard, it may have been deleted.

Thanks for your help,

Adil