Workflow not sending emails to related "Contacts" via the Related Field - Contacts: Contact Name

[Jsam]

P.S. - I posted a topic about this but it did not go through nor it registered under my profile. Hopefully this will not create any duplicates.

ISSUE: All of a sudden, “Opportunities” workflows that are set to send emails to related “Contacts” (via the Related Field -> Contacts: Contact Name) stopped working. What’s surprising is it also happened on a separate copy of SuiteCRM.

1. Similar workflows - on both live and a development copy - are no longer sending mails. However, other actions, e.g. create a record (task) or modify record (assign to a user) works. .
2. This only happens on workflows related to OPPORTUNITIES. For LEADS, the Record Email works.
3. The error logs shows this: Wed Jun 17 15:28:02 2015 [14892][1][FATAL] Job b1d87520-efc9-fe7a-7b04-5581ca45daa8 (Run Report Generation Scheduled Tasks) failed in CRON run. But that scheduler is active and configured properly.
4. Permissions are ok. Nothing has changed since the last time the workflows work. Cache and custom directories, etc. are set to 777
5. There is also something like this on the log, not sure if it’s related:

Wed Jun 17 15:04:51 2015 [12185][1][FATAL] Query Failed: SELECT contacts.id ref_id , jt0.assigned_user_id opportunity_role_fields_owner, ‘Opportunities’ opportunity_role_fields_mod, opportunities_contacts.opportunity_id opportunity_id, opportunities_contacts.id opportunity_role_id, opportunities_contacts.contact_role opportunity_role , accounts.name account_name, jtl1.account_id account_id FROM contacts LEFT JOIN accounts_contacts jtl1 ON contacts.id=jtl1.contact_id AND jtl1.deleted=0

LEFT JOIN accounts accounts ON accounts.id=jtl1.account_id AND accounts.deleted=0
AND accounts.deleted=0 INNER JOIN opportunities_contacts ON contacts.id=opportunities_contacts.contact_id AND opportunities_contacts.opportunity_id=‘1659c02d-0f5b-5156-f3ca-5581bbfa4faa’ AND opportunities_contacts.deleted=0

where contacts.deleted=0: MySQL error 1054: Unknown column ‘jt0.assigned_user_id’ in ‘field list’

Please help. I don’t know why this suddenly happened. Thank you in advance.

[darrelh]

I have a similar issue sending emails about Opportunities, although I also have what seems to be a problem with beans. Tonight I tested an email for Quotes and it fired off fine. Did you find a solution?
My post is here: https://suitecrm.com/forum/suitecrm-7-0-discussion/6195-aow-emails-fail-php-errors

[terencelhl]

@DTWebmaster

P.S. - I posted a topic about this but it did not go through nor it registered under my profile. Hopefully this will not create any duplicates.

ISSUE: All of a sudden, “Opportunities” workflows that are set to send emails to related “Contacts” (via the Related Field → Contacts: Contact Name) stopped working. What’s surprising is it also happened on a separate copy of SuiteCRM.

1. Similar workflows - on both live and a development copy - are no longer sending mails. However, other actions, e.g. create a record (task) or modify record (assign to a user) works. .
2. This only happens on workflows related to OPPORTUNITIES. For LEADS, the Record Email works.
3. The error logs shows this: Wed Jun 17 15:28:02 2015 [14892][1][FATAL] Job b1d87520-efc9-fe7a-7b04-5581ca45daa8 (Run Report Generation Scheduled Tasks) failed in CRON run. But that scheduler is active and configured properly.
4. Permissions are ok. Nothing has changed since the last time the workflows work. Cache and custom directories, etc. are set to 777
5. There is also something like this on the log, not sure if it’s related:

Wed Jun 17 15:04:51 2015 [12185][1][FATAL] Query Failed: SELECT contacts.id ref_id , jt0.assigned_user_id opportunity_role_fields_owner, ‘Opportunities’ opportunity_role_fields_mod, opportunities_contacts.opportunity_id opportunity_id, opportunities_contacts.id opportunity_role_id, opportunities_contacts.contact_role opportunity_role , accounts.name account_name, jtl1.account_id account_id FROM contacts LEFT JOIN accounts_contacts jtl1 ON contacts.id=jtl1.contact_id AND jtl1.deleted=0

LEFT JOIN accounts accounts ON accounts.id=jtl1.account_id AND accounts.deleted=0
AND accounts.deleted=0 INNER JOIN opportunities_contacts ON contacts.id=opportunities_contacts.contact_id AND opportunities_contacts.opportunity_id=‘1659c02d-0f5b-5156-f3ca-5581bbfa4faa’ AND opportunities_contacts.deleted=0

where contacts.deleted=0: MySQL error 1054: Unknown column ‘jt0.assigned_user_id’ in ‘field list’

Please help. I don’t know why this suddenly happened. Thank you in advance.

Was there any change in operating system recently? If yes, try to uninstall the updates.