When trying to view the statistics for last month on the all websites dashboard, I get this message:
There is an error. Please report the message and full backtrace in the Piwik forums.
Warning: Division by zero in /mnt/stor9-wc2-dfw1/510324/510494/stats.kmimediagroup.com/web/content/plugins/MultiSites/Controller.php on line 373
Backtrace -->
#0 Piwik_ErrorHandler(2, Division by zero, /mnt/stor9-wc2-dfw1/510324/510494/stats.kmimediagroup.com/web/content/plugins/MultiSites/Controller.php, 373, Array ([startDate] => 2012-04-04,[endDate] => 2012-05-04,[query] => SELECT ox_data_summary_ad_hourly
.impressions, ox_affiliates
.name
, ox_data_summary_ad_hourly
.total_revenue FROM ox_affiliates
LEFT JOIN ox_zones
ON ox_zones
.affiliateid = ox_affiliates
.affiliateid LEFT JOIN ox_data_summary_ad_hourly
ON ox_data_summary_ad_hourly
.zone_id = ox_zones
.zoneid WHERE ox_data_summary_ad_hourly
.date_time < ‘2012-05-04’ AND ox_data_summary_ad_hourly
.date_time > ‘2012-04-04’;,[conn] => Resource id #142,[queryResult] => Resource id #143,[result] => Array ([0] => Array ([impressions] => 10,[name] => Military Advanced Education,[total_revenue] => ),[1] => Array ([impressions] => 18,[name] => Geospatial Intelligence Forum,[total_revenue] => ),[2] => Array ([impressions] => 23,[name] => Military Information Technology,[total_…#1 Piwik_MultiSites_Controller->getLostImpressions(2012-04-04, 2012-05-04) called at [/mnt/stor9-wc2-dfw1/510324/510494/stats.kmimediagroup.com/web/content/plugins/MultiSites/Controller.php:97]#2 Piwik_MultiSites_Controller->getSitesInfo() called at [/mnt/stor9-wc2-dfw1/510324/510494/stats.kmimediagroup.com/web/content/plugins/MultiSites/Controller.php:38]#3 Piwik_MultiSites_Controller->index() called at [(null):0]#4 call_user_func_array(Array ([0] => Piwik_MultiSites_Controller Object ([] => names,[] => desc,[] => visits,[] => Array (),[] => 1,[] => 50,[] => month,[] => Piwik_Date Object ([] => 1336132642,[] => UTC),[] => 2009-12-01,2012-05-31,[] => MultiSites,[] => 2012-05-04,[] => 1,[] => Piwik_Site Object ([] => 1)),[1] => index), Array ()) called at [/mnt/stor9-wc2-dfw1/510324/510494/stats.kmimediagroup.com/web/content/core/FrontController.php:125]#5 Piwik_FrontController->dispatch() called at [/mnt/stor9-wc2-dfw1/510324/510494/stats.kmimediagroup.com/web/content/index.php:57]
Any idea how to fix? Thank you!