1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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

Discussion in 'Troubleshooting and Problems' started by rwm1962, Jul 30, 2015.

  1. rwm1962

    rwm1962 Active Member

    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.

    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.

    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)

  2. rwm1962

    rwm1962 Active Member

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

    Mike XenForo Developer Staff Member

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

    rwm1962 Active Member

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

    rwm1962 Active Member

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

    Amaury Well-Known Member

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

    Mike XenForo Developer Staff Member

    You're sure the posts are in a thread that is visible? (Is the forum set to include post counts?)
    Amaury likes this.
  8. rwm1962

    rwm1962 Active Member

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

    rwm1962 Active Member

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

    rwm1962 Active Member

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

    rwm1962 Active Member

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

    Result. (y)

Share This Page