Closed Bug 530842 Opened 12 years ago Closed 12 years ago

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]

Categories

(Calendar :: Provider: Local Storage, defect)

defect
Not set
critical

Tracking

(Not tracked)

RESOLVED FIXED

People

(Reporter: ssitter, Assigned: Fallen)

Details

(Keywords: regression, Whiteboard: [needed beta][no l10n impact])

Attachments

(1 file)

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]
*sigh*
Assignee: nobody → philipp
Flags: blocking-calendar1.0+
Whiteboard: [needed beta][no l10n impact]
Same error after upgrade from Thunderbird 2.0.0.24pre with Lightning 0.9.
Keywords: regression
Summary: Upgrade Sunbird 0.9 to 1.0pre fails [error: no such table: idx_cal_alarms_cal_id_item_id_recurrence_id_recurrence_id_tz] → 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]
Attached patch Fix - v1Splinter Review
Attachment #414313 - Flags: review?(mschroeder)
Attachment #414313 - Flags: review?(ssitter)
Comment on attachment 414313 [details] [diff] [review]
Fix - v1

r=mschroeder (for the code)
Attachment #414313 - Flags: review?(mschroeder) → review+
Comment on attachment 414313 [details] [diff] [review]
Fix - v1

r=ssitter
Attachment #414313 - Flags: review?(ssitter) → review+
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
Status: NEW → RESOLVED
Closed: 12 years ago
OS: Windows 7 → All
Hardware: x86 → All
Resolution: --- → FIXED
Target Milestone: --- → 1.0
Target Milestone: 1.0 → 1.0b1
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!
You need to log in before you can comment on or make changes to this bug.