I am running 4.7.20 and my topic and post counts are inaccurate. When I compare my test site with my live site they are totally different. I no longer see the recount tool in the AdminCP, and I've tried reverting my skin to the default, but the inaccurate counts did not change.

If your Live site is lower than your test site, you will want to check if there were any deletions or archivals. If your test site is lower than your live site, I would need to know what you're seeing as abnormal there as because as your test site becomes more outdated, you would expect that to happen. Recounts can be done by going to any member in the ACP and then under Posts -> click Recount -> count all members.

I am running a recount now, thanks for letting me know where that setting went to...but both sites have the same percentage of archived posts (90%), yet the count is so far off between the two that it seems very strange to me. The only real difference in the two sites is the test site uses no caching, and it also does not use the built in cron job to update things.

Here is the live site with count examples:

Here is the TEST site with count examples:

I will let you know how the recount process goes--it seems to take a while.

You may wish to check your moderator logs to see if anyone mass moved topics or anything - either accidentally or otherwise.

After looking things over, it doesn't appear to be the case. The number of topics in each area closely matches between both sites.

PS - and my moderators don't have any deletion powers.

After the recount process ran a couple of the forums updated their counts, but most are still far off. Is there any command line script that can be run to force the recounts? Are archived posts included in these counts?

LIVE SITE after recount:

Strangely it looks like only a couple the different forums updated, but most did not.

Edited May 17May 17 by sadams101

Although I've cleared the Admin's "Clear System Caches" multiple times after running the recount, this still seems like a cache issue. I just posted the prior screen shot a few minutes ago, and now I see that the "Celiac Disease Pre-Diagnosis, Testing & Symptoms" forum updated its posts correctly--just a few minutes after posting the shot above--see below. Can you tell me how this info is cached. I am using Redis and perhaps it isn't clearing properly?

Edited May 17May 17 by sadams101

You'll likely want to ensure all background tasks have completed from the recount in ACP -> System -> Dashboard -> Background Processes. There are a lot of items which are related here.

Thanks, none are running, but they did run and take several hours to complete. Unfortunately many of the counts are still way off for most the the various forums.

Any idea what might cause this?

That is peculiar. I would suggest disabling Redis and/or any other caching then seeing if that has any impact. If not, we'd need access to further investigate, I'm afraid.

Thanks, I know how to disable the Redis cache, but is there a way to also flush the Redis cache, and is it safe to do this?

9 minutes ago, sadams101 said:

Thanks, I know how to disable the Redis cache, but is there a way to also flush the Redis cache, and is it safe to do this?

Typically, clearing cache should help purge this but if something, for some reason, isn't purging correctly, we want to avoid that altogether so disabling Redis in the constants.php file would be best.

That makes sense, but when I switch back to Redis will the cache be flushed, or should I do that manually from command line? What I don't want to happen is for the old values to start displaying again if they are still stored in the Redis cache...so would using this command after I switch caching methods ensure that this won't come back?

redis-cli FLUSHALL

If we determine the issue to be something on the software-side of interacting with Redis, we will likely resolve that for you and then our developers will provide recommendations based on that (it may be that nothing is needed). At this juncture, we're just trying to troubleshoot the issue at-hand and removing anything that could complicate that (i.e. outdated cache due to something incorrect) is paramount.

Unfortunately, hosting-based support, such as command lines to flush Redis, is outside our scope of support so is not something we can directly provide.

I found out some more info which I'd like to report. I've been watching the counts for each forum that I have, and have noticed that some have updated to the correct counts. This made me wonder why some updated, because the changes had nothing to do with me clearing the cache. I noticed that when a new topic was posted in a forum with an incorrect count, the total number of posts updated to the correct count. Why would this be? What caused the counts to be off in the first place?

I suspect that when I ran the last update the counts were somehow changed to the incorrect low counts, and now when a new topic is posted this gets fixed. The reason that I believe this is because the date of when I ran that update seems to fit with some of my forums, which have been posted to since I ran that update.

PS - This doesn't seem to work all the time, but I noticed it did work in a few of my forums.

We would need to look further into this for you, however the access details on file appear to be incorrect or missing. Could you please update these details by visiting your client area, selecting the relevant purchase, then clicking "Review/Update Access Information" under the "Stored Access Information" section. 

We look forward to further assisting you. 

Thank you for the offer, but my solution outlined above did work. Here is a summary:

1) Add a new post to the forum;

2) Wait for 15 minutes or so (I think one of the cronjobs runs and updates the number of posts...not sure which one)

I don't see a reason to try to find out the cause at this point.

#1 above should say "topic", rather than post.

There was a bug in one or two releases prior to 4.7.19 where archived posts weren't included in the count. That may have something to do with it if those forums haven't been posted in for a while.

But yes, you're right. Posting something in one of those forums will trigger a delayed recount that ensures the values are correct.