Bug found: Error adding Role to Security Group

Whenever I try to add a Role to a Security Group, I get the following error:
Database failure. Please refer to suitecrm.log for details.

The details are as follows:
Fri Dec 16 20:57:42 2022 [1601791][1][FATAL] Mysqli_query failed.
Fri Dec 16 20:57:42 2022 [1601791][1][FATAL] Error retrieving SecurityGroup list: Query Failed: (SELECT acl_roles.id , acl_roles.name , acl_roles.description , acl_roles.created_by , ‘aclroles’ panel_name FROM acl_roles INNER JOIN securitygroups_acl_roles ON acl_roles.id=securitygroups_acl_roles.role_id AND securitygroups_acl_roles.securitygroup_id=‘409a38c1-090e-139d-ea51-639cdb7c9e34’ AND securitygroups_acl_roles.deleted=0

where acl_roles.deleted=0) ORDER BY acl_roles.name asc LIMIT 0,10: MySQL error 1250: Table ‘acl_roles’ from one of the SELECTs cannot be used in global ORDER clause
Fri Dec 16 20:57:42 2022 [1601791][1][FATAL] [ListView::processUnionBeans] . Database failure. Please refer to suitecrm.log for details.

Does anyone know how to get around this? I am using MySQL 8.0

Thanks

Ivan

Hey
This is the solution to your issue

Thank you so much!!

This corrected the problem.

Ivan