fix digest preview not working on mysql because of a quoted LIMIT argument

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();