Project

General

Profile

[SOLVED] Migrating everything from Redmine 2.x to 3.3

Added by Imre Bertalan almost 8 years ago

Hello Forum!

I've been given a task to create a new redmine installation on a different server and move our database (projects, issues, users, etc), plugins and themes to it. I was able to create a new installation of Redmine 3 and it was working like a charm. Even installed the plugins and the themes as well and they all worked.

After creating a new database with the name redmine_migrated and imported the sql from the previous redmine, it just doesn't work. In the log, I recieve the following:

Started GET "/" for 37.220.134.162 at 2016-09-15 10:19:06 +0000
Processing by WelcomeController#index as HTML
Completed 500 Internal Server Error in 3ms (ActiveRecord: 0.6ms)

ActiveRecord::StatementInvalid (Mysql2::Error: Unknown column 'updated_on' in 'where clause': UPDATE `tokens` SET `tokens`.`updated_on` = '2016-09-15 10:19:06.510037' WHERE `tokens`.`user_id` = 5 AND `tokens`.`value` = '6fb6e3f378403307d6ede2c42fdc5bbd2d1b6464' AND `tokens`.`action` = 'session' AND (updated_on > '2016-09-14 10:19:06.509725')):
  app/models/user.rb:424:in `verify_session_token'
  app/controllers/application_controller.rb:77:in `session_expired?'
  app/controllers/application_controller.rb:67:in `session_expiration'

Do you know how to resolve this issue?

Cheers Mates!

Bert


Replies (1)

RE: Migrating everything from Redmine 2.x to 3.3 - Added by Imre Bertalan almost 8 years ago

Ok, figured out. The server had wrong timezone set and therefore Redmine wasn't allowing anyone to enter.

    (1-1/1)