MyBB Community Forums

While upgrading, I take this error... So I couldn't upgrade...

Quote:Performing Queries

Performing necessary upgrade queries..

Fatal error: [SQL] [1062] Duplicate entry 'captive' for key 2
ALTER TABLE mybb_users ADD UNIQUE KEY username (username) in /home/felix/public_html/inc/db_mysql.php on line 548

---

There were two usernames called "captive". I deleted one of them and try it again.

Did it work after deleting the duplicate?

Yes, but I think there are so many other duplicate usernames, so I'm struggling to delete them. How can I find all duplicate members and delete them all? Do you have any method for this?

---

I tried this query which displayed me all the duplicate usernames. I deleted all them, and now try again...

SELECT username
FROM mybb_users
GROUP BY username HAVING count(*) >1

How would they have managed to register with a name that already existed

After all I deleted 17 duplicate usernames...