diff options
| author |  Alexandre Alapetite <alexandre@alapetite.fr>
| 2025-10-13 02:14:03 +0200 |
|---|---|---|
| committer |  GitHub <noreply@github.com>
| 2025-10-13 02:14:03 +0200 |
| commit | 201c113041c97d6ba6d02fd851be02ac84a11780 (patch) | |
| tree | bc53b70b4d62ce104961a832f09a2ec439d49be0 /app/Models/EntryDAO.php | |
| parent | 348b6e358b0bf701a7c0e400e8c4773fe2659cd8 (diff) | |
Fix SQL updateEntry (#8105)
fix https://github.com/FreshRSS/FreshRSS/issues/8087#issuecomment-3395337832
Regression from https://github.com/FreshRSS/FreshRSS/pull/7886
Diffstat (limited to 'app/Models/EntryDAO.php')
| -rw-r--r-- | app/Models/EntryDAO.php | 2 |
1 files changed, 1 insertions, 1 deletions
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)' |