These issues are intertwined. I think we should refactor the Live plugin and add some much needed unit tests.
Confirmed, regression of #1458 again
IIRC this was to fix a problem when the period != 'day'.
See proposed patch in: http://forum.piwik.org/read.php?2,72889,page=1#msg-72911
/piwik/plugins/Live/API.php you will find on about line 240:
- $processedDate = Piwik_Date::factory($date, $currentTimezone);// if not commented, the Period below fails ->setTimezone($currentTimezone);
+ $processedDate = Piwik_Date::factory($date)->setTimezone($currentTimezone);
(In ) Refs #572
Testing is welcome, please report any bug you find!
see report in http://forum.piwik.org/read.php?2,73916
This change resolved my issue with incorrectly processed time zones.
(In ) Fixes #2145 as far as I can see, it should be fixed, but I've been wrong all previous times so testing is very much welcome! thx
Refs #1966 Improving visitor log performance by rewriting the query