Closed Bug 450285 Opened 15 years ago Closed 15 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: 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.