java.lang.RuntimeException: Unable to start activity ComponentInfo{com.example.enxin.crystallise/com.example.enxin.crystallise.MainActivity}: android.database.sqlite.SQLiteException: no such column: thoughts (code 1): , while compiling: SELECT _id, title, message, thoughts, category, date FROM note

Stack Overflow | En Xin | 5 months ago
  1. 0

    java.lang.RuntimeException in database

    Stack Overflow | 5 months ago | En Xin
    java.lang.RuntimeException: Unable to start activity ComponentInfo{com.example.enxin.crystallise/com.example.enxin.crystallise.MainActivity}: android.database.sqlite.SQLiteException: no such column: thoughts (code 1): , while compiling: SELECT _id, title, message, thoughts, category, date FROM note
  2. 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
  3. 0

    DB migration fails when DB version <= 10

    GitHub | 3 years ago | maxme
    android.database.sqlite.SQLiteException: no such table: localdrafts (code 1): , while compiling: SELECT blogID, title, content, picturePaths, date, categories, tags, status, password, latitude, longitude FROM localdrafts ORDER BY id desc
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    SQLite no such column when trying to read from database (android)

    Stack Overflow | 2 years ago
    android.database.sqlite.SQLiteException: no such column: amount (code 1): , while compiling: SELECT _id, desc, amount FROM expenses
  6. 0

    android SQLITE database app crashes oncreate when it runs the getAllComments() method

    Stack Overflow | 2 years ago
    android.database.sqlite.SQLiteException: no such column: name (code 1): , while compiling: SELECT _id, comment, name FROM comments

  1. Minafaw 2 times, last 4 months ago
  2. Ranjana Dangol 1 times, last 5 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 column: thoughts (code 1): , while compiling: SELECT _id, title, message, thoughts, category, date FROM note

    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:1314)
    9. android.database.sqlite.SQLiteDatabase.queryWithFactory(SQLiteDatabase.java:1161)
    10. android.database.sqlite.SQLiteDatabase.query(SQLiteDatabase.java:1032)
    11. android.database.sqlite.SQLiteDatabase.query(SQLiteDatabase.java:1200)
    11 frames
  3. com.example.enxin
    MainActivityListFragment.onActivityCreated
    1. com.example.enxin.crystallise.NotebookDbAdapter.getAllNotes(NotebookDbAdapter.java:98)
    2. com.example.enxin.crystallise.MainActivityListFragment.onActivityCreated(MainActivityListFragment.java:39)
    2 frames
  4. Android Platform
    ActivityThread.performLaunchActivity
    1. android.app.Fragment.performActivityCreated(Fragment.java:1708)
    2. android.app.FragmentManagerImpl.moveToState(FragmentManager.java:908)
    3. android.app.FragmentManagerImpl.moveToState(FragmentManager.java:1062)
    4. android.app.FragmentManagerImpl.moveToState(FragmentManager.java:1044)
    5. android.app.FragmentManagerImpl.dispatchActivityCreated(FragmentManager.java:1853)
    6. android.app.Activity.performCreate(Activity.java:5234)
    7. android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1087)
    8. android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2148)
    8 frames