diff options
author | Bernhard Posselt <dev@bernhard-posselt.com> | 2016-04-07 00:13:18 +0200 |
---|---|---|
committer | Bernhard Posselt <dev@bernhard-posselt.com> | 2016-04-07 00:13:18 +0200 |
commit | 883b7ff215a8d786d0b881f75645c99c434147e0 (patch) | |
tree | 4e21341f78e36a4a7b631043819f94be22a4d89e | |
parent | 75839b01dd1a8224f033876b2cacd6b1d2c97cb2 (diff) |
fix update statemet
-rw-r--r-- | db/itemmapper.php | 4 | ||||
-rw-r--r-- | db/mysql/itemmapper.php | 4 |
2 files changed, 4 insertions, 4 deletions
diff --git a/db/itemmapper.php b/db/itemmapper.php index 8ccb3ca06..bbb4ca95d 100644 --- a/db/itemmapper.php +++ b/db/itemmapper.php @@ -387,8 +387,8 @@ class ItemMapper extends NewsMapper { // as unread if ($isRead) { $sql = 'UPDATE `*PREFIX*news_items` - SET `status` = `status` & ? - AND `last_modified` = ? + SET `status` = `status` & ?, + `last_modified` = ? WHERE `fingerprint` = ? AND `feed_id` IN ( SELECT `f`.`id` FROM `*PREFIX*news_feeds` AS `f` diff --git a/db/mysql/itemmapper.php b/db/mysql/itemmapper.php index fa08f933f..633f13967 100644 --- a/db/mysql/itemmapper.php +++ b/db/mysql/itemmapper.php @@ -70,8 +70,8 @@ class ItemMapper extends \OCA\News\Db\ItemMapper { $sql = 'UPDATE `*PREFIX*news_items` `items` JOIN `*PREFIX*news_feeds` `feeds` ON `feeds`.`id` = `items`.`feed_id` - SET `items`.`status` = `items`.`status` & ? - AND `items`.`last_modified` = ? + SET `items`.`status` = `items`.`status` & ?, + `items`.`last_modified` = ? WHERE `items`.`fingerprint` = ? AND `feeds`.`user_id` = ?'; $params = [~StatusFlag::UNREAD, $lastModified, |