From 8a5220b3dbb8ad2272af0f2a0ea504db98ebc33e Mon Sep 17 00:00:00 2001 From: Christian Weiske Date: Sun, 17 Jan 2021 15:31:54 +0100 Subject: Fix search on SQLite database on Nextcloud 19 May have been broken some time already. --- lib/notestorage.php | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/lib/notestorage.php b/lib/notestorage.php index 275374c..b430331 100644 --- a/lib/notestorage.php +++ b/lib/notestorage.php @@ -298,8 +298,8 @@ class NoteStorage $keywordGroups['NOT'] = array(); } - $sqlTplAnd = ' AND (note_title ILIKE ? OR note_tags ILIKE ? OR note_content ILIKE ?)'; - $sqlTplNot = ' AND NOT (note_title ILIKE ? OR note_tags ILIKE ? OR note_content ILIKE ?)'; + $sqlTplAnd = ' AND (`note_title` ILIKE ? OR `note_tags` ILIKE ? OR `note_content` ILIKE ?)'; + $sqlTplNot = ' AND NOT (`note_title` ILIKE ? OR `note_tags` ILIKE ? OR `note_content` ILIKE ?)'; $arData = array( $this->username ); @@ -546,4 +546,4 @@ class NoteStorage ); } } -?> \ No newline at end of file +?> -- cgit v1.2.3