Hi there,
in my mantisbt (Version 1.0.1) I have a User that has registered twice with different usernames. Let's say 'doe' and 'john doe'.
He worked under both accounts. When I try to filter for hist issues I certainly don't get all the information I want because I only filter on one username.
What I would like to do is eleminate 'john doe' and repace all his occurances by 'doe'.
Can anyone give me a hint how to to that?
I'm familiar with SQL so I think I will do sth. like: UPDATE tablexy SET reporter_id = 43 WHERE reporter_id = 43
In which tables do I have to search for the user ID.
Thanks in advance
Andreas
Eleminate double user account
Moderators: Developer, Contributor
I don't have this in front of me right now, however after logging into MySQL,
run the following command:
use database [database name];
show tables;
Take a look at the table listing and see if there is a table that 'sounds' correct. For more detail, you can use the 'describe' command, or a simple
select * from [tablename] where reporter_id="43";
If you look and still can't find it, please re-post under this item and I will pull it apart and find it for you.
Good Luck!
run the following command:
use database [database name];
show tables;
Take a look at the table listing and see if there is a table that 'sounds' correct. For more detail, you can use the 'describe' command, or a simple
select * from [tablename] where reporter_id="43";
If you look and still can't find it, please re-post under this item and I will pull it apart and find it for you.
Good Luck!