cordova-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Carl Mason (JIRA)" <>
Subject [jira] [Created] (CB-592) SQLITE Error code = 23, msg = not authorized (Intermittently)
Date Fri, 27 Apr 2012 09:47:48 GMT
Carl Mason created CB-592:

             Summary: SQLITE Error code = 23, msg = not authorized (Intermittently)
                 Key: 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

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

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:!default.jspa
For more information on JIRA, see:


View raw message