cordova-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Nolan Lawson (JIRA)" <>
Subject [jira] [Comment Edited] (CB-592) SQLITE Error code = 23, msg = not authorized (Intermittently)
Date Fri, 08 Mar 2013 18:24:13 GMT


Nolan Lawson edited comment on CB-592 at 3/8/13 6:22 PM:

Issue filed: CB-2639.  Thanks for the commentary, [~bowserj].

[edit] Moved my questions to the other bug; no sense in posting them here.
      was (Author: nolanlawson):
    Issue filed: CB-2639.  Thanks for the commentary, [~bowserj].

So if Android 4.x uses Cordova's implementation, any idea why it would fail on 4.0.4?  Also,
would it be possible to simply use the Cordova implementation everywhere, assuming the native
implementation on older Android devices is just hopelessly broken?

Also, if WebSQL is being deprecated, is the future-proof recommended solution to just use
a native SQLite plugin ([such as this one|])?
> SQLITE Error code = 23, msg = not authorized (Intermittently)
> -------------------------------------------------------------
>                 Key: CB-592
>                 URL:
>             Project: Apache Cordova
>          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: Minor
> 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
> (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)
deploy the application and execute a second time - and go on to 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. 

This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see:

View raw message