From: KH Lau Date: Tue, 24 Oct 2017 02:52:03 +0000 (+0800) Subject: DataObjects/Events.php X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=bd2d30892a71c6d59c264ad0f0a57bf5285e6b25 DataObjects/Events.php --- diff --git a/DataObjects/Events.php b/DataObjects/Events.php index 1c26ba1b..15e3b1e8 100644 --- a/DataObjects/Events.php +++ b/DataObjects/Events.php @@ -94,7 +94,7 @@ class Pman_Core_DataObjects_Events extends DB_DataObject if(!empty($q['dup_check'])){ $et = DB_DataObject::factory($tn); $this->_join .= "LEFT JOIN {$et->tableName()} AS evet ON (evet.id=Events.id)"; - $this->selectAdd("(select count(*)+1 from Events where Events.dup_id = evet.evet_id) as cnt "); + $this->selectAdd("(select count(*)+1 from Events where Events.dup_id = evet.id) as cnt "); $this->selectAs($et,'%s','evet'); $this->having('dup_id = 0 ');