android.database.sqlite.SQLiteException

no such table: table_name(code 1): , while compiling: SELECT * FROM table_name

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web1779

  • via Stack Overflow by Chandru
    , 10 months ago
    no such table: table_name(code 1): , while compiling: SELECT * FROM table_name
  • via Stack Overflow by Unknown author, 1 year ago
    unrecognized token: "'%xyz" (code 1): , while compiling: **SELECT column FROM TABLE_NAME WHERE Name LIKE '%xyz��������������������������������������������������������������������%'**
  • no such table: table (code 1): , while compiling: SELECT COUNT(*) FROM `table` WHERE `id` = ?
  • Stack trace

    • 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.<init>(SQLiteProgram.java:58) at android.database.sqlite.SQLiteQuery.<init>(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)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    11 times, 2 weeks ago
    2 times, 1 month ago
    58 times, 4 months ago
    4 times, 4 months ago
    Unknown user
    Once, 10 months ago
    109 more bugmates