android.database.sqlite.SQLiteException: no such table: table_name(code 1): , while compiling: SELECT * FROM table_name

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Stack Overflow by Chandru
, 1 year ago
no such table: table_name(code 1): , while compiling: SELECT * FROM table_name
via Stack Overflow by Unknown author, 2 years ago
unrecognized token: "'%xyz" (code 1): , while compiling: **SELECT column FROM TABLE_NAME WHERE Name LIKE '%xyz��������������������������������������������������������������������%'**
via Stack Overflow by HextechEnthusiast
, 1 year ago
no such column: COLUMN_USER_USERNAME (code 1): , while compiling: SELECT usuaid, username, password FROM usuario WHERE COLUMN_USER_USERNAME = ?
via Stack Overflow by Smu
, 2 years ago
no such table: REMINDER_TABLE (code 1): , while compiling: SELECT * FROM REMINDER_TABLE WHERE USERNAME=? AND REMINDER_DATE=? AND REMINDER_TIME=?
via GitHub by wirawansanusi
, 2 years ago
no such table: PRODUCT (code 1): , while compiling: SELECT * FROM PRODUCT
via Stack Overflow by Hayes121
, 2 years ago
no such table: recipes (code 1): , while compiling: SELECT reciep_name FROM recipes
android.database.sqlite.SQLiteException: no such table: table_name(code 1): , while compiling: SELECT * FROM table_name
at android.database.sqlite.SQLiteConnection.nativePrepareStatement(SQLiteConnection.java)
at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:889)
at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:500)
at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
at android.database.sqlite.SQLiteProgram.(SQLiteProgram.java:58)
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:1316)
at android.database.sqlite.SQLiteDatabase.queryWithFactory(SQLiteDatabase.java:1163)
at android.database.sqlite.SQLiteDatabase.query(SQLiteDatabase.java:1034)
at android.database.sqlite.SQLiteDatabase.query(SQLiteDatabase.java:1202)
at com.takeoffandroid.database.DBAccess.getCount(SourceFile:384)

Users with the same issue

12 times, 1 month ago
40 times, 3 months ago
347 times, 3 months ago
9 times, 4 months ago
Once, 6 months ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.