From: Alan Knowles Date: Thu, 4 Oct 2018 04:29:41 +0000 (+0800) Subject: Prune.php X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=47dfb275f495126582af09f25e18f5758400e990 Prune.php --- diff --git a/Prune.php b/Prune.php index 5b49bd98..633f5717 100644 --- a/Prune.php +++ b/Prune.php @@ -76,7 +76,7 @@ class Pman_Core_Prune extends Pman WHERE action = 'NOTIFY' and event_when < NOW() - INTERVAL 1 WEEK GROUP BY on_id, on_table HAVING mm > 2 ORDER BY mm desc; */ - //DB_DataObject::debugLevel(1); + DB_DataObject::debugLevel(1); $f = DB_DataObject::Factory('Events'); $f->selectAdd(); $f->selectAdd("on_id, on_table, min(id) as min_id, max(id) as max_id, count(*) as mm"); @@ -85,6 +85,7 @@ class Pman_Core_Prune extends Pman $f->having("mm > 2"); $f->orderBy('mm desc') ; $f->limit(10000); + exit; $ar = $f->fetchAll(); foreach($ar as $f) { $q = DB_DataObject::Factory('Events');