diff options
author | Andrew Dolgov <[email protected]> | 2021-03-08 09:10:44 +0300 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2021-03-08 09:10:44 +0300 |
commit | 46b77fc6b7e1a90b768b2372cabc893872efe85d (patch) | |
tree | 5d3315941f4d70f5172268aeecb6ce00c4b47fdf | |
parent | 5db6939dc9628886391bcaa18965de94727c96d9 (diff) |
fix digest preview not working on mysql because of a quoted LIMIT argument
-rw-r--r-- | classes/digest.php | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/classes/digest.php b/classes/digest.php index 2fea99344..94e5cd1fc 100644 --- a/classes/digest.php +++ b/classes/digest.php @@ -119,7 +119,7 @@ class Digest link, score, content, - " . SUBSTRING_FOR_DATE . "(last_updated,1,19) AS last_updated + ".SUBSTRING_FOR_DATE."(last_updated,1,19) AS last_updated FROM ttrss_user_entries,ttrss_entries,ttrss_feeds LEFT JOIN @@ -132,8 +132,8 @@ class Digest AND unread = true AND score >= 0 ORDER BY ttrss_feed_categories.title, ttrss_feeds.title, score DESC, date_updated DESC - LIMIT :limit"); - $sth->execute([':user_id' => $user_id, ':limit' => $limit]); + LIMIT " . (int)$limit); + $sth->execute([':user_id' => $user_id]); $headlines_count = 0; $headlines = array(); |