Fixed Moderated posts issue with postcount

[ainwood]

We moderate any post from a new member that has links in it. If we find that the post is spam, we run the spam cleaner to move the posts to a forum with no post count, and ban the user. We find that even though the posts are in a no-postcount forum, the posts are showing in the banned users postcount.

Have tested / confirmed that moving a post normally from another forum to the no postcount forum correctly adjusts the postcount. It appears only related to posts that have gone straight from the moderator queue to the no postcount forum.

 

[Mike]

This is fixed for the next release now. The issue had to do with the approval happening with the move from spam cleaning (which we do to take it out of the approval).

 

[ainwood]

Great - thanks!

 

[Mouth]

This is fixed for the next release now.

Will the upgrade process also retrospectively fix for existing threads/posts meeting this condition?

 

[Chris D]

No, it won't be.

 

[Mouth]

No, it won't be.

Rebuild User Post Counts will, after installing the next release?

 

[Chris D]

We don't have a rebuild that recalculates post counts. If you have one by a third party I see no reason why it wouldn't work.

This might work:

https://xenforo.com/community/resources/rebuild-user-post-counts-query.363/