با سلام بنده هنگام ارتقای ورژن دیتا ببیس برنامه با خطای زیر مواجه میشم ک حس میکنم بخاطر خالی بودن دیتا بیس ایجاد شده هست که هیچ ستونی شاید اایجاد نشده !
متن خطا :
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