Fix parenthesis escaping bug (#5633)

fix https://github.com/FreshRSS/FreshRSS/issues/5632
In the SQL search, parentheses should not be escaped. Escaped parenthesis in the SQL search were tolerated by PostgreSQL but not by SQLite.

1 files changed, 6 insertions, 0 deletions

diff --git a/app/Models/Search.php b/app/Models/Search.php
index 52b000344..404b8bfac 100644
--- a/app/Models/Search.php
+++ b/app/Models/Search.php
@@ -73,6 +73,7 @@ class FreshRSS_Search {
 
 	public function __construct(string $input) {
 		$input = self::cleanSearch($input);
+		$input = self::unescape($input);
 		$this->raw_input = $input;
 
 		$input = $this->parseNotEntryIds($input);
@@ -662,4 +663,9 @@ class FreshRSS_Search {
 		}
 		return trim($input);
 	}
+
+	/** Remove escaping backslashes for parenthesis logic */
+	private static function unescape(string $input): string {
+		return str_replace(['\\(', '\\)'], ['(', ')'], $input);
+	}
 }