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

myandroidsolutions.com | 3 months ago
  1. 0

    Android Database Tutorial - My Android Solutions

    myandroidsolutions.com | 3 months ago
    android.database.sqlite.SQLiteException: no such table: People (code 1): , while compiling: SELECT * FROM People
  2. 0

    Error executing sqlite query

    Stack Overflow | 3 years ago | user2764599
    android.database.sqlite.SQLiteException: no such table: qt_um_stock_items_qty (code 1): , while compiling: SELECT BAL_DATE AS ON_DT, (IFNULL ( IN_QTY, 0)-IFNULL (OUT_QTY, 0)) AS CL_QTY,(SELECT CODE || '-' || NAME FROM qm_um_stock_items WHERE ID = STOCK_ITEM_ID) AS ITEM,(SELECT CODE|| '-' ||NAME FROM qm_um_unit WHERE ID = BASE_UNIT_ID ) AS UNIT FROM qt_um_stock_items_qty WHERE STOCK_CENTER_ID =? AND STOCK_ITEM_ID=?
  3. 0

    Execute query in Sqlite database in android

    Stack Overflow | 2 years ago | user3411639
    android.database.sqlite.SQLiteException: no such table: Table1 (code 1): , while compiling: select CellID from Table1 where _id='2'
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Sqlite database path is not working

    Stack Overflow | 3 years ago | Tasneem
    android.database.sqlite.SQLiteException: no such table: QUESTIONS (code 1): , while compiling: SELECT * FROM QUESTIONS
  6. 0

    Android "no such table" on some devices

    Stack Overflow | 4 years ago | user1751439
    java.lang.RuntimeException: Unable to start activity ComponentInfo{com.radoman.gameofthrones/com.radoman.gameofthrones.FavQuotesActivity}: android.database.sqlite.SQLiteException: no such table: quotes (code 1): , while compiling: SELECT * FROM quotes WHERE fav=1

  1. Aria Pahlavan 8 times, last 2 weeks ago
  2. mrokay97 2 times, last 4 months ago
  3. Riyaz 1 times, last 6 months ago
  4. Bardh 1 times, last 6 months ago
  5. jk 12 times, last 7 months ago
4 more registered users
17 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. android.database.sqlite.SQLiteException

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

    at android.database.sqlite.SQLiteConnection.nativePrepareStatement()
  2. Android Platform
    SQLiteDatabase.rawQuery
    1. android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
    2. android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:882)
    3. android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:493)
    4. android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
    5. android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:58)
    6. android.database.sqlite.SQLiteQuery.<init>(SQLiteQuery.java:37)
    7. android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:44)
    8. android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1314)
    9. android.database.sqlite.SQLiteDatabase.rawQuery(SQLiteDatabase.java:1253)
    9 frames
  3. com.example.myactivity
    MyActivity$1.onClick
    1. com.example.myactivity.DataBaseManager.select(DataBaseManager.java:168)
    2. com.example.myactivity.MyActivity.updateTextView(MyActivity.java:97)
    3. com.example.myactivity.MyActivity$1.onClick(MyActivity.java:52)
    3 frames
  4. Android Platform
    ActivityThread.main
    1. android.view.View.performClick(View.java:4204)
    2. android.view.View$PerformClick.run(View.java:17355)
    3. android.os.Handler.handleCallback(Handler.java:725)
    4. android.os.Handler.dispatchMessage(Handler.java:92)
    5. android.os.Looper.loop(Looper.java:137)
    6. android.app.ActivityThread.main(ActivityThread.java:5041)
    6 frames
  5. Java RT
    Method.invoke
    1. java.lang.reflect.Method.invokeNative(Native Method)
    2. java.lang.reflect.Method.invoke(Method.java:511)
    2 frames
  6. Android
    ZygoteInit.main
    1. com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:793)
    2. com.android.internal.os.ZygoteInit.main(ZygoteInit.java:560)
    2 frames
  7. Android Platform
    NativeStart.main
    1. dalvik.system.NativeStart.main(Native Method)
    1 frame