[ https://issues.apache.org/jira/browse/CB-2912?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13623945#comment-13623945 ]
Thibault Durand commented on CB-2912: ------------------------------------- Do you switch for Android 4.x only since 2.6.0 ? Because i didn't have any issue before. And yes, normally i have the error with websql on creating table which exists, but it's not causing the app to crash. And yes i know i shouldn't use websql anymore, but indexed db is just pain in the ass. Seems websql will be supported on mobile device for a long time. > Android 4.X SQLite issue ( maybe conflict using websql) > ------------------------------------------------------- > > Key: CB-2912 > URL: https://issues.apache.org/jira/browse/CB-2912 > Project: Apache Cordova > Issue Type: Bug > Components: Android > Affects Versions: 2.6.0 > Environment: Android 4.0.3 , Android 4.2 > Reporter: Thibault Durand > Assignee: Joe Bowser > Priority: Minor > > Hello, > I have an issue with my app using the last version of cordova with cordova > CLI (NPM , version @2.6.0) > Cordova version is master : commit 47593b2bc1dba9bf46545b1da24577f937966e12 > My app use websql, and it seems there are some conflict with SQLite on > Android 4.X , android 2.X works just fine (i don't really know what websql > api uses...) > Here is the stacktrace, the database seems to be initialized but each request > trigger a System error : > 04-05 11:58:13.413: W/System.err(5739): > android.database.sqlite.SQLiteException: table user_card already exists: , > while compiling: CREATE TABLE user_card( id INTEGER NOT NULL PRIMARY KEY > AUTOINCREMENT, card_stat_id INTEGER, es TEXT, fr TEXT, it TEXT, de TEXT, > esperanto TEXT, en TEXT, txt_es TEXT, txt_fr TEXT, txt_en TEXT, txt_it TEXT, > txt_de TEXT, txt_esperanto TEXT, typeCard TEXT, usage TEXT, genre TEXT, image > TEXT, licence TEXT, sound TEXT, linked_card TEXT, tags TEXT, category TEXT, > level INTEGER ); > 04-05 11:58:13.413: W/System.err(5739): at > android.database.sqlite.SQLiteCompiledSql.native_compile(Native Method) > 04-05 11:58:13.413: W/System.err(5739): at > android.database.sqlite.SQLiteCompiledSql.<init>(SQLiteCompiledSql.java:68) > 04-05 11:58:13.413: W/System.err(5739): at > android.database.sqlite.SQLiteProgram.compileSql(SQLiteProgram.java:134) > 04-05 11:58:13.413: W/System.err(5739): at > android.database.sqlite.SQLiteProgram.compileAndbindAllArgs(SQLiteProgram.java:361) > 04-05 11:58:13.413: W/System.err(5739): at > android.database.sqlite.SQLiteStatement.acquireAndLock(SQLiteStatement.java:260) > 04-05 11:58:13.413: W/System.err(5739): at > android.database.sqlite.SQLiteStatement.executeUpdateDelete(SQLiteStatement.java:84) > 04-05 11:58:13.413: W/System.err(5739): at > android.database.sqlite.SQLiteDatabase.executeSql(SQLiteDatabase.java:2034) > 04-05 11:58:13.413: W/System.err(5739): at > android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1974) > 04-05 11:58:13.413: W/System.err(5739): at > org.apache.cordova.Storage.executeSql(Storage.java:169) > 04-05 11:58:13.413: W/System.err(5739): at > org.apache.cordova.Storage.execute(Storage.java:83) > 04-05 11:58:13.413: W/System.err(5739): at > org.apache.cordova.api.CordovaPlugin.execute(CordovaPlugin.java:66) > 04-05 11:58:13.413: W/System.err(5739): at > org.apache.cordova.api.PluginManager.exec(PluginManager.java:222) > 04-05 11:58:13.413: W/System.err(5739): at > org.apache.cordova.ExposedJsApi.exec(ExposedJsApi.java:44) > 04-05 11:58:13.413: W/System.err(5739): at > android.webkit.JWebCoreJavaBridge.sharedTimerFired(Native Method) > 04-05 11:58:13.413: W/System.err(5739): at > android.webkit.JWebCoreJavaBridge.sharedTimerFired(Native Method) > 04-05 11:58:13.413: W/System.err(5739): at > android.webkit.JWebCoreJavaBridge.fireSharedTimer(JWebCoreJavaBridge.java:92) > 04-05 11:58:13.413: W/System.err(5739): at > android.webkit.JWebCoreJavaBridge.handleMessage(JWebCoreJavaBridge.java:108) > 04-05 11:58:13.413: W/System.err(5739): at > android.os.Handler.dispatchMessage(Handler.java:99) > 04-05 11:58:13.413: W/System.err(5739): at > android.os.Looper.loop(Looper.java:137) > 04-05 11:58:13.413: W/System.err(5739): at > android.webkit.WebViewCore$WebCoreThread.run(WebViewCore.java:823) > 04-05 11:58:13.413: W/System.err(5739): at > java.lang.Thread.run(Thread.java:856) > Cordova 2.5.0 and under works fine. > Thanks -- 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: http://www.atlassian.com/software/jira