java.lang.RuntimeException: Unable to start activity ComponentInfo{com.example.timeonice/com.example.timeonice.MainActivity}: android.database.sqlite.SQLiteException: no such column: plus (code 1): , while compiling: SELECT DISTINCT _id, number, lastname, firstname, position, timeonice, plus, minus FROM mainTable

Stack Overflow | user3078867 | 2 years ago
  1. 0

    Eclispe: SQLiteException no such column : plus (code 1) - EclPeople.com

    eclpeople.com | 12 months ago
    java.lang.RuntimeException: Unable to start activity ComponentInfo{com.example.timeonice/com.example.timeonice.MainActivity}: android.database.sqlite.SQLiteException: no such column: plus (code 1): , while compiling: SELECT DISTINCT _id, number, lastname, firstname, position, timeonice, plus, minus FROM mainTable
  2. 0

    SQLiteException no such column : plus (code 1)

    Stack Overflow | 2 years ago | user3078867
    java.lang.RuntimeException: Unable to start activity ComponentInfo{com.example.timeonice/com.example.timeonice.MainActivity}: android.database.sqlite.SQLiteException: no such column: plus (code 1): , while compiling: SELECT DISTINCT _id, number, lastname, firstname, position, timeonice, plus, minus FROM mainTable
  3. 0

    Table not created in SQLite database

    Stack Overflow | 2 years ago | Smu
    android.database.sqlite.SQLiteException: no such table: REMINDER_TABLE (code 1): , while compiling: SELECT * FROM REMINDER_TABLE WHERE USERNAME=? AND REMINDER_DATE=? AND REMINDER_TIME=?
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    FATAL EXCEPTION : main on Android SQLite

    Stack Overflow | 3 years ago | user3230689
    android.database.sqlite.SQLiteException: no such column: lxnv(code 1): , while compiling: SELECT DISTINCT userid, password FROM Users WHERE userid=lxnv
  6. 0

    android.database.sqlite.SQLiteException: no such table: (code 1)

    Stack Overflow | 1 year ago | jalilIrfan
    java.lang.RuntimeException: Unable to start activity ComponentInfo{com.jalil.justquiz/com.jalil.justquiz.MainActivity}: android.database.sqlite.SQLiteException: no such table: quiz_title (code 1): , while compiling: SELECT DISTINCT quiz_title FROM quiz_title WHERE _id = 1

  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 column: plus (code 1): , while compiling: SELECT DISTINCT _id, number, lastname, firstname, position, timeonice, plus, minus FROM mainTable

    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)
    10 frames
  3. com.example.timeonice
    MainActivity.onCreate
    1. com.example.timeonice.DBAdapter.getAllRows(DBAdapter.java:159)
    2. com.example.timeonice.DBAdapter.deleteAll(DBAdapter.java:146)
    3. com.example.timeonice.MainActivity.onCreate(MainActivity.java:135)
    3 frames
  4. Android Platform
    ActivityThread.performLaunchActivity
    1. android.app.Activity.performCreate(Activity.java:5231)
    2. android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1087)
    3. android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2159)
    3 frames