SQL Bug in Process Emailer

Idea created by Brad Foster on Sep 26, 2017
    Delivered
    Score0

    Don't know where to report bugs so putting it here.

     

    The SQL in this is wrong- the extra comma in the select is breaking it.

     

    C:\projects\crm\modules\pmse_Inbox\engine\PMSEHandlers\PMSEEmailHandler.php : Line 386

    $db = DBManagerFactory::getInstance();
    $query  = " SELECT eabr.bean_id, ";
    $query .= " FROM email_addr_bean_rel eabr ";
    $query .= " JOIN email_addresses ea on ea.id = eabr.email_address_id";
    $query .= " where ea.email_address = ?";
    $query .= " and ea.deleted = 0 ";
    $query .= " and eabr.deleted = 0 " ;

     

    Using enterprise 7.9.0

     

    Thanks

    Brad