Project

General

Profile

Unable to update users after migration - Error 500

Added by Tobi von Rohr over 1 year ago

Hi everyone

I migrated from Redmine 3.4.4 to a freshly installed 4.1.0 on Debian 11 with the official manual from this wiki. I used mysqldump to export the database and imported it again on the new system and made sure all nessesary files were copied and permissions set correctly.

Everything seems to work well at the moment, except that we get an error 500 when trying to update any user (new password or new email or anything like this).

The production.log says:

Started PATCH "/users/66" for 213.189.140.90 at 2022-09-08 10:54:29 +0200
Processing by UsersController#update as HTML
  Parameters: {"utf8"=>"✓", "authenticity_token"=>"LL5zJSQckWb0QczGGGiCk0DngVSFMwWm8n3UEoK3v5KRpOkRT8w3+6cuxH9vRYWxwaE/m/l81eypGN2WuL9IXw==", "user"=>{"login"=>"svls", "firstname"=>"xxx", "lastname"=>"xxx", "mail"=>"xxx", "language"=>"de", "admin"=>"0", "password"=>"[FILTERED]", "password_confirmation"=>"[FILTERED]", "generate_password"=>"[FILTERED]", "must_change_passwd"=>"0", "mail_notification"=>"only_assigned", "notified_project_ids"=>[""]}, "pref"=>{"no_self_notified"=>"1", "hide_mail"=>"1", "time_zone"=>"", "comments_sorting"=>"asc", "warn_on_leaving_unsaved"=>"1", "textarea_font"=>"", "recently_used_projects"=>"3", "history_default_tab"=>"notes"}, "commit"=>"Speichern", "id"=>"66"}
  Current user: xxx (id=565)
Completed 500 Internal Server Error in 33ms (ActiveRecord: 3.6ms)

NoMethodError (undefined method `identity_url' for #<User:0x000055f8afa22d50>
Did you mean?  identity_url=):

I ran rake db migrate and everything and also searched around for similar issues with no success. Any help is highly appreciated!

Environment:
  Redmine version                4.1.0.stable
  Ruby version                   2.7.4-p191 (2021-07-07) [x86_64-linux-gnu]
  Rails version                  5.2.4.1
  Environment                    production
  Database adapter               Mysql2
  Mailer queue                   ActiveJob::QueueAdapters::AsyncAdapter
  Mailer delivery                smtp
SCM:
  Git                            2.30.2
  Filesystem                     
Redmine plugins:
  redmine_ckeditor               1.2.3


Replies (2)

RE: Unable to update users after migration - Error 500 - Added by Tobi von Rohr over 1 year ago

Fixed it with the help of one friendly fellow in the IRC Chat:

Because I had tried migrating to V 5.0 before (which didnt work because of an old plugin...) and used a DB Dump from the 5.0 version the column identity_url in the users table did not exist, after creating it manually, everything works as expected.

RE: Unable to update users after migration - Error 500 - Added by Nikolay - 3 months ago

Thanks bro! You helped me a lot!

    (1-2/2)