Wondering if anyone can help me figure this out.
Sun Dec 11 15:12:32 2022 [3697406][1][FATAL] Error retrieving AOW_WorkFlow list: Query Failed: (SELECT aow_processed.id , aow_processed.status , aow_processed.date_entered , aow_processed.date_modified , aow_processed.parent_id , aow_processed.parent_type , aow_processed.created_by , ‘aow_processed’ panel_name FROM aow_processed INNER JOIN aow_workflow aow_processed_rel ON aow_processed.aow_workflow_id=aow_processed_rel.id AND aow_processed_rel.deleted=0
where ( aow_processed.aow_workflow_id=‘b376e18c-9609-1174-7ede-5ee7c12b01e1’) AND aow_processed.deleted=0) ORDER BY aow_processed.date_entered desc LIMIT 0,10: MySQL error 1250: Table ‘aow_processed’ from one of the SELECTs cannot be used in global ORDER clause
Sun Dec 11 15:12:32 2022 [3697406][1][FATAL] [ListView::processUnionBeans] . Database failure. Please refer to suitecrm.log for details.
I have absolutely no idea why this is happening. I have transferred the crm from one server to another done complete repair on everything and this is the only error that I am getting.
Anyone seen this before.