From 2fa54cc627cd9a370004a48e1b6430a8a9990846 Mon Sep 17 00:00:00 2001 From: wn_ Date: Sun, 18 May 2025 14:26:05 +0000 Subject: Deprecate and remove use of the 'SUBSTRING_FOR_DATE' constant. With MySQL support removed (b154bc7a10e46dc9fa0406996507c4fd410366da) this constant is unnecessary. --- classes/Feeds.php | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'classes/Feeds.php') diff --git a/classes/Feeds.php b/classes/Feeds.php index 7640185c1..7b0fc60cc 100644 --- a/classes/Feeds.php +++ b/classes/Feeds.php @@ -400,8 +400,8 @@ class Feeds extends Handler_Protected { $reply['content'] .= "

"; - $sth = $this->pdo->prepare("SELECT " . SUBSTRING_FOR_DATE . "(MAX(last_updated), 1, 19) AS last_updated FROM ttrss_feeds - WHERE owner_uid = ?"); + $sth = $this->pdo->prepare("SELECT SUBSTRING_FOR_DATE(MAX(last_updated), 1, 19) AS last_updated + FROM ttrss_feeds WHERE owner_uid = ?"); $sth->execute([$_SESSION['uid']]); $row = $sth->fetch(); @@ -2239,7 +2239,7 @@ class Feeds extends Handler_Protected { $orig_ts = strtotime(substr($k, 1)); $k = date("Y-m-d", TimeHelper::convert_timestamp($orig_ts, $user_tz_string, 'UTC')); - array_push($query_keywords, "(".SUBSTRING_FOR_DATE."(updated,1,LENGTH(".$pdo->quote($k).")) $not = ".$pdo->quote($k).")"); + array_push($query_keywords, "(SUBSTRING_FOR_DATE(updated,1,LENGTH(".$pdo->quote($k).")) $not = ".$pdo->quote($k).")"); } else { // treat as leftover text -- cgit v1.2.3-54-g00ecf