Solved: 6 Years, 10 Months ago MyBB Merge 1062 - Duplicate entry '' for key 'username' problem.
#1
Solved: 6 Years, 10 Months ago
Hello,

I'm trying to merge 2x mybb forums into one but I always do get this error.
Anyone knows a solution?

Thank you in advance

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1062 - Duplicate entry '' for key 'username'
Query:
INSERT INTO mybb_users (`usergroup`,`additionalgroups`,`displaygroup`,`import_usergroup`,`import_additionalgroups`,`import_displaygroup`,`import_uid`,`username`,`password`,`salt`,`loginkey`,`email`,`regdate`,`lastactive`,`lastvisit`,`website`,`showsigs`,`signature`,`showavatars`,`timezone`,`avatardimensions`,`avatartype`,`avatar`,`lastpost`,`icq`,`aim`,`yahoo`,`skype`,`google`,`hideemail`,`allownotices`,`regip`,`lastip`,`language`,`passwordconvert`,`passwordconverttype`,`postnum`,`invisible`,`birthday`,`birthdayprivacy`,`subscriptionmethod`,`receivepms`,`receivefrombuddy`,`pmnotice`,`pmnotify`,`showquickreply`,`ppp`,`tpp`,`daysprune`,`timeformat`,`dst`,`buddylist`,`ignorelist`,`style`,`away`,`awaydate`,`returndate`,`referrer`,`referrals`,`reputation`,`timeonline`,`showcodebuttons`,`totalpms`,`unreadpms`,`pmfolders`,`notepad`,`threadmode`,`showredirect`,`dateformat`,`dstcorrection`,`warningpoints`,`moderateposts`,`moderationtime`,`suspendposting`,`suspensiontime`,`suspendsignature`,`suspendsigtime`,`coppauser`,`classicpostbit`,`loginattempts`,`usernotes`,`showimages`,`showvideos`,`threadnum`,`usertitle`,`buddyrequestspm`,`buddyrequestsauto`,`awayreason`,`sourceeditor`) VALUES (2,'',0,2,'',0,11,'','','','','[email protected]',1384185536,1403269769,1403250935,'',1,'',1,'2','100|98','upload','./uploads/avatars/avatar_11.png?dateline=1388826568',1397073945,'0','','','','',0,1,X'50a79a5a',X'50a79a5a','english','','',524,0,'','all',0,1,0,1,0,1,0,0,0,'0',0,'1','',0,0,0,'0',0,1,0,237139,1,116,0,'1**Inbox$%%$2**Sent Items$%%$3**Drafts$%%$4**Trash Can','','linear',1,'0',2,0,0,0,0,0,0,0,0,0,1,'',1,1,'16','','1','0','','0')
Reply


Messages In This Thread
MyBB Merge 1062 - Duplicate entry '' for key 'username' problem. - by salichomg - 2015-08-31, 03:35 AM

Forum Jump:


Users browsing this thread: 1 Guest(s)