Not Solved SMF import forums SQL error
#1
Not Solved
I'm trying to merge from a SMF 2.0.14 forum to Mybb, at first I used the latest Mybb version but I had some issues that the aim field was non existent on mybb, so instead I used 1.8.10 which allowed it to go forward with importing the issues.

Now I'm getting a different error though.



MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
    1366 - Incorrect integer value: '' for column `jimmy_testmybb`.`mybb_forums`.`pid` at row 1
Query:
    INSERT INTO mybb_forums (`import_fid`,`name`,`description`,`import_pid`,`disporder`,`linkto`,`lastpost`,`parentlist`,`lastposter`,`lastposttid`,`lastposteruid`,`lastpostsubject`,`threads`,`posts`,`type`,`active`,`open`,`allowhtml`,`allowmycode`,`allowsmilies`,`allowimgcode`,`allowvideocode`,`allowpicons`,`allowtratings`,`usepostcounts`,`usethreadcounts`,`password`,`showinjump`,`style`,`overridestyle`,`rulestype`,`rules`,`unapprovedthreads`,`unapprovedposts`,`defaultdatecut`,`defaultsortby`,`defaultsortorder`,`pid`) VALUES (18,'The war','',0,15,'',0,'','',0,0,'',0,0,'f',1,1,0,1,1,1,'1',1,1,1,1,'',1,0,0,0,'',0,0,0,'','','') 

Please contact the MyBB Group for technical support.

It should fill in something for the pid I'm guessing but it doesn't, could this be because I'm using some child boards as well?
Reply


Messages In This Thread
SMF import forums SQL error - by jimmy1987 - 2020-02-23, 04:02 PM
RE: SMF import forums SQL error - by .m. - 2020-02-23, 04:41 PM
RE: SMF import forums SQL error - by jimmy1987 - 2020-02-23, 04:45 PM
RE: SMF import forums SQL error - by .m. - 2020-02-23, 04:48 PM
RE: SMF import forums SQL error - by jimmy1987 - 2020-02-23, 06:39 PM
RE: SMF import forums SQL error - by .m. - 2020-02-24, 05:39 AM
RE: SMF import forums SQL error - by noyle - 2020-02-25, 09:19 AM

Forum Jump:


Users browsing this thread: 1 Guest(s)