# Calendar multiplies its calendar (-subscription)

Since about a week I have the very strange behavior that the calendar-subscription multiplies itself in 'manage calendars'. Resulting in having double, triple etc. entries in the calendar. The calendar used is a Google sync. The only way to get rid of it (for an hour or so) is to delete the Goggle account in settings and reinstall.

In the real Google calendar (website etc.) the entries are not doubled, tripled etc.

What is that?

https://www.dropbox.com/s/0iq49715f6parga/20150826220014.png?dl=0

edit retag close delete

2

Thank you for this bug report. This is caused by a bug in our sync plugin. I believe that it will be fixed by https://github.com/nemomobile/buteo-sync-plugins-social/pull/42/files which is aimed for 1.2.0 release.

( 2015-08-27 06:14:02 +0300 )edit
1

Unfortunately, this fix will not make the 1.2.0 release as we are still resolving some issues with it. It will make 1.2.1 instead.

( 2015-09-09 07:19:50 +0300 )edit

Unfortunately this bug is still present or again present in SFOS 2.1.1. The suggested solution (answer from @groxxorg) did solve it (at least for now).

( 2017-08-04 11:46:16 +0300 )edit

Also still existing in 2.1.2.3 @chris.adams

( 2017-10-08 09:18:53 +0300 )edit

Sort by » oldest newest most voted

I managed to remove the extra calendars by using the answer from https://together.jolla.com/question/59173/delete-all-entries-from-a-calendar/ :

devel-su
sqlite3 /home/nemo/.local/share/system/privileged/Calendar/mkcal/db
SELECT * FROM Calendars;
DELETE FROM Components WHERE Notebook='<insert calendar id from the previous listing>';
DELETE FROM Calendars WHERE CalendarID='<insert calendar id from the previous listing>';

more

Quick & Clean Solution: Sometimes my calendars also start to multiply themselves. The calendars are syncronized with my OwnCloud - there are no problems with that, only on my Jolla. Instead of deleting single superfluous calendar as mentioned above, you can delete all multiple calendars in a bunch by deleting the following file:

devel-su rm /home/nemo/.local/share/system/privileged/Calendar/mkcal/db

It works well; After a reboot everything looks healthy again. Your superfluous calendars will not show up, only the desired calendars will be displayed. I found the way to this solution here. (thx to @nomeata)

more

Thanks you for that solution. I will test it next time my calendar (on a owncloud too) will begin to mulitply itself!

( 2017-05-22 17:37:46 +0300 )edit

Works for me. My calendar is synced from Baikal, not OwnCloud, so this is probably not related to a particular CalDAV server.

( 2017-06-20 11:08:56 +0300 )edit

This looks to have become quite a bit worse since Fiskarsijoki/2.0.4.14: a daily event I have on Google calendar is now repeated 14 times each day. Going to try the above deletion trick later to see if it can help manage things in the meantime.

more

Hello, before deleting the entries from the db, may you report the duplicated lines from Components table ? (sorting out something like SELECT * from Components if you don't have too many events stored in your calendar)

By increasing the verbosity in the log (https://together.jolla.com/question/137685/caldav-on-owncloud-9/), may you see your Google event being added when you trigger a sync, and may you find the server answer from the log ?

This may help to find out what is causing this…

( 2016-10-28 18:02:27 +0300 )edit

Will try to get you some examples and take a look at the log too.

( 2016-10-28 18:05:27 +0300 )edit

( 2016-10-28 18:16:07 +0300 )edit

So, some more data: my database was partly corrupt when I started sqlite3: queries would get results, but finish with "Error: database disk image is malformed". I .dumped it, .read into a new one and replaced the database, losing around a dozen items out of 8,000 in the Google calendar I'm getting the duplication in. An example of a problem event is a repeating daily meeting, where for every day the event repeats the calendar creates a new copy of the event. I have 55 copies of it from 55 days at one time of day; then someone changed it to another time of day and I've 14 copies of it from the 14 days since. Fields

.. are the same for all 14 recent copies of this event, with values

• xxx|Event|xxx||1477061100|1477064700|Europe/London|0|1477062000|1477065600|Europe/London|0|0|hangout|daily checkin|0|255.0|255.0|0||2|jolla-sociald:gcal-id:xxx_20161021T144500Z|||0|1477061100|1477064700|||0|0|0|0|0||1477668853|||0

(I replaced a few UIDs and private strings with "xxx").

3 rows of fields that do vary (again, with part of a UID replaced with 'x')

• componentid,datecreated,datestamp,datelastmodified,url,uid,datedeleted
• 15754|1477070720|1477070720|1477070720|urn:x-ical:xxxxxxxx-d951-4999-a902-636a88 ab1166|xxxxxxxx-d951-4999-a902-636a88ab1166|1477668853
• 16008|1477137225|1477137225|1477137225|urn:x-ical:xxxxxxxx-d19e-4d49-89c2-2a80b3 c28d85|xxxxxxxx-d19e-4d49-89c2-2a80b3c28d85|1477668853
• 16217|1477144993|1477144993|1477144993|urn:x-ical:xxxxxxxx-32a7-4256-ab3b-c81a05 636592|xxxxxxxx-32a7-4256-ab3b-c81a05636592|1477668853
( 2016-10-28 20:22:29 +0300 )edit

Hmm that was difficult to format legibly! Will look into the logs next.

( 2016-10-28 20:29:35 +0300 )edit

Actually I found a solution for this: I reset my Jolla to the factory settings and started from scratch (incl. the suggested updates etc.). A bit of work but now the phone runs much smoother and faster, thus not only this calendar issue is solved. I suggest a few people her to do the same if their phone has issues.

more

I've tried this and it results in exactly the same problems after some time.

( 2016-10-28 17:57:43 +0300 )edit

I believe this is a duplicate of: https://together.jolla.com/question/63213/calendars-duplicated-when-creating-an-event/

more