summaryrefslogtreecommitdiffstats
path: root/db
diff options
context:
space:
mode:
authorBernhard Posselt <nukeawhale@gmail.com>2013-09-05 14:36:34 +0200
committerBernhard Posselt <nukeawhale@gmail.com>2013-09-05 14:36:41 +0200
commitefa881fd42c28adabb916650ea2b817effff71e8 (patch)
treed8ae976c572fd3ae282e73ceeafcefd21325d950 /db
parent37484b28aecbc0afcc5bb153e0940ea643c998f5 (diff)
trying to fix delete older than threshold query
Diffstat (limited to 'db')
-rw-r--r--db/itemmapper.php4
1 files changed, 2 insertions, 2 deletions
diff --git a/db/itemmapper.php b/db/itemmapper.php
index e66b8c166..0eec5f2cb 100644
--- a/db/itemmapper.php
+++ b/db/itemmapper.php
@@ -264,10 +264,10 @@ class ItemMapper extends Mapper implements IMapper {
if($limit > 0) {
$params = array($status, $row['feed_id']);
- $sql = 'DELETE FROM `*PREFIX*news_items` `items` ' .
+ $sql = 'DELETE FROM `*PREFIX*news_items` ' .
'WHERE NOT ((`status` & ?) > 0) ' .
'AND `feed_id` = ? ' .
- 'ORDER BY `items`.`id` ASC';
+ 'ORDER BY `id` ASC';
$this->execute($sql, $params, $limit);
}