Closed Bug 450285 Opened 17 years ago Closed 17 years ago

Startup Error: mozStorage exception: createStatement failed

Categories

(Calendar :: Provider: Local Storage, defect)

Product:
Calendar
Component:
Provider: Local Storage
Type:
defect
Priority:
Not set
Severity:
normal

Tracking

(Not tracked)

Status:
RESOLVED FIXED

People

(Reporter: ssitter, Assigned: ssitter)

References

Details

(Keywords: regression)

Attachments

(1 file)

fix statements
2.54 KB, patch
Fallen
: review+
Details | Diff | Splinter Review
Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.2pre) Gecko/2008081209 Calendar/0.6a1 Steps to Reproduce: 1. Start Sunbird with new profile 2. Check Error Console Actual Results: Error: mozStorage exception: createStatement failed, statement: 'SELECT * FROM cal_attendees WHERE item_id = :item_id AND cal_id = 0AND recurrence_id IS NULL', error: 'unrecognized token: "0AND"' - [Exception... "Component returned failure code: 0x80004005 (NS_ERROR_FAILURE) [mozIStorageConnection.createStatement]" nsresult: "0x80004005 (NS_ERROR_FAILURE)" location: "JS frame :: file:///.../js/calStorageCalendar.js :: createStatement :: line 112" data: no] Source file: file:///.../js/calStorageCalendar.js Line: 119 Error: mozStorage exception: createStatement failed, statement: 'SELECT * FROM cal_attendees WHERE item_id = :item_id AND cal_id = 0AND recurrence_id = :recurrence_id AND recurrence_id_tz = :recurrence_id_tz', error: 'unrecognized token: "0AND"' - [Exception... "Component returned failure code: 0x80004005 (NS_ERROR_FAILURE) [mozIStorageConnection.createStatement]" nsresult: "0x80004005 (NS_ERROR_FAILURE)" location: "JS frame :: file:///.../js/calStorageCalendar.js :: createStatement :: line 112" data: no] Source file: file:///.../js/calStorageCalendar.js Line: 119 Error: mozStorage exception: createStatement failed, statement: 'SELECT * FROM cal_properties WHERE item_id = :item_id AND cal_id = 0AND recurrence_id = :recurrence_id AND recurrence_id_tz = :recurrence_id_tz', error: 'unrecognized token: "0AND"' - [Exception... "Component returned failure code: 0x80004005 (NS_ERROR_FAILURE) [mozIStorageConnection.createStatement]" nsresult: "0x80004005 (NS_ERROR_FAILURE)" location: "JS frame :: file:///.../js/calStorageCalendar.js :: createStatement :: line 112" data: no] Source file: file:///.../js/calStorageCalendar.js Line: 119 Error: mozStorage exception: createStatement failed, statement: 'SELECT * FROM cal_recurrence WHERE item_id = :item_id AND cal_id = 0ORDER BY recur_index', error: 'unrecognized token: "0ORDER"' - [Exception... "Component returned failure code: 0x80004005 (NS_ERROR_FAILURE) [mozIStorageConnection.createStatement]" nsresult: "0x80004005 (NS_ERROR_FAILURE)" location: "JS frame :: file:///.../js/calStorageCalendar.js :: createStatement :: line 112" data: no] Source file: file:///.../js/calStorageCalendar.js Line: 119
Flags: blocking-calendar0.9?
Attached patch fix statements — — Splinter Review
Assignee: nobody → ssitter
Status: NEW → ASSIGNED
Attachment #333433 - Flags: review?(daniel.boelzle)
Blocks: 449401
Comment on attachment 333433 [details] [diff] [review] fix statements Looks good, r=philipp
Attachment #333433 - Flags: review?(daniel.boelzle) → review+
Checked in on HEAD and MOZILLA_1_8_BRANCH -> FIXED
Status: ASSIGNED → RESOLVED
Closed: 17 years ago
Flags: blocking-calendar0.9?
OS: Windows XP → All
Hardware: PC → All
Resolution: --- → FIXED
Target Milestone: --- → 0.9
You need to log in before you can comment on or make changes to this bug.

Attachment

General

Creator:
Created:
Updated:
Size: