Well, I appreciate it. I might have to go live with phpBB tomorrow afternoon if I can’t figure out how to use S-P, but I’d definitely prefer the latter if there’s any way to move forth with data intact. ;o)

Sorry I missed you last night. But no – am still not sure why this should be any different from past phpBB db’s. There doesn’t seem to be any obvious tie-up between the parent and forum IDs in the table. At least no blatantly obvious relationship that I can see…

Still – if you are willing to make a small code edit then we could try to use some brute force… if that is possible you need the file /sp-import/importers/phpbb.php

Down on line 83 you should find the block that is labelled: ‘# SFFORUMS Table Mappings‘. We are going to change the entries for ->select and ->where. Basically we need to remove the ‘WHERE parent_id != 0’ text from both lines so it ends up as:

$map['sfforums']->select = 'SELECT * FROM <%dbname%>.<%dbbasepfix%>forums ORDER BY forum_id';
$map['sfforums']->where     = '';

and then try to perform the import again. Th easiest way to do that, of course, is to go you your currently installed but incomplete SP and use the uninstall option which will clear out all of the data. Then re-install and finally re-import.

I don’t know if this will work but it should not, at least, do any harm and it will have the effect of selecting all of the possible forums. If it does not then let me know and I can set up a test to import the DB here – that just takes a little time to prepare.