summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorBernhard Posselt <dev@bernhard-posselt.com>2016-04-07 00:11:20 +0200
committerBernhard Posselt <dev@bernhard-posselt.com>2016-04-07 00:11:20 +0200
commit75839b01dd1a8224f033876b2cacd6b1d2c97cb2 (patch)
tree0d5e8c5f68024a631702d79c8cc0b0f70cd939d7
parentc552533794a24ee8fd431b2307a2b1610746c657 (diff)
revert it
-rw-r--r--db/itemmapper.php10
1 files changed, 5 insertions, 5 deletions
diff --git a/db/itemmapper.php b/db/itemmapper.php
index db7505a5e..8ccb3ca06 100644
--- a/db/itemmapper.php
+++ b/db/itemmapper.php
@@ -386,11 +386,11 @@ class ItemMapper extends NewsMapper {
// marking an item as unread should only mark the selected instance
// as unread
if ($isRead) {
- $sql = 'UPDATE `*PREFIX*news_items` AS `items`
- SET `items`.`status` = `items`.`status` & ?
- AND `items`.`last_modified` = ?
- WHERE `items`.`fingerprint` = ?
- AND `items`.`feed_id` IN (
+ $sql = 'UPDATE `*PREFIX*news_items`
+ SET `status` = `status` & ?
+ AND `last_modified` = ?
+ WHERE `fingerprint` = ?
+ AND `feed_id` IN (
SELECT `f`.`id` FROM `*PREFIX*news_feeds` AS `f`
WHERE `f`.`user_id` = ?
)';