@anonymous-piwik-user opened this Issue on October 20th 2011

It's seems a bug in Piwik archiving algorithm. In screenshot #1 that I show there are 0 visitors in october 19. By the way, actually I had 95 visitors. See screenshot #2: Little dig in database reveals that archiving was made on 16:59:59 OMST (that is, 9:59:59 UTC). My server works in OMST timezone.

When I tried to change field ts_archived in mysql table archive_numeric_2011_10 to value 2011-10-19 17:00:00, the Piwik began to show visitors count correctly.

I don't know from what point of source code this issue come from. Developers please fix it :)

@anonymous-piwik-user commented on October 20th 2011


@anonymous-piwik-user commented on October 20th 2011


@mattab commented on October 22nd 2011 Member

Thanks for the report and the info. What timezone did you set the website to in Piwik > Settings > Websites ?

@mattab commented on October 22nd 2011 Member

Note: we also did some work on the same issue for Piwik 1.6, see ticket #2548

@mattab commented on November 3rd 2011 Member
@mattab commented on December 18th 2011 Member

(In [5566]) Fixes #2728
I couldn't replicate the issue since it's an edge case, but I have the feeling that this would fix it (since the bug report was quite precise and highlighted a 1 second offset problem)

This Issue was closed on December 18th 2011
Powered by GitHub Issue Mirror