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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
