Support Forum
Support Forum
Offline
from the peanut gallery...
does parent_id = 0 indicate a top level forum? wouldnt all top level forums have it set to 0? and then any child forums would have it set to the parent id?
Visit Cruise Talk Central and Mr Papa's World
Offline
for Yellow Swordfish - I really don't know what you mean. Do I need to go into my tables and change something for it to work? I started with phpBB about 2 years ago, whatever version that was at the time, and definitely didn't modify the tables or even open phpmyadmin the whole time. All that said, no idea where to go with this other than if you think I should update something in the tables of the phpbb forum...which btw was restored perfectly in a new install of phpBB...so that leads me to believe that the tables are normal and fine per phpBB but not to the Sp-importer....?
Offline
nothing to do yet... Andy is looking into it and trying to figure out why its different than all the other phpbb3 databases we have converted...
its night in UK now, so he should respond back tomorrow...
Visit Cruise Talk Central and Mr Papa's World
Offline
np. Andy is doing all the work on this one! 
Visit Cruise Talk Central and Mr Papa's World
Offline
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)
Offline
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.
 |
YELLOW
SWORDFISH
|
All RSS1 Guest(s)