android.database.sqlite.SQLiteException: near ",": syntax error (code 1): , while compiling: DELETE FROM messages_table WHERE (time,recepient_id,sender_id) IN (("1469945224502","8c79c7d4bf2c11e38867e83935244df8","0a0897ceed5a11e38867e83935244df8"),("1466672473543","8c79c7d4bf2c11e38867e83935244df8","0a0897ceed5a11e38867e83935244df8"))

  1. 0

    Syntax exception while trying to delete a list of objects from the database in Android

    Stack Overflow | 5 months ago | Юрій Мазуревич
    android.database.sqlite.SQLiteException: near ",": syntax error (code 1): , while compiling: DELETE FROM messages_table WHERE (time,recepient_id,sender_id) IN (("1469945224502","8c79c7d4bf2c11e38867e83935244df8","0a0897ceed5a11e38867e83935244df8"),("1466672473543","8c79c7d4bf2c11e38867e83935244df8","0a0897ceed5a11e38867e83935244df8"))
  2. 0

    Why framework is looking for relation table for inserting OneToMany record.

    GitHub | 8 months ago | kasim1011
    android.database.sqlite.SQLiteException: no such table: attendance_report_hr_attendance_rel (code 1): , while compiling: DELETE FROM attendance_report_hr_attendance_rel WHERE attendance_report_id = ?
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 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
  5. 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

  1. jk 6 times, last 7 months ago
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 ",": syntax error (code 1): , while compiling: DELETE FROM messages_table WHERE (time,recepient_id,sender_id) IN (("1469945224502","8c79c7d4bf2c11e38867e83935244df8","0a0897ceed5a11e38867e83935244df8"),("1466672473543","8c79c7d4bf2c11e38867e83935244df8","0a0897ceed5a11e38867e83935244df8"))

    at android.database.sqlite.SQLiteConnection.nativePrepareStatement()
  2. Android Platform
    SQLiteDatabase.delete
    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.SQLiteStatement.<init>(SQLiteStatement.java:31)
    7. android.database.sqlite.SQLiteDatabase.delete(SQLiteDatabase.java:1496)
    7 frames
  3. Unknown
    $JUST_MY_CLAS_NAME$6.run
    1. $JUST_MY_CLAS_NAME$6.run(BasicDAO.java:136)
    1 frame
  4. Java RT
    Thread.run
    1. java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1113)
    2. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:588)
    3. java.lang.Thread.run(Thread.java:818)
    3 frames