android - Failed to open database -

-

sorry beating horse again- i'm testing app runs on smaller devices fails create or open database on tab. app runs on samsung s3 mini, i'm trying out on samsung tab.

relevant code snippets

private static string db_path = "/data/data/com.example.squashbotv2/databases/"; private static string db_name = "squashbot.db";

    string mypath = db_path + db_name;     checkdb = sqlitedatabase.opendatabase(mypath, null, sqlitedatabase.open_readonly);

logcat

11-27 10:46:21.772: d/dalvikvm(3733): gc_for_alloc freed 103k, 4% free 6830k/7047k, paused 20ms 11-27 10:46:21.788: d/dalvikvm(3733): gc_for_alloc freed 2k, 4% free 7130k/7367k, paused 16ms 11-27 10:46:21.795: i/sqlitedatabasecpp(3733): sqlite returned: error code = 14, msg = cannot open file @ line 27862 of [ed759d5a9e], db=/data/data/com.example.squashbotv2/databases/squashbot.db 11-27 10:46:21.795: i/sqlitedatabasecpp(3733): sqlite returned: error code = 14, msg = os_unix.c: open() @ line 27862 - "" errno=2 path=/data/data/com.example.squashbotv2/databases/squashbot.db, db=/data/data/com.example.squashbotv2/databases/squashbot.db 11-27 10:46:21.795: e/sqlitedatabasecpp(3733): sqlite3_open_v2("/data/data/com.example.squashbotv2/databases/squashbot.db", &handle, 1, null) failed 11-27 10:46:21.803: e/sqlitedatabase(3733): failed open database. closing it. 11-27 10:46:21.803: e/sqlitedatabase(3733): android.database.sqlite.sqlitecantopendatabaseexception: unable open database file 11-27 10:46:21.803: e/sqlitedatabase(3733):     @ android.database.sqlite.sqlitedatabase.dbopen(native method) 11-27 10:46:21.803: e/sqlitedatabase(3733):     @ android.database.sqlite.sqlitedatabase.opendatabase(sqlitedatabase.java:1123) 11-27 10:46:21.803: e/sqlitedatabase(3733):     @ android.database.sqlite.sqlitedatabase.opendatabase(sqlitedatabase.java:1074) 11-27 10:46:21.803: e/sqlitedatabase(3733):     @ android.database.sqlite.sqlitedatabase.opendatabase(sqlitedatabase.java:1050) 11-27 10:46:21.803: e/sqlitedatabase(3733):     @ database.database.checkdatabase(database.java:139) 11-27 10:46:21.803: e/sqlitedatabase(3733):     @ database.database.create(database.java:107) 11-27 10:46:21.803: e/sqlitedatabase(3733):     @ com.example.squashbotv2.dashboard.oncreate(dashboard.java:37) 11-27 10:46:21.803: e/sqlitedatabase(3733):     @ android.app.activity.performcreate(activity.java:4465) 11-27 10:46:21.803: e/sqlitedatabase(3733):     @ android.app.instrumentation.callactivityoncreate(instrumentation.java:1053) 11-27 10:46:21.803: e/sqlitedatabase(3733):     @ android.app.activitythread.performlaunchactivity(activitythread.java:1934) 11-27 10:46:21.803: e/sqlitedatabase(3733):     @ android.app.activitythread.handlelaunchactivity(activitythread.java:1995) 11-27 10:46:21.803: e/sqlitedatabase(3733):     @ android.app.activitythread.access$600(activitythread.java:128) 11-27 10:46:21.803: e/sqlitedatabase(3733):     @ android.app.activitythread$h.handlemessage(activitythread.java:1161) 11-27 10:46:21.803: e/sqlitedatabase(3733):     @ android.os.handler.dispatchmessage(handler.java:99) 11-27 10:46:21.803: e/sqlitedatabase(3733):     @ android.os.looper.loop(looper.java:137) 11-27 10:46:21.803: e/sqlitedatabase(3733):     @ android.app.activitythread.main(activitythread.java:4514) 11-27 10:46:21.803: e/sqlitedatabase(3733):     @ java.lang.reflect.method.invokenative(native method) 11-27 10:46:21.803: e/sqlitedatabase(3733):     @ java.lang.reflect.method.invoke(method.java:511) 11-27 10:46:21.803: e/sqlitedatabase(3733):     @ com.android.internal.os.zygoteinit$methodandargscaller.run(zygoteinit.java:790) 11-27 10:46:21.803: e/sqlitedatabase(3733):     @ com.android.internal.os.zygoteinit.main(zygoteinit.java:557) 11-27 10:46:21.803: e/sqlitedatabase(3733):     @ dalvik.system.nativestart.main(native method) 11-27 10:46:21.866: i/sqlitedatabasecpp(3733): sqlite returned: error code = 1, msg = no such table: android_metadata, db=/data/data/com.example.squashbotv2/databases/squashbot.db 11-27 10:46:21.866: e/sqlitedatabasecpp(3733): select locale android_metadata failed 11-27 10:46:21.866: e/sqlitedatabase(3733): failed open database. closing it. 11-27 10:46:21.866: e/sqlitedatabase(3733): android.database.sqlite.sqliteexception: no such table: android_metadata 11-27 10:46:21.866: e/sqlitedatabase(3733):     @ android.database.sqlite.sqlitedatabase.native_setlocale(native method) 11-27 10:46:21.866: e/sqlitedatabase(3733):     @ android.database.sqlite.sqlitedatabase.setlocale_(sqlitedatabase.java:2205) 11-27 10:46:21.866: e/sqlitedatabase(3733):     @ android.database.sqlite.sqlitedatabase.setlocale(sqlitedatabase.java:2193) 11-27 10:46:21.866: e/sqlitedatabase(3733):     @ android.database.sqlite.sqlitedatabase.opendatabase(sqlitedatabase.java:1124) 11-27 10:46:21.866: e/sqlitedatabase(3733):     @ android.database.sqlite.sqlitedatabase.opendatabase(sqlitedatabase.java:1074) 11-27 10:46:21.866: e/sqlitedatabase(3733):     @ android.database.sqlite.sqlitedatabase.opendatabase(sqlitedatabase.java:1050) 11-27 10:46:21.866: e/sqlitedatabase(3733):     @ database.database.open(database.java:187) 11-27 10:46:21.866: e/sqlitedatabase(3733):     @ com.example.squashbotv2.dashboard.oncreate(dashboard.java:47) 11-27 10:46:21.866: e/sqlitedatabase(3733):     @ android.app.activity.performcreate(activity.java:4465) 11-27 10:46:21.866: e/sqlitedatabase(3733):     @ android.app.instrumentation.callactivityoncreate(instrumentation.java:1053) 11-27 10:46:21.866: e/sqlitedatabase(3733):     @ android.app.activitythread.performlaunchactivity(activitythread.java:1934) 11-27 10:46:21.866: e/sqlitedatabase(3733):     @ android.app.activitythread.handlelaunchactivity(activitythread.java:1995) 11-27 10:46:21.866: e/sqlitedatabase(3733):     @ android.app.activitythread.access$600(activitythread.java:128) 11-27 10:46:21.866: e/sqlitedatabase(3733):     @ android.app.activitythread$h.handlemessage(activitythread.java:1161) 11-27 10:46:21.866: e/sqlitedatabase(3733):     @ android.os.handler.dispatchmessage(handler.java:99) 11-27 10:46:21.866: e/sqlitedatabase(3733):     @ android.os.looper.loop(looper.java:137) 11-27 10:46:21.866: e/sqlitedatabase(3733):     @ android.app.activitythread.main(activitythread.java:4514) 11-27 10:46:21.866: e/sqlitedatabase(3733):     @ java.lang.reflect.method.invokenative(native method) 11-27 10:46:21.866: e/sqlitedatabase(3733):     @ java.lang.reflect.method.invoke(method.java:511) 11-27 10:46:21.866: e/sqlitedatabase(3733):     @ com.android.internal.os.zygoteinit$methodandargscaller.run(zygoteinit.java:790) 11-27 10:46:21.866: e/sqlitedatabase(3733):     @ com.android.internal.os.zygoteinit.main(zygoteinit.java:557) 11-27 10:46:21.866: e/sqlitedatabase(3733):     @ dalvik.system.nativestart.main(native method) 11-27 10:46:21.866: d/androidruntime(3733): shutting down vm 11-27 10:46:21.866: w/dalvikvm(3733): threadid=1: thread exiting uncaught exception (group=0x40be51f8) 11-27 10:46:21.873: e/androidruntime(3733): fatal exception: main 11-27 10:46:21.873: e/androidruntime(3733): java.lang.runtimeexception: unable start activity componentinfo{com.example.squashbotv2/com.example.squashbotv2.dashboard}: android.database.sqlite.sqliteexception: no such table: android_metadata 11-27 10:46:21.873: e/androidruntime(3733):     @ android.app.activitythread.performlaunchactivity(activitythread.java:1970) 11-27 10:46:21.873: e/androidruntime(3733):     @ android.app.activitythread.handlelaunchactivity(activitythread.java:1995) 11-27 10:46:21.873: e/androidruntime(3733):     @ android.app.activitythread.access$600(activitythread.java:128) 11-27 10:46:21.873: e/androidruntime(3733):     @ android.app.activitythread$h.handlemessage(activitythread.java:1161) 11-27 10:46:21.873: e/androidruntime(3733):     @ android.os.handler.dispatchmessage(handler.java:99) 11-27 10:46:21.873: e/androidruntime(3733):     @ android.os.looper.loop(looper.java:137) 11-27 10:46:21.873: e/androidruntime(3733):     @ android.app.activitythread.main(activitythread.java:4514) 11-27 10:46:21.873: e/androidruntime(3733):     @ java.lang.reflect.method.invokenative(native method) 11-27 10:46:21.873: e/androidruntime(3733):     @ java.lang.reflect.method.invoke(method.java:511) 11-27 10:46:21.873: e/androidruntime(3733):     @ com.android.internal.os.zygoteinit$methodandargscaller.run(zygoteinit.java:790) 11-27 10:46:21.873: e/androidruntime(3733):     @ com.android.internal.os.zygoteinit.main(zygoteinit.java:557) 11-27 10:46:21.873: e/androidruntime(3733):     @ dalvik.system.nativestart.main(native method) 11-27 10:46:21.873: e/androidruntime(3733): caused by: android.database.sqlite.sqliteexception: no such table: android_metadata 11-27 10:46:21.873: e/androidruntime(3733):     @ android.database.sqlite.sqlitedatabase.native_setlocale(native method) 11-27 10:46:21.873: e/androidruntime(3733):     @ android.database.sqlite.sqlitedatabase.setlocale_(sqlitedatabase.java:2205) 11-27 10:46:21.873: e/androidruntime(3733):     @ android.database.sqlite.sqlitedatabase.setlocale(sqlitedatabase.java:2193) 11-27 10:46:21.873: e/androidruntime(3733):     @ android.database.sqlite.sqlitedatabase.opendatabase(sqlitedatabase.java:1124) 11-27 10:46:21.873: e/androidruntime(3733):     @ android.database.sqlite.sqlitedatabase.opendatabase(sqlitedatabase.java:1074) 11-27 10:46:21.873: e/androidruntime(3733):     @ android.database.sqlite.sqlitedatabase.opendatabase(sqlitedatabase.java:1050) 11-27 10:46:21.873: e/androidruntime(3733):     @ database.database.open(database.java:187) 11-27 10:46:21.873: e/androidruntime(3733):     @ com.example.squashbotv2.dashboard.oncreate(dashboard.java:47) 11-27 10:46:21.873: e/androidruntime(3733):     @ android.app.activity.performcreate(activity.java:4465) 11-27 10:46:21.873: e/androidruntime(3733):     @ android.app.instrumentation.callactivityoncreate(instrumentation.java:1053) 11-27 10:46:21.873: e/androidruntime(3733):     @ android.app.activitythread.performlaunchactivity(activitythread.java:1934) 11-27 10:46:21.873: e/androidruntime(3733):     ... 11 more

