456838 - Failed to load one of the local calendars

Status: VERIFIED DUPLICATE of bug 450256

(Calendar :: Lightning Only, defect)

Description

[Chris C]

User-Agent:       Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.2) Gecko/2008091620 Firefox/3.0.2
Build Identifier: Lightning 0.9 (build 2008091719)

Everytime I load Thunderbird, I'm having this error message :

[Exception... "Component returned failure code: 0x80004005 (NS_ERROR_FAILURE) [mozIStorageConnection.createTable]"  nsresult: "0x80004005 (NS_ERROR_FAILURE)"  location: "JS frame :: file:///P:/Mozilla/Thunderbird/extensions/%7Be2fda1a4-762b-4020-b5ad-a41df1933103%7D/components/calStorageCalendarModule.js -> file:///P:/Mozilla/Thunderbird/extensions/%7Be2fda1a4-762b-4020-b5ad-a41df1933103%7D/js/calStorageCalendar.js :: anonymous :: line 1236"  data: no]

It's happening with only one of my local calendars (I can email the ics file on request), and it didn't happen with 0.9pre build 2008081018.
I had already tested a more recent 0.9pre build, but I had this same problem.

Line 1236 of the quoted JS file :
"SELECT event_start_tz   AS zone FROM cal_events     WHERE event_start_tz   IS NOT NULL UNION " +

This line 1236 is about events, not todo entries. The point is, the only changes I have made to this calendar recently were to todo entries, not events. The latest change I did to an event is older than the current "stable", release I'm using right now (0.9pre 2008081018).

Reproducible: Always

Steps to Reproduce:
1.
2.
3.

Comment 1

[Stefan Sitter [:ssitter]]

If you installed the 20080810 nightly build you must recreate your database file. 

See corresponding blog post <http://weblogs.mozillazine.org/calendar/2008/08/daniels_developer_notes_be_car.html> and workaround in Bug 450256 Comment #11.

Did you do this?

Comment 2

[Chris C]

No I didn't...I guess my search criteria weren't good enough to find this bug.

Works now, thanks !