Good Afternoon All,
I am unable to assign roles OR users to security groups (SuiteCRM>Admin>Security Suite Management). Anytime I try, I receive the error seen in the screenshot. The suiteCRM.log is as follows:
Tue Feb 7 14:28:06 2023 [10168][1][FATAL] Mysqli_query failed.
Tue Feb 7 14:28:06 2023 [10168][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=‘42781c6d-0456-6af1-57a0-63e2a5ae2ac8’ 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
Tue Feb 7 14:28:06 2023 [10168][1][FATAL] [ListView::processUnionBeans] . Database failure. Please refer to suitecrm.log for details.
Tue Feb 7 14:28:17 2023 [16356][1][FATAL] Mysqli_query failed.
Tue Feb 7 14:28:17 2023 [16356][1][FATAL] Query Failed: SELECT favorites.*
FROM favorites
JOIN config ON ( config.id = favorites.parent_id )
WHERE favorites.assigned_user_id = ‘1’
AND favorites.parent_type = ‘Administration’
AND favorites.deleted = 0
AND config.deleted = 0
ORDER BY favorites.date_entered DESC LIMIT 0,10: MySQL error 1054: Unknown column ‘config.deleted’ in ‘where clause’
Tue Feb 7 14:28:50 2023 [10168][1][FATAL] Mysqli_query failed.
Tue Feb 7 14:28:50 2023 [10168][1][FATAL] Query Failed: SELECT favorites.*
FROM favorites
JOIN config ON ( config.id = favorites.parent_id )
WHERE favorites.assigned_user_id = ‘1’
AND favorites.parent_type = ‘Administration’
AND favorites.deleted = 0
AND config.deleted = 0
ORDER BY favorites.date_entered DESC LIMIT 0,10: MySQL error 1054: Unknown column ‘config.deleted’ in ‘where clause’
Tue Feb 7 14:29:37 2023 [572][1][FATAL] Mysqli_query failed.
Tue Feb 7 14:29:37 2023 [572][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=‘42781c6d-0456-6af1-57a0-63e2a5ae2ac8’ 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
Tue Feb 7 14:29:37 2023 [572][1][FATAL] [ListView::processUnionBeans] . Database failure. Please refer to suitecrm.log for details.
Tue Feb 7 14:29:55 2023 [10168][1][FATAL] Mysqli_query failed.
Tue Feb 7 14:29:55 2023 [10168][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=‘42781c6d-0456-6af1-57a0-63e2a5ae2ac8’ 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
Tue Feb 7 14:29:55 2023 [10168][1][FATAL] [ListView::processUnionBeans] . Database failure. Please refer to suitecrm.log for details.
Tue Feb 7 14:30:16 2023 [11540][1][FATAL] Mysqli_query failed.
Tue Feb 7 14:30:16 2023 [11540][1][FATAL] Error retrieving ACLRole list: Query Failed: (SELECT securitygroups.id , securitygroups.name , securitygroups.description , securitygroups.assigned_user_id , ‘securitygroups’ panel_name FROM securitygroups INNER JOIN securitygroups_acl_roles ON securitygroups.id=securitygroups_acl_roles.securitygroup_id AND securitygroups_acl_roles.role_id=‘7b6dd089-b7f8-2feb-af62-63e2a5ebcdf5’ AND securitygroups_acl_roles.deleted=0
where securitygroups.deleted=0) ORDER BY securitygroups.name asc LIMIT 0,10: MySQL error 1250: Table ‘securitygroups’ from one of the SELECTs cannot be used in global ORDER clause
Tue Feb 7 14:30:16 2023 [11540][1][FATAL] [ListView::processUnionBeans] . Database failure. Please refer to suitecrm.log for details.
Tue Feb 7 14:33:21 2023 [16356][1][FATAL] Mysqli_query failed.
Tue Feb 7 14:33:21 2023 [16356][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=‘42781c6d-0456-6af1-57a0-63e2a5ae2ac8’ 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
Tue Feb 7 14:33:21 2023 [16356][1][FATAL] [ListView::processUnionBeans] . Database failure. Please refer to suitecrm.log for details.
Tue Feb 7 14:33:35 2023 [16356][1][FATAL] Mysqli_query failed.
Tue Feb 7 14:33:35 2023 [16356][1][FATAL] Error retrieving SecurityGroup list: Query Failed: (SELECT users.id , users.first_name , users.last_name , LTRIM(RTRIM(CONCAT(IFNULL(users.first_name,‘’),’ ‘,IFNULL(users.last_name,’')))) as full_name, users.user_name , users.phone_work , users.created_by , ‘users’ panel_name FROM users INNER JOIN securitygroups_users ON users.id=securitygroups_users.user_id AND securitygroups_users.securitygroup_id=‘42781c6d-0456-6af1-57a0-63e2a5ae2ac8’ AND securitygroups_users.deleted=0
where users.deleted=0) ORDER BY users.user_name asc LIMIT 0,10: MySQL error 1250: Table ‘users’ from one of the SELECTs cannot be used in global ORDER clause
Tue Feb 7 14:33:35 2023 [16356][1][FATAL] [ListView::processUnionBeans] . Database failure. Please refer to suitecrm.log for details.