i have tried:

  • cleaning
  • uninstalling & reinstalling

searching through similar queries online there not seem 1 solid solution, , seems if problem can caused number of different things. can help?

thanx in advance


Comments

Post a Comment

Popular posts from this blog

matlab - "Contour not rendered for non-finite ZData" -

-
i'm trying plot frequency characteristic equation using ezplot, matlab gives following warning, "contour not rendered non-finite zdata". have used command plot frequency equations warning , plot display empty , not change axis range well. can please help. appreciated. here's code i'm using. % transfer matrix case-i, thin rotor clear all; clc; ei = 1626; l = 0.15; m = 0.44108; = 2.178*10^-4; i_p = 2.205*10^-5; itr = 0.24; i_pr = 0.479; syms p n; f = [1 l*1i l^2/(2*ei)*1i l^3/(6*ei); 0 1 l/ei -l^2/(2*ei)*1i; 0 0 1 -l*1i; 0 0 0 l]; p = [ 1 0 0 0; 0 1 0 0; 0 -it*p^2+i_p*n*p 1 0; -m*p^2 0 0 1]; p_r = [1 0 0 0; 0 1 0 0; 0 -itr*p^2+i_pr*n*p 1 0; -m*p^2 0 0 1]; = f*p*f*p*f*p*f; b = p_r*f*p*f*p*f; r = a(1,2)/a(1,4); a12_p = 0; a22_p = a(2,2)-r*a(2,4); a32_p = a(3,2)-r*a(3,4); a42_p = a(4,2)-r*a(4,4); ap(2,2) = a22_p; ap(3,2) = a32_p; ap(4,2) = a42_p; ap(4,4) = 1; c = b*ap; m = [c(3,2) c(3,4); c(4,2) c(4,...
Read more

