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: [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 _______________________________________________ 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
