CalDav synced all-day events not visible
asked 2014-06-10 13:24:47 +0200
Hi everybody,
I activated the caldav feature right after updating to the new Sailfish version. First of all it worked as expected and found the calendars and started syncing.
But then if I look in the calendar there are missing events which are present in Owncloud it self perfectly fine. I had a look in the database of the calendar (/home/nemo/.local/share/system/privileged/Calendar/mkcal/db) and saw that the missing events are in the database but not shown.
Here is one line which is not displayed but their:
40|bb8e7d24-fcfc-4892-a182-b9588c632387|Event|Fronleichnam||1403128800|1403136000||0|0|0||0|0|||0|255.0|255.0|0||1402394525|1402394525|1402394525|0||||0|0|0|||urn:x-ical:DE-IF-FRONL-2014|DE-IF-FRONL-2014|1|0|0|0|0||0|||0
And one line which is displayed:
45|bb8e7d24-fcfc-4892-a182-b9588c632387|Event|Mariä Himmelfahrt||1281823200|1281830400||0|0|0||0|0||nur vereinzelt in überw. kath. Gem. Feiertag|0|255.0|255.0|0||1402394525|1402394525|1402394525|0||||0|0|0|||urn:x-ical:DE-IF-MHIMF|DE-IF-MHIMF|0|0|0|0|0||0|||0
Table structure:
#define CREATE_COMPONENTS \
"CREATE TABLE IF NOT EXISTS Components(ComponentId INTEGER PRIMARY KEY AUTOINCREMENT, Notebook TEXT, Type TEXT, Summary TEXT, Category TEXT, DateStart INTEGER, DateStartLocal INTEGER, StartTimeZone TEXT, HasDueDate INTEGER, DateEndDue INTEGER, DateEndDueLocal INTEGER, EndDueTimeZone TEXT, Duration INTEGER, Classification INTEGER, Location TEXT, Description TEXT, Status INTEGER, GeoLatitude REAL, GeoLongitude REAL, Priority INTEGER, Resources TEXT, DateCreated INTEGER, DateStamp INTEGER, DateLastModified INTEGER, Sequence INTEGER, Comments TEXT, Attachments TEXT, Contact TEXT, InvitationStatus INTEGER, RecurId INTEGER, RecurIdLocal INTEGER, RecurIdTimeZone TEXT, RelatedTo TEXT, URL TEXT, UID TEXT, Transparency INTEGER, LocalOnly INTEGER, Percent INTEGER, DateCompleted INTEGER, DateCompletedLocal INTEGER, CompletedTimeZone TEXT, DateDeleted INTEGER, extra1 STRING, extra2 STRING, extra3 INTEGER)"
Thx @koudi a little fix to bring events to view is setting the DateEndDue field in the tables. But setting them manually cannot be the solution it should be set automatically.
sqlite> update components set DateEndDue=1403211703 where Summary="Fronleichnam";
Thanks for help
There are issues with displaying all-day events, looks like it is also the case with your entries.
Blizzz ( 2014-06-10 13:32:26 +0200 )editYeah, all events in question are allday events so this could be the answer.
Sailor ( 2014-06-10 13:38:29 +0200 )editSame problem. I thought this could be cause by radicale server (I've read on some devel list that there are some problems with it), but if those events get to database, it is probably some problem with calendar app. Not sure what is the issue, because facebook and local calendars show all day events without any problems.
koudi ( 2014-06-10 14:09:20 +0200 )edit@koudi there are not all "allday" events affected only a few of them. That's why I posted the DB entries maybe a developer sees the difference.
Sailor ( 2014-06-10 14:17:49 +0200 )edit@Sailor after quick trial&error I found out that (in my dataset) filling DateEndDue makes it show. Even though it's not just it - my events show in one day, but they actually span more days. Setting transparency, classification or duration makes no difference.
koudi ( 2014-06-10 14:58:01 +0200 )edit