Project

General

Profile

error 500 when editing user

Added by john reborn 6 months ago

Hello

Redmine works fine for me for many years! Thank you!:)
But now something happen and it shows me 'error 500'< when editing user, even myself.

Redmine 4.0.6 in Docker.

In logs only that

Processing by UsersController#update as HTML
  Parameters: {"utf8"=>"✓", "authenticity_token"=>"MSCtQmzb3Hi4T82XWy5pYTQirVY/ZjD/Y7t1tc4dQR3TSnvkYEwg4RKKrUlVQ4nycD8jW/Z5fop5GBuhD07okw==", "user"=>{"login"=>"423400", "firstname"=>"firstname", "lastname"=>"lasname", "mail"=>"fdsfds@google.com", "language"=>"en", "admin"=>"0", "auth_source_id"=>"1", "password"=>"[FILTERED]", "password_confirmation"=>"[FILTERED]", "generate_password"=>"[FILTERED]", "must_change_passwd"=>"0", "mail_notification"=>"only_my_events", "notified_project_ids"=>["{163=>163}", "{168=>168}", "{165=>165}", "{141=>141}", "{147=>147}", "{142=>142}", "{148=>148}", "{149=>149}", "{164=>164}", ""]}, "pref"=>{"favourite_project_id"=>"", "no_self_notified"=>"1", "hide_mail"=>"0", "time_zone"=>"Warsaw", "comments_sorting"=>"asc", "warn_on_leaving_unsaved"=>"1", "textarea_font"=>"", "ghost_mode"=>"0"}, "commit"=>"Save", "id"=>"134"}
  Current user: 312100 (id=89)
Completed 500 Internal Server Error in 84ms (ActiveRecord: 41.4ms)

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

app/controllers/users_controller.rb:145:in `update'
lib/redmine/sudo_mode.rb:63:in `sudo_mode'
Started GET "/" for 192.168.96.1 at 2023-10-25 12:32:56 +0000
Processing by WelcomeController#index as HTML

Please help. I know, that this version is too old, but it works fine for me for many years.
And be, anybody knows solution. Thanx!


Replies (6)

RE: error 500 when editing user - Added by Holger Just 6 months ago

Legacy OpenID support was dropped from Redmine in version 5.0.0. When this feature was removed, we also removed the identity_url column from the users table.

With your error, it appears you are using an old Redmine version (likely the 4.,0.6 version you stated) with a Redmine database which was already migrated to the database schema used Redmine >= 5.0. This will not work and can likely introduce data consistency issues and random errors like this. You should only use an updated database with the exact Redmine version you used to migrate it.

Downgrading a version (that is: using an older Redmine version again after you already migrated your database with a newer version) is only partially supported. For that, you first need to reverse the migrations (which only possible on on the newer version which defines those database migrations) and then downgrade your version.

With that being said, as you apparently already upgraded your database, I would recommend to fully upgrade your running Redmine to a newer supported version, which then also fixes a lot of security issues along the way.

RE: error 500 when editing user - Added by john reborn 6 months ago

Thank you for explanation!

I did try docker with the new version. I didn't realize it would affect the base

I'll update redmine of course! Thanks for the advice! But later.
Is there any way to restore functionality now? In the new version to revert the base changes? Is there such functionality?

And then return 4.0.6?
And separately I will install version 5.
Thank you very much once more!!! :)

RE: error 500 when editing user - Added by john reborn 6 months ago

BTW, maybe I can fix the DB with hands somehow ?

RE: error 500 when editing user - Added by john reborn 6 months ago

I have a dump of DB from 4.0.6 saved before experiments:) .
But already some tasks have been added.
I assume the main table 'users' to look identity_url column?

RE: error 500 when editing user - Added by Ross Volkman 6 months ago

The error you're encountering in Redmine 4.0.6 might be related to compatibility issues or custom code conflicts. Consider upgrading to a newer version for a more stable solution. For those seeking a reliable partner in the journey toward educational success, https://www.topessaywriting.org/personal-statement-writing-service is a valuable resource for students aspiring to make a lasting impression Crafting a compelling personal statement is crucial for college and scholarship applications, and this service understands the significance of standing out in a competitive academic landscape. With a team of skilled writers, they ensure that students' voices are authentically captured, highlighting their achievements, aspirations, and individuality.

    (1-6/6)