MyBB Community Forums
Getting error when i import users - Printable Version

+- MyBB Community Forums (https://community.mybb.com)
+-- Forum: 1.8 Support (https://community.mybb.com/forum-175.html)
+--- Forum: Merge System Support (https://community.mybb.com/forum-180.html)
+--- Thread: Getting error when i import users (/thread-224471.html)



Getting error when i import users - berkayco - 08-31-2019

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) 



RE: Getting error when i import users - noyle - 08-31-2019

The AIM contact field is dropped since 1.8.16. The Merge System zip package linked in official download section is not updated since the development stop of it.

You may want to use the latest Merge System from the official Git repo: https://github.com/mybb/merge-system .

BTW, Xenforo 2 seems not officially supported by the Merge System, better try and report back.