Hi,
On a custom Notes module, Relationship, it is checked on Save for certain conditions. In addition, we would like to check the related Contact (One-Many) module for specific condition. Unfortunately AOW never runs once the Contact contact condition is checked. We would appreciate any advice on how to solve this.
SuiteCRM Version 7.3.2 Sugar Version 6.5.20 (Build 1001)
Server version: 5.5.57-0ubuntu0.14.04.1 (Ubuntu)
Wed Sep 13 14:54:26 2017 [6533][bd3e186c-f383-5582-0a1c-51484423b2fb][FATAL] project_resource for projects_contacts_resources failed to load
Wed Sep 13 14:54:28 2017 [6533][bd3e186c-f383-5582-0a1c-51484423b2fb][FATAL] project_resource for projects_contacts_resources failed to load
Wed Sep 13 15:02:30 2017 [7147][bd3e186c-f383-5582-0a1c-51484423b2fb][FATAL] Query Failed: SELECT dbe_relationship.id AS id FROM dbe_relationship LEFT JOIN dbe_relationship_contacts_c ON dbe_relationship.id=dbe_relationship_contacts_c.dbe_relationship_contactsdbe_relationship_idb AND dbe_relationship_contacts_c.deleted=0
LEFT JOIN contacts dbe_relationship_contacts ON dbe_relationship_contacts.id=dbe_relationship_contacts_c.dbe_relationship_contactscontacts_ida AND dbe_relationship_contacts.deleted=0
LEFT JOIN contacts_cstm dbe_relationship_contacts_cstm ON contacts.id = dbe_relationship_contacts_cstm.id_c WHERE dbe_relationship_contacts_cstm.journey_status_c = 'test' AND dbe_relationship.id = 'd2146cfe-5f92-9872-2907-52305e1e6f19' LIMIT 0,1: MySQL error 1054: Unknown column 'contacts.id' in 'on clause'
Wed Sep 13 15:02:30 2017 [7147][bd3e186c-f383-5582-0a1c-51484423b2fb][FATAL] Get One Failed:SELECT dbe_relationship.id AS id FROM dbe_relationship LEFT JOIN dbe_relationship_contacts_c ON dbe_relationship.id=dbe_relationship_contacts_c.dbe_relationship_contactsdbe_relationship_idb AND dbe_relationship_contacts_c.deleted=0
LEFT JOIN contacts dbe_relationship_contacts ON dbe_relationship_contacts.id=dbe_relationship_contacts_c.dbe_relationship_contactscontacts_ida AND dbe_relationship_contacts.deleted=0
LEFT JOIN contacts_cstm dbe_relationship_contacts_cstm ON contacts.id = dbe_relationship_contacts_cstm.id_c WHERE dbe_relationship_contacts_cstm.journey_status_c = 'test' AND dbe_relationship.id = 'd2146cfe-5f92-9872-2907-52305e1e6f19': MySQL error 1054: Unknown column 'contacts.id' in 'on clause'
A similar issue exist when we use Send Email for a Related Record Contact is used. AOW shows status as Running with no Completion. Sending email using any other means is ok; as well as primarily using Contact module rather than a related module.
Thank you for your kind assistance in advance.
Luke