Project

General

Profile

How to migrate Redmine v1.2 -to- v3.4/4.1 ?

Added by Kai Tiffany about 4 years ago

I'm trying to upgrade a Redmine v1.2.1-2 installation to an updated Bitnami Redmine stack (version 3.4 or 4.1). The problem I'm having is with the DB:migrate command within Rails 5.2. I aready reviews these directions:

https://www.redmine.org/projects/redmine/wiki/redmineupgrade
https://www.redmine.org/projects/redmine/wiki/RedmineUpgrade?version=53

Step 1 - Import the older database with this MySQL command (works):

mysql> source c:\temp\redmine.sql

Step 2 - Migrate the older database (Rails 2.3?) using current Rails 5.2 with command:

x:\Bitnami\redmine...\apps\redmine\htdocs> bundle exec rake db:migrate RAILS_ENV=production

Our trouble is that post-migration table "tokens" is missing column "updated_on" and table "users" is missing column "must_change_passwd" and without those columns, the Redmine application code will only error out. I can fix those two table issues but then there are many others and I'd hope to have a solution that doesn't involve manually mapping out all the table-columns pre-migration and then manually running dozens of individual "ALTER TABLE" commands to fix all the damaged tables (plus fill-in required data in all the columns which were added back).

Does anyone know either:
1. A way to properly migrate an older database into the current database version, or
2. Have a list of all the table-column fixes required to go from Redmine v1.2.1-2 to version 3.4/4.1?

I looked in the folowing tickets for help without finding anything useful:

Feature #23630 - Migrate to Rails 5.2
Patch #29424 - Convert migration file from 4.2 to 5.2