Support Forum

Importer got the users…but nothing else

DR Dave Rodenbaugh
Dave Rodenbaugh
Member

So I just got the importer to run on my WP 3.5.1 box, migrating phpBB 3.0 to SP 5.2.7.  The importer ran for awhile, without ANY errors and displayed this at the end:

 

User/Member Data Created for Members 19001 – 19100

Members Post Counts Updated

IMPORTED:
   19061 Users
   0 Groups
   0 Forums
   0 Topics
   0 Posts

Um, Dude, where are my posts?!  And forums and…

Something isn’t right, but the lack of errors and any other data is discouraging.  What happened and how can I fix it without duplicating the 19000 users I already have?

12 Answers

New Answer

DR Dave Rodenbaugh
Dave Rodenbaugh
Member

As an experiment, I repeated the import again.  I got the exact same result both times–19K users, no groups, posts or topics at all.

Again, the last few lines of the import:

 

User/Member Data Created for Members 18001 – 18100

User/Member Data Created for Members 18101 – 18200

User/Member Data Created for Members 18201 – 18300

User/Member Data Created for Members 18301 – 18400

User/Member Data Created for Members 18401 – 18500

User/Member Data Created for Members 18501 – 18600

User/Member Data Created for Members 18601 – 18700

User/Member Data Created for Members 18701 – 18800

User/Member Data Created for Members 18801 – 18900

User/Member Data Created for Members 18901 – 19000

User/Member Data Created for Members 19001 – 19100

Members Post Counts Updated

IMPORTED:
   19061 Users
   0 Groups
   0 Forums
   0 Topics
   0 Posts

 

No other errors, messages or output was created.  Help!

MP Mr Papa
Mr Papa
Member

sorry, SP 5.2.7???  we dont have such a version… current is 5.2.6 with 5.3 coming any day when wp releases 3.6…

we have had fair number of users use the phpbb importer with no issues, so this is surprising…

was the utf8 option on or off?

did you also check the error log?

Andy should be by this afternoon, he wrote the importer and may be able to offer more insight..

DR Dave Rodenbaugh
Dave Rodenbaugh
Member

Sorry, yes, SP 5.2.6, build 8677 (that’s where the 7 got in)

UTF-8 was OFF.

I found one error log on the /public_html, but it was last modified 6 days ago, so nothing there.

I did not find an error_log under your plugin’s main folder or the sp-import folder, so not sure where else to check on that one.

YS Yellow Swordfish
Yellow Swordfish
Member

There is an error log for the forum within the Toolbox section of the admin but your site php error log will be more extensive – or at least should be.

I am not familiar with the bbPress version numbers but can you confirm that you are using the correct bbPress importer script? There are two – one for bbPress as plugin and one for bbPress in it’s older incarnation as a separate site…

YS Yellow Swordfish
Yellow Swordfish
Member

Whoops! Sorry – I misread that one!

Do you know how to – and are you able to look – at your database tables at all?

If so could you take a look at the phpBB data – find the ‘forums’ table – the ‘parent_id’ column – and tell me if any entries in that column are NOT equal to zero?

DR Dave Rodenbaugh
Dave Rodenbaugh
Member

Sure.

I have 4 entries in phpbb_forums (forum IDs 3-6), but all have a parent ID of 0.

FYI:  The Error Log section under Toolbox->Error Log is empty (shows “There are no error log entries”)

YS Yellow Swordfish
Yellow Swordfish
Member

That’s the problem. Every phpBB database I have seen has a non-zero number – not that I know why for certain.

We could try changing the rules in your case to see what happens but it’s a bit of a shot in the dark. But if you want to try it I can tell you what to change if you don’t mind making a small edit to a code file.

DR Dave Rodenbaugh
Dave Rodenbaugh
Member

I’m a developer, so tweaking is my life.  :)

Let me know what to try.

YS Yellow Swordfish
Yellow Swordfish
Member

In the /importers folder of the importer plugin you wil find the phpbb.php control script.

Go down to the SFFORUMS table mapping block and change the 2 instances of ‘WHERE parent_id != 0’ to ‘WHERE parent_id = 0’.

I honestly have no idea whether this will actually solve it but it is worth a try. If the phpBB folk have made a structural change in this version then I may need to write a separate script for it.

DR Dave Rodenbaugh
Dave Rodenbaugh
Member

OK, I did what you asked…re-ran the importer and it seems to be getting farther now!  The import yields:

User/Member Data Created for Members 19001 – 19100

Forum Group Forum Group Created

Forum Created: FAQ (Topics: 22 Posts: 46)

Forum Created: Support Questions (Topics: 3319 Posts: 17163)

Forum Created: General Discussion (Topics: 254 Posts: 825)

Forum Created: Enhancement Suggestions (Topics: 235 Posts: 720)

Members Post Counts Updated

IMPORTED:
   19069 Users
   1 Groups
   4 Forums
   3830 Topics
   18754 Posts

I think we’re good!  Thanks!

MP Mr Papa
Mr Papa
Member

good news!  now we just need to understand why those parent id were different than all the other imports…