Know your Mysql 4.0?

[ClubMed]

I need help concerning a phpBB forum and Mysql.

I used to have an old phpBB (www.phpbb.com) forum running version 2.0.3

Then I made a new forum running version 2.0.4

I wanted to copy the old post to the new one. So in phpMyAdmin (web based version) I dropped the old tables: phpbb_posts, phpbb_posts_test, phpbb_topics.

And coppied the same tables from the older database.

The new forum appears to be empty (0 posts) but if you click on it you can see some of the older threads, there are many more than show up.

Anyone know what I need to do to get all the posts to show up and and for these threads (and posts) to be properly seen by the new forum?

You can see the testforum here: www.alhaffar.com/testforum1

Thanks!.

[vass0922]

May not be a MySQL problem.

I don't know the forum software you're using but it sounds like you're missing a join somewhere.

If the software uses an INNER JOIN in the queries the data has to match exactly on both sides of the join or ZERO data will appear.
Its possible that 2.0.4 has a field in it that 2.0.3 does not. When the new software looks for that field with the join it doesn't find it and therefore shows zero posts.
(data may show up in different views as the missing field(s) isn't/aren't required for that view.

Good Luck