Random issue with topic_replies count (Invisible Posts)

[Rah1]

Hi,

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.
.