diff options
| author |  Alexandre Alapetite <alexandre@alapetite.fr>
| 2021-07-24 19:25:59 +0200 |
|---|---|---|
| committer |  GitHub <noreply@github.com>
| 2021-07-24 19:25:59 +0200 |
| commit | 247dfa6c1ba0f60b7cca63141c94d5754b2bd7e5 (patch) | |
| tree | 5e03c8c7895d9e9d5c17d881a5028f4141790d6c /app | |
| parent | fe59d02066fc7a64e91ffbf13575b885c16022c0 (diff) | |
Fix marking as read a label with SQLite (#3711)
Cf. https://github.com/FreshRSS/FreshRSS/pull/3709#issuecomment-885334063
Diffstat (limited to 'app')
| -rw-r--r-- | app/Models/EntryDAOSQLite.php | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/app/Models/EntryDAOSQLite.php b/app/Models/EntryDAOSQLite.php index 82d7c099c..f0b9a318b 100644 --- a/app/Models/EntryDAOSQLite.php +++ b/app/Models/EntryDAOSQLite.php @@ -253,11 +253,11 @@ DROP TABLE IF EXISTS `tmp`; Minz_Log::debug('Calling markReadTag(0) is deprecated!'); } - $sql = 'UPDATE `_entry` e ' - . 'SET e.is_read = ? ' - . 'WHERE e.is_read <> ? AND e.id <= ? AND ' - . 'e.id IN (SELECT et.id_entry FROM `_entrytag` et ' - . ($id == '' ? '' : 'WHERE et.id = ?') + $sql = 'UPDATE `_entry` ' + . 'SET is_read = ? ' + . 'WHERE is_read <> ? AND id <= ? AND ' + . 'id IN (SELECT et.id_entry FROM `_entrytag` et ' + . ($id == '' ? '' : 'WHERE et.id_tag = ?') . ')'; $values = array($is_read ? 1 : 0, $is_read ? 1 : 0, $idMax); if ($id != '') { |