BentFranklin
asked on
Undelete Lightning Calendar
Windows 7
Thunderbird 6
Lightning 1.0b5
I deleted a calendar hosted locally, one that I thought had no events in it. Lightning asked "Are you sure you want to unsubscribe to this calendar?" This sounded innocuous so I unsubscribed, and then in horror all my events went away. So, I went ahead and tried to resubscribe by making a new calendar with the same name. No luck. Am I hosed? Or is there a way to use the backup ics files in my Thunderbird profile to restore my state?
UPDATE: SEE LAST POST FOR SOLUTION
Thunderbird 6
Lightning 1.0b5
I deleted a calendar hosted locally, one that I thought had no events in it. Lightning asked "Are you sure you want to unsubscribe to this calendar?" This sounded innocuous so I unsubscribed, and then in horror all my events went away. So, I went ahead and tried to resubscribe by making a new calendar with the same name. No luck. Am I hosed? Or is there a way to use the backup ics files in my Thunderbird profile to restore my state?
UPDATE: SEE LAST POST FOR SOLUTION
ASKER
More information:
For simplicity I didn't mention above that there were two calendars, one local (named Home) and one an ics on a network share (named Office). I had delete the Home calendar thinking it was empty, but apparently the past few weeks of entries had been into the home calendar. It appears the ics files in calendar-data/backup are all backups of the ics data. So, to extract the missing events, it has to come from the local.sqlite or the storage.sdb.
For simplicity I didn't mention above that there were two calendars, one local (named Home) and one an ics on a network share (named Office). I had delete the Home calendar thinking it was empty, but apparently the past few weeks of entries had been into the home calendar. It appears the ics files in calendar-data/backup are all backups of the ics data. So, to extract the missing events, it has to come from the local.sqlite or the storage.sdb.
ASKER
More information:
storage.sdb is on 3702 bytes and hasn't changed since I installed Lightning over a year ago. the sqlite files are much larger.
I'm trying to browse the sqlite data using PHPLiteAdmin. That is creating its own challenges.
storage.sdb is on 3702 bytes and hasn't changed since I installed Lightning over a year ago. the sqlite files are much larger.
I'm trying to browse the sqlite data using PHPLiteAdmin. That is creating its own challenges.
ASKER
Got PHPLiteAdmin working and found all the missing records in one of the sqlite databases!
It looks like I have to manually editing prefs.js to have Lightning recognize the calendar. Created a new local calendar as a template. Easy enough to change the GUID for cal-id. But what else does it require/expect?
It looks like I have to manually editing prefs.js to have Lightning recognize the calendar. Created a new local calendar as a template. Easy enough to change the GUID for cal-id. But what else does it require/expect?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I'm glad to see you figured it out. Thanks for listing the steps.
I suggest you accept your last comment as the solution. Your points will be refunded to you, and the question & answer will be saved for others to learn from in the future.
I suggest you accept your last comment as the solution. Your points will be refunded to you, and the question & answer will be saved for others to learn from in the future.
ASKER
Please state your reason for accepting your own comment as the solution:
My reason for accepting my own comment as the solution.
My reason for accepting my own comment as the solution.
ASKER
Questions:
1. What version of sqlite is that file?
2. Is the data contained there or in storage.sdb?
3. What is the purpose of all the ics files in calendar-data/backup?