Project

General

Profile

Redmine migration

Added by Av3k . over 7 years ago

Hello,

I need help on a redmine migration.

I migrate from 2.6 to a brand new server on the last version.

What I did is a new installation foolowing this link : http://www.redmine.org/projects/redmine/wiki/install_Redmine_25x_on_Centos_65_complete

Its ok and fonctionnal. I migrate the conf files etc...

Now i have exported the database by mysqldump and imported into the new one (same db and user name/pwd).

Seems ok but when I try to login i got a :
"Internal error

An error occurred on the page you were trying to access."

The only things I got on redmine logs is :
@Processing by AccountController#login as HTML
Parameters: {"utf8"=>"✓", "authenticity_token"=>"/sgopslOctrFbO5M2A6/gZGQGf66Tt+tOoTzcQ4GMizr7ELTJEG+msVLzxfv9Ffvhzh38y+qrfneBmTGlGJ8xw==", "back_url"=>"http://XXX.XXX.X.XXX/", "username"=>"XXXXX", "password"=>"[FILTERED]", "login"=>"Connexion »"}
Current user: anonymous
Successful authentication for 'XXXX' from 10.0.9.44 at 2017-01-26 16:36:39 UTC
Completed 500 Internal Server Error in 54ms (ActiveRecord: 6.6ms)

ActiveRecord::StatementInvalid (Mysql2::Error: Unknown column 'tokens.updated_on' in 'order clause': SELECT `tokens`.`id` FROM `tokens` WHERE `tokens`.`user_id` = 45 AND `tokens`.`action` = 'session' ORDER BY `tokens`.`updated_on` DESC LIMIT 18446744073709551615 OFFSET 9):
app/models/token.rb:84:in `delete_previous_tokens'
app/models/user.rb:410:in `generate_session_token'
app/controllers/application_controller.rb:82:in `start_user_session'
app/controllers/application_controller.rb:162:in `logged_user='
app/controllers/account_controller.rb:259:in `successful_authentication'
app/controllers/account_controller.rb:205:in `password_authentication'
app/controllers/account_controller.rb:191:in `authenticate_user'
app/controllers/account_controller.rb:40:in `login'
lib/redmine/sudo_mode.rb:63:in `sudo_mode'
@

Can someone please help?

Thanks in advance.


Replies (1)

RE: Redmine migration - Added by Anonymous over 7 years ago

just an idea: when doing the mysqldump, did you include drop/create-table statements? I found this crucial when replacing an exisiting DB with a mysql-dump via import. drop/create table is a phpmyadmin option which is not selected by default.

And: did you do a DB-migration (rake-task)? If your target server uses a higher redmine version this is necessary.

cheers

Immanuel.

    (1-1/1)