MyBB Community Forums

Hello guys,

I tried to import the user table to my local test forum. First I export that table and then I went to phpmyadmin and then I click on table mybb_users and import, but then I got the error.

Error
SQL query:

-- -- Dumping data for table mybb_adminoptions -- INSERT INTO mybb_adminoptions (uid, cpstyle, codepress, notes, permissions, defaultviews, loginattempts, loginlockoutexpiry) VALUES (0, '', 1, '', 'a:5:{s:6:"config";a:17:{s:3:"tab";s:1:"0";s:8:"settings";s:1:"0";s:7:"banning";s:1:"0";s:14:"profile_fields";s:1:"0";s:7:"smilies";s:1:"0";s:8:"badwords";s:1:"0";s:6:"mycode";s:1:"0";s:9:"languages";s:1:"0";s:10:"post_icons";s:1:"0";s:14:"help_documents";s:1:"0";s:7:"plugins";s:1:"0";s:16:"attachment_types";s:1:"0";s:9:"mod_tools";s:1:"0";s:7:"spiders";s:1:"0";s:9:"calendars";s:1:"0";s:7:"warning";s:1:"0";s:15:"thread_prefixes";s:1:"0";}s:5:"forum";a:5:{s:3:"tab";s:1:"0";s:10:"management";s:1:"0";s:13:"announcements";s:1:"0";s:16:"moderation_queue";s:1:"0";s:11:"attachments";s:1:"0";}s:5:"style";a:3:{s:3:"tab";s:1:"0";s:6:"themes";s:1:"0";s:9:"templates";s:1:"0";}s:5:"tools";a:15:{s:3:"tab";s:1:"0";s:13:"system_health";s:1:"0";s:5:"cache";s:1:"0";s:5:"tasks";s:1:"0";s:[...]

MySQL said:

#1062 - Duplicate entry '0' for key 'PRIMARY'

I'm not a programmer and I don't know what does mean or how to fix this? Can anyone please help me with this?

Many thanks

You need to use the Merge system to merge two MyBB installs together. This error is because you are trying to insert a row in the table which already exists.

See http://docs.mybb.com/Running_the_Merge_System.html for more info