Carl Mason created CB-592:
-----------------------------
Summary: SQLITE Error code = 23, msg = not authorized (Intermittently)
Key: CB-592
URL: https://issues.apache.org/jira/browse/CB-592
Project: Apache Callback
Issue Type: Bug
Components: Android, CordovaJS
Affects Versions: 1.6.1
Environment: Android 3.1. Cordova 1.6.1 but also older versions (also appears to
be the same in "phonegap" 1.3.0. Motorola Xoom. Eclipse. JQuery Mobile.
Reporter: Carl Mason
Assignee: Joe Bowser
Priority: Blocker
Intermittently receiving the error message, when executing an update statement on SQLLite
database.
04-27 10:22:38.288: I/SqliteDatabaseCpp(1428): sqlite returned: error code = 23, msg = not
authorized, db=/data/data/com.packagename/databases/webview.db
(example)
tx.executeSql('UPDATE JOB SET postcode = "' + $("#tbPostcode").val() + '" WHERE id = "' +
window.localStorage.getItem("job_id") +'"', [], querySuccess, errorCB);
It appears it could be to do with the version variable in openDatabase(..).
When I fire openDatabase on a FIRST execution with a version "1.0", create some tables and
insert some data - I will get the above error intermittently when trying to update. However,
if I then change all of the database interaction to a version "1.1" (or anything different)
and create a second database and start updating/interacting with the database the error goes
away. Obviously this is not a feasible workaround when deploying an app live. I must stress
that its intermittent, without any change to the code base.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
|