From 3904320f95bbe5370dd0e9a59962df004f297cc5 Mon Sep 17 00:00:00 2001 From: Bernhard Posselt Date: Sun, 6 Apr 2014 22:16:39 +0200 Subject: fix probably broken sql query on sqlite and postgres for deleting items after a folder was deleted --- db/foldermapper.php | 5 ++--- 1 file changed, 2 insertions(+), 3 deletions(-) (limited to 'db') diff --git a/db/foldermapper.php b/db/foldermapper.php index 5245a1b12..8859268e0 100644 --- a/db/foldermapper.php +++ b/db/foldermapper.php @@ -74,9 +74,8 @@ class FolderMapper extends Mapper implements IMapper { $params = array($entity->getId()); $this->execute($sql, $params); - $sql = 'DELETE FROM `*PREFIX*news_items` `items` '. - 'LEFT JOIN `*PREFIX*news_feeds` `feeds` ON '. - '`items`.`feed_id` = `feeds`.`id` WHERE `feeds`.`id` IS NULL'; + $sql = 'DELETE FROM `*PREFIX*news_items` WHERE `feed_id` NOT IN '. + '(SELECT `feeds`.`id` FROM `*PREFIX*news_feeds` `feeds`)'; $this->execute($sql); } -- cgit v1.2.3