I had installed ISPConfig and everything was working fine. I've now notised that sibnce Aug. 29th on sites stats have been updated or any new sites stat folder created The stats viewable using the control panel are upto date. The only change was on Aug 30th I updated to 2.2.6. What do I need to do to get it working agian?
I've followed the instructions except I do not have the webalizer on the options tab? "then login ispconfig -> goto site you want -> choose option tab and unchecked Webalizer Statistic -> Save after few minutes rechecked Webalizer Statistic and Save again" I took a look at the database table ips_isp_web there is a field called web_webalizer that is NULL for all my sites. Is it possible that the update did not complete properly and the database was updated to a new version but the admin panel was not. Should I try updating to the latest version or fixe this problem before updating?
I think its not nescessary to update or edir the database. Please wait until tomorrow if the stats where generated this night.
Stats still not updateing. I looked into the webalizer.php script and the following line sticks out "if($web_data = $mod->db->queryOneRecord("SELECT * FROM isp_isp_web WHERE doc_id = '$web_doc_id' AND webalizer_stats = '1'"))" Looking at the table isp_isp_web I do not have the field webalizer_stats in the table.
Please try to create the field webalizer_stats in the ISPConfig database in the table isp_isp_web and set the default to 1
I did something similar, I removed " AND webalizer_stats = '1' " from the SQL statment in the PHP file. The stats updated. I'm still wondering how the Database and the Programing are out of sync. Was the DB supposed to be upgraded with 2.2.6 or is there a way to check what version of the DB design I am running? Also is it possible to create the stats for the missing months it did not run?
I will check that. No, at least not automatically with the webalizer scripts from ISPConfig. You might be able to recreate them manually if the logfiles for these months are still available, but I've not tested it.
Thanks for looking into it. I'd like to get my system squared away so I can upgrade to the latest version. I figured it would be a long shot on the past months data but had to ask. Thanks for your help