Error retrieving AOW_WorkFlow list: Query Failed: - After transfer to new server

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.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 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.

This error looks like the error caused by MySQL 8.0.31

1 Like