AOW not sending emails

SuiteCRM Forum - English Language SuiteCRM General Discussion
1

Dear Will,

After upgrade and reinstall SuiteCRM Version 7.1.1, the AOW still can;t sending emails and status display it’s running :frowning: .

here’s error log
Fri Apr 4 12:40:37 2014 [8718][1][FATAL] Query Failed: SELECT aos_contracts.id AS id FROM aos_contracts WHERE aos_contracts.status = ‘Valid’ AND aos_contracts.contact_id = ‘dd170318-344b-78ab-1617-52fd8126b9df’ AND aos_contracts_cstm.reminderemail_c = ‘No’ AND aos_contracts.end_date < DATE_ADD(NOW(), INTERVAL + 1 month) AND aos_contracts.contract_type = ‘H’ AND aos_contracts.deleted = 0 : MySQL error 1054: Unknown column ‘aos_contracts_cstm.reminderemail_c’ in ‘where clause’
Fri Apr 4 12:40:37 2014 [8718][1][FATAL] Query Failed: SELECT aos_contracts.id AS id FROM aos_contracts WHERE aos_contracts_cstm.reminderemail_c = ‘No’ AND aos_contracts.status = ‘Valid’ AND aos_contracts_cstm.account_type_c = ‘Partner’ AND aos_contracts.end_date < DATE_ADD(NOW(), INTERVAL + 1 month) AND aos_contracts.contract_type = ‘P’ AND aos_contracts.deleted = 0 : MySQL error 1054: Unknown column ‘aos_contracts_cstm.reminderemail_c’ in ‘where clause’
Fri Apr 4 12:40:37 2014 [8718][1][FATAL] Query Failed: SELECT aos_contracts.id AS id FROM aos_contracts WHERE aos_contracts_cstm.reminderemail_c = ‘No’ AND aos_contracts.status = ‘Valid’ AND aos_contracts_cstm.account_type_c = ‘Customer’ AND aos_contracts.end_date < DATE_ADD(NOW(), INTERVAL + 1 month) AND aos_contracts.contract_type = ‘P’ AND aos_contracts.deleted = 0 : MySQL error 1054: Unknown column ‘aos_contracts_cstm.reminderemail_c’ in ‘where clause’
Fri Apr 4 12:40:37 2014 [8718][1][FATAL] tasks for aos_contracts_tasks failed to load

Fri Apr 4 12:40:37 2014 [8718][1][FATAL] notes for aos_contracts_notes failed to load

Fri Apr 4 12:40:37 2014 [8718][1][FATAL] meetings for aos_contracts_meetings failed to load

Fri Apr 4 12:40:37 2014 [8718][1][FATAL] calls for aos_contracts_calls failed to load

Fri Apr 4 12:40:37 2014 [8718][1][FATAL] emails for emails_aos_contracts_rel failed to load

Fri Apr 4 12:40:37 2014 [8718][1][FATAL] Job 4c878b1f-bfc6-d057-484a-533e37aefea7 (Run AOW WorkFlow) failed in CRON run

2

Hi there,

What is your Server/MySQL/PHP setup? What are the permissions set on your instance?

Thanks,

Will.

3

Dear Will,

Thank you for your reply, i tried reinstall on 2 server with latest version, but result is same. the problem is workflow can’t work with custom field, The workflow can work well if running without custom field as screen 2

here’s error log when running with custom field
Mon Apr 7 10:54:37 2014 [14888][1][FATAL] Query Failed: SELECT aos_contracts.id AS id FROM aos_contracts WHERE aos_contracts_cstm.r_c = ‘r’ AND aos_contracts.deleted = 0 : MySQL error 1054: Unknown column ‘aos_contracts_cstm.r_c’ in ‘where clause’