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 | 10 months ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

    java.lang.RuntimeException in database

    Stack Overflow | 10 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. justCodeit 58 times, last 2 months ago
  2. Riyaz 4 times, last 2 months ago
  3. Minafaw 2 times, last 9 months ago
  4. Ranjana Dangol 1 times, last 10 months ago
  5. Stefan Braune 177 times, last 11 months ago
1 more registered users
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