Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Solved: 1 Year, 1 Month, 3 Weeks ago vbulletin to mybb import/ convert
#1
Solved: 1 Year, 1 Month, 3 Weeks ago
i am using Vbulletin 3.8x now i want to move mybb forum so i wanted to know how to import/convert my Vbuleltin data to mybb forum this is url 
Reply
#2
Solved: 1 Year, 1 Month, 3 Weeks ago
see MyBB Merge System
Reply
#3
Solved: 1 Year, 1 Month, 3 Weeks ago
(01-01-2019, 06:34 AM).m. Wrote: see MyBB Merge System

thanks getting below error 

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1054 - Unknown column 'aim' in 'field list'
Query:
INSERT INTO mybblk_users (usergroup,additionalgroups,displaygroup,`import_us
Reply
#4
Solved: 1 Year, 1 Month, 3 Weeks ago
comment out or delete below code lines & try again

~/merge/boards/vbulletin3/users.php --- line 92
$insert_data['aim'] = $data['aim'];

~/merge/resources/modules/users.php --- line 38
'aim' => '',
Reply
#5
Solved: 1 Year, 1 Month, 3 Weeks ago
Thanks its works
Reply
#6
Solved: 1 Year, 1 Month, 3 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?

(12-28-2019, 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


Forum Jump:


Users browsing this thread: 1 Guest(s)