ich habe eine Datenbank erstellt und mein Punkte wurden schön brav gespeichert, doch irgentwann bekam ich einen Force close und meine Liebe Logcat spuckte mir folgendes aus:
108-30 13:09:35.475: ERROR/Database(9173): Failure 1 (no such table: Scores) on 0x2eaaf0 when preparing 'INSERT INTO Scores (name, score) VALUES ('leon','404');'.
208-30 13:09:35.475: ERROR/AndroidRuntime(9173): FATAL EXCEPTION: main
308-30 13:09:35.475: ERROR/AndroidRuntime(9173): android.database.sqlite.SQLiteException: no such table: Scores: INSERT INTO Scores (name, score) VALUES ('leon','404');
408-30 13:09:35.475: ERROR/AndroidRuntime(9173): at android.database.sqlite.SQLiteDatabase.native_execSQL(Native Method)
508-30 13:09:35.475: ERROR/AndroidRuntime(9173): at android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1814)
608-30 13:09:35.475: ERROR/AndroidRuntime(9173): at com.shitbox.dblaster.dGame.InsertToDB(dGame.java:906)
708-30 13:09:35.475: ERROR/AndroidRuntime(9173): at com.shitbox.dblaster.dGame$1.onClick(dGame.java:896)
808-30 13:09:35.475: ERROR/AndroidRuntime(9173): at com.android.internal.app.AlertController$ButtonHandler.handleMessage(AlertController.java:158)
908-30 13:09:35.475: ERROR/AndroidRuntime(9173): at android.os.Handler.dispatchMessage(Handler.java:99)
1008-30 13:09:35.475: ERROR/AndroidRuntime(9173): at android.os.Looper.loop(Looper.java:144)
1108-30 13:09:35.475: ERROR/AndroidRuntime(9173): at android.app.ActivityThread.main(ActivityThread.java:4937)
1208-30 13:09:35.475: ERROR/AndroidRuntime(9173): at java.lang.reflect.Method.invokeNative(Native Method)
1308-30 13:09:35.475: ERROR/AndroidRuntime(9173): at java.lang.reflect.Method.invoke(Method.java:521)
1408-30 13:09:35.475: ERROR/AndroidRuntime(9173): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:868)
1508-30 13:09:35.475: ERROR/AndroidRuntime(9173): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:626)
1608-30 13:09:35.475: ERROR/AndroidRuntime(9173): at dalvik.system.NativeStart.main(Native Method)
208-30 13:09:35.475: ERROR/AndroidRuntime(9173): FATAL EXCEPTION: main
308-30 13:09:35.475: ERROR/AndroidRuntime(9173): android.database.sqlite.SQLiteException: no such table: Scores: INSERT INTO Scores (name, score) VALUES ('leon','404');
408-30 13:09:35.475: ERROR/AndroidRuntime(9173): at android.database.sqlite.SQLiteDatabase.native_execSQL(Native Method)
508-30 13:09:35.475: ERROR/AndroidRuntime(9173): at android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1814)
608-30 13:09:35.475: ERROR/AndroidRuntime(9173): at com.shitbox.dblaster.dGame.InsertToDB(dGame.java:906)
708-30 13:09:35.475: ERROR/AndroidRuntime(9173): at com.shitbox.dblaster.dGame$1.onClick(dGame.java:896)
808-30 13:09:35.475: ERROR/AndroidRuntime(9173): at com.android.internal.app.AlertController$ButtonHandler.handleMessage(AlertController.java:158)
908-30 13:09:35.475: ERROR/AndroidRuntime(9173): at android.os.Handler.dispatchMessage(Handler.java:99)
1008-30 13:09:35.475: ERROR/AndroidRuntime(9173): at android.os.Looper.loop(Looper.java:144)
1108-30 13:09:35.475: ERROR/AndroidRuntime(9173): at android.app.ActivityThread.main(ActivityThread.java:4937)
1208-30 13:09:35.475: ERROR/AndroidRuntime(9173): at java.lang.reflect.Method.invokeNative(Native Method)
1308-30 13:09:35.475: ERROR/AndroidRuntime(9173): at java.lang.reflect.Method.invoke(Method.java:521)
1408-30 13:09:35.475: ERROR/AndroidRuntime(9173): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:868)
1508-30 13:09:35.475: ERROR/AndroidRuntime(9173): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:626)
1608-30 13:09:35.475: ERROR/AndroidRuntime(9173): at dalvik.system.NativeStart.main(Native Method)
Merkwürdig denke ich mir es heißt ja openOrCreate
aber es kann keine table gefunden werden und am Code habe ich auch nichts geändert
1private void erstelleDBUndDBTabled()
2 {
3 myDB = mContext.openOrCreateDatabase(MY_DATABASE_NAME, Context.MODE_PRIVATE, null);
4 myDB.execSQL("CREATE TABLE IF NOT EXISTS " + MY_DATABASE_TABLE
5 + " (_id integer primary key autoincrement, name varchar(100), score varchar(100))"
6 +";");
7 }
2 {
3 myDB = mContext.openOrCreateDatabase(MY_DATABASE_NAME, Context.MODE_PRIVATE, null);
4 myDB.execSQL("CREATE TABLE IF NOT EXISTS " + MY_DATABASE_TABLE
5 + " (_id integer primary key autoincrement, name varchar(100), score varchar(100))"
6 +";");
7 }
1InsertToDB(Name.getText().toString(), Score.getText().toString());
1public void InsertToDB(String Name, String Score)
2 {
3 SQLiteDatabase myDB = null;
4 try {
5 myDB = mContext.openOrCreateDatabase(ColorBlasterGame.MY_DATABASE_NAME, Context.MODE_PRIVATE, null);
6 myDB.execSQL("INSERT INTO "+ColorBlasterGame.MY_DATABASE_TABLE+" (name, score) "
7 +"VALUES ('"+Name+"','"+Score+"');");
8 }
9 finally
10 {
11 if (myDB != null)
12 myDB.close();
13 }
14 }
Ich seh ja nix was da falsch wäre!2 {
3 SQLiteDatabase myDB = null;
4 try {
5 myDB = mContext.openOrCreateDatabase(ColorBlasterGame.MY_DATABASE_NAME, Context.MODE_PRIVATE, null);
6 myDB.execSQL("INSERT INTO "+ColorBlasterGame.MY_DATABASE_TABLE+" (name, score) "
7 +"VALUES ('"+Name+"','"+Score+"');");
8 }
9 finally
10 {
11 if (myDB != null)
12 myDB.close();
13 }
14 }
Danke an den der es erkennt und an alle die es versuchen
Ps:Nicht so streng ich bin der Neue
-----
"Hard work beats talent, when talent fails to work hard"
