From e804d7628a18b267b444cab3bc0596d8cd6276e0 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Wed, 9 Dec 2015 17:26:43 +0800 Subject: [PATCH] Prune.php --- Prune.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) 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); -- 2.39.2