Redmine migration
Added by Av3k . almost 8 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 almost 8 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.