[SOLVED] Migrating everything from Redmine 2.x to 3.3
Added by Imre Bertalan about 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 about 8 years ago
Ok, figured out. The server had wrong timezone set and therefore Redmine wasn't allowing anyone to enter.