matburt/mobileorg-android — Issue #183: Crash during startup: "no such column: file.node_id"
Author: altruizine
Created: 2012-03-05 19:32:35+00:00
State: open

MobileOrg 0.8.3 crashes during startup with the log output below. Using Android 2.1-update1 on a Motorola Flipout. Tried fresh install (deleted the app's data) -- no improvement. Version 0.6.2 used to work.

Thanks!

03-05 20:24:02.139 3183 3183 I sqlite3 : log level set to 0
03-05 20:24:02.303 3183 3183 W SQLiteDirectCursorDriver: Found SQL string that ends in ; -- SELECT data.* FROM orgdata data JOIN(SELECT f.node_id FROM files f) file on file.node_id = data._id ORDER BY data.name ASC;
03-05 20:24:02.311 3183 3183 D AndroidRuntime: Shutting down VM
03-05 20:24:02.311 3183 3183 W dalvikvm: threadid=3: thread exiting with uncaught exception (group=0x4001e288)
03-05 20:24:02.311 3183 3183 E AndroidRuntime: Uncaught handler: thread main exiting due to uncaught exception
03-05 20:24:02.311 3183 3183 E AndroidRuntime: java.lang.RuntimeException: Unable to start activity ComponentInfo{com.matburt.mobileorg/com.matburt.mobileorg.Gui.OutlineActivity}: android.database.sqlite.SQLiteException: no such column: file.node_id: , while compiling: SELECT data.* FROM orgdata data JOIN(SELECT f.node_id FROM files f) file on file.node_id = data._id ORDER BY data.name ASC
03-05 20:24:02.311 3183 3183 E AndroidRuntime: at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2558)
03-05 20:24:02.311 3183 3183 E AndroidRuntime: at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2574)
03-05 20:24:02.311 3183 3183 E AndroidRuntime: at android.app.ActivityThread.access$2400(ActivityThread.java:121)
03-05 20:24:02.311 3183 3183 E AndroidRuntime: at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1925)
03-05 20:24:02.311 3183 3183 E AndroidRuntime: at android.os.Handler.dispatchMessage(Handler.java:99)
03-05 20:24:02.311 3183 3183 E AndroidRuntime: at android.os.Looper.loop(Looper.java:136)
03-05 20:24:02.311 3183 3183 E AndroidRuntime: at android.app.ActivityThread.main(ActivityThread.java:4425)
03-05 20:24:02.311 3183 3183 E AndroidRuntime: at java.lang.reflect.Method.invokeNative(Native Method)
03-05 20:24:02.311 3183 3183 E AndroidRuntime: at java.lang.reflect.Method.invoke(Method.java:521)
03-05 20:24:02.311 3183 3183 E AndroidRuntime: at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:850)
03-05 20:24:02.311 3183 3183 E AndroidRuntime: at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:608)
03-05 20:24:02.311 3183 3183 E AndroidRuntime: at dalvik.system.NativeStart.main(Native Method)
03-05 20:24:02.311 3183 3183 E AndroidRuntime: Caused by: android.database.sqlite.SQLiteException: no such column: file.node_id: , while compiling: SELECT data.* FROM orgdata data JOIN(SELECT f.node_id FROM files f) file on file.node_id = data._id ORDER BY data.name ASC
03-05 20:24:02.311 3183 3183 E AndroidRuntime: at android.database.sqlite.SQLiteProgram.native_compile(Native Method)
03-05 20:24:02.311 3183 3183 E AndroidRuntime: at android.database.sqlite.SQLiteProgram.compile(SQLiteProgram.java:132)
03-05 20:24:02.311 3183 3183 E AndroidRuntime: at android.database.sqlite.SQLiteProgram.(SQLiteProgram.java:62)
03-05 20:24:02.311 3183 3183 E AndroidRuntime: at android.database.sqlite.SQLiteQuery.(SQLiteQuery.java:49)
03-05 20:24:02.311 3183 3183 E AndroidRuntime: at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:49)
03-05 20:24:02.311 3183 3183 E AndroidRuntime: at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1245)
03-05 20:24:02.311 3183 3183 E AndroidRuntime: at android.database.sqlite.SQLiteDatabase.rawQuery(SQLiteDatabase.java:1218)
03-05 20:24:02.311 3183 3183 E AndroidRuntime: at com.matburt.mobileorg.Parsing.OrgDatabase.getFileCursor(OrgDatabase.java:96)
03-05 20:24:02.311 3183 3183 E AndroidRuntime: at com.matburt.mobileorg.Gui.OutlineActivity.refreshDisplay(OutlineActivity.java:137)
03-05 20:24:02.311 3183 3183 E AndroidRuntime: at com.matburt.mobileorg.Gui.OutlineActivity.onCreate(OutlineActivity.java:102)
03-05 20:24:02.311 3183 3183 E AndroidRuntime: at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1047)
03-05 20:24:02.311 3183 3183 E AndroidRuntime: at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2521)
03-05 20:24:02.311 3183 3183 E AndroidRuntime: ... 11 more
03-05 20:24:02.318 1214 1214 I Process : Sending signal. PID: 3183 SIG: 3
03-05 20:24:02.318 1214 1214 E ActivityManager: SIGNAL_QUIT: to crashed process 3183
03-05 20:24:02.334 3183 3185 I dalvikvm: threadid=7: reacting to signal 3
03-05 20:24:02.334 3183 3185 I dalvikvm: Wrote stack trace to '/data/anr/traces.txt'