Odd SQL causing error when editing permissions
I recently updated to 2021.12 from quite an old version. If I try to edit permissions on roles I get the dreaded "something went wrong" page. Looking at the debug, the query seems sketchy:
'select distinct p.ID as `ID`, c., p.Name as `Name` from `GDN_c` `c` left join `GDN_p` `p` on c. = p.ID'
That query looks odd for a numebr of reasons - there is no GDN_c or GDN_p tables in the database. that c. in the select part seems to be missing a field name.