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