From fc2b26a6a27d19ecbfbb2202fd35b37568c65181 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Mon, 21 Apr 2008 05:53:19 +0100 Subject: add workaround for psql 8.3 stricter typechecking on SUBSTRING() (refs #201) --- modules/pref-feeds.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'modules/pref-feeds.php') diff --git a/modules/pref-feeds.php b/modules/pref-feeds.php index 9b718ace6..43be1cbe3 100644 --- a/modules/pref-feeds.php +++ b/modules/pref-feeds.php @@ -804,7 +804,7 @@ if ($_GET["slat"] == "true") { $show_last_article_info = true; $show_last_article_checked = "checked"; - $show_last_article_qpart = ", (SELECT SUBSTRING(MAX(updated),1,16) FROM ttrss_user_entries, + $show_last_article_qpart = ", (SELECT ".SUBSTRING_FOR_DATE."(MAX(updated),1,16) FROM ttrss_user_entries, ttrss_entries WHERE ref_id = ttrss_entries.id AND feed_id = F1.id) AS last_article"; } else if ($feeds_sort == "last_article") { -- cgit v1.2.3