480760 - Conversion to new database scheme fails on update

Status: RESOLVED WORKSFORME

(Calendar :: Provider: Local Storage, defect)

Description

[Rubén Martín [:Nukeador] ❌ [away till Aug 31st]]

User-Agent:       Mozilla/5.0 (X11; U; Linux i686; es-ES; rv:1.9.1b2) Gecko/20081201 Firefox/3.1b2
Build Identifier: 

I've just updated my lightning extension (using Tb3 beta 2) to the latest nightly (28-Feb-2009 04:00) and once I restart Thunderbird I get 3 error windows, two of them empty and the last one displaying:

[Exception... "Component returned failure code: 0x80004005 (NS_ERROR_FAILURE) [mozIStorageConnection.executeSimpleSQL]"  nsresult: "0x80004005 (NS_ERROR_FAILURE)"  location: "JS frame :: file:///home/nuke/.thunderbird/i7is6gje.tb3/extensions/%7Be2fda1a4-762b-4020-b5ad-a41df1933103%7D/modules/calUtils.jsm -> file:///home/nuke/.thunderbird/i7is6gje.tb3/extensions/%7Be2fda1a4-762b-4020-b5ad-a41df1933103%7D/calendar-js/calStorageCalendar.js :: anonymous :: line 416"  data: no]

The previous tasks are lost and just the remote calendars are accessible, the rest of them just display their names but with no content.

If you need me to test more thing or give you more information I can reproduce this error all the times just using the old storage file.

Reproducible: Always

Steps to Reproduce:
1. Create some task and events in remote/local calendars with a Lightning version previous to the database schema change
2. Install the latest nighlty and restart Tb
3. Try to access your previous calendars and tasks

Comment 1

[Stefan Sitter [:ssitter]]

Do you remember the version and BuildID of the Lightning version used before?

Current nightly builds are very broken. Does the update works if you upgrade to the 20090225 or 20090226 build? Previous nightly builds can be found at <http://ftp.mozilla.org/pub/mozilla.org/calendar/lightning/nightly/2009/02/>.

Comment 2

[Rubén Martín [:Nukeador] ❌ [away till Aug 31st]]

Unfortunately I can't remember which was the old version but the problem persist using these versions too.

When was the database schema changed? Maybe we can discover when the problem started.

Comment 3

[Rubén Martín [:Nukeador] ❌ [away till Aug 31st]]

I've found on another computer the old Lightning version installed and it only displays Lightning/1.0pre as version.

How can I get more information about the exact BuildID?

Comment 4

[Stefan Sitter [:ssitter]]

Current nightly builds are usable again. When repeating the upgrade test ensure that you replace storage.sdb and remove calendar-data\local.sqlite if already existent.

Comment 5

[Rubén Martín [:Nukeador] ❌ [away till Aug 31st]]

With March 8th build just one remote calendar is imported and the task interface goes to a weird "read-only mode" where I can't change filter, it's grayed. The task are imported three times.

Comment 6

[Stefan Sitter [:ssitter]]

Rubén, update from Thunderbird 2 / Lightning 0.9 release to Thunderbird 3 / Lightning 1.0b1 release should work correctly. Therefore I suggest to close this bug report.