android.database.sqlite.SQLiteException: no such column: alex (code 1): , while compiling: SELECT Image FROM User WHERE Name = alex

Stack Overflow | John | 3 months ago
  1. 0

    no such column in SQLite

    Stack Overflow | 3 months ago | John
    android.database.sqlite.SQLiteException: no such column: alex (code 1): , while compiling: SELECT Image FROM User WHERE Name = alex
  2. 0

    Why does my createOrUpdate() call fail?

    Stack Overflow | 1 year ago | John Ernest Guadalupe
    java.sql.SQLException: queryForLong from database failed: SELECT COUNT(*) FROM `table` WHERE `id` = ?
  3. 0

    Syntax error when querying SQLite

    Stack Overflow | 11 months ago | java progammera
    android.database.sqlite.SQLiteException: near "(": syntax error (code 1): , while compiling: select * from appointments_table where strftime ('%d.%m.%Y', date) > now.strftime('%d.%m.%Y')
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    `SQLiteException: no such collation sequence: JSON` on Barnes & Noble NOOK HD/HD+

    GitHub | 2 years ago | Takhion
    android.database.sqlite.SQLiteException: no such collation sequence: JSON: , while compiling: SELECT key, value, docid, revs.sequence, revid, json FROM maps, revs, docs WHERE maps.view_id=? AND key in (?) AND revs.sequence = maps.sequence AND docs.doc_id = revs.doc_id ORDER BY key LIMIT ? OFFSET ?
  6. 0

    SQL error in getConflictingRevisions()

    GitHub | 4 years ago | pegli
    android.database.sqlite.SQLiteException: near "OFFSET": syntax error: , while compiling: SELECT revid FROM revs WHERE doc_id=? AND current ORDER BY revid DESC OFFSET 1

  1. Aria Pahlavan 8 times, last 3 weeks ago
  2. mrokay97 2 times, last 4 months ago
  3. Riyaz 1 times, last 6 months ago
  4. Bardh 1 times, last 7 months ago
  5. jk 12 times, last 7 months ago
4 more registered users
17 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: alex (code 1): , while compiling: SELECT Image FROM User WHERE Name = alex

    at android.database.sqlite.SQLiteConnection.nativePrepareStatement()
  2. Android Platform
    SQLiteDatabase.rawQuery
    1. android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
    2. android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:888)
    3. android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:499)
    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.rawQuery(SQLiteDatabase.java:1253)
    9 frames
  3. com.example.seng
    MainActivity$1.onClick
    1. com.example.seng.healthyapp.MainActivity$1.onClick(MainActivity.java:76)
    1 frame
  4. Android Platform
    View.performClick
    1. android.view.View.performClick(View.java:4230)
    1 frame