BUG: calendar entries synced from google account with multiple calendars don't have a calendar assigned in the mkal db and are not shown in the calendar app
asked 2014-04-12 10:08:01 +0200
I have a google account with multiple (4) calendars. After updating to 1.0.5.16 only a few events from a few events google calendar show up. It seems as if only events from one show up, but when you look closely you find events from more than one. I tried to delete the account and readd it but it does not help. I tried to enable and disable calendars but with no luck. You can check whether you are affected by this bug by executing the following command as root:
sqlite3 /home/nemo/.local/share/system/privileged/Calendar/mkcal/db "SELECT * FROM Components WHERE Notebook = '';"
Update1: I queried the google.db with sqlite3 command line tool and there are events in 4 different calendars. So it seems that the events are synced to the device but are not displayed.
echo "SELECT localCalendarId FROM events GROUP BY localCalendarId;" | sqlite3 /home/nemo/.local/share/system/privileged/Calendars/google.db
Update2: I renamed the one calendar that was showing, that it is not the last one in the list, reset my calendar dbs, removed the google account and added it again. Thereafter still only events from one calendar show up, but it is a different one and not the last in the displayed list.
Update3: I querried the mkcal/db for events that are in google calendar but are not displayed in the jolla calendar app
sqlite3 /home/nemo/.local/share/system/privileged/Calendar/mkcal/db "SELECT * FROM Components;" | grep uniqueString
and I found for each google calendar entries in the db. So something is special about my calendars? Could there be a special value in an entry that stops the app from reading? How can I debug? I did not find any error message in journal while opening the calendar app
journalctl --all --follow --no-pager
Update 4: I got it, why the events are not displayed in the calendar app. In the Components table from mkal/db the Notebook column is empty for many events. So they belong to no calendar and hence they are not displayed.
sqlite3 /home/nemo/.local/share/system/privileged/Calendar/mkcal/db "SELECT * FROM Components WHERE Notebook = '';"
There must be a bug in mkcal while creating/persisting the calendar entries. Maybe the NotebookUUIDs are freed before the calendar entries are persisted?
Update 5: The bug is still present on 1.0.8.19.
Edit: changed sqlite to sqlite3
The sync client is now OSS see https://github.com/nemomobile/buteo-sync-plugins-social
Have the same problem after the update.
siggi_digital ( 2014-04-12 10:29:13 +0200 )editI have several external calendars synced with my google calendat, and they were never displayed. I was just waiting for an update to change that, and now you're saying you had those displayed already?!
Bimberle ( 2014-04-13 14:51:29 +0200 )editI have 4 own calendars. They show up in jolla. But calendars shared with me by others do not.
harry ( 2014-04-13 22:09:25 +0200 )editI have all google calendars displayed in the app. Maybe you can try link text ? that is supposed to group your google calendars
pat_o ( 2014-04-14 17:48:58 +0200 )editI know this site and all my own calendars (4) and some shared calendars from others are checked. My own calendars even appear in the jolla calendar app when I go to "Manage calendar", but only the events from one calendar show up. Do you see events from more then one of your google calendars in jolla?
harry ( 2014-04-14 18:08:54 +0200 )edit