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

Removed exchange accounts visible in calendar

asked 2014-02-19 14:04:52 +0300

eesko gravatar image

updated 2020-03-06 13:01:16 +0300

kandelabra gravatar image

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 flag offensive close delete

Comments

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).

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

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

workless ( 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.

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

It's in:

.local/share/system/privileged/Calendar/mkcal/
VDVsx ( 2014-05-15 18:53:48 +0300 )edit

1 Answer

Sort by » oldest newest most voted
8

answered 2014-05-19 11:22:22 +0300

Chan gravatar image

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 ;-) `

edit flag offensive delete publish link more

Comments

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. :-)

thepepor ( 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.

elkiaer ( 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?

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

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

carmenfdezb ( 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;
EanderAlx ( 2017-10-18 18:55:25 +0300 )edit
Login/Signup to Answer

Question tools

Follow
9 followers

Stats

Asked: 2014-02-19 14:04:52 +0300

Seen: 841 times

Last updated: Mar 06