Random issue with topic_replies count (Invisible Posts)

Discussions about the phpBB3 Forum. How to get the best from this powerful script.
Note that there is no official support for phpBB3 here, a place to share more than to ask for.

Moderator: Moderators

Random issue with topic_replies count (Invisible Posts)

Postby Rah1 » Mon Sep 05, 2011 9:43 am


I have a random issue that only comes in some random topics. The issue is that the first 4 posts of a new page (i.e. after the posts reaches the per page showing limits) are not visible. Then, after investigation in the database I was found that the fields "topic_replies, topic_replies_real" in the table "phpbb_topics" had an incorrect count. If I update the count manually from the db, the invisible posts will show up. Similarly, if I make a copy of the topic, the posts will again show up.

This is how I found the differences, (say the topic id is 85908):
Code: Select all
select topic_replies, topic_replies_real from phpbb_topics where topic_id = '85908'
select count(*) from phpbb_posts where topic_id='85908'

They show a difference 4.

Basically, the issue started just after the upgrade to latest 3.0.x version. I have many forums and many sub forums... I cannot have someone resynchronising it on daily basis. There must be a permanent solution.
User avatar
Posts: 1
Joined: Mon Sep 05, 2011 9:28 am


Return to phpBB Forum


  • Related topics
    Last post

Who is online

Users browsing this forum: No registered users and 19 guests