workflow error

📦 Install & Upgrade Help
1

hi,
I have created a module, and create a corresponding workflow, to send an email is certain fields have been marked.
Howver, the system do not send any email, and the log file error is inserted below - any advise, what to do?

LEFT JOIN nport_nport nport_nport_accounts ON nport_nport_accounts.id=nport_nport_accounts_c.nport_nport_accountsnport_nport_ida AND nport_nport_accounts.deleted=0
LEFT JOIN nport_nport_cstm nport_nport_accounts_cstm ON nport_nport.id = nport_nport_accounts_cstm.id_c WHERE nport_nport_accounts_cstm.simcard_sent_c = ‘1’ AND NOT EXISTS (SELECT * FROM aow_processed WHERE aow_processed.aow_workflow_id=‘753adf82-6ed6-bcab-1ba9-58e2ab80c31a’ AND aow_processed.parent_id=accounts.id AND aow_processed.status = ‘Complete’ AND aow_processed.deleted = 0) AND accounts.deleted = 0 : MySQL error 1054: Unknown column ‘nport_nport.id’ in ‘on clause’

2

It looks like you are joining nport_nport_cstm, but your ON clause is using nport_nport.id when it should be using nport_nport_cstm.id_c.

3

Thank you,

Any idea on how to fix it ?

4

Can you post a screen shot of your workflow settings?

5

ofcourse - happy to

attached screenshot