zero topics and zero posts after migration of phpbb to Drupal-6.15

hm... can you check to see if the data has been migrated in the database? see the last node and the last comment to see if they are in the database.

Next, for the node, go to the node page (node/nodenumber) and see if it displays there.

If so, the problem is probably in the taxonomy term mapping. Make sure the forum taxonomies are in the correct table.

I am having a similar issue. It would appear that posts are not being migrated into term_node. The posts have been imported into Drupal, but they lack a forum to go into and are basically in limbo.

Did you migrate from a clean phpbb3 or was phpbb3 an interim solution while migrating from some other forum software?

(If the forums were always phpbb, what version are you upgrading from?)

This was an interim solution from IP.board. All of the content, however is in phpbb3 correctly. Could the migration process really have a hang up when phpbb3 handles the content like it's native?

A few more questions:

1. Are the relevant forums being created? like if you go to the forum page, is there a list of fora there?
2. Are the phpbb forums in working order and navigatable prior to importing to Drupal? (can youtest with a copy of the database?) If so, the the problem is on this databases side and needs to be tracked (and if there weer any specific error messages, post them here too.)

A few weeks ago someone else reported a similar problem where phpbb3 was the intermediate step (however I cannot seem to find the issue but I cannot remember where they imported to phpbb from) and the issue was tracked down to be that the initial import into phpbb3 was not correctly filling in a phpbb table that we use to import the data into drupal.

1. In Drupal, yes, I can see all the forums/categories. No posts, however.
2. PHPBB works fine after importing the data from IP.Board and before/after importing to Drupal aside the expected login issues requiring users to reset passwords.

I ran the import again. Strangely enough, this time I saw no warning messages like I did before. I've never seen errors generated, just warnings referencing my theme. Occasionally, I'd see errors mentioning the number of posts not being a number. I came up with the same result of seeing all the forums but no posts.

Ok, I made a mistake with that last import (forgot to restored the old database, it's early). I attached some output generated by imports. I noted each step off in the file. Hope it helps.

Which other modules do you have installed? (can you do a test import with no extra modules enabled to see if makes a difference?)

CCK, aggregator, path, profile, image, mail, wysiwyg, advanced forum, advanced help, author pane, DHTML menu, shoutbox, user stats, views. I disabled them and ran as bare-bones as I could and still got the same result, albeit less warning messages.

One other thing to check - can you check is the tids in drupal_phpbb2drupal_temp_forum match the forum ids that are actually present? (you can check manually, or append forum/tid to the site url.)

I should have more time to try and debuge this over the coming weekend, so before then any extra information that you can provide or oddities you notice may be of great help tracking the issue down.

Maybe even compare the query used to import the topics with the data of a single topic to see if there are any table name mismatches (but that is unlikely since that should throw up errors.)

Sorry for the delay, I had been out of the country on vacation. It would appear the temp_* tables have integer values that correspond between the posts and post IDs in PHPBB and the node and node IDs in drupal.

part two, take one of the node ids in the table, have a look in the term_node table to see what tid it is mapped to.

then make sure that that tid is in the forum vocabulary. Do the numbers match?

(are your forum topics set to be published by default?)

Forum topics are published by default.

After migration, there are no nodes listed in term_node. I can add them manually and they appear in the forum, I can also change the content type in the node and it'll show up.

Can you check to see if the phpbb2drupal_temp_forum table is correctly populated?

That is a mapping of the forums in phpbb3 with the taxonomy term tid in drupal.

Looks like they're matching up with the forum_ids in phpbb. It would appear the problem lies in the migration not listing the posts in term_node for some reason.

are they also matching the tids for the drupal forum vocabulary?

and yes, I am thinking that the problem is somewhere in the matching code.

Either the tids in that table are wrong and do not match the tids in the drupal forum or the tids are not properly being read/converted.

Lets try to get a single node tested to see what happens - you will need to start from scratch with this and do everything again to see where the problem lies.

In phpbb2drupal.module, around line 532, is a loop starting with

  while ($result = db_fetch_object($topic_ids)) {

Comment out that line and the loop closing line (around line 677) to only run the code once.

Then between those lines, either replace all instances of $result->topic_id with a specific topic ID you want to test with, or before them put a "$result->topic_id =" and a number for the test ID.

Now around line 643, you need to add a few calls to show what is being saved:

  drupal_set_message(print_r($node, 1));
  drupal_set_message($tid);

and make sure the values in there are sensible.

If there is a problem, work your way back with the drupal set mesages higher and higher up til you can find the place where the problem is happening.

Got this. Looks like an empty object/array?

# Found 391 topics: Beginning Import
# Could not find post details of topic:
# stdClass Object ( [type] => forum [title] => [uid] => [status] => 1 [promote] => 0 [created] => [changed] => [comment] => 2 [moderate] => 0 [body] =>

[sticky] => 0 [format] => 2 [teaser] =>

[tid] => )

Mass close of D6 issues for this module as won't fix. Please see #1854186: Support for the 6.x branch.