Index: branches/5.2.x/core/units/email_events/email_events_event_handler.php =================================================================== diff -u -N -r15252 -r15268 --- branches/5.2.x/core/units/email_events/email_events_event_handler.php (.../email_events_event_handler.php) (revision 15252) +++ branches/5.2.x/core/units/email_events/email_events_event_handler.php (.../email_events_event_handler.php) (revision 15268) @@ -1,6 +1,6 @@ getObject(); /* @var $object kDBItem */ - $sql = 'DELETE FROM ' . TABLE_PREFIX . 'EmailEventSubscribers + $sql = 'SELECT SubscriptionId + FROM ' . TABLE_PREFIX . 'SystemEventSubscriptions WHERE EmailEventId = ' . $object->GetID(); - $this->Conn->Query($sql); + $ids = $this->Conn->GetCol($sql); + + if ( !$ids ) { + return; + } + + $temp_handler = $this->Application->recallObject('system-event-subscription_TempHandler', 'kTempTablesHandler'); + /* @var $temp_handler kTempTablesHandler */ + + $temp_handler->DeleteItems('system-event-subscription', '', $ids); } } \ No newline at end of file