diff options
| author | Christian Weiske <cweiske@cweiske.de> | 2021-01-17 15:31:54 +0100 |
|---|---|---|
| committer | Christian Weiske <cweiske@cweiske.de> | 2021-01-17 17:03:06 +0100 |
| commit | 8a5220b3dbb8ad2272af0f2a0ea504db98ebc33e (patch) | |
| tree | ef5c89a99c0ddf89c318d674d6f10ca2e27b9e1f | |
| parent | 15bb045c5a40d18ab5c9aec583f1720871ade28e (diff) | |
| download | grauphel-8a5220b3dbb8ad2272af0f2a0ea504db98ebc33e.tar.gz grauphel-8a5220b3dbb8ad2272af0f2a0ea504db98ebc33e.zip | |
Fix search on SQLite database on Nextcloud 19
May have been broken some time already.
| -rw-r--r-- | lib/notestorage.php | 6 |
1 files 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 +?> |