diff options
author | Bernhard Posselt <nukeawhale@gmail.com> | 2013-05-24 17:15:51 +0200 |
---|---|---|
committer | Bernhard Posselt <nukeawhale@gmail.com> | 2013-05-24 17:15:51 +0200 |
commit | 242555e659d4c03f46bc95a7437456718f1b6706 (patch) | |
tree | af4086281cb0ed4b76964690eeb15f9e20c8525c /db/foldermapper.php | |
parent | 37b48d2aef2b82db461c8227b78e01c5cdd8e9c1 (diff) |
fixed a bug when deleting folders
Diffstat (limited to 'db/foldermapper.php')
-rw-r--r-- | db/foldermapper.php | 11 |
1 files changed, 7 insertions, 4 deletions
diff --git a/db/foldermapper.php b/db/foldermapper.php index c2a44dc20..ceb70f18c 100644 --- a/db/foldermapper.php +++ b/db/foldermapper.php @@ -88,12 +88,15 @@ class FolderMapper extends Mapper implements IMapper { // someone please slap me for doing this manually :P // we needz CASCADE + FKs please - $sql = 'DELETE FROM `*PREFIX*news_feeds` WHERE `folder_id` = ?; '. - 'DELETE `items` FROM `*PREFIX*news_items` `items` '. - 'LEFT JOIN `*PREFIX*news_feeds` `feeds` ON '. - '`items`.`feed_id` = `feed`.`id` WHERE `feeds`.`id` IS NULL;'; + $sql = 'DELETE FROM `*PREFIX*news_feeds` WHERE `folder_id` = ?'; $params = array($entity->getId()); $this->execute($sql, $params); + + $sql = 'DELETE `items` FROM `*PREFIX*news_items` `items` '. + 'LEFT JOIN `*PREFIX*news_feeds` `feeds` ON '. + '`items`.`feed_id` = `feeds`.`id` WHERE `feeds`.`id` IS NULL'; + + $this->execute($sql); } |