We have moved to a new Sailfish OS Forum. Please start new discussions there.

# Removed exchange accounts visible in calendar

I'm having a problem where the calendar app shows exchange accounts that have been removed. I currently have no exchange accounts configured on the phone but the calendar app still shows two accounts (or two instances of the same account to be exact).

I recently wiped my phone and readded my accounts. After this I recovered a backup which also had the same accounts configured. After the recovery the calendar showed two instances of the exchange account while accounts showed only one.

Removing the account removed only one of the instances in the calendar. Recovering the backup again added the account in accounts and another instance in calendar. Removing the account after this left two instances of the account in the calendar (and none in accounts).

I there a way to manually remove accounts from the calendar or do I need to wipe the phone again?

edit retag close delete

Sounds like something went wrong with the backup, you can disable the calendars in the calendar app. If you want to remove them completely the only way is removing calendar database, this will remove any local entries and also all calendars from any other existent account(local data only, not from the server side).

( 2014-02-21 08:37:08 +0300 )edit
3

Same issue here, the calendar is not removed when the exchange account is removed

( 2014-03-27 15:53:40 +0300 )edit
1

Same here, except I haven't done any backups. I just removed my Exchange account, didn't disable the calendar first from the calendar app (not sure if that's the cause). When I added the same Exchange account back, I now have two Exchange calendars in calendar app, and would really like to get rid of the old one that is not linked to an account anymore. When creating an event in the calendar app and selecting which calendar to create it into, it suggests all disabled calendars also. The only way to distinguish the wrong Exchange calendar is to select a really ugly colour for it. =) Where can I find the calendar database? I would gladly remove everything and add back only the calendars needed.

( 2014-05-14 18:30:47 +0300 )edit
1

It's in:

.local/share/system/privileged/Calendar/mkcal/

( 2014-05-15 18:53:48 +0300 )edit

Sort by » oldest newest most voted

It is possible to delete the stranded Exchange account:

1. Open a Terminal and become root: devel-su
2. Open the database: sqlite3 .local/share/system/privileged/Calendar/mkcal/db
3. List the Calendar Tables: sqlite> select * from Calendars;

7861cc88-3c44-334d-aa77-990b9e080fcf|Default||#0000FF|663|0|||-1|1369892463|||1391795775|| 76143208-02a8-41fd-9612-146cf94d4600|Microsoft Exchange|*@*.de|#000000|167|0|Default|5|20971520|1392647606|||1392647606||

1. Delete the Exchange Entry: sqlite> DELETE FROM Calendars Where CalendarId="76143208-02a8-41fd-9612-146cf94d4600";

Hope it works for you. Did for me ;-) 

more

2

I had the same problem, which seems to persist even on release 1.0.8.19. Thanks for the instructions on how to manually remove the leftover calendars!

However, I noticed that the actual calendar entries were still showing (all-black and without a calendar name - which I just deleted before). The individual calendar entries are in the table Components. The calendar ID is in a field named "Notebook". So in order to remove any leftover calendar entries:

sqlite> DELETE FROM Components WHERE Notebook="{calendarID}";


(Replace "{calendarID}" with the ID of the calendar to be deleted, obviously.)

That worked for me, though I have no idea if I've messed anything up. Be careful. :-)

( 2014-07-16 10:39:51 +0300 )edit

But the big problem is to find the ID so you can delete the "Notebook", if you already have deleted the Calendar by the command "DELETE FROM Calendars Where CalendarId="{calendarID}";".

I do not know the command in sqlite but it succeed me to find the ID by copying the db-file to the computer and using the program "SqliteBrowser".

By cleaning-up the db-file, I do now have no problem syncing with my outlook account.

( 2014-09-15 15:23:22 +0300 )edit

This answer helped, thanks, but I was not pleased to do this since I am a regular user and do not have any clue of doing something in Terminal. This is obviously a bug and it should have a proper fix for regular users. Maybe adding an option in Jolla Utilities for this problem?

( 2015-05-21 17:26:33 +0300 )edit

Thank you so much, Chan!!! It works fine for me ;)

( 2015-09-10 19:16:16 +0300 )edit
3

It's also possible to find something in attendee and customproperties table.

SELECT ComponentId FROM Components WHERE Notebook="{calendarID}";
DELETE FROM Attendee WHERE ComponentId='XXX';
DELETE FROM Customproperties WHERE ComponentId='XXX;
`
( 2017-10-18 18:55:25 +0300 )edit