diff options
| author | wn_ <invalid@email.com> | 2025-05-18 14:26:05 +0000 |
|---|---|---|
| committer | wn_ <invalid@email.com> | 2025-05-18 14:26:05 +0000 |
| commit | 2fa54cc627cd9a370004a48e1b6430a8a9990846 (patch) | |
| tree | 67a549d12e3224486f3c24036ffadb33cab441df /classes/Feeds.php | |
| parent | 0acaac7115017f72120a6baea13778563a755238 (diff) | |
Deprecate and remove use of the 'SUBSTRING_FOR_DATE' constant.
With MySQL support removed (b154bc7a10e46dc9fa0406996507c4fd410366da) this constant is unnecessary.
Diffstat (limited to 'classes/Feeds.php')
| -rw-r--r-- | classes/Feeds.php | 6 |
1 files changed, 3 insertions, 3 deletions
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'] .= "<p><span class=\"text-muted\">"; - $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 |