Page 1 of 1

statistics http 500

Posted: Fri Dec 31, 2010 12:36 pm
by piere123
Hi,

I have been using statistics module for about 9 months with no problem.  I have just upgraded to cmsms 1.9.2 from 1.8.2 and upgraded statistics to 1.1.0.  When I go to view the statistics I get a http 500, any ideas?

Thanks in advance

Mark

Re: statistics http 500

Posted: Thu Jan 06, 2011 9:01 pm
by jellef
Hi Mark,

I had this problem before with previous releases and again with 1.1.0 today, after not reading out the statistics data for over a month. I found out that the number of records collected by the option to register the data of individual visitors (can't find the exact name of the option in the settings menu because I don't have the english version) is the bottleneck. You find a warning with this option that it can cause problems with busy sites. I believe the problem occurs when you startup this module reading all data from the database. It takes too long and it times out. I solved the problem by resetting the record 'cms_module_stat_logstrings'. If in your database the number is very high (in my case > 18000), try to reset it. I use the utitlity MySqlDumper for this, which I also use to make backups (please do before you try this operation).

The alternative is to completely uninstall the module, but you will lose all the data. If your statistics fill up rapidly, it may be better to disable the option.

Regards,

Jelle