Only one calendars events visible when two calendars have same names
I had two calendars with same names. (Old one from Exchange was imported to Google Account as PST file after migrating our company emails to Google and it caused no problem there, I saw every event and notifications in my browser and desktop email client).
When I added Google calendar to SFOS old Exchange account was also added to Sailfish calendars (it's ok since I was subscribed to it via Google). But Sailfish showed events only from Exchange file - that obviously was emty. Exchange calendar somehow "covered" Google calendar. After disabling (not deleting) Exchange account in SFOS calendars settings events from Google calendar became visible at once.
I nearly missed the event due to this bug.
Sailfish X, 3.2.1.20
May I ask you to dump something ? Don't delete anything and try to run this command:
devel-su -p sqlite3 ~/.local/share/system/privileged/Calendar/mkcal/db "select * from calendars;"
This requires that you have installed sqlite package with
devel-su pkcon refresh; devel-su pkcon install sqlite
.It will list all the calendars currently stored in the database. I'm wondering if there are two of them having the same uid.
Damien Caliste ( 2020-03-06 13:33:48 +0200 )editI need to re-import this calendar since I already deleted it. Hope I still have this PST file. I'll try and report then.
kandelabra ( 2020-03-06 15:52:21 +0200 )edit@Damien Caliste I afraid I can't reimport it. It's about 6 Gb .pst file with all my emails for several years. All I can do now is to post screenshot with accounts names
In my Google account on desktop there were the same two calendars, so I guess that it was imported to SFOS device when I logged into Google account on this device.
kandelabra ( 2020-03-07 16:26:24 +0200 )editI was interesting to look at uid of notebooks as stored in the database, since they are the key of the hashtable storage. The name of the notebook is just a property. It was the obvious first thing to look at.
Damien Caliste ( 2020-03-09 10:28:06 +0200 )edit@Damien Caliste Is it possible to pull these UID out of the backup fles?
kandelabra ( 2020-03-10 10:24:29 +0200 )edit