2013-02-17, 03:23 PM
Hi!
I'm trying to convert from FluxBB 1.5.1, selecting PunBB in the Merge System. It did successfully the first steps until importing users it run into problem:
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1366 - Incorrect integer value: '' for column 'lastpost' at row 1
Query:
INSERT INTO mybb_users (
What is wrong?
I'm trying to convert from FluxBB 1.5.1, selecting PunBB in the Merge System. It did successfully the first steps until importing users it run into problem:
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1366 - Incorrect integer value: '' for column 'lastpost' 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
,failedlogin
,usernotes
,passwordconvertsalt
) VALUES ('2','','2','4','4','4','7','Solari','','','0','[email protected]','1174541944','1174542205','1174542205','','1','','1','2','','','','','','','','','1','0','217.198.224.162','','0','0','','eacb0d1b53a6f12893e95c7c5aec16de3ff2a939','punbb','0','0','','all','2','1','0','1','1','1','0','0','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','0','1','0','0','0','0','0','0','0','0','0','0','0','','') What is wrong?