java.lang.RuntimeException: Unable to start activity ComponentInfo{com.main/com.main.Activity_Main}: android.database.sqlite.SQLiteException: no such table: Categories (code 1): , while compiling: SELECT * FROM Categories WHERE Categories.Id=? LIMIT 1

Stack Overflow | Freewister | 3 months ago
  1. 0

    Android Database Mapper - No such table

    Stack Overflow | 3 months ago | Freewister
    java.lang.RuntimeException: Unable to start activity ComponentInfo{com.main/com.main.Activity_Main}: android.database.sqlite.SQLiteException: no such table: Categories (code 1): , while compiling: SELECT * FROM Categories WHERE Categories.Id=? LIMIT 1
  2. 0

    Why is this sqlite database column not being created?

    Stack Overflow | 2 years ago
    android.database.sqlite.SQLiteException: no such column: image (code 1): , while compiling: SELECT DISTINCT _id, task, date, image FROM mainToDo
  3. 0

    database app crashes despite incrementing the database's version

    Stack Overflow | 12 months ago | mustapha kammoun
    android.database.sqlite.SQLiteException: no such column: _id (code 1): , while compiling: SELECT DISTINCT _id, membername, memberstudylevel, memberbirthday FROM members
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 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
  6. 0

    What is table E? (Proguard issues)

    GitHub | 12 months ago | wirawansanusi
    android.database.sqlite.SQLiteException: no such table: PRODUCT (code 1): , while compiling: SELECT * FROM PRODUCT

  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: Categories (code 1): , while compiling: SELECT * FROM Categories WHERE Categories.Id=? LIMIT 1

    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:889)
    3. android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:500)
    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)
    10 frames
  3. com.activeandroid
    Model.load
    1. com.activeandroid.Model.query(Model.java:306)
    2. com.activeandroid.Model.querySingle(Model.java:332)
    3. com.activeandroid.Model.load(Model.java:224)
    3 frames
  4. com.main
    Activity_Main.onCreate
    1. com.main.Activity_Main.onCreate(Activity_Main.java:59)
    1 frame
  5. Android Platform
    ActivityThread.performLaunchActivity
    1. android.app.Activity.performCreate(Activity.java:5990)
    2. android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1106)
    3. android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2278)
    3 frames