[rt-users] User duplication

[Roy El-Hames]

Hi Kenneth;

I am guessing you mean the Name column and not the Id column within the 
Users table, (if its the Id column then you need to check the sql 
engine, that field is pri auto_incremented and the sql engine should n't 
be allowing duplicate to happen) ..
I have seen a duplicate Name, in my case it was due to someone changing 
things from mysql (which is wrong), it may also happen with some sort of 
import.
what I did to fix is by using sql I changed the name:
update Users set Name = x where Name = Y (for each one you do not want 
to keep); then used RT to remove group membership if any exist then 
disable the users ..
then if you wish delete them from the database using sql or better still 
use rtx-shredder (if it works for you).

Roy
Kenneth Crocker wrote:
> To all,
>
>
>     I've noticed that RT, in this case 3.4.4, allows duplicate 
> UserIds. I've got a user that is in the system with 3 Ids that ALL 
> look exactly the same. One with an E_mail address, the other 2 without 
> and they were ALL created by the system. I have three questions:
>     1) Is this normal or OK?
>     2) what can I do to stop this behavior?
>     3) How can I get rid of the two USerIDs I do NOT want? (SQL?)
>
>     Well, maybe that's 4 questions. Anyway, does anyone have any 
> experience in this situation and can you give me some advice on the 
> above? Thanks.
>
> Kenn
> LBNL
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com
>