Skip to content

Typing " (double quotation mark) in the search box causes crash

Here's the logcat:

02-20 23:37:29.324 7176-7176/app.varlorg.unote.debug E/SQLiteLog: (1) unrecognized token: ""  ORDER BY Date_creation  DESC"
02-20 23:37:29.324 7176-7176/app.varlorg.unote.debug E/InputEventSender: Exception dispatching finished signal.
02-20 23:37:29.324 7176-7176/app.varlorg.unote.debug E/MessageQueue-JNI: Exception in MessageQueue callback: handleReceiveCallback
02-20 23:37:29.325 7176-7176/app.varlorg.unote.debug E/MessageQueue-JNI: android.database.sqlite.SQLiteException: unrecognized token: ""  ORDER BY Date_creation  DESC" (code 1): , while compiling: SELECT  * FROM table_notes WHERE Titre LIKE  "%"%"  ORDER BY Date_creation  DESC
    at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
    at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:889)
    at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:500)
    at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
    at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:58)
    at android.database.sqlite.SQLiteQuery.<init>(SQLiteQuery.java:37)
    at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:44)
    at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1318)
    at android.database.sqlite.SQLiteDatabase.rawQuery(SQLiteDatabase.java:1257)
    at app.varlorg.unote.NotesBDD.fillListNote(NotesBDD.java:238)
    at app.varlorg.unote.NotesBDD.getSearchedNotes(NotesBDD.java:233)
    at app.varlorg.unote.NoteMain$3.onTextChanged(NoteMain.java:221)
    at android.widget.TextView.sendOnTextChanged(TextView.java:8186)
    at android.widget.TextView.handleTextChanged(TextView.java:8248)
    at android.widget.TextView$ChangeWatcher.onTextChanged(TextView.java:10370)
    ...