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 | 10 months ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

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

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

    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 | 1 year 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