android.database.sqlite.SQLiteException: no such column: ٢ (code 1): , while compiling: SELECT id, url, user, session, timestamp, status, type, mimetype FROM web WHERE status=٢ AND url=? AND user=? ORDER BY timestamp DESC

GitHub | husadd | 10 months ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    GitHub comment 360#237719358

    GitHub | 10 months ago | husadd
    android.database.sqlite.SQLiteException: no such column: ٢ (code 1): , while compiling: SELECT id, url, user, session, timestamp, status, type, mimetype FROM web WHERE status=٢ AND url=? AND user=? ORDER BY timestamp DESC
  2. 0

    Add another column to SQLite database Android

    Stack Overflow | 9 months ago | Michael
    java.lang.RuntimeException: An error occurred while executing doInBackground()
  3. 0

    Cant recognize column in the second table

    Stack Overflow | 2 months ago | Nir Cohen
    java.lang.RuntimeException: Unable to start activity ComponentInfo{com.example.nir.nestleapp/com.example.nir.nestleapp.IceCreamMenuActivity}: android.database.sqlite.SQLiteException: no such column: IceCream (code 1): , while compiling: SELECT IceCream, Price FROM PriceTable
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    SQLiteLog: (1) No such table: Series

    Stack Overflow | 2 months ago | nkpg
    android.database.sqlite.SQLiteException: no such table: series (code 1): , while compiling: SELECT * FROM series
  6. 0

    Failing to escape single quotes in queries

    GitHub | 3 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

  1. justCodeit 58 times, last 2 months ago
  2. Riyaz 4 times, last 3 months ago
  3. Minafaw 2 times, last 10 months ago
  4. Ranjana Dangol 1 times, last 11 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: ٢ (code 1): , while compiling: SELECT id, url, user, session, timestamp, status, type, mimetype FROM web WHERE status=٢ AND url=? AND user=? ORDER BY timestamp DESC

    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:893)
    3. android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:504)
    4. android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:726)
    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:1426)
    9. android.database.sqlite.SQLiteDatabase.queryWithFactory(SQLiteDatabase.java:1273)
    10. android.database.sqlite.SQLiteDatabase.query(SQLiteDatabase.java:1144)
    11. android.database.sqlite.SQLiteDatabase.query(SQLiteDatabase.java:1312)
    11 frames
  3. org.quantumbadger.redreader
    CacheManager$RequestHandlerThread.run
    1. org.quantumbadger.redreader.cache.CacheDbManager.select(CacheDbManager.java:108)
    2. org.quantumbadger.redreader.cache.CacheManager$RequestHandlerThread.handleRequest(CacheManager.java:371)
    3. org.quantumbadger.redreader.cache.CacheManager$RequestHandlerThread.run(CacheManager.java:337)
    3 frames