Fix search on SQLite database on Nextcloud 19

May have been broken some time already.

diff --git a/lib/notestorage.php b/lib/notestorage.php
index 275374c4ed7f36348cb11c7328cad93fdb1994eb..b430331d67d11a134b971f22697d37b954ebb3ab 100644 (file)
--- 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
+?>