answered
2015-01-05 21:46:02 +0200
Kim 
2071 ●41 ●61 ●67
Thanks to the comments from jovirkku and jjaone, I have solved the problem.
For some reason the update have deleted all calendars except "Default" and "Birthdays", and it would seem I have (mostly) been using the calendar "Personal" (probably because this was the one imported from my N9).
Using Sqlite3 i exported the table Components to a csv file, using the following commands:
devel-su
cd /home/nemo/.local/share/system/privileged/Calendar/mkcal
sqlite3 ./db
.header on
.mode csv
.once /home/nemo/db.csv
select * from Components;
To get an idea of what calendars existed, and what their id was, I also executed the command:
select * from Calendars;
I then transferred db.csv to my laptop, and imported it into a spreadsheet.
I found the Notebook id of the missing entries, and reactivated them using this command:
update Components
set Notebook="[new notebook id]", DateDeleted=0
where DateDeleted=[DateDeleted] and Notebook="[old Notebook id]"
Where:
[new notebook id] is the id of the notebook you want the entries to appear in.
[DateDeleted] is the Linux time stamp of the update (also the value you'll find in the field DateDeleted on the calendar entries), in my case this was 1418927775.
[old Notebook id] the value in the field Notebook on the calendar entries.
I hope this helps someone.
Kim
My events are still there. I do sync with Exchange, which may have helped. Good luck with your problem!
rob_kouw ( 2014-12-20 16:22:03 +0200 )editI have the same thing. I made a backup as described below before the upgrade, events gone, restored the backup, events still gone. the db file is 414KB in size.
bennypr0fane ( 2015-01-02 17:12:09 +0200 )edit