or commiting the transaction after every 10 contacts
Sounds more suitable to me, as this is the real problem (as far as I understand) but you are the one, who knows the code 😉
(Split from https://forums.bitfire.at/topic/1730/task-sync-cannot-set-timezone-for-utc-properties/)
Same problem here with latest stable version of Thunderbird Lightning with existing and creating new events in DAViCal database. Not possible to change TZID format manually. DAVdroid will need to be able to parse this, probabaly with some fail safe functionality that can handle this. Even though it might be an incorrect format, it will take a long long time before fixes have been rolled out for all clients and DAV services that use it. Please, see also the debug info I have send you today per email.
Examples from field caldav_data
for VEVENT
in table caldav_data
from DAViCal are:
BEGIN:VCALENDAR\r
PRODID:-//Mozilla.org/NONSGML Mozilla Calendar V1.1//EN\r
VERSION:2.0\r
BEGIN:VTIMEZONE\r
TZID:Europe/Amsterdam\r
BEGIN:DAYLIGHT\r
TZOFFSETFROM:+0100\r
TZOFFSETTO:+0200\r
TZNAME:CEST\r
DTSTART:19700329T020000\r
RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=3\r
END:DAYLIGHT\r
...
DTSTART;TZID=Europe/Amsterdam:20180521T193000\r
DTEND;TZID=Europe/Amsterdam:20180521T211500\r
...
Did you send the debug info to play@bitfire.at? I have checked the mailbox but didn’t see anything related.
I have split this thread because the other thread was about tasks and specifically the COMPLETED
property, whereas this thread seems to be about events.
Can you please provide exact steps to reproduce, the complete (anonymized) VEVENT with all properties, DAVdroid debug info and maybe verbose DAVdroid logs etc as described in [READ BEFORE POSTING] What’s required to diagnose a problem?
The VEVENT you have provided looks good and I’m quire sure that your problem comes from other properties which have been omitted in your excerpt. I would have to reproduce the problem with the full VEVENT to have a look at that. Especially, I suspect that this might be a problem with the DTSTAMP
property, and maybe not even related to Thunderbird, but to another client which has created the original event, because everything works with Thunderbird here.
No, to support@davdroid.com I also work with Etar https://f-droid.org/en/packages/ws.xsoh.etar/ but did not touch these events with that app.
Does the following help to find the root cause?
BEGIN:VCALENDAR\r
PRODID:-//Mozilla.org/NONSGML Mozilla Calendar V1.1//EN\r
VERSION:2.0\r
BEGIN:VTIMEZONE\r
TZID:Europe/Amsterdam\r
BEGIN:DAYLIGHT\r
TZOFFSETFROM:+0100\r
TZOFFSETTO:+0200\r
TZNAME:CEST\r
DTSTART:19700329T020000\r
RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=3\r
END:DAYLIGHT\r
BEGIN:STANDARD\r
TZOFFSETFROM:+0200\r
TZOFFSETTO:+0100\r
TZNAME:CET\r
DTSTART:19701025T030000\r
RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=10\r
END:STANDARD\r
END:VTIMEZONE\r
BEGIN:VEVENT\r
CREATED:20180424T120309Z\r
LAST-MODIFIED:20180424T120418Z\r
DTSTAMP:20180424T120418Z\r
UID:0c919f51-e341-4dd3-9577-f649ba31df20\r
SUMMARY:Training\r
RRULE:FREQ=WEEKLY\r
DTSTART;TZID=Europe/Amsterdam:20180425T193000\r
DTEND;TZID=Europe/Amsterdam:20180425T204500\r
TRANSP:OPAQUE\r
LOCATION:Address\r
DESCRIPTION:http://website.com\r
X-MOZ-GENERATION:4\r
END:VEVENT\r
BEGIN:VEVENT\r
CREATED:20180424T120348Z\r
LAST-MODIFIED:20180424T120357Z\r
DTSTAMP:20180424T120357Z\r
UID:0c919f51-e341-4dd3-9577-f649ba31df20\r
SUMMARY:Training\r
RECURRENCE-ID;TZID=Europe/Amsterdam:20180425T193000\r
DTSTART;TZID=Europe/Amsterdam:20180425T193000\r
DTEND;TZID=Europe/Amsterdam:20180425T204500\r
TRANSP:OPAQUE\r
LOCATION:Address\r
DESCRIPTION:http://website.com\r
X-MOZ-GENERATION:1\r
END:VEVENT\r
BEGIN:VEVENT\r
CREATED:20180424T120358Z\r
LAST-MODIFIED:20180424T120403Z\r
DTSTAMP:20180424T120403Z\r
UID:0c919f51-e341-4dd3-9577-f649ba31df20\r
SUMMARY:Training\r
RECURRENCE-ID;TZID=Europe/Amsterdam:20180502T193000\r
DTSTART;TZID=Europe/Amsterdam:20180502T193000\r
DTEND;TZID=Europe/Amsterdam:20180502T204500\r
TRANSP:OPAQUE\r
LOCATION:Address\r
DESCRIPTION:http://website.com\r
X-MOZ-GENERATION:2\r
END:VEVENT\r
BEGIN:VEVENT\r
CREATED:20180424T120404Z\r
LAST-MODIFIED:20180424T120409Z\r
DTSTAMP:20180424T120409Z\r
UID:0c919f51-e341-4dd3-9577-f649ba31df20\r
SUMMARY:Training\r
RECURRENCE-ID;TZID=Europe/Amsterdam:20180509T193000\r
DTSTART;TZID=Europe/Amsterdam:20180509T193000\r
DTEND;TZID=Europe/Amsterdam:20180509T204500\r
TRANSP:OPAQUE\r
LOCATION:Address\r
DESCRIPTION:http://website.com\r
X-MOZ-GENERATION:3\r
END:VEVENT\r
BEGIN:VEVENT\r
CREATED:20180424T120409Z\r
LAST-MODIFIED:20180424T120418Z\r
DTSTAMP:20180424T120418Z\r
UID:0c919f51-e341-4dd3-9577-f649ba31df20\r
SUMMARY:Training\r
RECURRENCE-ID;TZID=Europe/Amsterdam:20180516T193000\r
DTSTART;TZID=Europe/Amsterdam:20180516T193000\r
DTEND;TZID=Europe/Amsterdam:20180516T204500\r
TRANSP:OPAQUE\r
LOCATION:Address\r
DESCRIPTION:http://website.com\r
X-MOZ-GENERATION:4\r
END:VEVENT\r
END:VCALENDAR\r
Thunderbird 52.7.0 Lightning 4.5.7
@pander Thanks, I’ll have a look at that. I guess it’s related to https://forums.bitfire.at/topic/1727/calendarstorageexception-couldn-t-read-locally-stored-event.
I couldn’t reproduce the problem with this event and other Lightning events are working here, too. This seems not to be related to Lightning, but to https://forums.bitfire.at/topic/1727/nullpointerexception-attempt-to-invoke-virtual-method-void-java-util-calendar-settimezone-java-util-timezone-on-a-null-object-reference. If I only could reproduce it…
Please follow up there.