mardi 1 mars 2016

SQLite - Problems opening a db that exists

I am running the cordova sqlite-ext plugin (http://ift.tt/1RDSQvE) with my cordova android project and have attempted to open a pre-existing sqlite .db. I keep seeing the error below, saying that it is opening my database but not finding the tables.

I decided to rename the database completely to "wibblewobble" to see if it would produce an unknown error since wibblewobble does not exist but I am still getting the same result.

Anyone using sqlite plugin can explain why this is appearing in my logcat and my content is not appearing? Why am I receiving fake errors saying the database is opening when it clearly is not?

 03-01 10:59:22.210 850-911/cafr.b.appfinder W/PluginManager: THREAD WARNING: exec() call to SQLitePlugin.open blocked the main thread for 71ms. Plugin should use CordovaInterface.getThreadPool().
 03-01 10:59:22.510 850-850/cafr.b.appfinder I/chromium: [INFO:CONSOLE(106)] "new transaction is waiting for open operation", source: file:///android_asset/www/plugins/cordova-sqlite-ext/www/SQLitePlugin.js (106)
 03-01 10:59:23.780 850-850/cafr.b.appfinder I/chromium: [INFO:CONSOLE(80)] "DB opened: wibblewobble.db", source: file:///android_asset/www/plugins/cordova-sqlite-ext/www/SQLitePlugin.js (80)
 03-01 10:59:24.240 850-911/cafr.b.appfinder W/PluginManager: THREAD WARNING: exec() call to SQLitePlugin.backgroundExecuteSqlBatch blocked the main thread for 64ms. Plugin should use CordovaInterface.getThreadPool().
 03-01 10:59:25.880 850-903/cafr.b.appfinder E/SQLiteLog: (1) no such table: MainDatabase
 03-01 10:59:25.890 850-903/cafr.b.appfinder W/System.err: android.database.sqlite.SQLiteException: no such table: MainDatabase (code 1): , while compiling: SELECT DISTINCT Category FROM `MainDatabase`
 03-01 10:59:25.890 850-903/cafr.b.appfinder W/System.err:     at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)

Aucun commentaire:

Enregistrer un commentaire