2019-08-31, 01:40 PM
Hello guys. I'm trying move MYBB from Xenforo 2. I used Merge script this operation. But i got this error when i import users. How can i do?
SQL Error:
1054 - Unknown column 'aim' 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`,`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`) VALUES (4,'2,2,2,2,2,2,2',4,3,'2,12,13,14,15,16,17',3,1,'Berkay ÃobanoÄlu','','','','[email protected]',1521839944,1561754940,1561754940,'',1,'',1,'3','','','',0,'','','','','',1,1,X'',X'','','$2y$10$3Kw3h5J.TrllH9hWFlzXJuTFe/BpHTj6FIkDylc3Ag88/BiFammU2','',0,0,'30-3-2001','all',2,1,0,1,1,1,0,0,0,'',0,'','',0,0,0,'',0,0,0,0,1,0,0,'1**Inbox$%%$2**Sent Items$%%$3**Drafts$%%$4**Trash Can','','',1,'',1,0,0,0,0,0,0,0,0,0,0,'',1,1)