From: Christian Weiske <cweiske@cweiske.de>
Date: Sun, 17 Jan 2021 14:31:54 +0000 (+0100)
Subject: Fix search on SQLite database on Nextcloud 19
X-Git-Tag: v0.7.5~3
X-Git-Url: https://git.cweiske.de/grauphel.git/commitdiff_plain/8a5220b3dbb8ad2272af0f2a0ea504db98ebc33e

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 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
+?>