How to get rid of duplicate users in bulk

  • Time
  • Show
Clear All
new posts
  • MarathonStudios
    New Member
    • Nov 2010
    • 26
    • 4.0.x

    [Forum] How to get rid of duplicate users in bulk

    I recently used IMPEX to transfer 2200 users and around 70K posts from a PHPBB install on Now, after the transfer, the user accounts got duplicated multiple times - each account has several account duplicates named "import_Name" in the database. There aren't any tools in Impex or the ACP that can merge or delete all of these duplicate users, and my users cannot log in as a result of this. How can I delete all of these duplicate users?
  • Steve Machol
    Former Customer Support Manager
    • Jul 2000
    • 154488

    There is no option to do this en masse. That is there because all those users were already registered on your forums with those names, hence the 'imported_' prefix.

    Assuming you did not finalize this import in the past, can you explain why you already have accounts with those usernames?
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography

    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


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