No visits in widget "Visits by server time" - Piwik 1.7.1


(macada) #1

We have more than 40 sites in our piwik.
In some of them, the widget “visits by server time” has time ranges without visits.
For example, in the file attached, between 2h/3h there is no visits but in the previous and the next range there are visits… and web page was fully alive I mean on, in that range
Any help will be welcome.
Cheers


(jOoL) #2

To you see other reports that show visits during this time period ?


(macada) #3

I thought taht the issue is related on the change in time on Sunday 25. From 2am to 3am there is no visits because that hour didnt exists… but I was wrong

The error happens in other days…

The error only happens in “Server time” widget.

In the file attached compares two dates (26/02/2012 and 25/02/2012). On the 25th the “server time” widget the range missed is between 23:00/0:00. On the 26th, the range missed is 2:00/3:00am

See file attached

Regards


(jOoL) #4

If you delete datas in database and regenerate stats from logs, does it show same issue ?


(macada) #5

I deleted the two Mysql tables piwik_archive_* for the specific month containing the dates to re-process… and nothing… piwik shows same results in those bar graphics.

What can I do?

Costumer are complaining about this issue… any help is welcome.

Thx in advance.


(jOoL) #6

What are the days concerned ? Since when does it happen? Various time range or always 2am?


(macada) #7

It was only in two days.

Rest of the month was perfect

Files are attached


(macada) #8

I have just checked the apache log file in that problematic hour, between 2am and 3am… and… there is traffic:

74.125.XXX.XXX - - [26/Mar/2011:02:21:40 +0100] “GET … HTTP/1.1” 301 429 “-” “Mozilla/5.0 (en-us) AppleWebKit/525.13 (KHTML, like Gecko; Google Web Preview) Version/3.1 Safari/525.13”

213.37.XXX.XXX - - [26/Mar/2011:02:22:07 +0100] “GET … HTTP/1.1” 200 1676 “-” “Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; OfficeLiveConnector.1.3; OfficeLivePatch.0.0; InfoPath.2; .NET4.0C)”

190.47.XXX.XXX - - [26/Mar/2011:02:24:12 +0100] “GET …” 200 12314 “-” “Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US) AppleWebKit/534.16 (KHTML, like Gecko) Chrome/10.0.648.151 Safari/534.16”


(jOoL) #9

it looks like a problem with changing to summer time on server… maybe a dismatch between timezone in php, mysql, host what else…

I don’t see why then.