[MySQL] phpBB not displaying topics

[Nikola Skoric]

Hi there...

Yes, I know there exists a suport forum for discussion about problems
with phpBB, but noone there seems to know the solution to my problem...
so I ask here.

I've been messing around with phpbb_ tables in my database... I'm trying
to convert a incomplete Ikonboard forum to phpBB, and had to do lots of
stuff manually (which is fine as I'm familliar with MySQL). And, now I'm
stuck and can't figure out the problem...

The forum in question is:

http://fly.srk.fer.hr/~nick/remorkeri/phpBB2/

The situation is this:
a) from the outside:
On index.php I can see numer of topics, number of posts and info about
last post. On viewforum.php I get "There are no posts in this forum.".
b) from the inside:
select post_id, topic_id, forum_id from phpbb_posts;
returns a whole bunch of everything, so this table seems OK.

select post_id, post_text from phpbb_posts_tex t;
same thing.

select topic_id, forum_id, topic_title from phpbb_topics;
same thing.

So, form the inside everything seems nice. So, why viewforum.php doesn't
see the articles? I tried to figure out the PHP code, but couldn't,
haven't got all the time in the world...

Anyway, can anybody help?

--
"Now the storm has passed over me
I'm left to drift on a dead calm sea
And watch her forever through the cracks in the beams
Nailed across the doorways of the bedrooms of my dreams"

[Nikola Skoric]

Re: [MySQL] phpBB not displaying topics

Dana Tue, 19 Apr 2005 10:51:00 +0200
Nikola Skoric (nick-news@net4u.hr) kaze...[color=blue]
> Anyway, can anybody help?[/color]

Wierd piece of software is this phpBB I can say... The problem was this:

mysql> select count(*) from phpbb_topics where topic_first_pos t_id=1;
+----------+
| count(*) |
+----------+
| 1 |
+----------+
1 row in set (0.00 sec)

mysql> select count(*) from phpbb_topics where topic_first_pos t_id=0;
+----------+
| count(*) |
+----------+
| 335 |
+----------+
1 row in set (0.00 sec)

So, then I realized that the post with the topic_first_pos t_id=1 was the
one visible... so for the fun of it I did this:

mysql> update phpbb_topics set topic_first_pos t_id=1;
Query OK, 335 rows affected (0.02 sec)
Rows matched: 336 Changed: 335 Warnings: 0

And now I can see all of my topics... ~:-\ Although they are sorted in
somewhat randomly manner and "Guest" is Author of all of the topics...
but at least I've moved a bit :-)


--
"Now the storm has passed over me
I'm left to drift on a dead calm sea
And watch her forever through the cracks in the beams
Nailed across the doorways of the bedrooms of my dreams"