SID Sabadell created GUACAMOLE-2208:
---------------------------------------
Summary: guacamole-client:1.6.0 "Unexpected internal error" when
deleting a group
Key: GUACAMOLE-2208
URL: https://issues.apache.org/jira/browse/GUACAMOLE-2208
Project: Guacamole
Issue Type: Bug
Components: guacamole
Affects Versions: 1.6.0
Environment: I'am testing on docker environment
Reporter: SID Sabadell
In Docker I am testing to update the version of guacamole-client:1.5.5 to
guacamole-client:1.6.0.
If I try to delete a user group in version 1.6.0, an error is generated.
{noformat}
guacamole-1 | 14:02:55.583 [http-nio-8080-exec-4] INFO
o.a.g.event.EventLoggingListener - User "guacadmin" (authenticated by "mysql")
failed to delete user group "GroupNameToDelete" within "mysql":
guacamole-1 | ### 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 =
'GroupNameToDelete'' at line 5
guacamole-1 | ### The error may exist in
org/apache/guacamole/auth/jdbc/usergroup/UserGroupMapper.xml
guacamole-1 | ### The error may involve defaultParameterMap
guacamole-1 | ### The error occurred while setting parameters
guacamole-1 | ### SQL: DELETE FROM guacamole_entity WHERE
type = 'USER_GROUP' name = ?
guacamole-1 | ### 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 = 'GroupNameToDelete'' at li
ne 5
guacamole-1 | 14:02:55.583 [http-nio-8080-exec-4] ERROR
o.a.g.rest.RESTExceptionMapper - Unexpected internal error:
guacamole-1 | ### 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 =
'GroupNameToDelete'' at line 5
guacamole-1 | ### The error may exist in
org/apache/guacamole/auth/jdbc/usergroup/UserGroupMapper.xml
guacamole-1 | ### The error may involve defaultParameterMap
guacamole-1 | ### The error occurred while setting parameters
guacamole-1 | ### SQL: DELETE FROM guacamole_entity WHERE
type = 'USER_GROUP' name = ?
guacamole-1 | ### 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 = 'GroupNameToDelete'' at li
ne 5 {noformat}
There are no problems with version 1.5.5
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
