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 | 7 months ago
  1. 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') #################################################################
  2. 0

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

    Stack Overflow | 8 months 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

    Why does my createOrUpdate() call fail?

    Stack Overflow | 1 year ago | John Ernest Guadalupe
    java.sql.SQLException: queryForLong from database failed: SELECT COUNT(*) FROM `table` WHERE `id` = ?
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Syntax error when querying SQLite

    Stack Overflow | 11 months 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')
  6. 0

    `SQLiteException: no such collation sequence: JSON` on Barnes & Noble NOOK HD/HD+

    GitHub | 2 years ago | Takhion
    android.database.sqlite.SQLiteException: no such collation sequence: JSON: , while compiling: SELECT key, value, docid, revs.sequence, revid, json FROM maps, revs, docs WHERE maps.view_id=? AND key in (?) AND revs.sequence = maps.sequence AND docs.doc_id = revs.doc_id ORDER BY key LIMIT ? OFFSET ?

  1. Aria Pahlavan 8 times, last 3 weeks ago
  2. mrokay97 2 times, last 4 months ago
  3. Riyaz 1 times, last 6 months ago
  4. Bardh 1 times, last 6 months ago
  5. jk 12 times, last 7 months ago
4 more registered users
17 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

    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