Prevent concatenating words for full text search index

[tt-rss.git] / update.php

diff --git a/update.php b/update.php
index 216a9c1f47758aa7030541a8cb46db5642e2a861..25269bdcfc4a0e0fe1c73dda9659b9f60dab05ca 100755 (executable)
--- a/update.php
+++ b/update.php
@@ -347,7 +347,8 @@
                        $result = db_query("SELECT id, title, content FROM ttrss_entries WHERE tsvector_combined IS NULL ORDER BY id LIMIT $limit");
 
                        while ($line = db_fetch_assoc($result)) {
-                               $tsvector_combined = db_escape_string(mb_substr($line['title'] . ' ' . strip_tags($line['content']),
+                               $content_separated = str_replace('<', ' <', $line['content']);
+                               $tsvector_combined = db_escape_string(mb_substr($line['title'] . ' ' . strip_tags($content_separated),
                                        0, 1000000));
 
                                db_query("UPDATE ttrss_entries SET tsvector_combined = to_tsvector('english', '$tsvector_combined') WHERE id = " . $line["id"]);