Recommended upgrade path from 3.0.1.stable to 5.0.2
Added by dm_red mine about 2 years ago
I have inherited a really old Redmine install on Windows and want to migrate to the 5.0.2 Debian appliance by Bitnami, tried the upgrade directly and it failed, what would be the proper upgrade path?
The current install has the following versions:
OS: Windows Server 2008 R2 64bits
Environment:
Redmine version 3.0.1.stable
Ruby version 2.0.0-p594 (2014-10-27) [i386-mingw32]
Rails version 4.2.0
Environment production
Database adapter Mysql2
SCM:
Subversion 1.8.10
Git 1.9.5
Filesystem
Redmine plugins:
no plugin installed
Replies (3)
RE: Recommended upgrade path from 3.0.1.stable to 5.0.2
-
Added by Go MAEDA about 2 years ago
dm_red mine wrote:
I have inherited a really old Redmine install on Windows and want to migrate to the 5.0.2 Debian appliance by Bitnami, tried the upgrade directly and it failed, what would be the proper upgrade path?
What errors occurred during the upgrade? I have updated directly from Redmine 2.x or 3.x to 5.0.
RE: Recommended upgrade path from 3.0.1.stable to 5.0.2
-
Added by dm_red mine about 2 years ago
Go MAEDA wrote:
dm_red mine wrote:
I have inherited a really old Redmine install on Windows and want to migrate to the 5.0.2 Debian appliance by Bitnami, tried the upgrade directly and it failed, what would be the proper upgrade path?
What errors occurred during the upgrade? I have updated directly from Redmine 2.x or 3.x to 5.0.
Hello, I got the errors described in this thread: https://www.redmine.org/boards/2/topics/67406
undefined local variable or method `twofa_scheme'
Did you upgrade from a windows based install to a linux one? Because I believe this might be a reason why my upgrade failed.
RE: Recommended upgrade path from 3.0.1.stable to 5.0.2
-
Added by dm_red mine about 2 years ago
The upgrade from 3.0.1 to 4.0.0 while on Windows 2008 also failed, when I log in I get the message below:
Redmine is unavailable and displays the following message:
_Internal error
An error occurred on the page you were trying to access.
If you continue to experience problems please contact your Redmine administrator for assistance.
If you are the Redmine administrator, check your log files for details about the error._
And this is what the logs are showing:
Started GET "/redmine/" for 127.0.0.1 at 2022-08-08 11:08:39 +0200 Processing by WelcomeController#index as HTML Current user: anonymous Rendering welcome/index.html.erb within layouts/base Rendered welcome/index.html.erb within layouts/base (39.0ms) Completed 200 OK in 702ms (Views: 122.9ms | ActiveRecord: 253.0ms) Started GET "/redmine/" for 127.0.0.1 at 2022-08-08 11:09:37 +0200 Processing by WelcomeController#index as HTML Current user: anonymous Rendering welcome/index.html.erb within layouts/base Rendered welcome/index.html.erb within layouts/base (1.0ms) Completed 200 OK in 20ms (Views: 7.1ms | ActiveRecord: 2.7ms) Started GET "/redmine/login" for 127.0.0.1 at 2022-08-08 11:09:40 +0200 Processing by AccountController#login as HTML Current user: anonymous Rendering account/login.html.erb within layouts/base Rendered account/login.html.erb within layouts/base (7.2ms) Completed 200 OK in 68ms (Views: 13.2ms | ActiveRecord: 1.8ms) Started POST "/redmine/login" for 127.0.0.1 at 2022-08-08 11:09:47 +0200 Processing by AccountController#login as HTML Parameters: {"utf8"=>"✓", "authenticity_token"=>"qTOtlx72d12qC/LzGe6prOIYSvXjzSfZ4JIgBTBWCf2ZjSWv+9qeZlTSN5aVG4Js5qqBWvOC0/mwtPo2mdYVTA==", "back_url"=>"http://localhost/redmine/", "username"=>"redadmin", "password"=>"[FILTERED]", "login"=>"Acceder"} Current user: anonymous Successful authentication for 'redadmin' from 127.0.0.1 at 2022-08-08 09:09:47 UTC Redirected to http://localhost/redmine/ Completed 302 Found in 206ms (ActiveRecord: 84.2ms) Started GET "/redmine/" for 127.0.0.1 at 2022-08-08 11:10:02 +0200 Processing by WelcomeController#index as HTML Current user: redadmin (id=1) Rendering welcome/index.html.erb within layouts/base Rendered welcome/index.html.erb within layouts/base (22.1ms) Completed 200 OK in 87ms (Views: 37.2ms | ActiveRecord: 41.4ms) Started GET "/redmine/" for 127.0.0.1 at 2022-08-08 11:20:12 +0200 Processing by WelcomeController#index as HTML Completed 500 Internal Server Error in 8ms (ActiveRecord: 1.5ms) ActiveRecord::StatementInvalid (Mysql2::Error: Unknown column 'tokens.updated_on' in 'field list': UPDATE `tokens` SET `tokens`.`updated_on` = '2022-08-08 11:20:12' WHERE `tokens`.`user_id` = 1 AND `tokens`.`value` = 'c41206198df5d2e1f0e60796cff53007e71c6d71' AND `tokens`.`action` = 'session'): app/models/user.rb:448:in `verify_session_token' app/controllers/application_controller.rb:77:in `session_expired?' app/controllers/application_controller.rb:67:in `session_expiration'
EDIT: I was able to fix it by adding this column to the database:
USE mydatabase; ALTER TABLE tokens ADD updated_on VARCHAR(60);
Now I will try the upgrade to 5.0.2 on windows, if it works I will migrate that to linux.
Current environment:
Windows 2008 64bits
Environment:
Redmine version 4.0.0.stable
Ruby version 2.3.3-p222 (2016-11-21) [i386-mingw32]
Rails version 5.2.2
Environment production
Database adapter Mysql2
Mailer queue ActiveJob::QueueAdapters::AsyncAdapter
Mailer delivery smtp
SCM:
Git 2.19.1
Filesystem
Redmine plugins:
no plugin installed