Wrong number of new posts (comments+topics) with revision enabled

Try this simple patch.

Just reporting I also have this problem. Will try patch from #2

I also have the wrong number for number of topics and replies in the forum listings and for the statistics with number of replies at the bottom of the forum listing.
Changing current lines 145 through 147 from

$query->join('forum_index', 'f', 'n.nid = f.nid');
$query->addExpression('COUNT(f.nid)', 'topic_count');
$query->addExpression('SUM(f.comment_count)', 'comment_count');

back to the 7.x-2.0 code:

$query->join('forum', 'f', 'n.vid = f.vid');
$query->addExpression('COUNT(n.nid)', 'topic_count');
$query->addExpression('SUM(ncs.comment_count)', 'comment_count');

Fixed the counts in the forum lists

Looking for the other issue now

@daften:
Can you show me example of wrong topic count?
Above patch (#5) was applied as per #145353: Forums performance improvements

Yes, but the problem there is a different problem due to forum hierarchy
As far as comment #7 is concerned, yes, for the forum module. This code is in the advanced_forum module in the function that was copied from forum.module...

The main problem is the double entries in the forum_index table, I don't understand at all why they would be necessary. They are exact duplicates ... I've asked for more info on issue #1466458: Duplicate entries in in forum_index table

@daften:

does changing line (from #5):

$query->addExpression('COUNT(f.nid)', 'topic_count');

to:

$query->addExpression('COUNT(DISTINCT(f.nid))', 'topic_count');

solve the problem? (using forum_index table, of course).

Closing this.

@troky. putting the distinct on the count for forum_index fixes the wrong topic count yes.

For people who just need this to work right now, I made a patch that applies to the 7.x-2.1 version of advanced forum, since the core issue doesn't seem to be advancing at all.