[
https://issues.apache.org/jira/browse/GUACAMOLE-2208?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Nick Couchman closed GUACAMOLE-2208.
------------------------------------
Resolution: Duplicate
> 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
> Priority: Major
>
> 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)
