diff options
author | Bernhard Posselt <dev@bernhard-posselt.com> | 2014-04-06 22:05:09 +0200 |
---|---|---|
committer | Bernhard Posselt <dev@bernhard-posselt.com> | 2014-04-06 22:05:09 +0200 |
commit | d70f905f91dd94064bd1202878dc10f054701af8 (patch) | |
tree | 73939462e0a8b995036916d204d508fb9b901d54 /db/itemmapper.php | |
parent | dfce69a3ae26b449e653958665aa66586cb1e842 (diff) |
fix deletion of items from users on sqlite
Diffstat (limited to 'db/itemmapper.php')
-rw-r--r-- | db/itemmapper.php | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/db/itemmapper.php b/db/itemmapper.php index eee3adb6a..68360cf13 100644 --- a/db/itemmapper.php +++ b/db/itemmapper.php @@ -281,8 +281,8 @@ class ItemMapper extends Mapper implements IMapper { * @param string $userId the name of the user */ public function deleteUser($userId) { - $sql = 'DELETE FROM `*PREFIX*news_items` `items` ' . - 'WHERE `items`.`feed_id` IN (' . + $sql = 'DELETE FROM `*PREFIX*news_items` ' . + 'WHERE `feed_id` IN (' . 'SELECT `feeds`.`id` FROM `*PREFIX*news_feeds` `feeds` ' . 'WHERE `feeds`.`user_id` = ?' . ')'; |