so it got a parent forum but missed the subforums?  or vice versa…  and this was up to date phpbb3?

did it get any posts from the missed forums or completely missed them?  was the forum created?  can you look in the sfforums table and see if they exist?

sorry, just trying to be exact…

Mr Papa said
so it got a parent forum but missed the subforums?  or vice versa…  and this was up to date phpbb3?

did it get any posts from the missed forums or completely missed them?  was the forum created?  can you look in the sfforums table and see if they exist?

sorry, just trying to be exact…

 

No worries – thanks for your quick reply. It only got the (only) 2 subforums and its threads/posts…completely missed the parent forums (7 total) and all their threads/posts (100s). This was phpbb3.0.11 (current version).

I looked into the sfforums table and saw only the two subforums in there (here are two screenshots). Looks like the parent forums just didn’t transfer.

As an experiment, I uploaded my .sql file into a fresh install of phpbb3.0.11 and all the forums/subforums/posts are there, error-free.

Anything we can do?

Thanks!

You have not said what messages you received when the import finished. Were any errors reported? Like a list of forums or topics that failed to import for example?

Sorry – there were no error messages. I didn’t save a screenshot but it basically was all green and listed out total subscribers imported (600+), two forums, # of posts, etc. It appeared to be a totally normal “success” message with some additional information at the bottom of what else to change (admin users, etc.). No import “failed” messages or line items whatsoever.

No error messages is suggestive of the fact that the importer knew nothing about these forums to start with. If a forum is ‘known’ but fails to import for any reason then this triggers messages. No message probably means it wasn’t even aware of their existence.

The only reason I can think of for this is that perhaps phpBB have made some changes to their database schema in the latest versions that we are unaware of. The only possible way I have to test that theory is if someone such as yourself is willing to let me have a copy of the database so I can look at it….

I was thinking along the same lines.

Happy to share it with you! Where should I send it…or should I send you phpmyadmin for it?

I appreciate your help.

email it to support at simple-press dot com…

Has been emailed. Did you receive it?

Yes indeed and have just been looking at it.

This IS different to any other phpBB database I have seen before but I have no idea why. When creating the lost of forums that need to be imported we use the criteria of ‘WHERE parent_id != 0’ within the forums table. in your database this only applies to 2 forums and what I don’t know or understand is why other, active. forums have a parent_id of 0.

I am hoping you may be able to shed some light on this…

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?

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….?

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…

Great – thanks Mr Papa!

np. Andy is doing all the work on this one!