From 201c113041c97d6ba6d02fd851be02ac84a11780 Mon Sep 17 00:00:00 2001 From: Alexandre Alapetite Date: Mon, 13 Oct 2025 02:14:03 +0200 Subject: Fix SQL updateEntry (#8105) fix https://github.com/FreshRSS/FreshRSS/issues/8087#issuecomment-3395337832 Regression from https://github.com/FreshRSS/FreshRSS/pull/7886 --- app/Models/EntryDAO.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'app/Models/EntryDAO.php') diff --git a/app/Models/EntryDAO.php b/app/Models/EntryDAO.php index 93abc9a29..f05f10f6e 100644 --- a/app/Models/EntryDAO.php +++ b/app/Models/EntryDAO.php @@ -290,7 +290,7 @@ SQL; . 'SET title=:title, author=:author, ' . (static::isCompressed() ? 'content_bin=COMPRESS(:content)' : 'content=:content') . ', link=:link, date=:date, `lastSeen`=:last_seen' - . ', `lastUserModified`=MAX(:last_user_modified, `lastUserModified`)' + . ', `lastUserModified`=GREATEST(:last_user_modified, `lastUserModified`)' . ', hash=' . static::sqlHexDecode(':hash') . ', is_read=COALESCE(:is_read, is_read)' . ', is_favorite=COALESCE(:is_favorite, is_favorite)' -- cgit v1.2.3