Ask / Submit
44

CalDav synced all-day events not visible

asked 2014-06-10 13:24:47 +0300

Sailor gravatar image

updated 2015-01-14 17:50:47 +0300

ralooyar gravatar image

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

edit retag flag offensive close delete

Comments

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 )edit

Yeah, all events in question are allday events so this could be the answer.

Sailor ( 2014-06-10 13:38:29 +0300 )edit

Same 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

1 Answer

Sort by » oldest newest most voted
5

answered 2014-07-26 14:25:25 +0300

blam gravatar image

Thanks for the detailed report. This will be fixed in the next release to set the DTEND automatically if the server has not provided it, which is sufficient to make it appear in the calendar, as koudi mentioned.

edit flag offensive delete publish link more

Comments

Thank you for the update and the upcoming fix :).

Sailor ( 2014-07-27 01:56:25 +0300 )edit
1

Still no news in [SailfishDevel] Jolla release plan for high-level features - update 9

Sailor ( 2014-08-20 22:34:58 +0300 )edit

This bug is still present in 1.0.8.21 (Tahkalampi), manually changing DateEndDue did fix the problem in my case. So please provide this patch in the next Jolla release.

ralooyar ( 2014-11-18 11:52:10 +0300 )edit

For the work around, should i set DateEndDue in the db file or on the server?

EDIT: Obviously in the db file, got it now...

Jolly-Jo ( 2014-11-27 08:09:51 +0300 )edit
1

I can confirm that this bug is fixed in 1.1.1.27. Thanks for your work ;-)

ActaTux ( 2014-12-28 14:04:09 +0300 )edit
Login/Signup to Answer

Question tools

Follow
11 followers

Stats

Asked: 2014-06-10 13:24:47 +0300

Seen: 1,100 times

Last updated: Mar 12 '15