Calendar appointments disappeared after upgrading to Thunderbird 3.1.5 Lightning 1.0b2

UNCONFIRMED
Unassigned

Status

Calendar
Lightning Only
UNCONFIRMED
7 years ago
7 years ago

People

(Reporter: Jeff, Unassigned)

Tracking

Details

(Reporter)

Description

7 years ago
User-Agent:       Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; GTB6.6; .NET CLR 1.1.4322; InfoPath.1; .NET CLR 2.0.50727; MS-RTC LM 8; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)
Build Identifier: 1.0b2

I had been getting a prompt to upgrade Thunderbird for a while but kept deferring until today. I finally accepted the upgrade which included a new version of Lightning. The upgrade seemed to be successful but hung when it restarted Thunderbird. There was a noticed about a non-responsive script which I think made a reference to Lightning. I eventually was able to get Thunderbird open and it worked fine. However, my calendar is empty. I noticed a couple error on the error console but they didn't mean much to me. They are:

Error: Can't create calendar for 6347394b-c4c8-4aa0-b0e4-766e1d643c5c (storage, moz-profile-calendar://): [Exception... "Component returned failure code: 0x80004005 (NS_ERROR_FAILURE) [mozIStorageConnection.executeSimpleSQL]"  nsresult: "0x80004005 (NS_ERROR_FAILURE)"  location: "JS frame :: file:///E:/PortableApps/ThunderbirdPortable/Data/profile/extensions/%7Be2fda1a4-762b-4020-b5ad-a41df1933103%7D/modules/calUtils.jsm -> file:///E:/PortableApps/ThunderbirdPortable/Data/profile/extensions/%7Be2fda1a4-762b-4020-b5ad-a41df1933103%7D/calendar-js/calStorageCalendar.js :: cSC_prepareInitDB :: line 246"  data: no]

and...

Error: [Exception... "Component returned failure code: 0x80004005 (NS_ERROR_FAILURE) [mozIStorageConnection.executeSimpleSQL]"  nsresult: "0x80004005 (NS_ERROR_FAILURE)"  location: "JS frame :: file:///E:/PortableApps/ThunderbirdPortable/Data/profile/extensions/%7Be2fda1a4-762b-4020-b5ad-a41df1933103%7D/modules/calUtils.jsm -> file:///E:/PortableApps/ThunderbirdPortable/Data/profile/extensions/%7Be2fda1a4-762b-4020-b5ad-a41df1933103%7D/calendar-js/calStorageCalendar.js :: cSC_prepareInitDB :: line 246"  data: no], error: table cal_calendar_schema_version already exists

Reproducible: Always

Steps to Reproduce:
1. Open Thunderbird
2. look at empty calendar
3.
Actual Results:  
When I look at my calendar, all of my events are gone. 

Expected Results:  
I expected to see the events that existed in the calendar prior to the upgrade.
What version(s) did you upgrade from? The calendar data is not lost, it just seems there is trouble loading the database. Somewhere on our blog there is a link to an extension that may be able to fix your issue, I can't find it right now though.
(Reporter)

Comment 2

7 years ago
Thanks for the reply Philipp. I don't recall which version I was using prior to the upgrade but I believe it was 2.?. I did quite a bit of searching the day I had the issue and didn't have any success finding a solution. I will look specifically for a link to an extension and see if I have any luck. In the mean time, if anyone else knows where to find the link/extension, please post.

Thanks!!
(Reporter)

Comment 3

7 years ago
I just found the update history. I upgraded from 2.0.0.24 which was installed on 4/11/2010. I installed 6 security updates from the time I installed 2.0.0.14 on 9/9/2008 and the time I installed 3.1.5 on 11/15/2010. I realize you don't ask for the history but I thought it might be helpful to show I've been using Thunderbird for quite some time and the calendar data has survived a number of updates.
Jeff, sorry for the late reply, I was unsure how to solve this issue remotely. If you don't have confidential information in your profile, maybe you can send it to me zipped? I'll try to debug and find out what the upgrade issue is.

See http://support.mozillamessaging.com/en-US/kb/Profiles 
The minimum files I need are:

prefs.js
storage.sdb
calendar-data/local.sqlite
calendar-data/cache.sqlite

Files I specifically don't need:

ImapMail/
Mail/
cert8.dir
[somenumber].s
abook.mab
"cert7.db" and "cert8.db"
key3.db
secmod.db
signons.txt (and all files with signons in the name)
Jeff, any updates on this?
(Reporter)

Comment 6

7 years ago
Sorry Philipp, I haven't had time to look at this until now. I just found some of the data you are looking for but I didn't find cache.sqlite. The modified date of Storage.sdb matches the upgrade date. The other files were updated this past week. Do you still want the data? I can tell you the appointments I lost have all come and gone so there is no value in retrieving them. However, if this would help prevent the problem from occurring in the future, I'm all for it. Just realized I need to ask one question - would the storage.sdb file contain confidential info? If so, what type of info?
(In reply to comment #6)
> Sorry Philipp, I haven't had time to look at this until now. I just found some
> of the data you are looking for but I didn't find cache.sqlite. 
Its ok if you don't have cache.sqlite, it is only created if you use cached calendars.


>The modified
> date of Storage.sdb matches the upgrade date. The other files were updated this
> past week. Do you still want the data? I can tell you the appointments I lost
> have all come and gone so there is no value in retrieving them. 
So you are saying you've recreated all appointments that have lost? Or did you just ignore them? If its the latter, then I'd still like the data and possibly a title of a few of the events you have lost.

> However, if
> this would help prevent the problem from occurring in the future, I'm all for
> it. Just realized I need to ask one question - would the storage.sdb file
> contain confidential info? If so, what type of info?
The storage.sdb used to contain calendar data in 0.9, but this data was moved to local.sqlite with the 1.0b1 upgrade. It is theoretically possible that other extensions have used this file to store data, but I don't know if this is the case. If you would like to examine this file beforehand, you can download the sqlite manager extension. You can also examine local.sqlite with it:

https://addons.mozilla.org/firefox/addon/sqlite-manager/
You need to log in before you can comment on or make changes to this bug.