450993 - cal_id not found when I create a new storage calendar

Status: VERIFIED DUPLICATE of bug 450406

(Calendar :: Provider: Local Storage, defect)

Description

[Pete Riley]

User-Agent:       Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.16) Gecko/20080702 Firefox/2.0.0.16
Build Identifier: Lightning 0.9pre 2008-08-17 19 / Thunderbird 2.0.0.16 / WinXP

The cal_id column isn't found when I create a new storage calendar.  The error console shows LOTS of errors like this:

Error: mozStorage exception: createStatement failed, statement: 'SELECT * FROM cal_attendees WHERE item_id = :item_id AND cal_id = 2 AND recurrence_id IS NULL', error: 'no such column: cal_id' - [Exception... "Component returned failure code: 0x80004005 (NS_ERROR_FAILURE) [mozIStorageConnection.createStatement]"  nsresult: "0x80004005 (NS_ERROR_FAILURE)"  location: "JS frame :: file:///C:/Data/Databases/Thunderbird/extensions/%7Be2fda1a4-762b-4020-b5ad-a41df1933103%7D/components/calStorageCalendarModule.js -> file:///C:/Data/Databases/Thunderbird/extensions/%7Be2fda1a4-762b-4020-b5ad-a41df1933103%7D/js/calStorageCalendar.js :: createStatement :: line 112"  data: no]
Source File: file:///C:/Data/Databases/Thunderbird/extensions/%7Be2fda1a4-762b-4020-b5ad-a41df1933103%7D/components/calStorageCalendarModule.js -> file:///C:/Data/Databases/Thunderbird/extensions/%7Be2fda1a4-762b-4020-b5ad-a41df1933103%7D/js/calStorageCalendar.js
Line: 119


The problem isn't just with the cal_attendees table, there are error messages for most or all of the tables.

Reproducible: Always

Steps to Reproduce:
1) In Lightning, double click under calendar list in calendar mode.
2) Accept the default calendar type ("On My Computer")
   and click Next.
Actual Results:  
Lots of errors

Comment 1

[Bas van den Bosch]

Caused by bug 449401 probably.

Comment 2

[Stefan Sitter [:ssitter]]

Works for me using Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.8.1.17pre) Gecko/2008081720 Calendar/0.9pre.

Did you installed the 20080810 nightly build? In that case you need to recreate the database file. See Bug 450406.

Comment 3

[Pete Riley]

Stefan, you're right, I did install the nightly that had the bad schema.  I didn't realize it because I don't usually use storage calendars and I didn't have any problems until last night when I was trying to test something with a storage calendar.  I'll re-create my storage.sdb when I have time tonight and close this bug if everything's okay.

Bas, thanks for the link to that other bug.

Comment 5

[Pete Riley]

I re-created my storage.sdb and calendars and everything is working again.

So that I don't have to do this again, I now version storage.sdb and my local ics files each day.  This is of course more useful than just a single backup copy, especially in a situation like this where the problem is hidden for many days.