Missing some stats

Posts 253

Points 3,895

Reply

Edoardo Posted: Thu, Mar 29 2007 5:33 AM

rated by 0 users

Hi there,

I'm missing some stats, if you look below in "In the past 3 days..." section is empty.
Bug?

Forum Statistics

10 users have contributed to 68 threads and 140 posts.

In the past 24 hours, we have 5 new thread(s), 54 new post(s), and 0 new user(s).

In the past 3 days, the most popular thread for everyone has been "". The post with the most views is "". The most replies were made to "".

Please welcome our newest member MZA.

Bye.
Dodo.

Running CS 2008.5 SP1 (v4.1.31106.3070) on Windows Server 2008 RTM and SQL2005 w/SP2.

Filed under: Beta2 Bug
| Post Points: 20

Posts 2,115

Points 27,605

Reply

Keyvan Nayyeri replied on Thu, Mar 29 2007 6:31 AM

rated by 0 users

Probably all your forums are private (or at least forums with new posts in latest days are private) and this is the normal behavior for private forums because they're excluded in these stats.

Keyvan Nayyeri
Waegis Anti-Spam Filter - Stay Away from Spams on Your Community Server Sites

| Post Points: 20

Posts 253

Points 3,895

Reply

Edoardo replied on Thu, Mar 29 2007 8:18 AM

rated by 0 users

Urgh... bad news ideed.

Yes, all my forums are private.
There's no way to bypass this issue?

Bye.
Dodo.

Running CS 2008.5 SP1 (v4.1.31106.3070) on Windows Server 2008 RTM and SQL2005 w/SP2.

| Post Points: 35

Posts 2,115

Points 27,605

Reply

Keyvan Nayyeri replied on Thu, Mar 29 2007 10:35 AM

rated by 0 users

I don't think but I'm not 100% sure.

Keyvan Nayyeri
Waegis Anti-Spam Filter - Stay Away from Spams on Your Community Server Sites

| Post Points: 5

Posts 1,879

Points 37,940

Reply

Jose Lema replied on Thu, Mar 29 2007 12:06 PM

rated by 0 users

Edoardo:

Urgh... bad news ideed.

Yes, all my forums are private.
There's no way to bypass this issue?

You can always modify the stored procedure that calculates the information. Open cs_system_UpdateSite and look for the SQL that's calculating the @MostViewsPostID, @MostActivePostID, and @MostReadPostID. Each of these has a line that checks permissions:

isnull(jP2.AllowMask,jP.AllowMask) & convert(bigint,0x0000000000000001) = convert(bigint,0x0000000000000001) AND

While it's untested (and therefore unsupported Smile ) if you remove that line (in each of the three lookups) you should end up seeing the results you're looking for. Remember that these stat updates run every couple of hours so you'll need to either run it manually or wait.