Sqlite missing a column while putting a data

Question

i try to copy my data in SQLite android but i get a message that a column was missing.here's the code below:

    private static final int DATABASE_VERSION = 1;

// Database Name
private static final String DATABASE_NAME = "Arretschoisi";

// Contacts table name
private static final String TABLE_CONTACTS = "arret";

// Contacts Table Columns names
private static final String KEY_ID = "id";
private static final String ID_Trajet="id_trajet";
private static final String ID_TRAJET_PUBLIC="code_publique_ligne";
private static final String DESTINATION="destination_trajet";
private static final String TIME_TO_WAIT="temps_attente";
private static final String TIME="temps_passage_prevu";


public DatabaseStationChoice(Context context) {
    super(context, DATABASE_NAME, null, DATABASE_VERSION);
}

// Creating Tables
@Override
public void onCreate(SQLiteDatabase db) {

    String CREATE_CONTACTS_TABLE = "CREATE TABLE " + TABLE_CONTACTS + " ("
            + KEY_ID + " INTEGER PRIMARY KEY," +
            ID_Trajet + " TEXT, "+ 
            ID_TRAJET_PUBLIC + " TEXT, " + 
            DESTINATION + " TEXT, " +
            TIME_TO_WAIT + " TEXT, " +
            TIME + " TEXT" +");";
    db.execSQL(CREATE_CONTACTS_TABLE);
}

// Upgrading database
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
    // Drop older table if existed
    db.execSQL("DROP TABLE IF EXISTS " + TABLE_CONTACTS);
    // Create tables again
    onCreate(db);
}

/**
 * All CRUD(Create, Read, Update, Delete) Operations
 */
//delete all rows in table
public void deleteAll()
{
    SQLiteDatabase db = this.getWritableDatabase();
    db.delete(TABLE_CONTACTS,null,null);
    //   db.execSQL("DROP TABLE IF EXISTS " + TABLE_CONTACTS);
    //   db.execSQL("TRUNCATE TABLE " + TABLE_CONTACTS);
    db.close();
}

// Adding new contact
void addHorraire(Horraire horaire) {
    SQLiteDatabase db = this.getWritableDatabase();

    ContentValues values = new ContentValues();
    values.put(ID_Trajet, horaire.getID_SQL()); // horaire Id_sql
    values.put(ID_TRAJET_PUBLIC, horaire.getadr_id_pub()); // horaire num public
    values.put(DESTINATION, horaire.getadr_des()); // horaire destination
    values.put(TIME_TO_WAIT, horaire.getadr_2wait()); // horaire d attente
    values.put(TIME, horaire.getadr_time()); // horaire d'arriver

    // Inserting Row
    db.insert(TABLE_CONTACTS, null, values);
    db.close(); // Closing database connection
}

and the error from logcat:

(1) table arret has no column named destination_trajet
Error inserting code_publique_ligne=L-8 destination_trajet=Fin temps_passage_prevu=289 temps_attente=16:20 id_trajet=8
android.database.sqlite.SQLiteException: table arret has no column named destination_trajet (code 1): , while compiling: INSERT INTO arret(code_publique_ligne,destination_trajet,temps_passage_prevu,temps_attente,id_trajet) VALUES (?,?,?,?,?)
android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
    at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:886)
    at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:497)
    at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
    at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:58)
    at android.database.sqlite.SQLiteStatement.<init>(SQLiteStatement.java:31)
    at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1467)
    at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1339)
    at com.example.citybus.DatabaseStationChoice.addHorraire(DatabaseStationChoice.java:84)
    at com.example.citybus.Proximite$sendstationfortime.onPostExecute(Proximite.java:174)
    at com.example.citybus.Proximite$sendstationfortime.onPostExecute(Proximite.java:1)
    at android.os.AsyncTask.finish(AsyncTask.java:631)
    at android.os.AsyncTask.access$600(AsyncTask.java:177)

so the architecture of my data base is like:

[{\"id_trajet\":8,\"code_publique_ligne\":\"L-8\",\"texte_destination_trajet\":\"Fin\",\"temps_attente\":289,\"temps_passage_prevu\":\"16:20\"}] thanks

Your database dont have any error. post Full Logcat. – Shvet Oct 13 '14 at 16:31 — Shvet, Oct 13 '14 at 16:31
can you put your `arret` table structure here? – Rustam Oct 13 '14 at 16:32 — Rustam, Oct 13 '14 at 16:32

Sina Amirshekari · Accepted Answer · 2014-10-13T16:47:02.983

1

if you've applied the new changes :

increment DATABASE_VERSION by one to force execute onUpgrade() method
or drop the old database file from your device

edited Oct 13 '14 at 16:47

answered Oct 13 '14 at 16:41

Sina Amirshekari

1,908
1
15
17

thanks it's done.but can you tell me how that the version can be solve problem – Souhail Oct 13 '14 at 16:59
your welcome - onUpgrade() called, if the database version is increased in your application code. This method allows you to update an existing database schema – Sina Amirshekari Oct 13 '14 at 17:04

Sqlite missing a column while putting a data

1 Answers1