Announcement

Collapse
No announcement yet.

duplicate users

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • duplicate users

    I am having an issue with duplicate users with Different ID's is there a SQL query I could run or some script to delete the duplicate users?

    *EDIT* found an old thread where I was told nothing could be done

    http://www.vbulletin.com/forum/showthread.php?t=108340
    Last edited by Slybone; Sun 23 Jan '05, 5:47am.

  • #2
    I can't test this as I don't have duplicate users however, this should bring up what you require...
    Code:
    SELECT userid,username
    FROM user
    GROUP BY userid
    HAVING (count(username)) > 1
    Once identified, you may be able to use the ACP -> Users -> Merge feature.
    Lats...

    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...
    X