upgrade database

ساخت وبلاگ
با سلام بنده هنگام ارتقای ورژن دیتا ببیس برنامه با خطای زیر مواجه میشم ک حس میکنم بخاطر خالی بودن دیتا بیس ایجاد شده هست که هیچ ستونی شاید اایجاد نشده !
متن خطا : 
05-09 15:05:12.507 32396-32396/? E/Zygote: v2
05-09 15:05:12.508 32396-32396/? E/Zygote: accessInfo : 0
05-09 15:05:15.482 32396-32396/com.example.mahdi.car2 E/SQLiteLog: (1) no such table: learndata
05-09 15:05:15.489 32396-32396/com.example.mahdi.car2 E/AndroidRuntime: FATAL EXCEPTION: main
                                                                       Process: com.example.mahdi.car2, PID: 32396
                                                                       android.database.sqlite.SQLiteException: no such table: learndata (code 1): , while compiling: SELECT * FROM learndata
                                                                       #################################################################
                                                                       Error Code : 1 (SQLITE_ERROR)
                                                                       Caused By : SQL(query) error or missing database.
                                                                        (no such table: learndata (code 1): , while compiling: SELECT * FROM learndata)
                                                                       #################################################################
                                                                           at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
                                                                           at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:1005)
                                                                           at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:570)
                                                                           at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
                                                                           at android.database.sqlite.SQLiteProgram.(SQLiteProgram.java:59)
                                                                           at android.database.sqlite.SQLiteQuery.(SQLiteQuery.java:37)
                                                                           at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:44)
                                                                           at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1618)
                                                                           at android.database.sqlite.SQLiteDatabase.rawQuery(SQLiteDatabase.java:1557)
                                                                           at com.example.mahdi.car2.DataBaseAccess.getid(DataBaseAccess.java:192)
                                                                           at com.example.mahdi.car2.learnClass.LoadPanel(learnClass.java:51)
                                                                           at com.example.mahdi.car2.learnClass$1.run(learnClass.java:40)
                                                                           at android.os.Handler.handleCallback(Handler.java:751)
                                                                           at android.os.Handler.dispatchMessage(Handler.java:95)
                                                                           at android.os.Looper.loop(Looper.java:154)
                                                                           at android.app.ActivityThread.main(ActivityThread.java:6688)
                                                                           at java.lang.reflect.Method.invoke(Native Method)
                                                                           at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:1468)
                                                                           at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:1358)

این هم کد داخل کلاس دیتا بیس هست 

