android.database.sqlite.SQLiteException: no such table: SHOW (code 1): , while compiling: SELECT * FROM SHOW WHERE (SHOW_ID = ? )

GitHub | fermatijoe | 3 months ago
  1. 0

    SQLiteException: no such table:

    GitHub | 3 months ago | fermatijoe
    android.database.sqlite.SQLiteException: no such table: SHOW (code 1): , while compiling: SELECT * FROM SHOW WHERE (SHOW_ID = ? )
  2. 0

    GitHub comment 607#222329225

    GitHub | 6 months ago | kenk11
    android.database.sqlite.SQLiteException: no such table: TRIP_DETAIL (code 1): , while compiling: SELECT * FROM TRIP_DETAIL WHERE (M_STATUS = ? )
  3. 0

    HISTORY_PRODUCT missing

    GitHub | 3 weeks ago | teolemon
    android.database.sqlite.SQLiteException: no such table: HISTORY_PRODUCT (code 1): , while compiling: SELECT * FROM HISTORY_PRODUCT WHERE barcode = ?
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    SQLiteException: near "=": syntax error (code 1)

    Stack Overflow | 6 months ago | Georgi Koemdzhiev
    android.database.sqlite.SQLiteException: near "=": syntax error (code 1): , while compiling: SELECT id FROM Property WHERE id =
  6. 0

    Failing to escape single quotes in queries

    GitHub | 2 years ago | johngray1965
    android.database.sqlite.SQLiteException: near "s": syntax error (code 1): , while compiling: SELECT _id, name FROM transactions WHERE name LIKE 'Crosby's%' ORDER BY name ASC

  1. Minafaw 2 times, last 4 months ago
  2. Ranjana Dangol 1 times, last 6 months ago
  3. Stefan Braune 177 times, last 6 months ago
  4. dmitry 53 times, last 6 months ago
11 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: SHOW (code 1): , while compiling: SELECT * FROM SHOW WHERE (SHOW_ID = ? )

    at android.database.sqlite.SQLiteConnection.nativePrepareStatement()
  2. Android Platform
    SQLiteDatabase.query
    1. android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
    2. android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:887)
    3. android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:498)
    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:1316)
    9. android.database.sqlite.SQLiteDatabase.queryWithFactory(SQLiteDatabase.java:1163)
    10. android.database.sqlite.SQLiteDatabase.query(SQLiteDatabase.java:1034)
    11. android.database.sqlite.SQLiteDatabase.query(SQLiteDatabase.java:1240)
    11 frames
  3. com.orm
    SugarRecord.find
    1. com.orm.SugarRecord.find(SugarRecord.java:192)
    1 frame
  4. com.orm.query
    Select.list
    1. com.orm.query.Select.list(Select.java:118)
    1 frame
  5. com.dcs.shows
    DetailFragment.onCreateView
    1. com.dcs.shows.utils.FavoriteUtils.getListFromDb(FavoriteUtils.java:38)
    2. com.dcs.shows.utils.FavoriteUtils.checkIfThisIsFavorite(FavoriteUtils.java:23)
    3. com.dcs.shows.DetailFragment.onCreateView(DetailFragment.java:83)
    3 frames
  6. Android Support v4
    FragmentManagerImpl$1.run
    1. android.support.v4.app.Fragment.performCreateView(Fragment.java:2074)
    2. android.support.v4.app.FragmentManagerImpl.moveToState(FragmentManager.java:1104)
    3. android.support.v4.app.FragmentManagerImpl.moveToState(FragmentManager.java:1286)
    4. android.support.v4.app.BackStackRecord.run(BackStackRecord.java:758)
    5. android.support.v4.app.FragmentManagerImpl.execPendingActions(FragmentManager.java:1671)
    6. android.support.v4.app.FragmentManagerImpl$1.run(FragmentManager.java:532)
    6 frames
  7. Android Platform
    ActivityThread.main
    1. android.os.Handler.handleCallback(Handler.java:739)
    2. android.os.Handler.dispatchMessage(Handler.java:95)
    3. android.os.Looper.loop(Looper.java:148)
    4. android.app.ActivityThread.main(ActivityThread.java:5417)
    4 frames
  8. Java RT
    Method.invoke
    1. java.lang.reflect.Method.invoke(Native Method)
    1 frame
  9. Android
    ZygoteInit.main
    1. com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:726)
    2. com.android.internal.os.ZygoteInit.main(ZygoteInit.java:616)
    2 frames