버튼을클릭하면 숫자를입력하고 데이터베이스에 넣는건데 오류가 안나다가도 가끔씩 어플이 종료되는 에러가납니다.
에러로그를 로그입니다 이유를 모르겠습니다.
06-01 01:27:36.294: E/AndroidRuntime(2964): FATAL EXCEPTION: main
06-01 01:27:36.294: E/AndroidRuntime(2964): android.database.sqlite.SQLiteException: no such column: title: , while compiling: SELECT _id, title, amount, year, month, day FROM planner WHERE year = '2012' AND month = '6' AND day = '20'
06-01 01:27:36.294: E/AndroidRuntime(2964): at android.database.sqlite.SQLiteCompiledSql.native_compile(Native Method)
06-01 01:27:36.294: E/AndroidRuntime(2964): at android.database.sqlite.SQLiteCompiledSql.compile(SQLiteCompiledSql.java:92)
06-01 01:27:36.294: E/AndroidRuntime(2964): at android.database.sqlite.SQLiteCompiledSql.<init>(SQLiteCompiledSql.java:65)
06-01 01:27:36.294: E/AndroidRuntime(2964): at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:83)
06-01 01:27:36.294: E/AndroidRuntime(2964): at android.database.sqlite.SQLiteQuery.<init>(SQLiteQuery.java:49)
06-01 01:27:36.294: E/AndroidRuntime(2964): at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:42)
06-01 01:27:36.294: E/AndroidRuntime(2964): at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1356)
06-01 01:27:36.294: E/AndroidRuntime(2964): at android.database.sqlite.SQLiteDatabase.queryWithFactory(SQLiteDatabase.java:1235)
06-01 01:27:36.294: E/AndroidRuntime(2964): at android.database.sqlite.SQLiteDatabase.query(SQLiteDatabase.java:1189)
06-01 01:27:36.294: E/AndroidRuntime(2964): at android.database.sqlite.SQLiteDatabase.query(SQLiteDatabase.java:1271)
06-01 01:27:36.294: E/AndroidRuntime(2964): at com.bdk.sdiary.database.SDiaryDatabase.qustionDB(SDiaryDatabase.java:235)
06-01 01:27:36.294: E/AndroidRuntime(2964): at com.bdk.sdiary.accountBook.SDiaryAccountManagementListDialog$1.onClick(SDiaryAccountManagementListDialog.java:118)
06-01 01:27:36.294: E/AndroidRuntime(2964): at com.android.internal.app.AlertController$ButtonHandler.handleMessage(AlertController.java:160)
06-01 01:27:36.294: E/AndroidRuntime(2964): at android.os.Handler.dispatchMessage(Handler.java:99)
06-01 01:27:36.294: E/AndroidRuntime(2964): at android.os.Looper.loop(Looper.java:130)
06-01 01:27:36.294: E/AndroidRuntime(2964): at android.app.ActivityThread.main(ActivityThread.java:3740)
06-01 01:27:36.294: E/AndroidRuntime(2964): at java.lang.reflect.Method.invokeNative(Native Method)
06-01 01:27:36.294: E/AndroidRuntime(2964): at java.lang.reflect.Method.invoke(Method.java:507)
06-01 01:27:36.294: E/AndroidRuntime(2964): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:871)
06-01 01:27:36.294: E/AndroidRuntime(2964): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:629)
06-01 01:27:36.294: E/AndroidRuntime(2964): at dalvik.system.NativeStart.main(Native Method)




title이란 Column이 없다는데요. 데이터베이스 만드는데 문제가 있거나, 컬럼 이름을 잘못 지정하셨거나겠네요.