Hi, I've noticed that if I create a group with a space in its name, the group is created but cannot be deleted.
I've created a group called "SAS PCE" in my lab, but when I came to delete it, I get "Unexpected internal error". When I look in guacamole's logs, I see: --------------------- 14:45:51.296 [http-nio-8080-exec-6] ERROR o.a.g.rest.RESTExceptionMapper - Unexpected internal error: ### Error updating database. Cause: java.sql.SQLSyntaxErrorException: 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 'name = 'SAS PCE'' at line 5 ### The error may exist in org/apache/guacamole/auth/jdbc/usergroup/UserGroupMapper.xml ### The error may involve defaultParameterMap ### The error occurred while setting parameters ### SQL: DELETE FROM guacamole_entity WHERE type = 'USER_GROUP' name = ? ### Cause: java.sql.SQLSyntaxErrorException: 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 'name = 'SAS PCE'' at line 5 ----------------------- This should either allow deletions, or block creations, of groups with spaces in the name. Is this a reportable bug? Kind regards, Gareth Williams
