From e22e0d686c16615d25ce806d5a0d22ee7c186913 Mon Sep 17 00:00:00 2001 From: Skibbi Date: Tue, 18 Aug 2015 10:13:06 +0200 Subject: Prevent concatenating words for full text search index --- update.php | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'update.php') diff --git a/update.php b/update.php index 216a9c1f4..25269bdcf 100755 --- 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"]); -- cgit v1.2.3