I am facing an issue after upgrading a test instance of SugarCRM from MYSQL 5.7 to MYSQL 8.0 (in place upgrade after ubuntu server 18.0.4 to 20.0.4 upgrade)
Table 'job_queue' from one of the SELECTs cannot be used in global ORDER clause
I have configured the sql_mode as: sql_mode = "NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION"
Which has disabled full group by, but I have not faced the error message above before.
My previous MYSQL 5.7 sql_mode line will not allow MYSQL 8 to start so I modified it as above for testing
The instance I am testing is version 11.x, which is listed as supporting MYSQL 8.0
Have I missed a step in configuring MYSQL 8.0 to work correctly with SugarCRM?
