android.database.sqlite.SQLiteException: no such table [duplicate]

Question

ISSUE (LogCat)

sqlite returned: error code = 1, msg = no such table ...

android.database.sqlite.SQLiteException: no such table: ....

CODE

public void onCreate(SQLiteDatabase db) {
    Log.v("SQLAdapter","onCreate(SQLiteDatabase db)");
    db.execSQL("CREATE TABLE "+tablename
            +" ("
            +col1+ " TEXT PRIMARY KEY , "
            +col2+ " TEXT , "
            +col3+ " TEXT , "
            +col4+ " TEXT , "
            +col5+ " TEXT , "
            +col6+ " TEXT , "
            +col7+ " TEXT , "
            +col8+ " TEXT "
            +")");
    db.execSQL("CREATE TABLE "+configTable
            +" ("
            +colName+ " TEXT PRIMARY KEY , "
            +colValue+ " TEXT "
            +")");
    
    ContentValues cv=new ContentValues();
    cv.put(colName, "updated");
    cv.put(colValue, "-1");
    db.insert(configTable, colName, cv);
}

RESULT

configTable is being created

tablename is not being created

Where is the value of tablename set? I can't see it in your code. Also, you code never tried to access tablename, so what throws the error? — David Snabel-Caunt
– David Snabel-Caunt, Commented Jul 20, 2011 at 14:53
forget accessing it.. when i get the sqlite file thru ddms ,, i find configTable created but tablename not there — Sherif elKhatib
– Sherif elKhatib, Commented Jul 20, 2011 at 14:58
Did you try to insert something in tablename? You should receive an exception. Would you copy/paste it here? — Shlublu
– Shlublu, Commented Jul 20, 2011 at 15:26
07-21 03:32:23.224: ERROR/Database(11222): android.database.sqlite.SQLiteException: no such table: config: , while compiling: INSERT INTO config(colName, colValue) VALUES(?, ?); — Sherif elKhatib
– Sherif elKhatib, Commented Jul 20, 2011 at 15:35

sravan · Accepted Answer · 2011-12-22 11:35:07Z

11

simply Change Your Databse name in Data base class which you implemented Using SQliteDatabase

same problem i faced , isolved using same trick.

answered Dec 22, 2011 at 11:35

sravan

5,3311 gold badge33 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Sherif elKhatib Over a year ago

I can not test it anymore because I decided not to use SQL in any of my projects. Please if someone tests this and it turns to be wrong, tell me. For now! +1 and tick for you. thank you really

cesards Over a year ago

Happened the same here. I have 3 Classes ("X"DbHelper) inheriting from BaseDBHelper which has the database name. I've done what you mentioned and now it works... Is very estrange, isn't it???

Sherif elKhatib Over a year ago

@m3n0R very weird. I know I solved this by creating one SQL class for each table! But now am looking at this answer and the feedback. seems he got the right solution.

vahid sabet Over a year ago

It's the solution for me on android 10

sbo3000 · Accepted Answer · 2014-05-27 15:39:29Z

1

I had the same exception while testing on a real device. After I added a new table to my database I had to uninstall an older app version from the device . Only then the onCreate() method from the SQLiteOpenHelper subclass was called again.

answered May 27, 2014 at 15:39

sbo3000

1761 silver badge7 bronze badges

Comments

ken · Accepted Answer · 2013-01-28 09:36:46Z

0

Same problem. Fix the problem by deleting away the old xxx.db created by using the adb command

adb shell rm /data/data/xxx.db

answered Jan 28, 2013 at 9:36

ken

14.7k6 gold badges45 silver badges38 bronze badges

Comments

adev · Accepted Answer · 2016-01-24 12:29:26Z

0

"no such table" problem worked out!

When you are using a database.db, Android create also another file named database (without extension) with an android_metadata table.

Finally, I solved just changing DB_NAME ="mydb" with DB_NAME="mydb.db"

answered Jan 24, 2016 at 12:29

adev

3771 gold badge3 silver badges23 bronze badges

Comments

Ole Albers · Accepted Answer · 2016-07-25 12:27:03Z

0

I also faced the "no such table" problem. This is no problem from the database or table but from your application.

just you have reinstall our application and everything should be fine.

edited Jul 25, 2016 at 12:27

Ole Albers

9,39713 gold badges84 silver badges184 bronze badges

answered Jul 25, 2016 at 11:01

MalhotraUrmil

861 silver badge10 bronze badges

Collectives™ on Stack Overflow

android.database.sqlite.SQLiteException: no such table [duplicate]

5 Answers 5

4 Comments

Comments

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

4 Comments

Comments

Comments

Comments

Comments

Linked

Related