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) #################################################################

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via GitHub by kelson42
, 1 year ago
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
via Stack Overflow by Ziiil
, 1 year ago
################################################################# 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) #################################################################
via Stack Overflow by DJ. Aduvanchik
, 9 months ago
Unable to start activity ComponentInfo{com.example.djadu.signalminer121/com.example.djadu.signalminer121.ShowMeSQL}: android.database.sqlite.SQLiteException: no such table: cellinfoclass.db (code 1): , while compiling: SELECT _id, cellsignal
via Stack Overflow by Amgad
, 1 year ago
(SQLITE_ERROR) Caused By : SQL(query) error or missing database. (no such table: places (code 1): , while compiling: SELECT type, name FROM places WHERE _id=?) # Complete LogCat 11-20 10:52:35.231 28023-28023/com.amgad.hayy E/AndroidRuntime: FATAL EXCEPTION
via Stack Overflow by kshitij duraphe
, 1 month ago
################################################################# Error Code : 1 (SQLITE_ERROR) Caused By : SQL(query) error or missing database. (no such table: m1 (code 1): , while compiling: select * from m1) #################################################################
via GitHub by HiteshKhatri02
, 2 months ago
Unable to start activity ComponentInfo{com.google.android.apps.santatracker.debug/com.google.android.apps.santatracker.presentquest.MapsActivity}: android.database.sqlite.SQLiteException: no such table: USER (code 1): , while compiling: SELECT
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) #################################################################
at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:1058)
at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:623)
at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
at android.database.sqlite.SQLiteProgram.(SQLiteProgram.java:59)
at android.database.sqlite.SQLiteQuery.(SQLiteQuery.java:37)
at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:44)
at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1454)
at com.yahoo.squidb.data.adapter.SQLiteDatabaseAdapter.rawQuery(SQLiteDatabaseAdapter.java:209)
at com.yahoo.squidb.data.SquidDatabase.rawQuery(SquidDatabase.java:570)
at com.yahoo.squidb.data.SquidDatabase.query(SquidDatabase.java:1379)
at org.kiwix.kiwixcustomwikivoyage.database.RecentSearchDao.getRecentSearches(RecentSearchDao.java:27)
at org.kiwix.kiwixcustomwikivoyage.SearchActivity.onCreate(SearchActivity.java:53)
at android.app.Activity.performCreate(Activity.java:6876)
at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1135)
at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:3206)
at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:3349)
at android.app.ActivityThread.access$1100(ActivityThread.java:221)
at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1794)
at android.os.Handler.dispatchMessage(Handler.java:102)
at android.os.Looper.loop(Looper.java:158)
at android.app.ActivityThread.main(ActivityThread.java:7224)
at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:1230)
at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:1120)

Users with the same issue

2 times, 4 months ago
2 times, 1 year ago
2 times, 1 year ago
40 times, 1 month ago
347 times, 1 month ago
110 more bugmates

Know the solutions? Share your knowledge to help other developers to debug faster.