CalDav synced all-day events not visible
asked 2014-06-10 13:24:47 +0300
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 +0300 )editYeah, all events in question are allday events so this could be the answer.
Sailor ( 2014-06-10 13:38:29 +0300 )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 +0300 )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 +0300 )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 +0300 )edit@koudi hehe also tried to set the transparency and duration which had no effect. I try it with DateEndDue now ;). Thx
Sailor ( 2014-06-10 15:00:23 +0300 )edit@koudi that worked for me setting the DateEndDue made "Fronleichnam" visible: sqlite> update components set DateEndDue=1403211703 where Summary="Fronleichnam";
The interesting thing is it's not set for other events which show up. Very strange.
Sailor ( 2014-06-10 15:03:05 +0300 )editThe only things I can see, are birthdays. All other events are invisible. <- I must correct that, there are almost only birthdays in that table. Seems to me that it does not sync at all :-/
hardcodes.de ( 2014-06-10 15:41:23 +0300 )editThanks for this, I'll investigate this further. There is also an issue with all day events that cover multiple days: https://together.jolla.com/question/45970/all-day-events-which-cover-multiple-days-not-working-with-owncloud/
blam ( 2014-06-12 03:23:31 +0300 )editYep, can confirm the multiple days issue.
Sailor ( 2014-06-12 11:17:13 +0300 )editAre there any news if this will be fixed in the next update?
Sailor ( 2014-07-10 13:39:32 +0300 )editNot in the next one I'm afraid, possibly the one after that.
blam ( 2014-07-10 14:35:56 +0300 )editAccording to the comments of @ActaTux (comment) and @Jolly-Jo (comment-74085), this bug is fix with update 1.1.1.27.
So I will close this question. I hope, this is ok, since I am not the original poster. But love to have things cleaned up. ;)
ralooyar ( 2015-01-11 22:21:19 +0300 )editI have this problem with 1.1.2.16. Regression?
Sören ( 2015-03-12 21:58:04 +0300 )edit