summaryrefslogtreecommitdiffstats
path: root/db
diff options
context:
space:
mode:
authorBernhard Posselt <nukeawhale@gmail.com>2013-05-24 17:15:51 +0200
committerBernhard Posselt <nukeawhale@gmail.com>2013-05-24 17:15:51 +0200
commit242555e659d4c03f46bc95a7437456718f1b6706 (patch)
treeaf4086281cb0ed4b76964690eeb15f9e20c8525c /db
parent37b48d2aef2b82db461c8227b78e01c5cdd8e9c1 (diff)
fixed a bug when deleting folders
Diffstat (limited to 'db')
-rw-r--r--db/foldermapper.php11
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);
}