Re: [mantisbt-help] Change user id

[Fabian C. <Cen...@in...>]

At 13:17 26.01.2018, Fabian Cenedese wrote:
>Hi
>
>I wanted to change the access level of a user. But the
>Manage Users page always returned an error that the
>email already exists. Of course, it was used by this user
>that I wanted to change. After different tries to solve this
>I finally just deleted the user and recreated it with the
>desired settings. Unfortunately all bugs that were entered
>with the previous account now only show up with user11.
>Even with the same name the new user is not the same
>as the old. Is there a way to change the id or whatever is
>used for unique identification to the previous user account?

I now changed the user id with these commands:

  # start mysql to access the database, take password from mantis setup description
  >mysql -uroot -pPassword
  # start working with the mantis database
  USE mantis;
  # show the content of the user table
  SELECT * FROM mantis_user_table;
  # change the id of the new user
  UPDATE mantis_user_table SET id=OldId WHERE id=NewId;
  # check that id was changed
  SELECT * FROM mantis_user_table;
  # and we're done
  EXIT

Anything bad to expect from here? Can't be worse than
not finding the new user anymore as happened with the
old user before.

Thanks

bye  Fabi