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
statistics http 500
statistics http 500
Last edited by piere123 on Fri Dec 31, 2010 12:49 pm, edited 1 time in total.
Re: statistics http 500
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
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
