View Single Post
Posts: 397 | Thanked: 185 times | Joined on Oct 2011
#6
Originally Posted by ynnad179 View Post
All right, I managed to remove my junk calendars by:

- Copying the file "db" from /home/user/.calendar to my PC
- Editing the "db" file (it's a SQLite file, so just use GUI/whatever you prefer)
- Copying it back to /home/user/.calendar (don't need root/super user)

How to remove junk calendars from the db file
In the table Calendars, you will see a list of calendars (Device, MfE, caldav). Note down. the CalendarId of the calendars you want to delete. Afterwards, delete the records of those calendars

Then, you have to remove ALL calendar entries in those calendars. Do so by removing the entries in the Components table. You may just want to use SQL commands like DELETE FROM Components WHERE Notebook = '<calendarId>' to save time.
(Tech note: the Notebook column in the Components table stores the calendarId.)

Then save the file, copy it back to your phone and it's done! Tested on my N9, PR1.1.

Jaylst: wanna add this to the tips and tricks? it'll be easier if someone just comes up with a script or something like that though!
Strange, I can't find any file inside the .calendar folder