Redmine

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.

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.

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

"try the upgrade to 5.0.2 on windows, if it works I will migrate that to linux"
Did this work?