Site statistics were updated for the last time on 2nd of June? I don't know why...

Hi,

I was wondering that my site statistics seems to keep constant in the last time. After looking in table cs_statistics_site, I've found out, that they have been updated for the last time on 2nd of June.

Does anybody have an idea why?

After looking around in the database I've found out that the SP cs_system_Update_Site" is updating the statistics. I have now executed the SP manually, and all statistics are now up to date. So the question for me is now why is this SP not called at least once every day or when it is called, why does it not update the statistics? Maybe it exits due to an error?

Michael

P.S.: I would also suggest to change the SP cs_Site_Statistics. To be a most active user should require to be active at all, which mean you should have made at least one post...

-- SELECT TOP 100 Users
SELECT TOP 100
    S.TotalPosts,
    U.*
FROM
    cs_statistics_User S,
    cs_vw_Users_FullUser U
WHERE
    S.UserID = U.cs_UserID AND
    U.EnableDisplayInMemberList = 1 AND
    S.TotalPosts > 0 AND
    U.cs_UserID > 0 and U.SettingsID = @SettingsID and S.SettingsID = @SettingsID
ORDER BY
    S.TotalPosts DESC

In the Control Panel, go to Administration, System Tools, Event Log.  Do you see a whole lot of "CS.Web Stopped" and "CS.Web Started" entries, fairly frequently?  If so, that is likely why.  There was an issue in CS v2.0 where the location it which is started and stopped the jobs wasn't the best, as IIS/ASP.NET could often unload/reload some of the CS modules and it would affect the jobs.  Unfortunately, it won't be fixed until CS v2.1.

Where do you find this? cs_Site_Statistics

Hi Ken,

yes there are a lot of "CS.Web Stopped" and "CS.Web Started" entries. So I think this is the reason. I will wait for CS 2.1, that's ok for  me. In the meanwhile I will execute the stored procedure manually from time to time.

Thanks,
Michael

Hi AFIEE,

you can find the table cs_statistics_site in your CS database. I recommend using the free Microsoft SQL Server Management Studio Express to look in your database.

Michael

Thanks so much

How can I manually update this so my site statistics will work? cs_system_Update_Site"