458059 - After installing a lightning 0.9 update it lost the all calendar data

Status: RESOLVED DUPLICATE of bug 470430

(Calendar :: General, defect)

Description

[Woody]

User-Agent:       Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.3) Gecko/2008092417 Firefox/3.0.3
Build Identifier: version 2.0.0.17 (20080914)

My boss installed the Lightning 0.9 update this morning and now it will not load the lightning calendar at all and will not let us revert back to the 0.8. It says the calendar has been updated with a newer version. I found a nightly build that was supposed be able to fix this problem but it said it was for version 3.0.
  We receives the following errors

[Exception... "Component returned failure code: 0x80004005 (NS_ERROR_FAILURE) [mozIStorageConnection.executeSimpleSQL]"  nsresult: "0x80004005 (NS_ERROR_FAILURE)"  location: "JS frame :: file:///C:/Documents%20and%20Settings/lbrunk/Application%20Data/Thunderbird/Profiles/jx1ewvs7.default/extensions/%7Be2fda1a4-762b-4020-b5ad-a41df1933103%7D/components/calStorageCalendarModule.js -> file:///C:/Documents%20and%20Settings/lbrunk/Application%20Data/Thunderbird/Profiles/jx1ewvs7.default/extensions/%7Be2fda1a4-762b-4020-b5ad-a41df1933103%7D/js/calStorageCalendar.js :: addColumn :: line 898"  data: no] 

This 



Reproducible: Always

Steps to Reproduce:
1.Update Lightning to 0.9
2.restart Thunderbird.
3.Click on Calendar icon in left information bar then click back to email.
Actual Results:  
[Exception... "Component returned failure code: 0x80004005 (NS_ERROR_FAILURE) [mozIStorageConnection.executeSimpleSQL]"  nsresult: "0x80004005 (NS_ERROR_FAILURE)"  location: "JS frame :: file:///C:/Documents%20and%20Settings/lbrunk/Application%20Data/Thunderbird/Profiles/jx1ewvs7.default/extensions/%7Be2fda1a4-762b-4020-b5ad-a41df1933103%7D/components/calStorageCalendarModule.js -> file:///C:/Documents%20and%20Settings/lbrunk/Application%20Data/Thunderbird/Profiles/jx1ewvs7.default/extensions/%7Be2fda1a4-762b-4020-b5ad-a41df1933103%7D/js/calStorageCalendar.js :: addColumn :: line 898"  data: no] 

Expected Results:  
Loaded calendar

Comment 1

[Woody]

I got the database to load correctly on the machine by changing the table entry cal_calendar_schema_version to 14 from it's previous state of 11.

Comment 2

[Woody]

the previous comment was in reference to the storage.sdb file in the user profile.

Comment 3

[Phillip Kenyon]

I encountered a similar error after upgrading sunbird 0.3.1 to sunbird 0.9 (I know the exact version because I never upgraded till now & I store copies of everything useful I download.  The suggestion above to use a DB editing tool to edit the cal_calendar_schema_version from 11 to the new 14 in the storage.sdb file worked good. -
Also, 
The error that got me here was : 
"An error was encountered preparing the calendar located at moz-profile-calendar:// for use. IT will not be available"
0x80004005

(NS_ERROR_FAILURE) [mozIStorageConnection.executeSimpleSQL]"  nsresult: "0x80004005 (NS_ERROR_FAILURE)"  location: "JS frame :: file:///C:/Program%20Files/Mozilla%20Sunbird/components/calStorageCalendarModule.js -> file:///C:/Program%20Files/Mozilla%20Sunbird/js/calStorageCalendar.js :: addColumn :: line 898"  data: no]

Comment 4

[Martin Schröder [:mschroeder]]

Confirmed in comment#3.

Comment 5

[Daniel Boelzle [:dbo]]

Woody, did your boss use nightly builds (0.9pre) before?

Comment 6

[Stefan Sitter [:ssitter]]

Could this be the same issue as described in Bug 456963? 

Woody, Phillip - do you run a Windows XP + Windows XP language pack as described in Bug 456963 Comment #7?

Comment 7

[Woody]

Stefan, 

We are running XP SP3. I have the exact installation on 3 other pc's but only this one failed. Also after changing the schema version the calendar did load but I could not do anything with it, you could view all the events but not update the claendar. You could open the create an event window but the Ok and cancel buttons failed to work. I finally had to export the calendar  then removed lightning and installed the latest release of Sunbird and imported the calendar back into sunbird. for her. I had to get it running quickly.

We do not have any language packs installed so i don't think it matches 456963

Comment 10

[Stefan Sitter [:ssitter]]

Same error has been reported for Mac OS X and Windows Vista.

Comment 11

[Daniel Boelzle [:dbo]]

Could anybody please figure out exact steps to reproduce the issue? Thanks!

It looks like the upgrade from 11->12 fails, i.e. one of the following:
                addColumn(this.mDB, "cal_attendees", "is_organizer", "BOOLEAN");
                addColumn(this.mDB, "cal_attendees", "properties", "BLOB");

Comment 12

[Torsten]

I have the same issue after installing lightning-0.9-tb-win.xpi.
I may have installed lightning and/or sunbird before, but not installed anymore. Maybe there was a local database already somewhere in the filesystem...

for Comment#11, my error console logs the following:

Fehler: Upgrade failed! DB Error: duplicate column name: is_organizer

Comment 13

[Torsten]

also see Bug 470430

Comment 14

[Torsten]

for me it worked to simply delete storage.sdb.
the next startup of thunderbird, the database has been recovered from scratch with - needless to say - no data in it. 
of course this is no scenario for Woodys Boss...

Comment 15

[Franz Wein]

Hi

when I installed version 0.9 I had the same issue: OS is Win XP SP3 (GERMAN)

[Exception... "Component returned failure code: 0x80004005 (NS_ERROR_FAILURE) [mozIStorageConnection.executeSimpleSQL]"  nsresult: "0x80004005 (NS_ERROR_FAILURE)"  location: "JS frame :: file:///C:/Programme/Mozilla%20Sunbird/components/calStorageCalendarModule.js -> file:///C:/Programme/Mozilla%20Sunbird/js/calStorageCalendar.js :: addColumn :: line 898"  data: no]

Has anybody an idea in what way I could restore my "old" calendar.

sinerely
Frnaz

Comment 16

[Philipp Kewisch [:Fallen][☁️📆]]

Franz, if you make a copy of the database and put it into a profile with whatever version you had before you had 0.9, does it still work there? If this works, export your calendar as ics, do an upgrade and see if its possible to import the ics calendar.