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/Pref_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/Pref_Feeds.php')
| -rw-r--r-- | classes/Pref_Feeds.php | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/classes/Pref_Feeds.php b/classes/Pref_Feeds.php index 75ae053bd..d27b7d750 100644 --- a/classes/Pref_Feeds.php +++ b/classes/Pref_Feeds.php @@ -74,7 +74,7 @@ class Pref_Feeds extends Handler_Protected { $feeds_obj = ORM::for_table('ttrss_feeds') ->table_alias('f') ->select_many('id', 'title', 'last_error', 'update_interval') - ->select_expr(SUBSTRING_FOR_DATE.'(last_updated,1,19)', 'last_updated') + ->select_expr('SUBSTRING_FOR_DATE(last_updated,1,19)', 'last_updated') ->left_outer_join('ttrss_user_entries', [ 'ue.feed_id', '=', 'f.id'], 'ue') ->select_expr('COUNT(ue.int_id) AS num_articles') ->where(['cat_id' => $cat_id, 'owner_uid' => $_SESSION['uid']]) @@ -261,7 +261,7 @@ class Pref_Feeds extends Handler_Protected { $feeds_obj = ORM::for_table('ttrss_feeds') ->table_alias('f') ->select_many('id', 'title', 'last_error', 'update_interval') - ->select_expr(SUBSTRING_FOR_DATE.'(last_updated,1,19)', 'last_updated') + ->select_expr('SUBSTRING_FOR_DATE(last_updated,1,19)', 'last_updated') ->left_outer_join('ttrss_user_entries', [ 'ue.feed_id', '=', 'f.id'], 'ue') ->select_expr('COUNT(ue.int_id) AS num_articles') ->where('owner_uid', $_SESSION['uid']) @@ -305,7 +305,7 @@ class Pref_Feeds extends Handler_Protected { $feeds_obj = ORM::for_table('ttrss_feeds') ->table_alias('f') ->select_many('id', 'title', 'last_error', 'update_interval') - ->select_expr(SUBSTRING_FOR_DATE.'(last_updated,1,19)', 'last_updated') + ->select_expr('SUBSTRING_FOR_DATE(last_updated,1,19)', 'last_updated') ->left_outer_join('ttrss_user_entries', [ 'ue.feed_id', '=', 'f.id'], 'ue') ->select_expr('COUNT(ue.int_id) AS num_articles') ->where('owner_uid', $_SESSION['uid']) |