package com.example.mahdi.car2;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.support.design.widget.Snackbar;
import android.util.Log;
import android.view.View;
import android.widget.ListView;
import android.widget.Toast;
import com.readystatesoftware.sqliteasset.SQLiteAssetHelper;
import java.util.ArrayList;
import java.util.List;
/**
* Created by Mahdi on 4/2/2017.
*/
public class DataBaseAccess extends SQLiteAssetHelper {
   private static final String DATABASE_NAME = "mydatabase.db";
   private static final int DATABASE_VERSION = 3;
   //---------------------------------------------------------DataCar
   private static final String DataCar_COLUMN_ID = "id";
   private static final String DataCar_COLUMN_Car = "car";
   private static final String DataCar_COLUMN_Tipe = "tipe";
   private static final String DataCar_COLUMN_YearCar = "yearcar";
   private static final String DataCar_COLUMN_Color = "color";
   private static final String DataCar_COLUMN_Kilometer = "kilometer";
   private static final String DataCar_COLUMN_Reminder = "reminder";
   private static final String DataCar_COLUMN_Image = "image";
   //---------------------------------------------------------LearnData
   private static final String LearnData_COLUMN_ID = "id";
   private static final String LearnData_COLUMN_subject = "subject";
   private static final String LearnData_COLUMN_Note = "note";
   private static final String LearnData_COLUMN_Note2 = "note2";
   private static final String LearnData_COLUMN_Note3 = "note3";
   //---------------------------------------------------------ServiceCar
   private static final String ServiceCar_COLUMN_ID = "id";
   private static final String ServiceCar_COLUMN_CarSelect = "CarSelect";
   private static final String ServiceCar_COLUMN_RoghanMotor = "RoghanMotor";
   private static final String ServiceCar_COLUMN_FilterRoghan = "FilterRoghan";
   private static final String ServiceCar_COLUMN_FilterHava = "FilterHava";
   private static final String ServiceCar_COLUMN_FilterBenzin = "FilterBenzin";
   private static final String ServiceCar_COLUMN_FilterKabin = "FilterKabin";
   private static final String ServiceCar_COLUMN_MayeShisheShor = "MayeShisheShor";
   private static final String ServiceCar_COLUMN_Sham = "Sham";
   private static final String ServiceCar_COLUMN_LentJelo = "LentJelo";
   private static final String ServiceCar_COLUMN_LentAghab = "LentAghab";
   private static final String ServiceCar_COLUMN_TasmeTime = "TasmeTime";
   private static final String ServiceCar_COLUMN_TasmeDinam = "TasmeDinam";
   private static final String ServiceCar_COLUMN_Battery = "Battery";
   private static final String ServiceCar_COLUMN_Lastic = "Lastic";
   private static final String ServiceCar_COLUMN_MayeRadiat = "MayeRadiat";
   private static final String ServiceCar_COLUMN_GasKoler = "GasKoler";
   private static final String ServiceCar_COLUMN_RoghanTormoz = "RoghanTormoz";
   private static final String ServiceCar_COLUMN_RoghanHydrolic = "RoghanHydrolic";
   private static final String ServiceCar_COLUMN_RoghanGearbox = "RoghanGearbox";
   private static final String ServiceCar_COLUMN_ShosteshoAnjector = "ShosteshoAnjector";
   private static final String ServiceCar_COLUMN_Catalizor = "Catalizor";
   private static final String ServiceCar_COLUMN_FesharbadLastic = "FesharbadLastic";
   private static final String ServiceCar_COLUMN_JabejaiLastic = "JabejaiLastic";
   private static final String ServiceCar_COLUMN_Sokht = "Sokht";
   private static final String ServiceCar_COLUMN_insurance = "insurance";
   private static final String ServiceCar_COLUMN_insurancebody = "insurancebody";
   private static final String ServiceCar_COLUMN_inspection = "inspection";
   private static final String ServiceCar_COLUMN_expirationcertificated = "expirationcertificated";
   private static final String ServiceCar_COLUMN_other = "other";
   //---------------------------------------------------------VideoData
   private static final String VideoData_COLUMN_ID = "id";
   private static final String VideoData_COLUMN_Title = "title";
   private static final String VideoData_COLUMN_Link = "link";
   SQLiteDatabase db ;
   private static final String TABLE_CREATE_DataCar = "create table " + "datacar"
           + " (" + DataCar_COLUMN_ID + " integer primary key not null, "
           + DataCar_COLUMN_Car + " text not null, "
           + DataCar_COLUMN_Tipe + " text not null, "
           + DataCar_COLUMN_YearCar + " text not null, "
           + DataCar_COLUMN_Color + " text not null, "
           + DataCar_COLUMN_Kilometer + " text not null, "
           + DataCar_COLUMN_Reminder + " text not null, "
           + DataCar_COLUMN_Image + " text not null);";
   private static final String TABLE_CREATE_LearnData = "create table " + "datacar"
           + " (" + LearnData_COLUMN_ID + " integer primary key not null, "
           + LearnData_COLUMN_subject + " text not null, "
           + LearnData_COLUMN_Note + " text not null, "
           + LearnData_COLUMN_Note2 + " text not null, "
           + LearnData_COLUMN_Note3 + " text not null);";
   private static final String TABLE_CREATE_ServiceCar = "create table " + "datacar"
           + " (" + ServiceCar_COLUMN_ID + " integer primary key not null, "
           + ServiceCar_COLUMN_CarSelect + " text not null, "
           + ServiceCar_COLUMN_RoghanMotor + " text not null, "
           + ServiceCar_COLUMN_FilterRoghan + " text not null, "
           + ServiceCar_COLUMN_FilterHava + " text not null, "
           + ServiceCar_COLUMN_FilterBenzin + " text not null, "
           + ServiceCar_COLUMN_FilterKabin + " text not null, "
           + ServiceCar_COLUMN_MayeShisheShor + " text not null, "
           + ServiceCar_COLUMN_Sham + " text not null, "
           + ServiceCar_COLUMN_LentJelo + " text not null, "
           + ServiceCar_COLUMN_LentAghab + " text not null, "
           + ServiceCar_COLUMN_TasmeTime + " text not null, "
           + ServiceCar_COLUMN_TasmeDinam + " text not null, "
           + ServiceCar_COLUMN_Battery + " text not null, "
           + ServiceCar_COLUMN_Lastic + " text not null, "
           + ServiceCar_COLUMN_MayeRadiat + " text not null, "
           + ServiceCar_COLUMN_GasKoler + " text not null, "
           + ServiceCar_COLUMN_RoghanTormoz + " text not null, "
           + ServiceCar_COLUMN_RoghanHydrolic + " text not null, "
           + ServiceCar_COLUMN_RoghanGearbox + " text not null, "
           + ServiceCar_COLUMN_ShosteshoAnjector + " text not null, "
           + ServiceCar_COLUMN_Catalizor + " text not null, "
           + ServiceCar_COLUMN_FesharbadLastic + " text not null, "
           + ServiceCar_COLUMN_JabejaiLastic + " text not null, "
           + ServiceCar_COLUMN_Sokht + " text not null, "
           + ServiceCar_COLUMN_insurance + " text not null, "
           + ServiceCar_COLUMN_insurancebody + " text not null, "
           + ServiceCar_COLUMN_inspection + " text not null, "
           + ServiceCar_COLUMN_expirationcertificated + " text not null, "
           + ServiceCar_COLUMN_other + " text not null);";
   private static final String TABLE_CREATE_VideoData = "create table " + "datacar"
           + " (" + VideoData_COLUMN_ID + " integer primary key not null, "
           + VideoData_COLUMN_Title + " text not null, "
           + VideoData_COLUMN_Link + " text not null);";
   public void onCreateTable(SQLiteDatabase db1) {
       db.execSQL(TABLE_CREATE_DataCar);
       db.execSQL(TABLE_CREATE_LearnData);
       db.execSQL(TABLE_CREATE_ServiceCar);
       db.execSQL(TABLE_CREATE_VideoData);
       this.db = db1;
   }
   @Override
   public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
       db.execSQL("DROP TABLE IF EXISTS " + "datacar");
       db.execSQL("DROP TABLE IF EXISTS " + "learndata");
       db.execSQL("DROP TABLE IF EXISTS " + "servicecar");
       db.execSQL("DROP TABLE IF EXISTS " + "videodata");
       // Create tables again
       onCreateTable(db);
       Log.d("---> Upgrade DataBase","Success");
   }
