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/Counters.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'classes/Counters.php') diff --git a/classes/Counters.php b/classes/Counters.php index e20657947..4f23a7a41 100644 --- a/classes/Counters.php +++ b/classes/Counters.php @@ -157,7 +157,7 @@ class Counters { $sth = $pdo->prepare("SELECT f.id, f.title, - ".SUBSTRING_FOR_DATE."(f.last_updated,1,19) AS last_updated, + SUBSTRING_FOR_DATE(f.last_updated,1,19) AS last_updated, f.last_error, SUM(CASE WHEN unread THEN 1 ELSE 0 END) AS count, SUM(CASE WHEN marked THEN 1 ELSE 0 END) AS count_marked @@ -169,7 +169,7 @@ class Counters { } else { $sth = $pdo->prepare("SELECT f.id, f.title, - ".SUBSTRING_FOR_DATE."(f.last_updated,1,19) AS last_updated, + SUBSTRING_FOR_DATE(f.last_updated,1,19) AS last_updated, f.last_error, SUM(CASE WHEN unread THEN 1 ELSE 0 END) AS count, SUM(CASE WHEN marked THEN 1 ELSE 0 END) AS count_marked -- cgit v1.2.3-54-g00ecf