java.lang.RuntimeException: Unable to start activity ComponentInfo{com.example.shopkart/com.example.shopkart.MainActivity}: android.database.sqlite.SQLiteException: no such table: products: , while compiling: SELECT NAME from products

coderanch.com | 3 months ago
  1. 0

    Deploying a database along with apk file (Android forum at Coderanch)

    coderanch.com | 8 months ago
    java.lang.RuntimeException: Unable to start activity ComponentInfo{com.example.shopkart/com.example.shopkart.MainActivity}: android.database.sqlite.SQLiteException: no such table: products: , while compiling: SELECT NAME from products
  2. 0

    Deploying a database along with apk file (Android forum at Coderanch)

    coderanch.com | 3 months ago
    java.lang.RuntimeException: Unable to start activity ComponentInfo{com.example.shopkart/com.example.shopkart.MainActivity}: android.database.sqlite.SQLiteException: no such table: products: , while compiling: SELECT NAME from products
  3. 0

    Why does my createOrUpdate() call fail?

    Stack Overflow | 1 year ago | John Ernest Guadalupe
    java.sql.SQLException: queryForLong from database failed: SELECT COUNT(*) FROM `table` WHERE `id` = ?
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Syntax error when querying SQLite

    Stack Overflow | 11 months ago | java progammera
    android.database.sqlite.SQLiteException: near "(": syntax error (code 1): , while compiling: select * from appointments_table where strftime ('%d.%m.%Y', date) > now.strftime('%d.%m.%Y')
  6. 0

    `SQLiteException: no such collation sequence: JSON` on Barnes & Noble NOOK HD/HD+

    GitHub | 2 years ago | Takhion
    android.database.sqlite.SQLiteException: no such collation sequence: JSON: , while compiling: SELECT key, value, docid, revs.sequence, revid, json FROM maps, revs, docs WHERE maps.view_id=? AND key in (?) AND revs.sequence = maps.sequence AND docs.doc_id = revs.doc_id ORDER BY key LIMIT ? OFFSET ?

  1. Aria Pahlavan 8 times, last 3 weeks ago
  2. mrokay97 2 times, last 4 months ago
  3. Riyaz 1 times, last 6 months ago
  4. Bardh 1 times, last 7 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: products: , while compiling: SELECT NAME from products

    at android.database.sqlite.SQLiteCompiledSql.native_compile()
  2. Android Platform
    SQLiteDatabase.rawQuery
    1. android.database.sqlite.SQLiteCompiledSql.native_compile(Native Method)
    2. android.database.sqlite.SQLiteCompiledSql.compile(SQLiteCompiledSql.java:92)
    3. android.database.sqlite.SQLiteCompiledSql.<init>(SQLiteCompiledSql.java:65)
    4. android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:83)
    5. android.database.sqlite.SQLiteQuery.<init>(SQLiteQuery.java:49)
    6. android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:42)
    7. android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1358)
    8. android.database.sqlite.SQLiteDatabase.rawQuery(SQLiteDatabase.java:1326)
    8 frames
  3. com.example.shopkart
    MainActivity.onCreate
    1. com.example.shopkart.datamanager.retrieveproducts(datamanager.java:218)
    2. com.example.shopkart.MainActivity.onCreate(MainActivity.java:54)
    2 frames
  4. Android Platform
    ActivityThread.main
    1. android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1047)
    2. android.app.ActivityThread.performLaunchActivity(ActivityThread.java:1615)
    3. android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:1667)
    4. android.app.ActivityThread.access$1500(ActivityThread.java:117)
    5. android.app.ActivityThread$H.handleMessage(ActivityThread.java:935)
    6. android.os.Handler.dispatchMessage(Handler.java:99)
    7. android.os.Looper.loop(Looper.java:130)
    8. android.app.ActivityThread.main(ActivityThread.java:3689)
    8 frames
  5. Java RT
    Method.invoke
    1. java.lang.reflect.Method.invokeNative(Native Method)
    2. java.lang.reflect.Method.invoke(Method.java:507)
    2 frames
  6. Android
    ZygoteInit.main
    1. com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:842)
    2. com.android.internal.os.ZygoteInit.main(ZygoteInit.java:600)
    2 frames
  7. Android Platform
    NativeStart.main
    1. dalvik.system.NativeStart.main(Native Method)
    1 frame