Closed Bug 450285 Opened 15 years ago Closed 15 years ago

Startup Error: mozStorage exception: createStatement failed

Categories

(Calendar :: Provider: Local Storage, defect)

defect
Not set
normal

Tracking

(Not tracked)

RESOLVED FIXED

People

(Reporter: ssitter, Assigned: ssitter)

References

Details

(Keywords: regression)

Attachments

(1 file)

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 statementsSplinter 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: 15 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.