summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorBernhard Posselt <dev@bernhard-posselt.com>2016-04-07 00:13:18 +0200
committerBernhard Posselt <dev@bernhard-posselt.com>2016-04-07 00:13:18 +0200
commit883b7ff215a8d786d0b881f75645c99c434147e0 (patch)
tree4e21341f78e36a4a7b631043819f94be22a4d89e
parent75839b01dd1a8224f033876b2cacd6b1d2c97cb2 (diff)
fix update statemet
-rw-r--r--db/itemmapper.php4
-rw-r--r--db/mysql/itemmapper.php4
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,