User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:188.8.131.52) Gecko/20080702 Firefox/184.108.40.206 Build Identifier: Lightning 0.9pre 2008-08-17 19 / Thunderbird 220.127.116.11 / 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
Caused by bug 449401 probably.
Works for me using Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:18.104.22.168pre) 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.
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.
Status: UNCONFIRMED → RESOLVED
Last Resolved: 10 years ago
Resolution: --- → DUPLICATE
Duplicate of bug: 450406
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.
You need to log in before you can comment on or make changes to this bug.