How Post Count is Calculated

[tsptom]

I have a question about how post counts are determined. I have one member who has 5042 posts, according to the database using this query:

SELECT count(*)
FROM post
WHERE username = 'xxx'

But that gets 42 more rows than what the post count in the forum is, which says 5000 even.

The "visible" field has 5039 1's and 3 2's, if that means anything.

What would cause the difference?

Thanks.

[Lynne]

Do any of your forums have "Count Posts Made in this Forum Towards User Post Counts" set to No?

[tsptom]

Interesting. Is there a way to check that in the database, as opposed to checking the individual forum settings?

--------------- Added [DATE]1408389824[/DATE] at [TIME]1408389824[/TIME] ---------------

I'm not seeing any of the obvious forums set that way, like private forums and threads.

Could it have anything to do with deleted forums or threads? How about soft deleted posts?

[ozzy47]

Its possible it could be due to soft deleted posts, or posts that are in moderation.

[tsptom]

Thanks. Do you know how to eliminate soft deleted posts from this select statement?

SELECT count(*)
FROM post
WHERE username = 'xxx'

[ozzy47]

Try this:

SELECT count(*)
FROM post
WHERE username = 'xxx' AND visible = 1

[tsptom]

Adding visible took it down to the 5039. (there were three 2's in the visible column).

I think I will just have to go with the "posts" column in the user table. It matches the current forum's post count, but not what I count using the select. I was just curious why they didn't match.

Thank you!