Workflow action email related field contacts:contact fails

šŸ’¬ General Discussion
21

Then I donā€™t have any more ideas to help you, sorry :frowning:

You can open an Issue on Github if you think this is a bugā€¦

22

What about this part of the trace?

Wed May 30 20:18:07 2018 [32726][5f866ce7-1b02-0489-040b-5978c66ca7d6][INFO] Query Execution Time:0.0003049373626709
Wed May 30 20:18:07 2018 [32726][5f866ce7-1b02-0489-040b-5978c66ca7d6][INFO] Query:SELECT contacts.first_name, contacts.last_name, contacts.phone_work, contacts.id, contacts.assigned_user_id contact_name_owner, 'Contacts' contact_name_mod FROM contacts, emails_beans WHERE emails_beans.email_id='b4d80f7d-50b9-eb0a-3764-5b04c6e680e1' AND emails_beans.bean_id=contacts.id AND emails_beans.bean_module = 'Contacts' AND emails_beans.deleted=0 AND contacts.deleted=0
Wed May 30 20:18:07 2018 [32726][5f866ce7-1b02-0489-040b-5978c66ca7d6][INFO] Query Execution Time:0.00030994415283203
Wed May 30 20:18:07 2018 [32726][5f866ce7-1b02-0489-040b-5978c66ca7d6][DEBUG] Call(b4d80f7d-50b9-eb0a-3764-5b04c6e680e1): contact_name = 
Wed May 30 20:18:07 2018 [32726][5f866ce7-1b02-0489-040b-5978c66ca7d6][DEBUG] Call(b4d80f7d-50b9-eb0a-3764-5b04c6e680e1): contact_phone = 
Wed May 30 20:18:07 2018 [32726][5f866ce7-1b02-0489-040b-5978c66ca7d6][DEBUG] Call(b4d80f7d-50b9-eb0a-3764-5b04c6e680e1): contact_id = 
Wed May 30 20:18:07 2018 [32726][5f866ce7-1b02-0489-040b-5978c66ca7d6][DEBUG] Call(b4d80f7d-50b9-eb0a-3764-5b04c6e680e1): contact_email1 = 
Wed May 30 20:18:07 2018 [32726][5f866ce7-1b02-0489-040b-5978c66ca7d6][INFO] Query:SELECT id ,aop_case_updates.name as parent_name , aop_case_updates.assigned_user_id owner

./modules/Emails/Email.php:

public function fill_in_additional_detail_fields()
    {
 // Get the id and the name.
        $row = $this->db->fetchByAssoc($result);
        if ($row != null) {
            
            $contact = new Contact();
            $contact->retrieve($row['id']);
            $this->contact_name = $contact->full_name;
            $this->contact_phone = $row['phone_work'];
            $this->contact_id = $row['id'];
            $this->contact_email = $contact->emailAddress->getPrimaryAddress($contact);
            $this->contact_name_owner = $row['contact_name_owner'];
            $this->contact_name_mod = $row['contact_name_mod'];
            $GLOBALS['log']->debug("Call($this->id): contact_name = $this->contact_name");
            $GLOBALS['log']->debug("Call($this->id): contact_phone = $this->contact_phone");
            $GLOBALS['log']->debug("Call($this->id): contact_id = $this->contact_id");
            $GLOBALS['log']->debug("Call($this->id): contact_email1 = $this->contact_email");
        } else {
            $this->contact_name = '';
            $this->contact_phone = '';
            $this->contact_id = '';
            $this->contact_email = '';
            $this->contact_name_owner = '';
            $this->contact_name_mod = '';
            $GLOBALS['log']->debug("Call($this->id): contact_name = $this->contact_name");
            $GLOBALS['log']->debug("Call($this->id): contact_phone = $this->contact_phone");
            $GLOBALS['log']->debug("Call($this->id): contact_id = $this->contact_id");
            $GLOBALS['log']->debug("Call($this->id): contact_email1 = $this->contact_email");
        }