[TIMOB-1311] iOS: App Acting Oddly Because of SQLite DB Errors From Plausiblelabs
| GitHub Issue | n/a |
|---|---|
| Type | Bug |
| Priority | Medium |
| Status | Closed |
| Resolution | Invalid |
| Resolution Date | 2012-07-25T12:08:29.000+0000 |
| Affected Version/s | n/a |
| Fix Version/s | n/a |
| Components | iOS |
| Labels | n/a |
| Reporter | grant (at grantd) |
| Assignee | Neeraj Gupta |
| Created | 2011-04-15T02:49:06.000+0000 |
| Updated | 2012-07-26T22:26:16.000+0000 |
Description
My app was working fine on the device and simulator until it started acting really odd (can't navigate between tabs) and throwing errors (hundreds) in the API console like the one below. I don't use any SQL or database stuff in my app so I have no idea where this is coming from but it's ruining my app. Any help would be great.
Thanks,
Grant
2010-07-15 14:49:07.850 eConnect[265:207] [ERROR] A SQLite database error occurred on database '/Users//Library/Application Support/iPhone Simulator/4.0/Applications/901D53C8-F186-4960-A7A2-0305361/Library/Application Support/analytics/analytics.db': Error Domain=com.plausiblelabs.pldatabase Code=3 "An error occured parsing the provided SQL statement." UserInfo=0x7d5**** {com.plausiblelabs.pldatabase.error.vendor.code=1, NSLocalizedDescription=An error occured parsing the provided SQL statement., com.plausiblelabs.pldatabase.error.query.string=INSERT INTO pending_events VALUES (?), com.plausiblelabs.pldatabase.error.vendor.string=no such table: pending_events} (SQLite #1: no such table: pending_events) (query: 'INSERT INTO pending_events VALUES (?)')
Got it! I deleted the files in /Users/Me/Application Support/iPhone Simulator/4.0/Applications/ and the errors stopped. I lost me app's settings, but the problem was still fixed.
Caused by reporter's app being in inappropriate state. See comment.