android.database.sqlite.SQLiteException: no such column: QUANTITY (code 1): , while compiling: SELECT * FROM FTS WHERE (QUANTITY MATCH ?)

Stack Overflow | Grace D | 5 months ago
  1. 0

    SQLiteException: no such column error

    Stack Overflow | 5 months ago | Grace D
    android.database.sqlite.SQLiteException: no such column: QUANTITY (code 1): , while compiling: SELECT * FROM FTS WHERE (QUANTITY MATCH ?)
  2. 0

    android app todo list

    Stack Overflow | 8 months ago | Khulood
    java.lang.RuntimeException: An error occurred while executing doInBackground()
  3. 0

    S6 Edge latest OS version causing a SQL crash

    GitHub | 1 year ago | N2Android
    android.database.sqlite.SQLiteException: no such column: _id (code 1): , while compiling: SELECT _id, class FROM apps WHERE (package=?) ################################################################# Error Code : 1 (SQLITE_ERROR) Caused By : SQL(query) error or missing database. (no such column: _id (code 1): , while compiling: SELECT _id, class FROM apps WHERE (package=?)) #################################################################
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    DB-related crash

    GitHub | 2 years ago | blinskey
    java.lang.RuntimeException: An error occured while executing doInBackground()
  6. 0

    DB schema change

    GitHub | 4 years ago | jberkel
    android.database.sqlite.SQLiteException: no such column: sdn_alpha_id: , while compiling: SELECT sns_receiver_count, numberlabel, service_type, matched_number, type, contactid, lookup_uri, mime_type, sdn_alpha_id, sp_type, messageid, fname, simnum, lname, sns_pkey, account_id, formatted_number, call_out_duration, number, geocoded_location, account_name, is_read, raw_contact_id, source_data, cdnip_number, state, m_subject, date, real_phone_number, source_package, _id, sns_tid, name, normalized_number, name_reversed, _data, photo_id, logtype, reject_flag, has_content, m_content, country_code, frequent, cityid, bname, countryiso, numbertype, new, duration, cnap_name, address, e164_number, voicemail_uri FROM logs WHERE (logs.logtype=100 OR logs.logtype=110 OR logs.logtype=500 OR logs.logtype=800 OR logs.logtype=900 OR logs.logtype=1000 OR (logs.logtype=200 AND number NOT IN (SELECT number FROM logs WHERE number LIKE '%@%')) OR logs.logtype=300) AND (((date > ?) AND ((type != '4')))) ORDER BY date

  1. Indri Yunita 4 times, last 6 days ago
  2. dontdropmybass 1 times, last 4 months ago
  3. Rajesh 21 times, last 4 months ago
  4. ank_07 6 times, last 4 months ago
  5. ben.slama.jihed 86 times, last 6 months ago
4 more registered users
2 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

    no such column: QUANTITY (code 1): , while compiling: SELECT * FROM FTS WHERE (QUANTITY MATCH ?)

    at android.database.sqlite.SQLiteConnection.nativePrepareStatement()
  2. Android Platform
    SQLiteQueryBuilder.query
    1. android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
    2. android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:887)
    3. android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:498)
    4. android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
    5. android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:58)
    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:1316)
    9. android.database.sqlite.SQLiteQueryBuilder.query(SQLiteQueryBuilder.java:400)
    10. android.database.sqlite.SQLiteQueryBuilder.query(SQLiteQueryBuilder.java:294)
    10 frames
  3. com.gmd.referenceapplication
    SearchableActivity$1.onQueryTextChange
    1. com.gmd.referenceapplication.DatabaseTable.query(DatabaseTable.java:187)
    2. com.gmd.referenceapplication.DatabaseTable.getWordMatches(DatabaseTable.java:179)
    3. com.gmd.referenceapplication.SearchableActivity$1.onQueryTextChange(SearchableActivity.java:70)
    3 frames
  4. Android v7
    SearchView$12.onTextChanged
    1. android.support.v7.widget.SearchView.onTextChanged(SearchView.java:1150)
    2. android.support.v7.widget.SearchView.access$2000(SearchView.java:103)
    3. android.support.v7.widget.SearchView$12.onTextChanged(SearchView.java:1680)
    3 frames
  5. Android Platform
    BaseInputConnection.setComposingText
    1. android.widget.TextView.sendOnTextChanged(TextView.java:7991)
    2. android.widget.TextView.handleTextChanged(TextView.java:8053)
    3. android.widget.TextView$ChangeWatcher.onTextChanged(TextView.java:10157)
    4. android.text.SpannableStringBuilder.sendTextChanged(SpannableStringBuilder.java:1033)
    5. android.text.SpannableStringBuilder.replace(SpannableStringBuilder.java:559)
    6. android.text.SpannableStringBuilder.replace(SpannableStringBuilder.java:492)
    7. android.text.SpannableStringBuilder.replace(SpannableStringBuilder.java:491)
    8. android.view.inputmethod.BaseInputConnection.replaceText(BaseInputConnection.java:685)
    9. android.view.inputmethod.BaseInputConnection.setComposingText(BaseInputConnection.java:445)
    9 frames
  6. Android
    IInputConnectionWrapper$MyHandler.handleMessage
    1. com.android.internal.view.IInputConnectionWrapper.executeMessage(IInputConnectionWrapper.java:340)
    2. com.android.internal.view.IInputConnectionWrapper$MyHandler.handleMessage(IInputConnectionWrapper.java:78)
    2 frames
  7. Android Platform
    ActivityThread.main
    1. android.os.Handler.dispatchMessage(Handler.java:102)
    2. android.os.Looper.loop(Looper.java:148)
    3. android.app.ActivityThread.main(ActivityThread.java:5417)
    3 frames
  8. Java RT
    Method.invoke
    1. java.lang.reflect.Method.invoke(Native Method)
    1 frame
  9. Android
    ZygoteInit.main
    1. com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:726)
    2. com.android.internal.os.ZygoteInit.main(ZygoteInit.java:616)
    2 frames