I am using integromat to import data. I got an issue with the search module of integromat for SuiteCRM. When I search for name or last name there are no issues, but when I search for something else like email, I get the following error in the log, which integromat says it is about the SuiteCRM and not on our end. I am kind of surprised, because if it was on SuiteCRM side, then why I don’t have the same issue with searching for names and last names.
Here is the log when using SuiteCRM Search Module in Integromat to search for email email@example.com, which is an existing contact.
Mon Dec 10 15:26:25 2018 [FATAL] Mysqli_query failed.
Mon Dec 10 15:26:25 2018 [FATAL] Error running count query for Contact List: Query Failed: SELECT count(*) c FROM contacts LEFT JOIN contacts_cstm ON contacts.id = contacts_cstm.id_c LEFT JOIN users jt0 ON contacts.modified_user_id=jt0.id AND jt0.deleted=0
AND jt0.deleted=0 LEFT JOIN users jt1 ON contacts.created_by=jt1.id AND jt1.deleted=0
AND jt1.deleted=0 LEFT JOIN users jt2 ON contacts.assigned_user_id=jt2.id AND jt2.deleted=0
AND jt2.deleted=0 LEFT JOIN contacts jt5 ON contacts.reports_to_id=jt5.id AND jt5.deleted=0
AND jt5.deleted=0 LEFT JOIN campaigns jt6 ON contacts.campaign_id=jt6.id AND jt6.deleted=0
AND jt6.deleted=0 where (contacts.email LIKE ‘%firstname.lastname@example.org%’) AND contacts.deleted=0: MySQL error 1054: Unknown column ‘contacts.email’ in 'where clause’