Hi All,
I receive this error message on the cmdb_ci table when I try to either filter or group by various fields (support group, class, approval group, etc) on the Configuration Items list view or run a report using the same filters.
Ex.
Support Group: Syntax Error or Access Rule Violation detected by database ((conn=8606398) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'null LEFT JOIN sys_user_group sys_user_group1 ON cmdb0.`support_group` = sys_...' at line 1)
Class: Syntax Error or Access Rule Violation detected by database ((conn=8606400) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'null WHERE cmdb0.`sys_class_path` LIKE '/!!%' AND cmdb0.`sys_class_name` = 'c...' at line 1)
Please advise.
Thanks in advance!