/*    public void insertEntry(DiaryEntries entries){
       db = this.getWritableDatabase();
       ContentValues values = new ContentValues();
       String query = "SELECT * FROM " + TABLE_NAME;
       Cursor cursor = db.rawQuery(query, null);
       int count = cursor.getCount();
       values.put(DataCar_COLUMN_ID, count);
       values.put(DataCar_COLUMN_TITLE, entries.getTitle());
       values.put(DataCar_COLUMN_DETAILS, entries.getDetails());
       values.put(DataCar_COLUMN_SAVE_DATE, entries.getDate());
       values.put(DataCar_COLUMN_USER_ID, entries.getUser_id());
       db.insert(TABLE_NAME, null, values);
       db.close();
   }*/
   //
   SQLiteDatabase sqLiteDatabase = getWritableDatabase();
   public DataBaseAccess(Context context) {
       super(context, DATABASE_NAME, null, DATABASE_VERSION);
   }
   public List getid(int getid,String SelectTable) {
       List list = new ArrayList<>();
       Cursor cursor = sqLiteDatabase.rawQuery("SELECT * FROM "+SelectTable,null);
       cursor.moveToFirst();
       while (!cursor.isAfterLast()) {
           list.add(cursor.getString(getid));
           cursor.moveToNext();
       }
       cursor.close();
       return list;
   }
   public List Selectid(int getid,String SelectTable,String SelectColumn,int Contains) {
       List list = new ArrayList<>();
       Cursor cursor = sqLiteDatabase.rawQuery("SELECT * FROM "+SelectTable+" WHERE "+SelectColumn+"="+Contains,null);
       cursor.moveToFirst();
       while (!cursor.isAfterLast()) {
           //for(int i=0;i CommandData(int getid,String Command) {
       List list = new ArrayList<>();
       Cursor cursor = sqLiteDatabase.rawQuery(Command,null);
       cursor.moveToFirst();
       while (!cursor.isAfterLast()) {
           //for(int i=0;i

قبل از آپدیت ورژن هیچ مشکلی از نظر کارکرد نیست . تشکر

();i++)>
();i++)>

برنامه نویس...
ما را در سایت برنامه نویس دنبال می کنید

برچسب : نویسنده : خنجی prog بازدید : 219 تاريخ : سه شنبه 19 ارديبهشت 1396 ساعت: 19:09

خبرنامه