Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Not Solved Unknown column 'msn' in 'field list'
#1
Not Solved
MyBB has experienced an internal SQL error and cannot continue.

SQL Error:1054 - Unknown column 'msn' in 'field list'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,msn,hideemail,allownotices,regip,lastip,longregip,longlastip,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,uid,threadnum,usertitle,skype,google,buddyrequestspm,buddyrequestsauto,showimages,showvideos,awayreason,sourceeditor) VALUES ('4','','','4','','','1','Aaron_mybb_import553','a137e90251c49e5a5376ec1766720bc3','OqLRRdKI','ef7v7dUaK5dU2RNvIcfgksYoI3XyGDL3GoNDXEwsMXavOvXJwX','[email protected]','1409624795','1409791264','1409791264','','1','','1','0','140|105','upload','./uploads/avatars/avatar_1.jpg?dateline=1409626735','1409777623','','','','','0','1','ʴl<','ʴl<','0','0','','','','526','0','','all','0','1','0','1','1','1','0','0','0','0','0','','','6','0','0','','0','0','0','44638','1','353','0','1**Inbox$%%$2**Sent Items$%%$3**Drafts$%%$4**Trash Can','','linear','0','0','0','0','0','0','0','0','0','0','0','0','1','','','160','','','','1','0','1','1','','0')




I am getting that error whenever I try to merge MyBB to MyBB.
[Image: 468now.png]
#2
Not Solved
database being merged has custom profile field msn
you can add that field to your main database or drop the field in the merging database.
#3
Not Solved
@.m.: no, he's using the 1.6 merge system with a 1.8 board.

@op: please use 1.6 to merge your board and then upgrade to 1.8.
Support PMs will be ignored!


Forum Jump:


Users browsing this thread: 1 Guest(s)