530842 - Upgrade Sunbird/Lightning 0.9 to 1.0pre fails [error: no such table: idx_cal_alarms_cal_id_item_id_recurrence_id_recurrence_id_tz]

Status: RESOLVED FIXED

(Calendar :: Provider: Local Storage, defect)

Description

[Stefan Sitter [:ssitter]]

Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.1.6pre) Gecko/20091124 Calendar/1.0pre

Steps To Reproduce:
1. Create a new profile using Sunbird 0.9 (20080917)
2. Start with nightly build Calendar 1.0pre (20091124)

Actual Results:
A popup like "An error was encountered preparing the calendar located at moz-profile-calendar:// for use. It will not be available." Sunbird not usable.

Error Console output:
[calTimezoneService] timezones version: 1.2009p

Storage: Migrating storage.sdb -> local.sqlite

Error: [Exception... "Component returned failure code: 0x80004005 (NS_ERROR_FAILURE) [mozIStorageConnection.executeSimpleSQL]"  nsresult: "0x80004005 (NS_ERROR_FAILURE)"  location: "JS frame :: file:///D:/sunbird/calendar-js/calStorageCalendar.js :: anonymous :: line 219"  data: no], error: no such table: idx_cal_alarms_cal_id_item_id_recurrence_id_recurrence_id_tz

Error: [Exception... "Component returned failure code: 0x80004005 (NS_ERROR_FAILURE) [mozIStorageConnection.executeSimpleSQL]"  nsresult: "0x80004005 (NS_ERROR_FAILURE)"  location: "JS frame :: file:///D:/sunbird/calendar-js/calStorageCalendar.js :: anonymous :: line 219"  data: no]

Comment 1

[Philipp Kewisch [:Fallen][📱📆]]

*sigh*

Comment 2

[Stefan Sitter [:ssitter]]

Same error after upgrade from Thunderbird 2.0.0.24pre with Lightning 0.9.

Comment 3

[Philipp Kewisch [:Fallen][📱📆]]

Attachment: Fix - v1

Comment 4

[Martin Schröder [:mschroeder]]

Comment on attachment 414313 [details] [diff] [review]
Fix - v1

r=mschroeder (for the code)

Comment 5

[Stefan Sitter [:ssitter]]

Comment on attachment 414313 [details] [diff] [review]
Fix - v1

r=ssitter

Comment 6

[Philipp Kewisch [:Fallen][📱📆]]

Pushed to comm-central <http://hg.mozilla.org/comm-central/rev/c57a33c9ffbf> 
and comm-1.9.1  <http://hg.mozilla.org/releases/comm-1.9.1/rev/2ff61bdb6d08>

-> FIXED

Comment 7

[Stefan Vermeulen]

Same happend to me using now most recent Lightning 1.0b1

using the german Version of Calendar.

After migrating from a Vista to Win 7 System, I re-installed the Thunderbird + Lightning, I get the following message:

"Beim Bereitstellen des Kalenders mit der Adresse moz-profile-calendar:// ist ein Fehler aufgetreten. Er wird nicht 

verfügbar sein."
(When preparing calendar with the address moz-profile-calendar:// an error occured. It won't be available".
Error-Code: 0x80004005
Additonal description:
[Exception... "Component returned failure code: 0x80004005 (NS_ERROR_FAILURE) [mozIStorageConnection.executeSimpleSQL]"  

nsresult: "0x80004005 (NS_ERROR_FAILURE)"  location: "JS frame :: 

file:///C:/Users/stefan/AppData/Roaming/Thunderbird/Profiles/4yrqbqiz.default/extensions/%7Be2fda1a4-762b-4020-b5ad-

a41df1933103%7D/modules/calUtils.jsm -> file:///C:/Users/stefan

I had Lightning 0.9 with ThunderBithDay 0.2.9 as Extensions of Thunderbird 2.0.0.23 on he old computer, now it's 

Thunderbird 3.0.3 w/ Lightning 1.0b1 and ThunerBirthDay 0.3.3.

I saved the data using MozBackup 1.4.10-EN and restored it on the new computer w/ the same program. It seemed everythin was 

working fine, until I restarted Thunderbird and it updated some extensions (sorry, I didn't really write down which ones, 

but I think it was Lightning).

Now I cannot open any of the calendars, nor open new appointments nor do anything w/ the calendar.

Thank you in advance for your help!