MantisBT - v3.0 Release
View Issue Details
0001146v3.0 Release[All Projects] Generalpublic2012-06-03 03:532013-08-28 11:18
Reportersasquatch58 
Assigned Tocaseydk 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOSOS Version
Product Version 
Target VersionFixed in Version3.0.0 
Summary0001146: Timezone issues in Tasks
DescriptionUser pref timezone set to UTC+12 (NZST - daylight saving is OFF)
Enter a task - start date is NZST 2012-06-04 08:00:00, end date is NZST 2012-06-08 17:00:00.
w2p database entry for this task has task_start_date 2012-06-03 21:00:00 and task_end_date 2012-06-08 06:00:00. These are wrong if the databse is meant to be storing dates in UTC. For UTC (GMT/Zulu) task_start_date should be 2012-06-03 20:00:00 and task_end_date 2012-06-08 05:00:00 (subtracting 12h in both cases).
Task View displays the database entries unchanged - does not compensate for user pref and reloads these for editing. This is a regression from V2.31 and V2.4 as far as display goes.
TagsNo tags attached.
Attached Files

Notes
(0002545)
sasquatch58   
2012-06-03 03:56   
To clarify working day preferences are set to Mon - Fri Start 0800, End 1700.
(0002553)
Korkonius   
2012-06-05 22:04   
I cannot assign issues unfortunately, but i am working on the timezones now...
(0002559)
sasquatch58   
2012-06-28 17:31   
Refer to w2p forum http://forums.web2project.net/viewtopic.php?t=4183 for specifc detail
(0002562)
project_manager   
2012-06-30 07:38   
The task time display was in the w2p.3.x-2213 version correct.
Installed now the w2p.3.x-2470 version:
- user working hours: 9.00-17.00.
- local user hour: GMT+1h (Berlin).
example:
- database task_time: 8.00 (stored as GMT) ---> ok!
- task displayed in project view: 8.00 (GMT) ---> wrong!
- edit this task: 9.00 (GMT+1h) ---> ok!
---> store this task: stored in dB as 8.00 (GMT) ---> ok!
(0002565)
project_manager   
2012-06-30 07:47   
I also dont understand why my "default timezone" is GMT+2 (sysadmin)
shown under "System Status" ???
(0002569)
sasquatch58   
2012-06-30 16:22   
Your w2p System default timezone is derived from the System Timezone set in w2p System Configuration. This will override any server timezone settings set in php.ini config.
(0002570)
project_manager   
2012-07-01 13:26   
@icchengineer:
"w2p System default timezone is derived from the System Timezone set in w2p System Configuration..."
---> ok, but I set MY timezone in sysadmin to GMT+1 (Berlin, my USER tz).
---> So, DEFAULT timezone = USER tz + 1h ???
(0002628)
caseydk   
2012-08-07 21:06   
This one solves a good chunk of this problem: https://github.com/caseysoftware/web2project/pull/130 but I'm not 100% convinced that the timezones are working completely as expected..

Please note that this solution is *only* available in the v3.0-pre development and can't be applied to any version earlier (eg 2.4, 2.3, etc).
(0002629)
caseydk   
2012-08-07 21:07   
Further testing underway..
(0002679)
caseydk   
2012-11-01 22:18   
Resolved: https://github.com/caseysoftware/web2project/pull/155
(0002681)
sasquatch58   
2012-11-02 19:15   
Sorry Keith, latest build (from git/ master on 3 Nov) worse than before with tasks & timezones.
Create a task, set start date & duration of 10d & finish date is calculated as the following day :-(. Start time offsetting from expected 0800h (UTC+13) to 0600 UTC as recorded in the database - local tz incorrectly displayed. Note last update time correctly recorded in database by again displayed to user in UTC not local tz.
(0002710)
caseydk   
2012-11-24 17:04   
Resolved: https://github.com/caseysoftware/web2project/pull/170

Twelfth try is the charm?

It appears that somewhere along the way, the system decided to start using its own timezones to do conversions instead of the user-selected one. I believe it was an error on my part.

Or the system has gained sentience and we're in serious trouble..

Issue History
2012-06-03 03:53sasquatch58New Issue
2012-06-03 03:56sasquatch58Note Added: 0002545
2012-06-05 22:04KorkoniusNote Added: 0002553
2012-06-28 17:31sasquatch58Note Added: 0002559
2012-06-30 07:38project_managerNote Added: 0002562
2012-06-30 07:47project_managerNote Added: 0002565
2012-06-30 16:22sasquatch58Note Added: 0002569
2012-07-01 13:26project_managerNote Added: 0002570
2012-08-07 21:06caseydkNote Added: 0002628
2012-08-07 21:07caseydkNote Added: 0002629
2012-08-07 21:07caseydkAssigned To => caseydk
2012-08-07 21:07caseydkStatusnew => feedback
2012-11-01 22:18caseydkNote Added: 0002679
2012-11-01 22:18caseydkStatusfeedback => resolved
2012-11-01 22:18caseydkResolutionopen => fixed
2012-11-02 19:15sasquatch58Note Added: 0002681
2012-11-02 19:15sasquatch58Statusresolved => feedback
2012-11-02 19:15sasquatch58Resolutionfixed => reopened
2012-11-24 17:04caseydkNote Added: 0002710
2012-11-24 17:04caseydkStatusfeedback => resolved
2012-11-24 17:04caseydkResolutionreopened => fixed
2013-08-28 11:14caseydkFixed in Version => 3.0.0
2013-08-28 11:18caseydkStatusresolved => closed