[ solved ] Contact Owner - must be same in Accounts

[rslemer]

I found this error ...

2020-02-12T17:25:03-03:00 DEBUG index < getSortOrder
2020-02-12T17:25:03-03:00 DEBUG index > query select vtiger_crmentity.crmid from vtiger_notes
inner join vtiger_senotesrel on vtiger_senotesrel.notesid= vtiger_notes.notesid
left join vtiger_notescf ON vtiger_notescf.notesid= vtiger_notes.notesid
inner join vtiger_crmentity on vtiger_crmentity.crmid= vtiger_notes.notesid and vtiger_crmentity.deleted=0
inner join vtiger_crmentity crm2 on crm2.crmid=vtiger_senotesrel.crmid
LEFT JOIN vtiger_groups
ON vtiger_groups.groupid = vtiger_crmentity.smownerid
left join vtiger_seattachmentsrel on vtiger_seattachmentsrel.crmid =vtiger_notes.notesid
left join vtiger_attachments on vtiger_seattachmentsrel.attachmentsid = vtiger_attachments.attachmentsid
left join vtiger_users on vtiger_crmentity.smownerid= vtiger_users.id
where crm2.crmid=16733 ORDER BY title ASC
2020-02-12T17:25:03-03:00 INFO DB DB >ADODB error Query Failedelect vtiger_crmentity.crmid from vtiger_notes
inner join vtiger_senotesrel on vtiger_senotesrel.notesid= vtiger_notes.notesid
left join vtiger_notescf ON vtiger_notescf.notesid= vtiger_notes.notesid
inner join vtiger_crmentity on vtiger_crmentity.crmid= vtiger_notes.notesid and vtiger_crmentity.deleted=0
inner join vtiger_crmentity crm2 on crm2.crmid=vtiger_senotesrel.crmid
LEFT JOIN vtiger_groups
ON vtiger_groups.groupid = vtiger_crmentity.smownerid
left join vtiger_seattachmentsrel on vtiger_seattachmentsrel.crmid =vtiger_notes.notesid
left join vtiger_attachments on vtiger_seattachmentsrel.attachmentsid = vtiger_attachments.attachmentsid
left join vtiger_users on vtiger_crmentity.smownerid= vtiger_users.id
where crm2.crmid=16733 ORDER BY title ASC::->[1052]Column 'title' in order clause is ambiguous

---

if I mark the task in the workflow for moved documents as inactive, others will work well ...