matburt/mobileorg-android — Issue #177: SQLiteException ("no such column") resulting in FC after new install
Author: ssafar
Created: 2012-03-04 09:29:22+00:00
State: open

I just installed version 0.8.3 (free) from the Market, however, it doesn't start (force closes after trying to start it). I'm using a Sony-Ericsson Xperia X8, Android 2.1 (the one that came with the phone).

From adb logcat:

```
I/ActivityManager( 1202): Starting activity: Intent { cmp=com.matburt.mobileorg/.Settings.WizardActivity }
W/SQLiteDirectCursorDriver(11346): 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;
D/AndroidRuntime(11346): Shutting down VM
W/dalvikvm(11346): threadid=3: thread exiting with uncaught exception (group=0x40026160)
E/AndroidRuntime(11346): Uncaught handler: thread main exiting due to uncaught exception
E/AndroidRuntime(11346): 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
E/AndroidRuntime(11346):	at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2503)
E/AndroidRuntime(11346):	at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2519)
E/AndroidRuntime(11346):	at android.app.ActivityThread.access$2200(ActivityThread.java:123)
E/AndroidRuntime(11346):	at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1870)
E/AndroidRuntime(11346):	at android.os.Handler.dispatchMessage(Handler.java:99)
E/AndroidRuntime(11346):	at android.os.Looper.loop(Looper.java:123)
E/AndroidRuntime(11346):	at android.app.ActivityThread.main(ActivityThread.java:4370)
E/AndroidRuntime(11346):	at java.lang.reflect.Method.invokeNative(Native Method)
E/AndroidRuntime(11346):	at java.lang.reflect.Method.invoke(Method.java:521)
E/AndroidRuntime(11346):	at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:868)
E/AndroidRuntime(11346):	at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:626)
E/AndroidRuntime(11346):	at dalvik.system.NativeStart.main(Native Method)
E/AndroidRuntime(11346): 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
E/AndroidRuntime(11346):	at android.database.sqlite.SQLiteProgram.native_compile(Native Method)
E/AndroidRuntime(11346):	at android.database.sqlite.SQLiteProgram.compile(SQLiteProgram.java:110)
E/AndroidRuntime(11346):	at android.database.sqlite.SQLiteProgram.(SQLiteProgram.java:59)
E/AndroidRuntime(11346):	at android.database.sqlite.SQLiteQuery.(SQLiteQuery.java:49)
E/AndroidRuntime(11346):	at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:49)
E/AndroidRuntime(11346):	at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1221)
E/AndroidRuntime(11346):	at android.database.sqlite.SQLiteDatabase.rawQuery(SQLiteDatabase.java:1194)
E/AndroidRuntime(11346):	at com.matburt.mobileorg.Parsing.OrgDatabase.getFileCursor(OrgDatabase.java:96)
E/AndroidRuntime(11346):	at com.matburt.mobileorg.Gui.OutlineActivity.refreshDisplay(OutlineActivity.java:137)
E/AndroidRuntime(11346):	at com.matburt.mobileorg.Gui.OutlineActivity.onCreate(OutlineActivity.java:102)
E/AndroidRuntime(11346):	at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1047)
E/AndroidRuntime(11346):	at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2466)
E/AndroidRuntime(11346):	... 11 more
E/SemcCheckin(11346): Get crash dump level : java.io.FileNotFoundException: /data/semc-checkin/crashdump
W/ActivityManager( 1202): Unable to start service Intent { act=com.sonyericsson.android.jcrashcatcher.action.BUGREPORT_AUTO cmp=com.sonyericsson.android.jcrashcatcher/.JCrashCatcherService (has extras) }: not found
```