Simple Machines Community Forum

SMF Support => SMF 1.1.x Support => Topic started by: woodp on August 20, 2006, 08:09:32 PM

Title: "Recount all forum totals and statistics" not working?
Post by: woodp on August 20, 2006, 08:09:32 PM
SMF Version: SMF 1.1 RC2
Recently, I imported a webbbs board into an existing SMF board (using phpbb as an intermediate step). All the webbbs messages were stashed in an "Archive" forum. Afterwards, I associated the webbbs users with the correct ID_MEMBER. The board still works perfect but the post counts are inconsistent.

As you can see from the attached Show Stats image, it shows I've only posted two messages. My profile also says two messages. But if you look down in the "Most popular boards by Post" section, it shows two posts in the "Suggestions" forum and another seven in "Archive." And if you were to click on "Show
posts", you would see all 9 posts!

I have clicked on Admin > Maintenance > Find and repair any errors, and Admin > Maintenance > Recount all forum totals and statistics a number of times, but the number of posts continues at 2 ... even though sometimes it recognizes all nine.

Is there a script to run through the entire smf_messages table to properly count the number of messages?
Title: Re: "Recount all forum totals and statistics" not working?
Post by: higherauthority on August 20, 2006, 09:38:03 PM
you did a "Recount all forum totals and statistics." under Forum Maintenance right ?
Title: Re: "Recount all forum totals and statistics" not working?
Post by: woodp on August 20, 2006, 09:41:27 PM
Yes, that's exactly what (among other things) I tried ...
Title: Re: "Recount all forum totals and statistics" not working?
Post by: woodp on August 21, 2006, 06:55:30 AM
Quote from: higherauthority on August 20, 2006, 09:38:03 PM
you did a "Recount all forum totals and statistics." under Forum Maintenance right ?


I'm going to go so far as to say the "forum totals and statistics" doesn't include the post count. I'm running two SMF boards, one at 1.1RC2 and one at 1.1RC3, and in both cases, if I manually change the number of posts in the Profile menu and then run the "Recount all forum totals and statistics", it leaves the post count unchanged. Then, once again, I go into the profile menu and change the post count manually.

Can anyone else confirm this behavior?

Title: Re: "Recount all forum totals and statistics" not working?
Post by: Dannii on August 21, 2006, 06:57:41 AM
Post count shouldn't be changed by recounting statistics. Admins can set it to anything, it doesn't get change except when you post, or a post gets deleted.
Title: Re: "Recount all forum totals and statistics" not working?
Post by: woodp on August 21, 2006, 11:37:41 AM
Quote from: eldacar on August 21, 2006, 06:57:41 AM
Post count shouldn't be changed by recounting statistics.

Thank you very much for that confirmation! Your statement matches my experience 100%.

This may not be the right forum to ask the question, but has anyone written a script/mod to recalculate post counts?