1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56
| 11-01 20:06:17.270 339-339/com.example.kevin.quizzapp2 E/Database﹕ Failure 1 (AUTOINCREMENT is only allowed on an INTEGER PRIMARY KEY) on 0x2d2840 when preparing 'CREATE TABLE IF NOT EXISTS Question(idINTEGER PRIMARY KEY AUTOINCREMENT,questionTEXT,reponseTEXTt,optionATEXT,optionBTEXT,optionCTEXT)'.
11-01 20:06:17.311 339-339/com.example.kevin.quizzapp2 E/SQLiteOpenHelper﹕ Couldn't open QuizzApp for writing (will try read-only):
android.database.sqlite.SQLiteException: AUTOINCREMENT is only allowed on an INTEGER PRIMARY KEY: CREATE TABLE IF NOT EXISTS Question(idINTEGER PRIMARY KEY AUTOINCREMENT,questionTEXT,reponseTEXTt,optionATEXT,optionBTEXT,optionCTEXT)
at android.database.sqlite.SQLiteDatabase.native_execSQL(Native Method)
at android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1763)
at com.example.kevin.quizzapp2.MySQLiteOpenHelper.onCreate(MySQLiteOpenHelper.java:45)
at android.database.sqlite.SQLiteOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:126)
at android.database.sqlite.SQLiteOpenHelper.getReadableDatabase(SQLiteOpenHelper.java:187)
at com.example.kevin.quizzapp2.MySQLiteOpenHelper.getAllQuestion(MySQLiteOpenHelper.java:82)
at com.example.kevin.quizzapp2.QuizzActivity.onCreate(QuizzActivity.java:29)
at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1047)
at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:1611)
at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:1663)
at android.app.ActivityThread.access$1500(ActivityThread.java:117)
at android.app.ActivityThread$H.handleMessage(ActivityThread.java:931)
at android.os.Handler.dispatchMessage(Handler.java:99)
at android.os.Looper.loop(Looper.java:123)
at android.app.ActivityThread.main(ActivityThread.java:3683)
at java.lang.reflect.Method.invokeNative(Native Method)
at java.lang.reflect.Method.invoke(Method.java:507)
at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:839)
at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:597)
at dalvik.system.NativeStart.main(Native Method)
11-01 20:06:17.331 339-339/com.example.kevin.quizzapp2 D/AndroidRuntime﹕ Shutting down VM
11-01 20:06:17.340 339-339/com.example.kevin.quizzapp2 W/dalvikvm﹕ threadid=1: thread exiting with uncaught exception (group=0x40015560)
11-01 20:06:17.391 339-339/com.example.kevin.quizzapp2 E/AndroidRuntime﹕ FATAL EXCEPTION: main
java.lang.RuntimeException: Unable to start activity ComponentInfo{com.example.kevin.quizzapp2/com.example.kevin.quizzapp2.QuizzActivity}: android.database.sqlite.SQLiteException: Can't upgrade read-only database from version 0 to 1: /data/data/com.example.kevin.quizzapp2/databases/QuizzApp
at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:1647)
at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:1663)
at android.app.ActivityThread.access$1500(ActivityThread.java:117)
at android.app.ActivityThread$H.handleMessage(ActivityThread.java:931)
at android.os.Handler.dispatchMessage(Handler.java:99)
at android.os.Looper.loop(Looper.java:123)
at android.app.ActivityThread.main(ActivityThread.java:3683)
at java.lang.reflect.Method.invokeNative(Native Method)
at java.lang.reflect.Method.invoke(Method.java:507)
at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:839)
at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:597)
at dalvik.system.NativeStart.main(Native Method)
Caused by: android.database.sqlite.SQLiteException: Can't upgrade read-only database from version 0 to 1: /data/data/com.example.kevin.quizzapp2/databases/QuizzApp
at android.database.sqlite.SQLiteOpenHelper.getReadableDatabase(SQLiteOpenHelper.java:199)
at com.example.kevin.quizzapp2.MySQLiteOpenHelper.getAllQuestion(MySQLiteOpenHelper.java:82)
at com.example.kevin.quizzapp2.QuizzActivity.onCreate(QuizzActivity.java:29)
at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1047)
at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:1611)
************at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:1663)
************at android.app.ActivityThread.access$1500(ActivityThread.java:117)
************at android.app.ActivityThread$H.handleMessage(ActivityThread.java:931)
************at android.os.Handler.dispatchMessage(Handler.java:99)
************at android.os.Looper.loop(Looper.java:123)
************at android.app.ActivityThread.main(ActivityThread.java:3683)
************at java.lang.reflect.Method.invokeNative(Native Method)
************at java.lang.reflect.Method.invoke(Method.java:507)
************at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:839)
************at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:597)
************at dalvik.system.NativeStart.main(Native Method) |
Partager