[rt-users] User duplication

Kenneth Crocker KFCrocker at lbl.gov
Fri Sep 14 13:29:33 EDT 2007


Drew,


	That sounds like a good idea. Should save a lot of SQL coding. How does 
the merge work? Does it ultimate delete the old USER records or disable 
them?


Kenn
LBNL

On 9/14/2007 9:14 AM, Drew Barnes wrote:
> 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
> 



More information about the rt-users mailing list