java.lang.RuntimeException: Unable to start activity ComponentInfo{org.kiwix.kiwixcustomwikivoyage/org.kiwix.kiwixcustomwikivoyage.SearchActivity}: android.database.sqlite.SQLiteException: no such column: recentSearches.searchString (code 1): , while compiling: SELECT DISTINCT recentSearches.searchString AS searchString FROM recentSearches ORDER BY recentSearches._id DESC LIMIT 5 ################################################################# Error Code : 1 (SQLITE_ERROR) Caused By : SQL(query) error or missing database. (no such column: recentSearches.searchString (code 1): , while compiling: SELECT DISTINCT recentSearches.searchString AS searchString FROM recentSearches ORDER BY recentSearches._id DESC LIMIT 5) #################################################################

GitHub | kelson42 | 4 months ago
  1. 0

    New Wikivoyage crashes

    GitHub | 4 months ago | kelson42
    java.lang.RuntimeException: Unable to start activity ComponentInfo{org.kiwix.kiwixcustomwikivoyage/org.kiwix.kiwixcustomwikivoyage.SearchActivity}: android.database.sqlite.SQLiteException: no such column: recentSearches.searchString (code 1): , while compiling: SELECT DISTINCT recentSearches.searchString AS searchString FROM recentSearches ORDER BY recentSearches._id DESC LIMIT 5 ################################################################# Error Code : 1 (SQLITE_ERROR) Caused By : SQL(query) error or missing database. (no such column: recentSearches.searchString (code 1): , while compiling: SELECT DISTINCT recentSearches.searchString AS searchString FROM recentSearches ORDER BY recentSearches._id DESC LIMIT 5) #################################################################
  2. 0

    Android SQLiteException: bind or column index out of range: handle 0x2a0b88

    Stack Overflow | 2 years ago | Vikas
    android.database.sqlite.SQLiteException: bind or column index out of range: handle 0x2a0b88
  3. 0

    No such column error in Android Studio

    Stack Overflow | 1 month ago | Ziiil
    java.lang.RuntimeException: Unable to start activity ComponentInfo{com.example.zilunlin.bacpack/com.example.zilunlin.bacpack.MainActivity}: android.database.sqlite.SQLiteException: no such column: subject (code 1): , while compiling: SELECT _id, title, subject FROM tasks ################################################################# Error Code : 1 (SQLITE_ERROR) Caused By : SQL(query) error or missing database. (no such column: subject (code 1): , while compiling: SELECT _id, title, subject FROM tasks) #################################################################
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Kiwix for Android crash if ZIM file path contain "'"

    GitHub | 7 months ago | kelson42
    java.lang.RuntimeException: Unable to start activity ComponentInfo{org.kiwix.kiwixmobile/org.kiwix.kiwixmobile.SearchActivity}: android.database.sqlite.SQLiteException: near "S": syntax error (code 1): , while compiling: select * from recentsearches where zim = '/storage/extSdCard/ab'S/APKz/Download/wikipedia_en_all_simple_2015-08.zim' ################################################################# Error Code : 1 (SQLITE_ERROR) Caused By : SQL(query) error or missing database. (near "S": syntax error (code 1): , while compiling: select * from recentsearches where zim = '/storage/extSdCard/ab'S/APKz/Download/wikipedia_en_all_simple_2015-08.zim') #################################################################
  6. 0

    S6 Edge latest OS version causing a SQL crash

    GitHub | 1 year ago | N2Android
    android.database.sqlite.SQLiteException: no such column: _id (code 1): , while compiling: SELECT _id, class FROM apps WHERE (package=?) ################################################################# Error Code : 1 (SQLITE_ERROR) Caused By : SQL(query) error or missing database. (no such column: _id (code 1): , while compiling: SELECT _id, class FROM apps WHERE (package=?)) ################################################################# ################################################################# Error Code : 1 (SQLITE_ERROR) Caused By : SQL(query) error or missing database. (no such column: _id (code 1): , while compiling: SELECT _id, class FROM apps WHERE (package=?) ################################################################# Error Code : 1 (SQLITE_ERROR) Caused By : SQL(query) error or missing database. (no such column: _id (code 1): , while compiling: SELECT _id, class FROM apps WHERE (package=?)) #################################################################) #################################################################
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: recentSearches.searchString (code 1): , while compiling: SELECT DISTINCT recentSearches.searchString AS searchString FROM recentSearches ORDER BY recentSearches._id DESC LIMIT 5 ################################################################# Error Code : 1 (SQLITE_ERROR) Caused By : SQL(query) error or missing database. (no such column: recentSearches.searchString (code 1): , while compiling: SELECT DISTINCT recentSearches.searchString AS searchString FROM recentSearches ORDER BY recentSearches._id DESC LIMIT 5) #################################################################

    at android.database.sqlite.SQLiteConnection.nativePrepareStatement()
  2. Android Platform
    SQLiteDatabase.rawQueryWithFactory
    1. android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
    2. android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:1058)
    3. android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:623)
    4. android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
    5. android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:59)
    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:1454)
    9. android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1429)
    9 frames
  3. com.yahoo.squidb
    SquidDatabase.query
    1. com.yahoo.squidb.data.adapter.SQLiteDatabaseAdapter.rawQuery(SQLiteDatabaseAdapter.java:209)
    2. com.yahoo.squidb.data.SquidDatabase.rawQuery(SquidDatabase.java:570)
    3. com.yahoo.squidb.data.SquidDatabase.query(SquidDatabase.java:1379)
    3 frames
  4. org.kiwix.kiwixcustomwikivoyage
    SearchActivity.onCreate
    1. org.kiwix.kiwixcustomwikivoyage.database.RecentSearchDao.getRecentSearches(RecentSearchDao.java:27)
    2. org.kiwix.kiwixcustomwikivoyage.SearchActivity.onCreate(SearchActivity.java:53)
    2 frames
  5. Android Platform
    ActivityThread.main
    1. android.app.Activity.performCreate(Activity.java:6876)
    2. android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1135)
    3. android.app.ActivityThread.performLaunchActivity(ActivityThread.java:3206)
    4. android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:3349)
    5. android.app.ActivityThread.access$1100(ActivityThread.java:221)
    6. android.app.ActivityThread$H.handleMessage(ActivityThread.java:1794)
    7. android.os.Handler.dispatchMessage(Handler.java:102)
    8. android.os.Looper.loop(Looper.java:158)
    9. android.app.ActivityThread.main(ActivityThread.java:7224)
    9 frames
  6. Java RT
    Method.invoke
    1. java.lang.reflect.Method.invoke(Native Method)
    1 frame
  7. Android
    ZygoteInit.main
    1. com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:1230)
    2. com.android.internal.os.ZygoteInit.main(ZygoteInit.java:1120)
    2 frames