From c552533794a24ee8fd431b2307a2b1610746c657 Mon Sep 17 00:00:00 2001 From: Bernhard Posselt Date: Thu, 7 Apr 2016 00:06:35 +0200 Subject: update as --- db/itemmapper.php | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) diff --git a/db/itemmapper.php b/db/itemmapper.php index a2ad70a67..db7505a5e 100644 --- a/db/itemmapper.php +++ b/db/itemmapper.php @@ -386,12 +386,12 @@ class ItemMapper extends NewsMapper { // marking an item as unread should only mark the selected instance // as unread if ($isRead) { - $sql = 'UPDATE `*PREFIX*news_items` - SET `status` = `status` & ? - AND `last_modified` = ? - WHERE `fingerprint` = ? - AND feed_id IN ( - SELECT `f`.`id` FROM `*PREFIX*news_feeds` `f` + $sql = 'UPDATE `*PREFIX*news_items` AS `items` + SET `items`.`status` = `items`.`status` & ? + AND `items`.`last_modified` = ? + WHERE `items`.`fingerprint` = ? + AND `items`.`feed_id` IN ( + SELECT `f`.`id` FROM `*PREFIX*news_feeds` AS `f` WHERE `f`.`user_id` = ? )'; $params = [~StatusFlag::UNREAD, $lastModified, -- cgit v1.2.3