Issue with My Piwik Tracking


#1

Hello Everyone,

It might be a simple issue that Im facing, but couldnt figure out the reason for the issue.

Scenario:
Im new to Piwik and Im have installed version 2.11.2.
Piwik is installed in the webserver itself and the tracking is happening with any problem.

Problem:
The server time and mysql time is set to IST (GMT+5:30)
The dashboard shows users real time. I tested by logging in to the site and count comes perfect.

The problem is in the entry of this visit in the database (piwik_log_visit and piwik_log_action). The visit_first_action_time and visit_last_action_time is showing in GMT+0:00 timezone. The userlocaltime entry in log_visit is showing the IST. How can I fix the issue?

Solution Tried:
Somewhere I read that php.ini time should be set to Asia/Kolkata. Have tried that as well. But its not helping.
Really need help with this, as we use this table entried to do other analytics.

Looking for help from community… :frowning:


(Matthieu Aubry) #2

Hi there

it is normal and by design that Piwik stores Datetime in UTC timezone.