2013-08-03, 12:30 AM
Hi Guys,
I was tried using Merge System for Mybb 1.6.10 for import data of phpbb 3 but when run the import for User the system show the error:
Appears that the column salt in mybb is varchar(10) but the same column in phpbb3 is varchar(32). I change the column in mybb for varchar(32) but after this other error occurred with the column timeformat in mybb.
I'm remember that some time ago test the mybb 1.6.5 with merge and the table users was imported correctly.
Can help me with this?
I was tried using Merge System for Mybb 1.6.10 for import data of phpbb 3 but when run the import for User the system show the error:
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1406 - Data too long for column 'salt' at row 1
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`) VALUES ('1','','1','1','','1','1','Anonymous.','','20012dd685144bb1','OH5tTqHE8toCbf6CES6VvFrtWyHDlgubDDeTfQmBor2uuuUySs','','1225341105','0','0','','1','','1','00','0|0','','','0','','','','','1','0','','','0','0','','','phpbb3','0','1','','all','0','1','0','1','1','1','0','0','0','d M Y H:i','0','','','0','0','0','0','0','0','0','0','1','43','0','1**Inbox$%%$2**Sent Items$%%$3**Drafts$%%$4**Trash Can','','','1','0','1','0','0','0','0','0','0','0','0','0','0','')
Appears that the column salt in mybb is varchar(10) but the same column in phpbb3 is varchar(32). I change the column in mybb for varchar(32) but after this other error occurred with the column timeformat in mybb.
I'm remember that some time ago test the mybb 1.6.5 with merge and the table users was imported correctly.
Can help me with this?