I’m pretty new with pwik and after some 2 hours googling I gave up and I decided to ask here …
web server, linux, timezone set to CET, time is set properly
visitor (me, from another machine) have localtimezone set to CET and ltime set properly
mysql server (linux) have localtimezone set to CET and time set properly
mysql now() returns proper CET datetime value
apache+php linux server where pwik is hosted (different from web server) also have localtime set as CET and time set properly
phpinfo reports proper timezone for both “Default timezone” and “date.timezone”
pwik configuration for “all” and for the “site” is that timezone is CET …
and now when I look at piwik_log_visit.visit_last_action_time and piwik_log_visit.visit_first_action_time they are wrong ?! they are one hour late … so instead of showing 2011-01-25 02:25:00 it show 2011-01-25 01:25:00 !!! … but the visitor_localtime field show proper datetime value (the local time from visitor)…
the “real time viewers” is showing proper times but I’m confused about times in database ?!
I get the same error, I already chose Europe/Paris as Timezone on the website configuration but I still get the time with an hour late.
How can I disable the CET as you said ?
(I’m using Piwik 2.0.3)
All the visits and the actions created by Piwik are an hour late.
For e.g, I began a new visit at 11:30 a.m and in MySQL, I can see my visit but it was started at 10:30 a.m.
I checked my web server and the Apache logs: the hour is correct.
I analyzed the request sent to Piwik from my website : the _refts and the _viewts parameters. They are already late there :S
On the configuration of my website on Piwik, I set the timezone to Europe/Paris but i can see that it still use the UTC time.