Support Forum
Support Forum
Offline
I just successfully imported all of my users and their passwords, but a problem with the forums/posts: sp importer only imported 2 subforums and their posts (72 total posts) but omitted the rest.
My old forum structure:
Welcome to the forum - 1 post
Before-Purchase Questions - 1 post
Members Welcome - START HERE - 1 post
Introduce Yourself - 126 posts
General Questions - 194 posts
2 subforums containing 72 total posts (these are the two that worked)
the remaining 122 posts are just sort of there in the General Questions Forum as the posts for that main forum
Your Story - 21 posts
Off Topic - 23 posts
I am mostly concerned with importing the 122 posts in the General Questions forum that were omitted from the import. The rest I can easily recreate and/or don't desperately need. But the 122 contain many unanswered posts and folks are waiting for me to answer!
Did I do something wrong? My table name was phpbb_ - was I supposed to use something else? Anything I can do to add in just these (I know you can use the SP Importer with a non-empty forum).
Help!
Thanks
Offline
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...
Visit Cruise Talk Central and Mr Papa's World
Offline
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)
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!
Offline
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?
 |
YELLOW
SWORDFISH
|
Offline
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.
Offline
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....
|
YELLOW
SWORDFISH
|
Offline
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.
Offline
email it to support at simple-press dot com...
Visit Cruise Talk Central and Mr Papa's World
Offline
Has been emailed. Did you receive it?
Offline
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...
|
YELLOW
SWORDFISH
|
All RSS1 Guest(s)