delphi - Indy UDP Read Contents of Adata -

-
i using indy udp server read string of data. however, not know how work adata parameter. can around converting binary using bytetobin function below , convert hex using bintohex1 . feel stupid , works slow. know how can directly results without 2 conversions? thanks!! here codes: procedure tform1.idudpserver1udpread(athread: tidudplistenerthread; const adata: tidbytes; abinding: tidsockethandle); var buf: tidbytes; buffer: string; data_received: string; begin if bytestostring(adata) <> 'hello' begin buffer := hextostring('00'); setlength(buf, length(buffer)); copytidstring(buffer, buf, 0); abinding.sendto(abinding.peerip, abinding.peerport, buf); data_received := bintohex1(bytetobin(adata[1]) + bytetobin(adata[2]) + bytetobin(adata[3]) + bytetobin(adata[4]) + bytetobin(adata[5]) + bytetobin(adata[6]) + bytetobin(adata[7]) + bytetobin(adata[8]) + bytetobin(adata[9]) + bytetobin(adata[10]) + bytetobin(adata[11...
Read more

qt - How to embed QML toolbar and menubar into QMainWindow -

-
i using qwt library plot data. seems not possible embed qwidget qml quick 2 . so, decided create qmainwindow main window , create toolbar , menubar using quick controls . how should embed qml toolbar , menubar qmainwindow ? you should create qml applicationwindow qml menubar , toolbar main.qml applicationwindow { visible: false menubar: menubar { menu { title: "edit" menuitem { text: "cut" } } } toolbar: toolbar { row { anchors.fill: parent toolbutton { iconsource: "1.png" } } } } main.cpp qapplication app(argc, argv); qqmlapplicationengine engine; engine.load(qurl(qstringliteral("qrc:///main.qml"))); then pointer applicationwindow qwindow *qmlwindow = qobject_cast<qwindow*>(engine.rootobjects().at(0)); create window container, using qwidget::createwindowco...
Read more