MyBB Community Forums

hi all.
i uploaded all changed files and start upgrade php.
but it didnt work. Here is the error:

Fatal error: [SQL] [1062] Duplicate entry 'siyah_in_ci' for key 2
ALTER TABLE mybb_users ADD UNIQUE KEY username (username) in inc\db_mysql.php on line 544

how can i fix this problem?
thanks for help..

What stage did it happen at??

(2008-09-19, 06:26 PM)Matt_ Wrote: [ -> ]What stage did it happen at??

at the beginning. after first click to "Next"

You have duplicate users in your MyBB installation and this isn't allowed - You should delete or rename the duplicate users via your ACP or phpMyAdmin.

i dont know which users duplicated. how can i find them?

In phpMyAdmin SQL query window, use this query:

SELECT * mybb_users WHERE username='siyah_in_ci'

Delete one of the results that comes up.

i have same problem:
Fatal error: [SQL] [1062] Duplicate entry 'ظ…' for key 2
ALTER TABLE mybb_users ADD UNIQUE KEY username (username) in /home/ftalk/public_html/inc/db_mysql.php on line 544

but i can't find 'ظ…'
is there any way to find that?