MyBB Community Forums

Here today i face problem while upgrading my Forum Board from 1212 to 1404

the problem is

--

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

--

can someone plz help me i am in between upgrade

Have you uploaded all the files, and did you choose 1.2.12 from the upgrade list??

Yes already i done everything fine

i checked the SQL and i found same username with 2 different ID. Can u please tell me what SQL command i use to change username " karinamaheykm " to something else

(2862, 'karinamaheykm', '57f490bd05c5778f3c3432dffa3deda2', 'FepOamV7', 'HCDMyzmVVyUMsznDx8ua5Bl7maxkIiIXDKDCmN13PuptGAypiG', '[email protected]', 0, '', '', '', 2, '', 0, '', 1231301689, 1235689752, 1235627226, 0, 'http://apnadesi-tv.com', '0', '', '', '', '', 'all', '[img]http://i34.tinypic.com/143idkk.gif[/img]\r\n(above image is default signature from board)', 1, 1, 0, 1, 1, 1, 0, 1, 'linear', 1, 1, 1, 1, 30, 30, 0, '', '', '+1', 0, 2, '', '', 0, 0, 0, '0', '', '', '', 0, 0, '76.246.41.151', '', 0, 0, 'english', 61996, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),

(2863, 'karinamaheykm', 'c932ab3a606359f886b11e81dac19222', 'UWvSlctV', 'OmwSueTXFnIl8mJzBjUV5IgC21kuemB9adZFKOLlpzywutSxgF', '[email protected]', 0, '', '', '', 2, '', 0, '', 1231301689, 1231301689, 1231301689, 0, 'http://apnadesi-tv.com', '0', '', '', '', '', 'all', '[img]http://i34.tinypic.com/143idkk.gif[/img]\r\n(above image is default signature from board)', 1, 1, 0, 1, 1, 1, 0, 1, 'linear', 1, 1, 1, 1, 30, 30, 0, '', '', '+1', 0, 2, '', '', 0, 0, 0, '0', '', '', '', 0, 0, '76.246.41.151', '', 0, 0, 'english', 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),

Just manually change it?? If you use phpMyAdmin or something you can just edit it direct. Not really sure how you managed to get a duplicate, though.

Can u plz write the SQL querry to so that i can run and remove one of the above data from SQL.

As I just said, you can manually edit it and just change the username entry to something else. You may as well just change the name of one, not delete one, incase you need both.

Thanx for the help , i am new so it takes time to understand the thing i got ur point and now i am on the right spot. Thanx for the help

---

I am facing one error in Bottom

MyBB SQL Error

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
    2006 - MySQL server has gone away
Query:
    UPDATE mybb_users SET lastvisit='1235764992', lastactive='1235766106' WHERE uid='3' 

it is showing my userid 3 means it is showing to everyone .. how to get rid ?