6.0.0-beta1
7/13/25

[#10991] Allday events are not correctly synchronized
Summary Allday events are not correctly synchronized
Queue Synchronization
Queue Version Git master
Type Bug
State Resolved
Priority 2. Medium
Owners mrubinsk (at) horde (dot) org
Requester gsg (at) 2ghc (dot) de
Created 02/14/2012 (4898 days ago)
Due
Updated 08/29/2012 (4701 days ago)
Assigned 03/12/2012 (4871 days ago)
Resolved 03/13/2012 (4870 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch No

History
08/29/2012 12:32:48 PM Git Commit Comment #7 Reply to this comment
Changes have been made in Git (master):

commit 2b00e61bf937b5f7d94f9ecb72e51e83fa65bd6d
Author: Michael J Rubinsky <mrubinsk@horde.org>
Date:   Mon Mar 12 13:33:27 2012 -0400

     Always convert to local timezone when importing from AS events.

     Possible fix for Bug: 10991

  kronolith/lib/Event.php |    7 +++++--
  1 files changed, 5 insertions(+), 2 deletions(-)

http://git.horde.org/horde-git/-/commit/2b00e61bf937b5f7d94f9ecb72e51e83fa65bd6d
03/13/2012 05:45:04 AM Michael Rubinsky State ⇒ Resolved
 
03/12/2012 05:49:09 PM Git Commit Comment #6 Reply to this comment
Changes have been made in Git (develop):

commit c5c4d75a0c0de4fd231b1bdff8a0812a87fbf427
Author: Michael J Rubinsky <mrubinsk@horde.org>
Date:   Mon Mar 12 13:33:27 2012 -0400

     Always convert to local timezone when importing from AS events.

     Possible fix for Bug: 10991

  kronolith/lib/Event.php |    7 +++++--
  1 files changed, 5 insertions(+), 2 deletions(-)

http://git.horde.org/horde-git/-/commit/c5c4d75a0c0de4fd231b1bdff8a0812a87fbf427
03/12/2012 05:48:29 PM Michael Rubinsky Comment #5
Assigned to Michael Rubinsky
State ⇒ Feedback
Reply to this comment
Can you see if the following change fixes this for you?

http://github.com/horde/horde/commit/c5c4d75a0c0de4fd231b1bdff8a0812a87fbf427
03/12/2012 05:42:53 PM Git Commit Comment #4 Reply to this comment
Changes have been made in Git (master):

commit c5c4d75a0c0de4fd231b1bdff8a0812a87fbf427
Author: Michael J Rubinsky <mrubinsk@horde.org>
Date:   Mon Mar 12 13:33:27 2012 -0400

     Always convert to local timezone when importing from AS events.

     Possible fix for Bug: 10991

  kronolith/lib/Event.php |    7 +++++--
  1 files changed, 5 insertions(+), 2 deletions(-)

http://git.horde.org/horde-git/-/commit/c5c4d75a0c0de4fd231b1bdff8a0812a87fbf427
03/12/2012 05:38:44 PM Git Commit Comment #3 Reply to this comment
Changes have been made in Git (develop):

commit 2b00e61bf937b5f7d94f9ecb72e51e83fa65bd6d
Author: Michael J Rubinsky <mrubinsk@horde.org>
Date:   Mon Mar 12 13:33:27 2012 -0400

     Always convert to local timezone when importing from AS events.

     Possible fix for Bug: 10991

  kronolith/lib/Event.php |    7 +++++--
  1 files changed, 5 insertions(+), 2 deletions(-)

http://git.horde.org/horde-git/-/commit/2b00e61bf937b5f7d94f9ecb72e51e83fa65bd6d
02/15/2012 06:52:15 AM gsg (at) 2ghc (dot) de Comment #2 Reply to this comment
I must correct: I manually added one hour to the start date and 59 
minutes and 59 seconds to the end date in the event.php to match the 
kronolith allday event scheme.

Also, I did some researches and I think that allday events in 
kronolith also should be stored in utc in the database. Currently, 
these events are always stored from 00:00 to 23:59:59 regardless of 
the timezone the event is created in.
02/14/2012 08:58:15 PM gsg (at) 2ghc (dot) de Comment #1
Priority ⇒ 2. Medium
Type ⇒ Bug
Summary ⇒ Allday events are not correctly synchronized
Queue ⇒ Synchronization
Milestone ⇒
Patch ⇒ No
State ⇒ Unconfirmed
Reply to this comment
Synchronization of allday events from mobile to horde is incorrect. It 
works the other way around (from horde to the device).

Timezone of my mobile (Android 4.0.3) and server are set up correctly 
(both on UTC +1). I double checked this.

I created an allday event on my mobile and inspected the activesync post.
The start and end times are correcty transformed to UTC. But, 
according to the activesync protocol 
(http://msdn.microsoft.com/en-us/library/ee203617%28v=exchg.80%29.aspx), an 
allday starts at midnight of the start day and ends at midnight of the 
last day +1.
So an allday event for 02.14.2012 (in my case) is posted as an event 
from 02.13.2012 11pm to 02.14.2012 11pm.

Now this event is parsed and stored in the database. But allday events 
in horde (kronolith) start from midnight of the start day and end at 
11:59:00pm of the last day (afaik).
The activesync event is stored with the above datetimes (11pm to 11pm) 
and konolith shows the given event as allday from 02.13.2012 to 
02.14.2012 which is wrong.

To debug this issue I modified the function fromASAppointment in 
kronolith (lib/Event.php) and manually added one hour to $this->start 
and $this->end. After that, allday events are synchronized correctly 
from mobile to horde.

Summarized: I guess the conversation of the times of allday events is 
missing (at least from mobile to horde).

Saved Queries