1243364 - CET Parameter in ICS and Caldav ll do bug (+1 hours) if you have Europe/Paris timezone in lightning

Status: UNCONFIRMED

(Calendar :: General, defect)

Description

[mrtigre]

Attachment: lightning.jpg

User Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:43.0) Gecko/20100101 Firefox/43.0
Build ID: 20160105164030

Steps to reproduce:

Hello,

Iam of France 

Thunderbird version : 38.5.1
Lightning : 4.0.5.2


We have an server with horde groupware
(http://www.horde.org/apps/groupware)

We have Caldav or ICS added in lightning 4.0.5.2

When you create an event with :

thunderbird 
You have this -> 
BEGIN:VEVENT
DTSTART;TZID=Europe/Paris:20160130T180000
DTEND;TZID=Europe/Paris:20160130T190000
DTSTAMP:20160126T164357Z
UID:5c076bf0-c486-4d0b-9c07-778226163ed0
CREATED:20160126T164326Z
LAST-MODIFIED:20160126T164326Z
SUMMARY:thunderbird 18/19
CLASS:PUBLIC
STATUS:CONFIRMED
TRANSP:OPAQUE
END:VEVENT


IPHONE
BEGIN:VEVENT
DTSTART:20160126T160000Z
DTEND:20160126T170000Z
DTSTAMP:20160126T163736Z
UID:[e-mail]
CREATED:20160126T162228ZCET
LAST-MODIFIED:20160126T162228Z
SUMMARY:gg 17/18h
CLASS:PUBLIC
STATUS:CONFIRMED
TRANSP:OPAQUE
END:VEVENT



In webmail horde : 
WEBMAIL
BEGIN:VEVENT
DTSTART:20160130T110000Z
DTEND:20160130T120000Z
DTSTAMP:20160126T163736Z
UID:[e-mail]
CREATED:20160126T160838Z
LAST-MODIFIED:20160126T160838Z
SUMMARY:test webmail
CLASS:PUBLIC
STATUS:CONFIRMED
TRANSP:OPAQUE
END:VEVENT



Before version < 5 of Android 
we had this : 
ANDROID 
BEGIN:VEVENT
DTSTART:20160130T080000
DTEND:20160130T090000
DTSTAMP:20160126T163736Z
UID:[e-mail]
CREATED:20160126T154745Z
LAST-MODIFIED:20160126T154745Z
SUMMARY:Gg 16:42 8-9h
CLASS:PUBLIC
STATUS:CONFIRMED
TRANSP:OPAQUE
END:VEVENT 





But since update android > 5 (ex : Samsung A3 android 5.0.2, Samsumg S6)
There are this : 
ANDROID 
BEGIN:VEVENT
DTSTART;TZID=CET:20160130T080000
DTEND;TZID=CET:20160130T090000
DTSTAMP:20160126T163736Z
UID:[e-mail]
CREATED:20160126T154745Z
LAST-MODIFIED:20160126T154745Z
SUMMARY:Gg 16:42 8-9h
CLASS:PUBLIC
STATUS:CONFIRMED
TRANSP:OPAQUE
END:VEVENT 

There are this new : 
DTSTART;TZID=CET
DTEND;TZID=CET



So for example : 
I add event 8 at 9 hours with the Samsumg 
In my webmail i ll see 8 at 9 hours
In my samsumg i ll see 8 at 9 hours
In my Iphone i ll see 8 at 9 hours
But in lightning i ll see 9 at 10 hours




I did an test too create an local calendar with an import 
of an ics

BEGIN:VEVENT
DTSTART;TZID=CET:20160130T080000
DTEND;TZID=CET:20160130T090000
DTSTAMP:20160126T163736Z
UID:[e-mail]
CREATED:20160126T154745Z
LAST-MODIFIED:20160126T154745Z
SUMMARY:Gg 16:42 8-9h
CLASS:PUBLIC
STATUS:CONFIRMED
TRANSP:OPAQUE
END:VEVENT 

I ll see 9 at 10 h 


BEGIN:VEVENT
DTSTART:20160130T080000
DTEND:20160130T090000
DTSTAMP:20160126T163736Z
UID:[e-mail]
CREATED:20160126T154745Z
LAST-MODIFIED:20160126T154745Z
SUMMARY:Gg 16:42 8-9h
CLASS:PUBLIC
STATUS:CONFIRMED
TRANSP:OPAQUE
END:VEVENT 

I ll see 8 at 9 h 

I give you too an screen of parameter lightning :
It is on Europe/Paris.
On my server we are too Europe/Paris.
On iphone too Europe/Paris
On samsung too Europe/Paris

//
I did test too  with old version lightning < 4.05.2 there are too the problem
and i did test version lightning 4.6b1 with thunderbird 44.0 Beta there are too the problem


Actual results:

I have so with this parameter CET + 1 hour



Expected results:

normal hour same my webmail, same iphone, same samsung calendars, same outlook

Comment 1

[Stefan Sitter [:ssitter]]

I fail to understand the problem, maybe you can explain more? 

Did you mean that an event created in Lightning is correct but your CalDAV server is stripping the timezone information and converting the event from Europe/Paris to UTC? This sounds like server problem to me.

Or did you mean that one of your devices converts from Europe/Paris to CET timezone? How does the CET timezone definition looks like? Or is it not included in the calendar file? That would be an error in the application that created the event. Without valid timezone definition Lightning doesn't know how to handle the event.

Comment 2

[mrtigre]

Hello,
Ty of replay.
I fail to understand the problem, maybe you can explain more? 

Did you mean that an event created in Lightning is correct but your CalDAV server is stripping the timezone information and converting the event from Europe/Paris to UTC? This sounds like server problem to me.
> no problem is not of the server.

//
Yes when you create an event with an device Samsumg with S-Planner or others calendars app on this smartphone OS Android >= 5.0.2
Problem it is that Android App ll put in database "CET" in the "event_timezone"


When you create an event with Lighting, you have Europe/Paris in database.
But problem, it is after when Ligtning see the event timezone=CET 
We have in lightning +1 hour (my event is normally at 8am, in lightning i see this event 9am)

I did so an test with no server.
You go in the tools/Options/Calendar -> and in TimeZone you put Europe/Paris.
You create an calendar in ligtning on the computer on your hard drive.
You put an event in this calendar.
You export .ics and you open the .ics with Notepad++.

You ll have for the event ex : 

BEGIN:VEVENT
DTSTART;TZID=Europe/Paris:20160130T180000
DTEND;TZID=Europe/Paris:20160130T190000
DTSTAMP:20160126T164357Z
UID:5c076bf0-c486-4d0b-9c07-778226163ed0
CREATED:20160126T164326Z
LAST-MODIFIED:20160126T164326Z
SUMMARY:thunderbird 18/19
CLASS:PUBLIC
STATUS:CONFIRMED
TRANSP:OPAQUE
END:VEVENT

So this event is 8am-9am.
In this two lines :
DTSTART;TZID=Europe/Paris:20160130T180000
DTEND;TZID=Europe/Paris:20160130T190000 

You change Europe/Paris with CET so we ll have this : 
DTSTART;TZID=CET:20160130T180000
DTEND;TZID=CET:20160130T190000 

You delete your old calendar in lightning, import the .ics you had modify.
And the event ll be at 9am-10am

Comment 3

[mrtigre]

Hello

Comment 4

[Daniel Veditz [:dveditz]]

Not a security bug.

Comment 5

[[:MakeMyDay]]

Specifying the timezone name in the TZID parameter is not enough to display an event in the correct timezone. Also the timezone definition needs to be provided within the VCALENDAR which contains the VEVENT. So simply exchanging the TZID of a property of an VEVENT to another value is expected to display the event in wrong timezone.

That said, please check whether your server provides a timezone definition for CET for the respective calendar.

Can you check whether calendar.icaljs prefernce is enabled or disabled in the advanced preferences?

Comment 6

[mrtigre]

Hello,

My Server is [root@mail ~]# date jeu. avril 14 12:20:06 CEST 2016
In horde account user mail/agenda "My language=French" and my "timezone=Europe/Paris" 
The calendar.icaljs is false in Thunderbird.

regards,