Revision history [back]

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

Thanks for help

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

Thanks for help

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

Thanks for help

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

Thanks for help

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

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

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