DB에 새로운 칼럼을 추가 하기 전까지만 해도 잘 되다가 추가만 하면 오류가 뜨면서 앱이 종료 됩니다.

뭐 이런 상황이 일어나는 것인지...황당해서.... 이유도 모르겠구요....

 db.execSQL("CREATE TABLE today(_id INTEGER PRIMARY KEY AUTOINCREMENT, "
         +"title TEXT, " + "date TEXT, "+  "point TEXT, "  + "memo TEXT, "+"message TEXT);"); 

이부분이 DB 클래스 중에서 onCreate 부분입니다. 분명히 "message TEXT" 부분을 넣기 전에는 잘 돌아가던 것이 이부분을 넣자 마자 애러가 뜨네요... 황당... 뭐가 문제 일까요?? ㅜㅜ

SQLite를 사용해서 아이에 따로 DB를 구성해야 될지...이클립스에서 소스로만 DB를 하니 계속 애러만 발생해서...

10-30 01:00:26.156: E/AndroidRuntime(1419): FATAL EXCEPTION: main
10-30 01:00:26.156: E/AndroidRuntime(1419): java.lang.RuntimeException: Unable to start activity ComponentInfo{com.android.calednar/com.android.calednar.TodayActivity}: android.database.sqlite.SQLiteException: no such column: date: , while compiling: SELECT * FROM today WHERE date = '2012년10월1일'
10-30 01:00:26.156: E/AndroidRuntime(1419):  at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:1956)
10-30 01:00:26.156: E/AndroidRuntime(1419):  at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:1981)
10-30 01:00:26.156: E/AndroidRuntime(1419):  at android.app.ActivityThread.access$600(ActivityThread.java:123)
10-30 01:00:26.156: E/AndroidRuntime(1419):  at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1147)
10-30 01:00:26.156: E/AndroidRuntime(1419):  at android.os.Handler.dispatchMessage(Handler.java:99)
10-30 01:00:26.156: E/AndroidRuntime(1419):  at android.os.Looper.loop(Looper.java:137)
10-30 01:00:26.156: E/AndroidRuntime(1419):  at android.app.ActivityThread.main(ActivityThread.java:4424)
10-30 01:00:26.156: E/AndroidRuntime(1419):  at java.lang.reflect.Method.invokeNative(Native Method)
10-30 01:00:26.156: E/AndroidRuntime(1419):  at java.lang.reflect.Method.invoke(Method.java:511)
10-30 01:00:26.156: E/AndroidRuntime(1419):  at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:784)
10-30 01:00:26.156: E/AndroidRuntime(1419):  at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:551)
10-30 01:00:26.156: E/AndroidRuntime(1419):  at dalvik.system.NativeStart.main(Native Method)
10-30 01:00:26.156: E/AndroidRuntime(1419): Caused by: android.database.sqlite.SQLiteException: no such column: date: , while compiling: SELECT * FROM today WHERE date = '2012년10월1일'
10-30 01:00:26.156: E/AndroidRuntime(1419):  at android.database.sqlite.SQLiteCompiledSql.native_compile(Native Method)
10-30 01:00:26.156: E/AndroidRuntime(1419):  at android.database.sqlite.SQLiteCompiledSql.<init>(SQLiteCompiledSql.java:68)
10-30 01:00:26.156: E/AndroidRuntime(1419):  at android.database.sqlite.SQLiteProgram.compileSql(SQLiteProgram.java:143)
10-30 01:00:26.156: E/AndroidRuntime(1419):  at android.database.sqlite.SQLiteProgram.compileAndbindAllArgs(SQLiteProgram.java:361)
10-30 01:00:26.156: E/AndroidRuntime(1419):  at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:127)
10-30 01:00:26.156: E/AndroidRuntime(1419):  at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:94)
10-30 01:00:26.156: E/AndroidRuntime(1419):  at android.database.sqlite.SQLiteQuery.<init>(SQLiteQuery.java:53)
10-30 01:00:26.156: E/AndroidRuntime(1419):  at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:47)
10-30 01:00:26.156: E/AndroidRuntime(1419):  at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1564)
10-30 01:00:26.156: E/AndroidRuntime(1419):  at android.database.sqlite.SQLiteDatabase.rawQuery(SQLiteDatabase.java:1538)
10-30 01:00:26.156: E/AndroidRuntime(1419):  at com.android.calednar.TodayActivity.onCreate(TodayActivity.java:49)
10-30 01:00:26.156: E/AndroidRuntime(1419):  at android.app.Activity.performCreate(Activity.java:4465)
10-30 01:00:26.156: E/AndroidRuntime(1419):  at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1049)
10-30 01:00:26.156: E/AndroidRuntime(1419):  at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:1920)
10-30 01:00:26.156: E/AndroidRuntime(1419):  ... 11 more
10-30 01:00:26.176: E/DropBoxManagerService(885): Can't write: data_app_crash
10-30 01:00:26.176: E/DropBoxManagerService(885): java.io.IOException: Can't list files: /data/system/dropbox
10-30 01:00:26.176: E/DropBoxManagerService(885):  at com.android.server.DropBoxManagerService.init(DropBoxManagerService.java:574)
10-30 01:00:26.176: E/DropBoxManagerService(885):  at com.android.server.DropBoxManagerService.add(DropBoxManagerService.java:168)
10-30 01:00:26.176: E/DropBoxManagerService(885):  at android.os.DropBoxManager.addText(DropBoxManager.java:272)
10-30 01:00:26.176: E/DropBoxManagerService(885):  at com.android.server.am.ActivityManagerService$11.run(ActivityManagerService.java:7704)