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 | 8 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    New Wikivoyage crashes

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

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