Problem with the relations between forums and posts.

I had this same problem.

I ran the import the first time and it imported everything fine.

I went into users and saw all the users were there, I saw there was data if I went into the content section, but when I went to forums it just listed the Categories and Forums, but not any topics.

If I added the active forum topics block to left sidebar, I could then see forum posts and open them up.

I figured something didn't run correctly so I wiped all the content (Nodes, Users, Forum Content, Comments), then deleted data from the database and also uninstalled the module and tables that were created from modules (The 4 temp tables).

I then tried to re-install the module and re-import. It now just tells me that it's already been completed, and doesn't re-create the tables nor import any actual data.

I did try to go into drupal_sequences to adjust the sequence start data, but that shouldn't affect this I don't think.

Any help would be greatly appreciated :P

I fixed it!!! :P

I was reading through some other posts and messed with it quite a bit more.

I think it was a two fold problem.

One my data was in a seperate SQL Database, and even though I was telling it the physical address and password it wasn't pulling in correctly.

The other issue I believe was some data for the module in drupal_variables.

I wiped out all the variables for the module, and then disabled module from administration > modules, and then deleted the entry for the module under drupal_system.

I then re-added module from administration > modules and copied the data into the same database as drupal.

I ran the import again and everything went through smoothly.

Hmm. I have the same problem - is there anyone who knows what I might change straight in the database to fix? Unlike the above commentor I had the php data in the same database as the drupal, and I wiped variables before enabling the phpbb2drupal module to begin with.

Still, I get the same thing happening, the forum topics don't show up in forums, howvere they do show up in latetst forum posts block and looking there I see that all comments are imported into the right threads so that's all fine. It's just how do I get the forum topics to show up in the forums (where all the containers are imported perfectly as well.)

Looking on the bright side, I'm halfway there. ;P

Just to really make sure (and because I'm desperate to get this sorted out) I tried again. New import of (testing)database, check. Wipe all variables, check. Enable the previously unable phpbb2drupal module from admin >> modules, check. Do import of phpbb data which is in the same database as the rest.

Same exact issue - I have forums, forum conatiners, I have comments that reply to the correct forum posts - but the forum posts themselves do not appear in teh forum

However, if I turn on the "Latest forum posts" block, presto there they are!

Weird.

If I edit any forum post, they appear. Long and boring fix is to simply edit every post (not actually making changes but re-saving them). I don't know why, in the database there's no difference between an un-edited forum node and an edited one, but perhaps I'm looking in the wrong table for the change.

Ahaaa, I think I found the problem. Table "term_node" is completly empty.

I think understand what is happening here. When the following query (from the phpbb2drupal.module file) is made to acquire a topic...

    $query = db_query('SELECT *
      FROM %stopics t
      INNER JOIN %sposts p ON t.topic_id = p.topic_id
      INNER JOIN %sposts_text pt ON p.post_id = pt.post_id                            
      WHERE p.post_id = t.topic_first_post_id
      AND t.topic_id = %d',$pre, $pre, $pre, $result->topic_id);

....there is an issue when the topic and posts tables are joined. Both have a field 'forum_id', but in my database, this field is all zeros in the posts table. I don't know if this a typical case, as I am actually importing form Invision Power Board to PHPBB and then to Drupal. This may be an error in the Invision->PHPBB migration utility.

To work around this issue, I execute the following SQL statement on my PHPBB database (before using phpbb2drupal)

UPDATE phpbb_posts SET forum_id = (SELECT DISTINCT forum_id FROM phpbb_topics WHERE topic_id = phpbb_posts.topic_id)

This updates the forum_id field in the posts table to match those provided in the topics table.

It may be worth noting that on my first attempt to do this migration, everything actually did work fine. (no idea why, guess would be that the "other" forum_id field were somehow being used)

PS...thanks for your hard work on this migration tool, I ***REALLY*** appreciate it!

I assume phpbb2drupal cannot do anything to fix this? ie, this is only for "special occasions" such as what you were in?

(yes I am the current maintainer of this module, but I not terribly clued up when it comes to databases :o)

I am marking as fixed. If there IS something that should be done in the module, please re open (with an explanation of what should be changed and preferably code as you seem to be in a better position than me.).