Lightning ignores timezone while updating existing event

Bug #837598 reported by Gustavo Luiz Duarte
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
lightning-extension (Ubuntu)
Expired
Undecided
Unassigned

Bug Description

How to reproduce:
1. I setup my timezone to UTC-3.
2. I received an event invitation for 9h UTC-5.
3. I accepted the invitation and it was added to Lightning correctly at 11h.
4. I received an update to the existing event changing the day of the week (it is an weekly event) and the time to 14h UTC-5.
5. I clicked on Update and the event was updated on Lightning to the correct day of week and wrong time: 14h.
As my timezone is set to UTC-3 the event should be scheduled to 16h.

System info:
ii xul-ext-calendar-timezones 1.0~b2+build2+nobinonly-0ubuntu2
ii xul-ext-gdata-provider 1.0~b2+build2+nobinonly-0ubuntu2
ii xul-ext-lightning 1.0~b2+build2+nobinonly-0ubuntu2
ii thunderbird 3.1.12+build1+nobinonly-0ubuntu0.11.04.1
Ubuntu 11.04

Please let me know if you need any further information.

Revision history for this message
Gustavo Luiz Duarte (gustavold) wrote :

Trying to investigate this I found the following:

The event update has a bunch of recurrence entries instead of a single WEEKLY one (as the original invitation).
I parsed the ics file using python vobject library. Here is the recurrence part:

>>> pp.pprint(parsedCal.contents['vevent'][0].contents['rdate'][0].value[0:3])
[(datetime.datetime(2011, 8, 23, 14, 0, tzinfo=<tzicalvtz 'Central'>),
  datetime.datetime(2011, 8, 23, 15, 0, tzinfo=<tzicalvtz 'Central'>)),
 (datetime.datetime(2011, 8, 30, 14, 0, tzinfo=<tzicalvtz 'Central'>),
  datetime.datetime(2011, 8, 30, 15, 0, tzinfo=<tzicalvtz 'Central'>)),
 (datetime.datetime(2011, 9, 6, 14, 0, tzinfo=<tzicalvtz 'Central'>),
  datetime.datetime(2011, 9, 6, 15, 0, tzinfo=<tzicalvtz 'Central'>))]

Here is the recurrence information stored on local.sqlite3 after I accept the original invitation:
sqlite> select * from cal_recurrence where item_id='C32C061093D2B0B5852578ED00508018-Lotus_Notes_Generated';
C32C061093D2B0B5852578ED00508018-Lotus_Notes_Generated|WEEKLY|0|0||1323975600000000||1||||5||||||6351966f-d163-4cf6-8b50-3fd3ec699e23

After I accept the event update this is what I get using the same query:
sqlite> select * from cal_recurrence where item_id='C32C061093D2B0B5852578ED00508018-Lotus_Notes_Generated';
C32C061093D2B0B5852578ED00508018-Lotus_Notes_Generated|x-date|0|0|LT1314108000000000|||||||||||||6351966f-d163-4cf6-8b50-3fd3ec699e23
C32C061093D2B0B5852578ED00508018-Lotus_Notes_Generated|x-date|1|0|LT1314712800000000|||||||||||||6351966f-d163-4cf6-8b50-3fd3ec699e23
C32C061093D2B0B5852578ED00508018-Lotus_Notes_Generated|x-date|2|0|LT1315317600000000|||||||||||||6351966f-d163-4cf6-8b50-3fd3ec699e23
...

I could not find exactly what the prefix LT means.
From the link bellow it seems it is floating time:
http://mxr.mozilla.org/mozilla/source/calendar/providers/storage/calStorageCalendar.js#153

Interpreting the recurrences as UTC they are scheduled to 14:00
$ date -u -d @1314108000
Tue Aug 23 14:00:00 UTC 2011

Interpreting it as UTC-03 (my local timezone) it is scheduled to 11:00
$ date -d @1314108000
Tue Aug 23 11:00:00 BRT 2011

Observations:
1. It should not be stored as floating time since the ics file provides timezone information.
2. The event is scheduled for 14:00 UTC-05 and stored as 14:00 floating even if I'm in a different timezone.
3. Although the event recurrence is stored as floating time, Lightning seems to be interpreting it as UTC time, because, as I'm at UTC-03, the event is shown in Lightning starting at 11:00.

Revision history for this message
gf (gf-interlinks-deactivatedaccount) wrote :

Hello Gustavo,
Thank you for submitting this bug and reporting a problem with Thunderbird/Lightning.

You made this bug report in 2011 and there have been several versions of Ubuntu and Thunderbird since then.

Could you confirm that this is no longer a problem and that we can close the ticket?
Or, if it is still a problem, could you run the following (only once):
apport-collect 837598

and upload the updated logs and and any other logs that are relevant for this particular issue.

Thank you again for helping make Ubuntu and Thunderbird/Lightning better.

G

Changed in lightning-extension (Ubuntu):
status: New → Incomplete
Revision history for this message
Launchpad Janitor (janitor) wrote :

[Expired for lightning-extension (Ubuntu) because there has been no activity for 60 days.]

Changed in lightning-extension (Ubuntu):
status: Incomplete → Expired
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.