Solved: 2 Years, 8 Months, 2 Weeks ago vbulletin to mybb import/ convert
#6
Solved: 2 Years, 8 Months, 2 Weeks ago
I have also a similar problem

MyBB has experienced an internal SQL error and cannot continue.
SQL Error:1054 - Unknown column 'aim' in 'field list'Query:INSERTINTO 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`,`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`,`aim`,`passwordconvertsalt`)VALUES (2,'4,2',2,2,'6,27',2,1,'Hunter','','','','[email protected]',1136473920,1352827746,1312366447,'',1,'[align=center][B][color=Red]Ôï ÷åéñüôåñï äåí åßíáé íá ìçí Ý÷åéò êÜðïéïí ðïõ áãáðÜò, áëëÜ íá óôÝêåóáé äßðëá ôïõ êáé íá îÝñåéò üôé äåí åéíáé äéêüò óïõ[/color][/B]\r\n\r\n[/align]',1,'','','','',1202935560,'','','','',1,1,X'',X'','','590aa293c9d5742229ff4afcc05f666b','vb4',0,0,'05-01-1971','all',2,1,0,1,1,1,0,0,0,'',0,'','',0,0,0,'',0,0,0,0,1,63,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,'','^!K') 


Can you advice me?

(2019-12-28, 01:41 PM)liontaris Wrote: I have also a similar problem

MyBB has experienced an internal SQL error and cannot continue.
SQL Error:1054 - Unknown column 'aim' in 'field list'Query:INSERTINTO 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`,`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`,`aim`,`passwordconvertsalt`)VALUES (2,'4,2',2,2,'6,27',2,1,'Hunter','','','','[email protected]',1136473920,1352827746,1312366447,'',1,'[align=center][B][color=Red]Ôï ÷åéñüôåñï äåí åßíáé íá ìçí Ý÷åéò êÜðïéïí ðïõ áãáðÜò, áëëÜ íá óôÝêåóáé äßðëá ôïõ êáé íá îÝñåéò üôé äåí åéíáé äéêüò óïõ[/color][/B]\r\n\r\n[/align]',1,'','','','',1202935560,'','','','',1,1,X'',X'','','590aa293c9d5742229ff4afcc05f666b','vb4',0,0,'05-01-1971','all',2,1,0,1,1,1,0,0,0,'',0,'','',0,0,0,'',0,0,0,0,1,63,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,'','^!K') 


Can you advice me?


I delete also the aim !!! thanks
Reply


Messages In This Thread
vbulletin to mybb import/ convert - by kokoko420 - 2019-01-01, 05:30 AM
RE: vbulletin to mybb import/ convert - by .m. - 2019-01-01, 06:34 AM
RE: vbulletin to mybb import/ convert - by .m. - 2019-01-01, 06:49 AM
RE: vbulletin to mybb import/ convert - by liontaris - 2019-12-28, 01:41 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)