X-Git-Url: http://git.roojs.org/?a=blobdiff_plain;f=Prune.php;h=c4642f61e7f50134aaa6c09a9b749fc07e53a110;hb=e804d7628a18b267b444cab3bc0596d8cd6276e0;hp=c0a6c2986e46132d4b201693beb27883792c44d5;hpb=bd1d8f5687ffaab8dea1beced450363703e8b393;p=Pman.Core

diff --git a/Prune.php b/Prune.php
index c0a6c298..c4642f61 100644
--- a/Prune.php
+++ b/Prune.php
@@ -71,9 +71,9 @@ class Pman_Core_Prune extends Pman
         
         $f = DB_DataObject::Factory('Events');
         $f->selectAdd();
-        $f->selectAdd("on_id, min(id) as min_id, max(id) as max_id, count(*) as mm");
+        $f->selectAdd("on_id, on_table, min(id) as min_id, max(id) as max_id, count(*) as mm");
         $f->whereAdd("action = 'NOTIFY' and event_when < NOW() - INTERVAL 1 WEEK");
-        $f->groupBy('on_id');
+        $f->groupBy('on_id, on_table');
         $f->having("mm > 2");
         $f->orderBy('mm desc') ;
         $f->limit(1000);