[rt-users] User duplication

[Drew Barnes]

Or, if they have any tickets associated with the other IDs, use
http://search.cpan.org/~jesse/RT-Extension-MergeUsers-0.02/ to merge
them as far as the system in concerned.

Roy El-Hames wrote:
> 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
>>
>
> _______________________________________________
> 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