Fatal Exception raised when clicking in the "Search button"

[fmsouza]

It appears while opening the app for the very first time and clicking in the search button.

03-26 00:14:46.461 7694-7771/com.tormentaLabs.riobus I/OpenGLRenderer: Initialized EGL, version 1.4
03-26 00:14:50.008 7694-7694/com.tormentaLabs.riobus E/SQLiteLog: (1) no such column: NUMBER_OF_ACCESS
03-26 00:14:50.009 7694-7694/com.tormentaLabs.riobus D/AndroidRuntime: Shutting down VM
03-26 00:14:50.010 7694-7694/com.tormentaLabs.riobus E/AndroidRuntime: FATAL EXCEPTION: main
                                                                       Process: com.tormentaLabs.riobus, PID: 7694
                                                                       Theme: themes:{default=overlay:system}
                                                                       java.lang.RuntimeException: Unable to start activity ComponentInfo{com.tormentaLabs.riobus/com.tormentaLabs.riobus.search.SearchActivity_}: android.database.sqlite.SQLiteException: no such column: NUMBER_OF_ACCESS (code 1): , while compiling: SELECT * FROM LINES ORDER BY NUMBER_OF_ACCESS DESC
                                                                           at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2450)
                                                                           at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2510)
                                                                           at android.app.ActivityThread.-wrap11(ActivityThread.java)
                                                                           at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1363)
                                                                           at android.os.Handler.dispatchMessage(Handler.java:102)
                                                                           at android.os.Looper.loop(Looper.java:148)
                                                                           at android.app.ActivityThread.main(ActivityThread.java:5461)
                                                                           at java.lang.reflect.Method.invoke(Native Method)
                                                                           at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:726)
                                                                           at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:616)
                                                                        Caused by: android.database.sqlite.SQLiteException: no such column: NUMBER_OF_ACCESS (code 1): , while compiling: SELECT * FROM LINES ORDER BY NUMBER_OF_ACCESS DESC
                                                                           at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
                                                                           at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:889)
                                                                           at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:500)
                                                                           at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
                                                                           at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:58)
                                                                           at android.database.sqlite.SQLiteQuery.<init>(SQLiteQuery.java:37)
                                                                           at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:44)
                                                                           at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1316)
                                                                           at android.database.sqlite.SQLiteDatabase.rawQuery(SQLiteDatabase.java:1255)
                                                                           at com.tormentaLabs.riobus.core.controller.LineController.fetchCursor(LineController.java:55)
                                                                           at com.tormentaLabs.riobus.search.SearchActivity.afterViews(SearchActivity.java:61)
                                                                           at com.tormentaLabs.riobus.search.SearchActivity_.onViewChanged(SearchActivity_.java:90)
                                                                           at org.androidannotations.api.view.OnViewChangedNotifier.notifyViewChanged(OnViewChangedNotifier.java:41)
                                                                           at com.tormentaLabs.riobus.search.SearchActivity_.setContentView(SearchActivity_.java:55)
                                                                           at com.tormentaLabs.riobus.search.SearchActivity_.onCreate(SearchActivity_.java:44)
                                                                           at android.app.Activity.performCreate(Activity.java:6251)
                                                                           at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1108)
                                                                           at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2403)
                                                                           at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2510) 
                                                                           at android.app.ActivityThread.-wrap11(ActivityThread.java) 
                                                                           at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1363) 
                                                                           at android.os.Handler.dispatchMessage(Handler.java:102) 
                                                                           at android.os.Looper.loop(Looper.java:148) 
                                                                           at android.app.ActivityThread.main(ActivityThread.java:5461) 
                                                                           at java.lang.reflect.Method.invoke(Native Method) 
                                                                           at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:726) 
                                                                           at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:616) 

[limazix]

Last week I add this column to sort the lines by numbers of access. Since the is not in production I didn't create the migration structure. You just need to uninstall the app then install again. Doing this the DB will be recreated with the new structure.

[fmsouza]

Ok. So I'll leave this issue here for someone to fix before releasing the app for public.

[fmsouza]

If I do a wipe data before open the app, it works. Maybe it's trying to create the database on Android 6.0.1 but doesn't has the permission to access the storage, so the database is not created and the whole thing explodes...