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

[azzy9]

This error looks like the error caused by MySQL 8.0.31

MySQL error 1250: Table 'contacts' from one of the SELECTs cannot be used in global ORDER clause

In accounts the contacts and opportunities are not listed and instead there is the following error: Database failure. Please refer to suitecrm.log for details. In the log there are MySQL error 1250: Table ‘contacts’ from one of the SELECTs cannot be used in global ORDER clause errors for the related tables. On the internet I have found this, which leads me to think there is a bug with the version 7 and MySQL 8.0.31 If you’re getting an error that reads “ERROR 1250 (42000): Table ‘…’ from one o…