Only one calendars events visible when two calendars have same names

asked 2020-03-06 13:19:09 +0300

kandelabra gravatar image

updated 2020-03-06 15:54:00 +0300

jiit gravatar image

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

edit retag flag offensive close delete

Comments

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

I 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 +0300 )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

image description

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

I 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 +0300 )edit

@Damien Caliste Is it possible to pull these UID out of the backup fles?

kandelabra ( 2020-03-10 10:24:29 +0300 )edit