455358 - Database schema upgrade fails [An error was encountered preparing the calendar located at moz-profile-calendar:// for use.]

Status: RESOLVED WORKSFORME

(Calendar :: Internal Components, defect)

Description

[Stefan Sitter [:ssitter]]

[Trunk] database schema upgrade fails [An error was encountered preparing the calendar located at moz-profile-calendar:// for use.]

This is a follow-up bug for Bug 429521.

Upgrade test was done using Lightning 0.6a1 (20080914014006) together with Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1b1pre) Gecko/20080915030813 Shredder/3.0b1pre and a storage.sdb file created by Lightning 0.8 containing one event.

Upgrade still fails but I see different errors as in Bug 429521. After starting Shredder I get about 130 error dialog "An error was encountered preparing the calendar located at moz-profile-calendar:// for use. It will not be available."

Error Console shows:
[[[
Error: Assert failed: An error was encountered preparing the calendar located at moz-profile-calendar:// for use. It will not be available.
1: [<lightning-folder>/js/calUtils.js:1004] ASSERT
2: [<lightning-folder>/js/calCalendarManager.js:560] cmgr_createCalendar
3: [null:0] null
4: [chrome://calendar/content/calendar-management.js:114] loadCalendarManager
5: [chrome://calendar/content/calendar-chrome-startup.js:43] commonInitCalendar
Source file: <lightning-folder>/js/calUtils.js
Line: 1009
]]] (about 130 times)

[[[
Error: calendar is null
Source file: <lightning-folder>/js/calCalendarManager.js
Line: 580
]]] (about 260 times)

Console shows:
[[[
**** Upgrading calCalendarManager schema to 9/10
Windows version 5.1 < 6.0
**** Upgrading schema from 6/7/8/9 -> 10
timezones have been updated, updating calendar data.
timezones have been updated, updating calendar data.
mIsLightning is: true
mPlatform is: winnt
Checking for the old calendar extension/app
profileRoot = ...\Thunderbird\Profiles
searching for Firefox in ...\Mozilla\Firefox\Profiles
profileRoot = ...\Thunderbird\Profiles
searching for Sunbird in ...\Mozilla\Sunbird\Profiles
Checking for ical data
timezones have been updated, updating calendar data.
timezones have been updated, updating calendar data.
  ... (120 more messages 'timezones have been updated')  ...
timezones have been updated, updating calendar data.
timezones have been updated, updating calendar data.
using ...\Thunderbird\Profiles\h3wk0jr8.trunk\extensions\{e2fda1a4-762b-4020-b5ad-a41df1933103}\timezones.sqlitetime
zones version: 0.1.2008d
timezones have been updated, updating calendar data.
timezones have been updated, updating calendar data.
timezones have been updated, updating calendar data.
timezones have been updated, updating calendar data.
]]]

Comment 2

[Alexandre Leroux]

Don't know if it will help you but here's my log of what I believe might be the same bug. My platform is Linux so the bug should be listed as Linux too. Thanks!

[Exception... "Component returned failure code: 0x80004005 (NS_ERROR_FAILURE) [mozIStorageConnection.executeSimpleSQL]"  nsresult: "0x80004005 (NS_ERROR_FAILURE)"  location: "JS frame :: file:///users/dor/afsr/alx/.thunderbird/c2pj09la.default/extensions/%7Be2fda1a4-762b-4020-b5ad-a41df1933103%7D/components/calStorageCalendarModule.js -> file:///users/dor/afsr/alx/.thunderbird/c2pj09la.default/extensions/%7Be2fda1a4-762b-4020-b5ad-a41df1933103%7D/js/calStorageCalendar.js :: addColumn :: line 898"  data: no]

Comment 3

[Stefan Sitter [:ssitter]]

Works for me using Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1b3pre) Gecko/20081219 Calendar/1.0pre (BuildID: 20081219033507).

For testing I created a profile in Sunbird 0.5/0.7/0.8/0.9, added an event and task and opened the profile in Sunbird 1.0pre.