[rt-users] User duplication

[Kenneth Crocker]

Roy,


	You're right. It is ONLY the name column, but I still don't like it. It 
gets confusing. When someone wants to add a watcher and they get 3 
possibilities, what happens when they select one of the UserIds that has 
no E_mail address associated with it? It gets messy, so I AM going to 
have to see how many more of these exist and then run some SQL to change 
the references to the correct IDs and delete the ones I don't want. I 
don't think we have rtx-shredder and since we are currently testing 
3.6.4, I'm not sure I want it unless it works with the latest version. 
Is rtx-shredder working on 3.6.4 yet? Anyway Roy, thanks again for your 
help. I'm not sure how to prevent this from happening in the future but 
if there was a way, it would keep me from having to maintain the USERS 
table on a routine basis.


Kenn
LBNL

On 9/14/2007 8:46 AM, 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
>>
>