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 | 8 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Android Database Mapper - No such table

    Stack Overflow | 8 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 | 1 year 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 | 1 year ago | wirawansanusi
    android.database.sqlite.SQLiteException: no such table: PRODUCT (code 1): , while compiling: SELECT * FROM PRODUCT
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