Hi everyone

I receive the following error after reviewing a customer account module that I have developed. The relationship is with a custom contacts module. The thing is that it work fine in reverse, i.e. Contacts>Account, but not Account>Contact. The same thing happens when I try to relate the accounts module to any other module.

error:

Error running count query for FKCC1_FKCC_StakeholderGroups List: Query Failed SELECT count(*) c FROM fkcc1_fkcc_risks_issues LEFT JOIN users jt0 ON jt0.id= fkcc1_fkcc_risks_issues.assigned_user_id AND jt0.deleted=0 AND jt0.deleted=0 INNER JOIN fkcc1_fkcc_risks_issues ON (fkcc1_fkcc_risks_issues.id=fkcc1_fkcc_risks_issue s.fkcc1_fkcc_risks_issues_idb AND fkcc1_fkcc_risks_issues.fkcc1_fkcc_stakeholdergrou ps_ida= '27cfa2f3-92b0-777e-2515-483bffc47ab3') where ( fkcc1_fkcc_risks_issues.deleted=0 AND fkcc1_fkcc_risks_issues.deleted=0) AND fkcc1_fkcc_risks_issues.deleted=0 )::MySQL error 1066: Not unique table/alias: 'fkcc1_fkcc_risks_issues'

Any advice would be much appreciated.

Cheers
Steve