android sqlite no such column error

Question

I am Working on Android SQLite . I am creating new table and trying to insert values in it. But it gives no column LastName when trying to insert the values.

Please help me . Please check below code.

String query3 = "create table if not exists " + "SIGNUPINFO" + " ("                                 + "FirstName TEXT," + "LastName TEXT," + "EmailID TEXT," + "Password TEXT,"
+ "Phone TEXT," +"Security TEXT);";

db.execSQL(query3);

String query5 = "INSERT INTO SIGNUPINFO" + " (FirstName,LastName,EmailID,Password,Phone,Security) " + "VALUES ('"
+ firstName + "','" +lastName+  "','" + emailID  + "','" +password+  "','" + phone+ "','" + "security" +"');";

db.execSQL(query5);

have you update your table without update your database version? try clear your app data and run again, maybe your table is not update — Linh, Feb 14 '17 at 03:58
If you have root access, then try to pull out the .db file and see if the database has been successfully created. Use any DMBS tool and try to execute your query. Just ran the code you pasted and looks ok. — Dibzmania, Feb 14 '17 at 04:09

score 1 · Accepted Answer · edited May 23 '17 at 11:53

Please check refernce answer for same problem.May it will help you.

Well, If you are confindent about syntax for creating table, than it may happen when you add new column in your same table, for that...

1) Unistall from your device and run it again.

OR

2) Setting -> app -> ClearData

OR

3) Change DATABASE_NAME in your "DatabaseHandler" class ( I faced same problem. But I suuceed by changing DATABASE_NAME.)

OR

4) Change DATABASE_VERSION in your "DatabaseHandler" class (If you have added new column than it will upgrade autimatically)

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

So please mark sign @user3571631. – Kush Feb 16 '17 at 05:49 — Kush, Feb 16 '17 at 05:49

score -2 · Answer 2 · answered Feb 14 '17 at 04:11

put this code in application class and get database in externalstorage.

Then you can check column created or not in database table.

 public static void copyDataBase(Context mActivity) throws IOException {
        Log.d("tag", "Copy Database called");
        InputStream myInput = new FileInputStream(new File("/data/data/"
                + mActivity.getPackageName() + "/databases/"
                + "yourdb.sqlite"));
        File files = new File(Environment.getExternalStorageDirectory()
                + "/files/");
        files.mkdirs();
        String outFileName = Environment.getExternalStorageDirectory()
                + "/yourdb.sqlite";
        OutputStream myOutput = new FileOutputStream(outFileName);
        byte[] buffer = new byte[1024];
        int bufferLength;
        while ((bufferLength = myInput.read(buffer)) > 0) {
            myOutput.write(buffer, 0, bufferLength);
        }
        myOutput.flush();
        myOutput.close();
        myInput.close();
        Log.d("tag", "Copy Database Done");
    }

I hope its useful to you.

android sqlite no such column error

2 Answers2