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 ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot _______________________________________________ mantisbt-help mailing list mantisbt-help@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mantisbt-help
