[horde] Recurrent Appointments not reading timezone info correctly?
Michael J Rubinsky
mrubinsk at horde.org
Tue May 27 01:51:52 UTC 2014
Quoting Michael J Rubinsky <mrubinsk at horde.org>:
> Quoting Michael J Rubinsky <mrubinsk at horde.org>:
>
>> Quoting Simon Wilson <simon at simonandkate.net>:
>>
>>> ----- Message from simon at simonandkate.net ---------
>>> Date: Tue, 20 May 2014 15:25:04 +1000
>>> From: simon at simonandkate.net
>>> Subject: Re: [horde] Recurrent Appointments not reading timezone info
>>> correctly?
>>> To: mrubinsk at horde.org
>>> Cc: horde at lists.horde.org
>>>
>>>>> On 20 May 2014, at 1:47 pm, Michael J Rubinsky <mrubinsk at horde.org>
>>>>> wrote:
>>>>>
>>>>> Quoting Michael J Rubinsky <mrubinsk at horde.org>:
>>>>>
>>>>>> Quoting Simon Wilson <simon at simonandkate.net>:
>>>>>>
>>>>>>> Horde 5.1.6, Kronolith 4.1.5
>>>>>>>
>>>>>>> We setup TWO appointments in my wife's calendar, both inviting me as
>>>>>>> an attendee.
>>>>>>>
>>>>>>> First one was a SINGLE non-recurrent event that came through with
>>>>>>> times fine, displaying both in Katie's calendar all fine, and showing
>>>>>>> in my Imp ics viewer fine, and accepted and showing in Kronolith fine.
>>>>>>>
>>>>>>> <SNIP>
>>>>>>>
>>>>>>
>>>>>> Does the ics file look the same if it exported directly from Katie's
>>>>>> calendar?
>>>>>
>>>>> This may or may not be fixed by
>>>>>
>>> https://github.com/horde/horde/commit/7f6f41619c7ce923a56ba6f5d678aba30818daa8#diff-3115bd8529b81bde2eeba73f7cdde96d
>>> (this fixed a number of timezone related issues I uncovered while trying to
>>> track this
>>>>> down).
>>>>>
>>>>> --
>>>>> mike
>>>>
>>>> I'll check tonight, also what the ics looks like when exported from
>>>> Katie's calendar.
>>>>
>>>> Thanks Mike :)
>>>>
>>>> Simon.
>>>
>>> Hi Mike,
>>>
>>> Not fixed unfortunately. :(
>>>
>>> Changes applied to kronolith/lib/Application.php as per the push. Stopped
>>> httpd, horde-clear-cache, cleared xcache. Restarted everything. (Any
>>> way to confirm that it's taken effect?)
>>>
>>> I generated a test recurrent appointment for 8th July, every two weeks,
>>> 11am to 12 noon, in Katie's calendar, with me as an attendee.
>>>
>>> Appears in Katie's calendar fine, but the invite to me appears in Imp
>>> and imports as 10am to
>>> 11am.
>>>
>>> Three ics files following.
>>>
>>> Simon
>>>
>>>
>>>
>>> First is the ics as sent to me
>>> Second is the ics exported from Katie's calendar
>>> Third is the ics exported from MY calendar after accepting it.
>>>
>>> Both first two have the same information, with the event showing from
>>> 11am to 12 noon
>>>
>>> DTSTART;TZID=Australia/Brisbane:20140708T110000
>>> DTEND;TZID=Australia/Brisbane:20140708T120001
>>>
>>> My Imp displays it 10 to 11am, and it imports the same. The export
>>> from my calendar then shows:
>>>
>>> DTSTART;TZID=Australia/Brisbane:20140708T100000
>>> DTEND;TZID=Australia/Brisbane:20140708T110001
>>>
>>> ics as sent to me:
>>>
>>> BEGIN:VCALENDAR
>>> VERSION:2.0
>>> METHOD:REQUEST
>>> X-WR-CALNAME:Calendar of Katie Wilson
>>> PRODID:-//The Horde Project//Horde iCalendar Library//EN
>>> BEGIN:VEVENT
>>> DTSTART;TZID=Australia/Brisbane:20140708T110000
>>> DTEND;TZID=Australia/Brisbane:20140708T120001
>>> DTSTAMP:20140520T091239Z
>>> UID:20140520191239.rPFpybvjG1ykk_SLJ3vD6A6 at mail.simonandkate.net
>>> CREATED:20140520T091239Z
>>> LAST-MODIFIED:20140520T091239Z
>>> SUMMARY:Test
>>> ORGANIZER;CN=Katie Wilson:mailto:katie at simonandkate.net
>>> CLASS:PUBLIC
>>> STATUS:CONFIRMED
>>> TRANSP:OPAQUE
>>> ATTENDEE;ROLE=REQ-PARTICIPANT;PARTSTAT=NEEDS-ACTION;RSVP=TRUE:mailto:simon@
>>> simonandkate.net
>>> ATTENDEE;ROLE=REQ-PARTICIPANT;PARTSTAT=NEEDS-ACTION;RSVP=TRUE:mailto:katie@
>>> simonandkate.net
>>> RRULE:FREQ=WEEKLY;INTERVAL=1;BYDAY=TU;COUNT=5
>>> BEGIN:VALARM
>>> ACTION:DISPLAY
>>> DESCRIPTION:Test
>>> TRIGGER;VALUE=DURATION:-PT15M
>>> END:VALARM
>>> END:VEVENT
>>> BEGIN:VTIMEZONE
>>> TZID:Australia/Brisbane
>>> BEGIN:DAYLIGHT
>>> TZOFFSETFROM:+1000
>>> TZOFFSETTO:+1100
>>> DTSTART:19170101T000100
>>> TZNAME:EST
>>> END:DAYLIGHT
>>> BEGIN:STANDARD
>>> TZOFFSETFROM:+1100
>>> TZOFFSETTO:+1000
>>> DTSTART:19170325T020000
>>> TZNAME:EST
>>> END:STANDARD
>>> BEGIN:DAYLIGHT
>>> TZOFFSETFROM:+1000
>>> TZOFFSETTO:+1100
>>> DTSTART:19420101T020000
>>> TZNAME:EST
>>> END:DAYLIGHT
>>> BEGIN:STANDARD
>>> TZOFFSETFROM:+1100
>>> TZOFFSETTO:+1000
>>> DTSTART:19420329T020000
>>> TZNAME:EST
>>> END:STANDARD
>>> BEGIN:DAYLIGHT
>>> TZOFFSETFROM:+1000
>>> TZOFFSETTO:+1100
>>> DTSTART:19420927T020000
>>> TZNAME:EST
>>> END:DAYLIGHT
>>> BEGIN:STANDARD
>>> TZOFFSETFROM:+1100
>>> TZOFFSETTO:+1000
>>> DTSTART:19430328T020000
>>> RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=3;UNTIL=19440325T16000Z
>>> TZNAME:EST
>>> END:STANDARD
>>> BEGIN:DAYLIGHT
>>> TZOFFSETFROM:+1000
>>> TZOFFSETTO:+1100
>>> DTSTART:19431003T020000
>>> TZNAME:EST
>>> END:DAYLIGHT
>>> BEGIN:DAYLIGHT
>>> TZOFFSETFROM:+1000
>>> TZOFFSETTO:+1100
>>> DTSTART:19711031T020000
>>> RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=10;UNTIL=19711030T16000Z
>>> TZNAME:EST
>>> END:DAYLIGHT
>>> BEGIN:STANDARD
>>> TZOFFSETFROM:+1100
>>> TZOFFSETTO:+1000
>>> DTSTART:19720227T020000
>>> RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=2;UNTIL=19720226T16000Z
>>> TZNAME:EST
>>> END:STANDARD
>>> BEGIN:DAYLIGHT
>>> TZOFFSETFROM:+1000
>>> TZOFFSETTO:+1100
>>> DTSTART:19891029T020000
>>> RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=10;UNTIL=19911026T16000Z
>>> TZNAME:EST
>>> END:DAYLIGHT
>>> BEGIN:STANDARD
>>> TZOFFSETFROM:+1100
>>> TZOFFSETTO:+1000
>>> DTSTART:19900304T020000
>>> RRULE:FREQ=YEARLY;BYMONTH=3;BYDAY=1SU;UNTIL=19920229T16000Z
>>> TZNAME:EST
>>> END:STANDARD
>>> END:VTIMEZONE
>>> END:VCALENDAR
>>>
>>> And as exported from the event in Katie's calendar:
>>>
>>> BEGIN:VCALENDAR
>>> VERSION:2.0
>>> X-WR-CALNAME:Calendar of Katie Wilson
>>> PRODID:-//The Horde Project//Horde iCalendar Library//EN
>>> BEGIN:VEVENT
>>> DTSTART;TZID=Australia/Brisbane:20140708T110000
>>> DTEND;TZID=Australia/Brisbane:20140708T120001
>>> DTSTAMP:20140520T091305Z
>>> UID:20140520191239.rPFpybvjG1ykk_SLJ3vD6A6 at mail.simonandkate.net
>>> CREATED:20140520T091239Z
>>> LAST-MODIFIED:20140520T091239Z
>>> SUMMARY:Test
>>> ORGANIZER;CN=Katie Wilson:mailto:katie at simonandkate.net
>>> CLASS:PUBLIC
>>> STATUS:CONFIRMED
>>> TRANSP:OPAQUE
>>> ATTENDEE;ROLE=REQ-PARTICIPANT;PARTSTAT=NEEDS-ACTION;RSVP=TRUE:mailto:simon@
>>> simonandkate.net
>>> ATTENDEE;ROLE=REQ-PARTICIPANT;PARTSTAT=NEEDS-ACTION;RSVP=TRUE:mailto:katie@
>>> simonandkate.net
>>> RRULE:FREQ=WEEKLY;INTERVAL=1;BYDAY=TU;COUNT=5
>>> BEGIN:VALARM
>>> ACTION:DISPLAY
>>> DESCRIPTION:Test
>>> TRIGGER;VALUE=DURATION:-PT15M
>>> END:VALARM
>>> END:VEVENT
>>> BEGIN:VTIMEZONE
>>> TZID:Australia/Brisbane
>>> BEGIN:DAYLIGHT
>>> TZOFFSETFROM:+1000
>>> TZOFFSETTO:+1100
>>> DTSTART:19170101T000100
>>> TZNAME:EST
>>> END:DAYLIGHT
>>> BEGIN:STANDARD
>>> TZOFFSETFROM:+1100
>>> TZOFFSETTO:+1000
>>> DTSTART:19170325T020000
>>> TZNAME:EST
>>> END:STANDARD
>>> BEGIN:DAYLIGHT
>>> TZOFFSETFROM:+1000
>>> TZOFFSETTO:+1100
>>> DTSTART:19420101T020000
>>> TZNAME:EST
>>> END:DAYLIGHT
>>> BEGIN:STANDARD
>>> TZOFFSETFROM:+1100
>>> TZOFFSETTO:+1000
>>> DTSTART:19420329T020000
>>> TZNAME:EST
>>> END:STANDARD
>>> BEGIN:DAYLIGHT
>>> TZOFFSETFROM:+1000
>>> TZOFFSETTO:+1100
>>> DTSTART:19420927T020000
>>> TZNAME:EST
>>> END:DAYLIGHT
>>> BEGIN:STANDARD
>>> TZOFFSETFROM:+1100
>>> TZOFFSETTO:+1000
>>> DTSTART:19430328T020000
>>> RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=3;UNTIL=19440325T16000Z
>>> TZNAME:EST
>>> END:STANDARD
>>> BEGIN:DAYLIGHT
>>> TZOFFSETFROM:+1000
>>> TZOFFSETTO:+1100
>>> DTSTART:19431003T020000
>>> TZNAME:EST
>>> END:DAYLIGHT
>>> BEGIN:DAYLIGHT
>>> TZOFFSETFROM:+1000
>>> TZOFFSETTO:+1100
>>> DTSTART:19711031T020000
>>> RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=10;UNTIL=19711030T16000Z
>>> TZNAME:EST
>>> END:DAYLIGHT
>>> BEGIN:STANDARD
>>> TZOFFSETFROM:+1100
>>> TZOFFSETTO:+1000
>>> DTSTART:19720227T020000
>>> RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=2;UNTIL=19720226T16000Z
>>> TZNAME:EST
>>> END:STANDARD
>>> BEGIN:DAYLIGHT
>>> TZOFFSETFROM:+1000
>>> TZOFFSETTO:+1100
>>> DTSTART:19891029T020000
>>> RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=10;UNTIL=19911026T16000Z
>>> TZNAME:EST
>>> END:DAYLIGHT
>>> BEGIN:STANDARD
>>> TZOFFSETFROM:+1100
>>> TZOFFSETTO:+1000
>>> DTSTART:19900304T020000
>>> RRULE:FREQ=YEARLY;BYMONTH=3;BYDAY=1SU;UNTIL=19920229T16000Z
>>> TZNAME:EST
>>> END:STANDARD
>>> END:VTIMEZONE
>>> END:VCALENDAR
>>>
>>> ics exported from my calendar:
>>>
>>> BEGIN:VCALENDAR
>>> VERSION:2.0
>>> X-WR-CALNAME:Calendar of Simon Wilson
>>> PRODID:-//The Horde Project//Horde iCalendar Library//EN
>>> BEGIN:VEVENT
>>> DTSTART;TZID=Australia/Brisbane:20140708T100000
>>> DTEND;TZID=Australia/Brisbane:20140708T110001
>>> DTSTAMP:20140520T093228Z
>>> UID:20140520191239.rPFpybvjG1ykk_SLJ3vD6A6 at mail.simonandkate.net
>>> CREATED:20140520T093211Z
>>> LAST-MODIFIED:20140520T093211Z
>>> SUMMARY:Test
>>> CLASS:PUBLIC
>>> STATUS:CONFIRMED
>>> TRANSP:OPAQUE
>>> RRULE:FREQ=WEEKLY;INTERVAL=1;BYDAY=TU;COUNT=5
>>> BEGIN:VALARM
>>> ACTION:DISPLAY
>>> DESCRIPTION:Test
>>> TRIGGER;VALUE=DURATION:-PT15M
>>> END:VALARM
>>> END:VEVENT
>>> BEGIN:VTIMEZONE
>>> TZID:Australia/Brisbane
>>> BEGIN:DAYLIGHT
>>> TZOFFSETFROM:+1000
>>> TZOFFSETTO:+1100
>>> DTSTART:19170101T000100
>>> TZNAME:EST
>>> END:DAYLIGHT
>>> BEGIN:STANDARD
>>> TZOFFSETFROM:+1100
>>> TZOFFSETTO:+1000
>>> DTSTART:19170325T020000
>>> TZNAME:EST
>>> END:STANDARD
>>> BEGIN:DAYLIGHT
>>> TZOFFSETFROM:+1000
>>> TZOFFSETTO:+1100
>>> DTSTART:19420101T020000
>>> TZNAME:EST
>>> END:DAYLIGHT
>>> BEGIN:STANDARD
>>> TZOFFSETFROM:+1100
>>> TZOFFSETTO:+1000
>>> DTSTART:19420329T020000
>>> TZNAME:EST
>>> END:STANDARD
>>> BEGIN:DAYLIGHT
>>> TZOFFSETFROM:+1000
>>> TZOFFSETTO:+1100
>>> DTSTART:19420927T020000
>>> TZNAME:EST
>>> END:DAYLIGHT
>>> BEGIN:STANDARD
>>> TZOFFSETFROM:+1100
>>> TZOFFSETTO:+1000
>>> DTSTART:19430328T020000
>>> RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=3;UNTIL=19440325T16000Z
>>> TZNAME:EST
>>> END:STANDARD
>>> BEGIN:DAYLIGHT
>>> TZOFFSETFROM:+1000
>>> TZOFFSETTO:+1100
>>> DTSTART:19431003T020000
>>> TZNAME:EST
>>> END:DAYLIGHT
>>> BEGIN:DAYLIGHT
>>> TZOFFSETFROM:+1000
>>> TZOFFSETTO:+1100
>>> DTSTART:19711031T020000
>>> RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=10;UNTIL=19711030T16000Z
>>> TZNAME:EST
>>> END:DAYLIGHT
>>> BEGIN:STANDARD
>>> TZOFFSETFROM:+1100
>>> TZOFFSETTO:+1000
>>> DTSTART:19720227T020000
>>> RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=2;UNTIL=19720226T16000Z
>>> TZNAME:EST
>>> END:STANDARD
>>> BEGIN:DAYLIGHT
>>> TZOFFSETFROM:+1000
>>> TZOFFSETTO:+1100
>>> DTSTART:19891029T020000
>>> RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=10;UNTIL=19911026T16000Z
>>> TZNAME:EST
>>> END:DAYLIGHT
>>> BEGIN:STANDARD
>>> TZOFFSETFROM:+1100
>>> TZOFFSETTO:+1000
>>> DTSTART:19900304T020000
>>> RRULE:FREQ=YEARLY;BYMONTH=3;BYDAY=1SU;UNTIL=19920229T16000Z
>>> TZNAME:EST
>>> END:STANDARD
>>> END:VTIMEZONE
>>> END:VCALENDAR
>>
>>
>> Looked at this some again tonight. I've narrowed it down to the
>> fact that Horde seems to generate the wrong UTC offset when
>> importing the ics in Horde_Icalendar::_parseDateTime(). I have yet
>> to figure out WHY this happens, or if the tz data in the ics has
>> the wrong info...
>
> Ok. I found the issue, but I'm not familiar enough with the ics code
> to figure out how to fix this quickly. I'm going to create a ticket
> and break down the issue so hopefully Jan can take a look at it.
http://bugs.horde.org/ticket/13223
--
mike
The Horde Project
http://www.horde.org
https://www.facebook.com/hordeproject
https://www.twitter.com/hordeproject
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 5869 bytes
Desc: S/MIME Signature
URL: <http://lists.horde.org/archives/horde/attachments/20140526/ab0e17ef/attachment-0001.bin>
More information about the horde
mailing list