android.database.sqlite.SQLiteException: near "DESC": syntax error (code 1): , while compiling: DELETE FROM people_email_followers WHERE local_blog_id=?1 AND person_id IN (SELECT person_id FROM people_email_followers WHERE local_blog_id=?1 DESC LIMIT ?2) ################################################################# Error Code : 1 (SQLITE_ERROR) Caused By : SQL(query) error or missing database. (near "DESC": syntax error (code 1): , while compiling: DELETE FROM people_email_followers WHERE local_blog_id=?1 AND person_id IN (SELECT person_id FROM people_email_followers WHERE local_blog_id=?1 DESC LIMIT ?2)) #################################################################

GitHub | maxme | 4 months ago
  1. 0

    Crash report 5.7-rc-2: SQLite error in PeopleTable

    GitHub | 4 months ago | maxme
    android.database.sqlite.SQLiteException: near "DESC": syntax error (code 1): , while compiling: DELETE FROM people_email_followers WHERE local_blog_id=?1 AND person_id IN (SELECT person_id FROM people_email_followers WHERE local_blog_id=?1 DESC LIMIT ?2) ################################################################# Error Code : 1 (SQLITE_ERROR) Caused By : SQL(query) error or missing database. (near "DESC": syntax error (code 1): , while compiling: DELETE FROM people_email_followers WHERE local_blog_id=?1 AND person_id IN (SELECT person_id FROM people_email_followers WHERE local_blog_id=?1 DESC LIMIT ?2)) #################################################################
  2. 0

    cant delete element in sqlite android

    Stack Overflow | 6 years ago | madcoderz
    android.database.sqlite.SQLiteException: bind or column index out of range: handle 0x327de0
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    Android sqlite exception,how to fix?

    Stack Overflow | 6 years ago | fonter
    android.database.sqlite.SQLiteException: error code 14: unable to open database file
  5. 0

    Composite primary and foreign key in SQLite 3.7.11 android (foreign key mismatch (code 1)

    Stack Overflow | 2 years ago | Kishore
    android.database.sqlite.SQLiteException: foreign key mismatch (code 1): , while compiling: DELETE FROM child_table WHERE data_id=?
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 "DESC": syntax error (code 1): , while compiling: DELETE FROM people_email_followers WHERE local_blog_id=?1 AND person_id IN (SELECT person_id FROM people_email_followers WHERE local_blog_id=?1 DESC LIMIT ?2) ################################################################# Error Code : 1 (SQLITE_ERROR) Caused By : SQL(query) error or missing database. (near "DESC": syntax error (code 1): , while compiling: DELETE FROM people_email_followers WHERE local_blog_id=?1 AND person_id IN (SELECT person_id FROM people_email_followers WHERE local_blog_id=?1 DESC LIMIT ?2)) #################################################################

    at android.database.sqlite.SQLiteConnection.nativePrepareStatement()
  2. Android Platform
    SQLiteDatabase.delete
    1. android.database.sqlite.SQLiteConnection.nativePrepareStatement(SQLiteConnection.java)
    2. android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:1058)
    3. android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:623)
    4. android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
    5. android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:59)
    6. android.database.sqlite.SQLiteStatement.<init>(SQLiteStatement.java:31)
    7. android.database.sqlite.SQLiteDatabase.delete(SQLiteDatabase.java:1634)
    7 frames
  3. org.wordpress.android
    PeopleManagementActivity.onCreate
    1. org.wordpress.android.datasets.PeopleTable.deletePeopleExceptForFirstPage(PeopleTable.java:181)
    2. org.wordpress.android.ui.people.PeopleManagementActivity.onCreate(PeopleManagementActivity.java:105)
    2 frames
  4. Android Platform
    ActivityThread.main
    1. android.app.Activity.performCreate(Activity.java:6876)
    2. android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1135)
    3. android.app.ActivityThread.performLaunchActivity(ActivityThread.java:3207)
    4. android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:3350)
    5. android.app.ActivityThread.access$1100(ActivityThread.java:222)
    6. android.app.ActivityThread$H.handleMessage(ActivityThread.java:1795)
    7. android.os.Handler.dispatchMessage(Handler.java:102)
    8. android.os.Looper.loop(Looper.java:158)
    9. android.app.ActivityThread.main(ActivityThread.java:7229)
    9 frames
  5. Java RT
    Method.invoke
    1. java.lang.reflect.Method.invoke(Method.java)
    1 frame
  6. Android
    ZygoteInit.main
    1. com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:1230)
    2. com.android.internal.os.ZygoteInit.main(ZygoteInit.java:1120)
    2 frames
  7. XposedBridge
    XposedBridge.main
    1. de.robv.android.xposed.XposedBridge.main(XposedBridge.java:117)
    1 frame