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
#2
Not Solved
though not sure about actual cause, replies here can be of some help
Reply
#3
Not Solved
Seems indeed a probleem with child boards as far as I can see, as I don't have a very active board currently I can experiment a bit. I moved all child boards to the main category and then I could import them. I'm up till Posts now.

I'll post back here with any outcomes as that may help others as well Smile
Reply
#4
Not Solved
^ okay. Thanks for the feedback.
Reply
#5
Not Solved
Seems most things worked after doing that, missing a few avatars but nothing I can't fix manually.
Reply
#6
Not Solved
^ good to know it Smile
Reply
#7
Not Solved
The child forums being imported issue OP has encountered should be this one: https://github.com/mybb/merge-system/issues/238 and it might be fixed by this pull request: https://github.com/mybb/merge-system/pull/239 .
This PR isn't merged yet, so OP may use the intermediate build for MyBB version up to 1.8.21 for test: https://github.com/yuliu/mybb-merge-syst...ix-238.zip

For MyBB 1.8.22, OP may modify file ./merge/boards/smf2/forums.php according to changes specified here: https://github.com/mybb/merge-system/pul...04b1146365 .
Could be wrong but worth a try.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)