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

GitHub | kelson42 | 11 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

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

    GitHub | 11 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') #################################################################
  2. 0

    Unable to resume activity, no such table: infteh (code 1): , while compiling: select * from infteh

    Stack Overflow | 1 year ago | AIOA Manun
    java.lang.RuntimeException: Unable to resume activity {ru.aioa.itwords/ru.aioa.itwords.InftehActivity}: android.database.sqlite.SQLiteException: no such table: infteh (code 1): , while compiling: select * from infteh
  3. 0

    phonegap Sqlite plugin implementation-error and warning:no such table

    Stack Overflow | 4 years ago | user
    android.database.sqlite.SQLiteException: no such table: table_name: , while compiling: SELECT column_name FROM table_name; 04-12 18:11:58.391: W/System.err(400): at android.database.sqlite.SQLiteCompiledSql.native_compile(Native Method) 04-12 18:11:58.391: W/System.err(400): at android.database.sqlite.SQLiteCompiledSql.compile(SQLiteCompiledSql.java:91) 04-12 18:11:58.391: W/System.err(400): at android.database.sqlite.SQLiteCompiledSql.<init>(SQLiteCompiledSql.java:64) 04-12 18:11:58.391: W/System.err(400): at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:80) at android.database.sqlite.SQLiteQuery.<init>(SQLiteQuery.java:46)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Why does my createOrUpdate() call fail?

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

    Syntax error when querying SQLite

    Stack Overflow | 1 year 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')
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

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

    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:1093)
    3. android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:670)
    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.rawQuery(SQLiteDatabase.java:1393)
    9 frames
  3. org.kiwix.kiwixmobile
    SearchActivity.onCreate
    1. org.kiwix.kiwixmobile.utils.DatabaseHelper.getRecentSearches(DatabaseHelper.java:82)
    2. org.kiwix.kiwixmobile.SearchActivity.onCreate(SearchActivity.java:47)
    2 frames
  4. Android Platform
    ActivityThread.main
    1. android.app.Activity.performCreate(Activity.java:6178)
    2. android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1118)
    3. android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2652)
    4. android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2773)
    5. android.app.ActivityThread.access$900(ActivityThread.java:177)
    6. android.app.ActivityThread$H.handleMessage(ActivityThread.java:1434)
    7. android.os.Handler.dispatchMessage(Handler.java:102)
    8. android.os.Looper.loop(Looper.java:135)
    9. android.app.ActivityThread.main(ActivityThread.java:5930)
    9 frames
  5. Java RT
    Method.invoke
    1. java.lang.reflect.Method.invoke(Native Method)
    2. java.lang.reflect.Method.invoke(Method.java:372)
    2 frames
  6. Android
    ZygoteInit.main
    1. com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:1405)
    2. com.android.internal.os.ZygoteInit.main(ZygoteInit.java:1200)
    2 frames