XF 1.4 User post count wrong or is it? Wider issue?

[rwm1962]

Had this flaggged up to me for one user but I guess it could be a wider issue affecting more members.

Use has a post count of 66. Via their profile or search (ES) they have 2 threads & 20 posts so post count should read as 20.


However:
He has a total of 5 threads - 4 imported & 1 post-import. Imported threads are verified as existing (by following redirects on his post list on old forum).
He has a total of 53 posts - 44 imported & 9 post-import posts. Imported posts are verified as existing as above.

So:
Why is his post count showing 66 when it should be 53?
Why are 3 threads & 33 posts not showing via their profile or search?

Not sure if this is an isolated case or wider spread?

Will this archived query fix it or is there something else I need to do?

Recalculate and update all user post counts (query)

Thanks

 

[rwm1962]

I've just run the query on our test site - earlier clone of the forum. All it did was align the post count to the posts that are viewable via search or profile. So on the live site the postcount would drop from 66 to 20 & the posts being ignored by the post count would continue to be ignored.

 

[Mike]

If that query sets the post count to 20, that's based on what's actually in the database, so that would be the correct count (though that query doesn't handle forums that don't count posts within). Note that posts that are deleted or in deleted threads don't count and won't be in the search index.

It's worth pointing out that when we import, we generally just import the message count as is from the source, so it may have been incorrect there.

 

[rwm1962]

I still have access to the old forum & his post count is accurate there. The thing is the posts that don't show in a search of his threads or content are actually on the forum. His post count just isn't including them.

 

[rwm1962]

Also - one of my mod team has taken a look at some other accounts & is seeing mismatch on other accounts.

 

[Amaury]

@Liam W had add-on to rebuild post count, which may prove useful to you.

 

[Mike]

You're sure the posts are in a thread that is visible? (Is the forum set to include post counts?)

 

[rwm1962]

Thought that might be the Eureka solution but just checked & the forums the uncounted posts are in are ticked to count the users messages.

 

[rwm1962]

@Liam W had add-on to rebuild post count, which may prove useful to you.

I've just tried it but count remained the same unfortunately.

 

[rwm1962]

Belay that - some sections of the test/clone site were deleted to save space so it may have worked - need to do some counting!

 

[rwm1962]

@Liam W - His add on has fixed the issue. All the users posts are now available via search & their profile & post count matches.

Result.