[
https://issues.apache.org/jira/browse/GUACAMOLE-2088?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18003677#comment-18003677
]
Mike Jumper commented on GUACAMOLE-2088:
----------------------------------------
This is caused by a SQL syntax error introduced by [commit
f314e78|https://github.com/apache/guacamole-client/commit/f314e78c7cf7a41f1d709f18e0bfc3d58b440b92]
to the MySQL query for deleting a user group (an {{AND}} was deleted that
should not have been).
PostgreSQL and SQL Server do not have the same issue - it's just MySQL/MariaDB
where the error is present. Should be as simple as adding the {{AND}}.
> User groups created within MySQL/MariaDB cannot be deleted
> ----------------------------------------------------------
>
> Key: GUACAMOLE-2088
> URL: https://issues.apache.org/jira/browse/GUACAMOLE-2088
> Project: Guacamole
> Issue Type: Bug
> Components: guacamole-auth-jdbc-mysql
> Affects Versions: 1.6.0
> Environment: Rocky Linux
> Reporter: Michael
> Priority: Major
> Attachments: guacfolder.PNG
>
>
> Hi team,
> First Id like to say thank you for this tool, been using it for a while.
> regarding v1.6 just released, I have installed it the same method as v1.5.x
> however, it seems I am encountering an error when trying to delete any Groups.
> Could I share some logs or could this be checked somehow ?
> https://ibb.co/xSD6vBt8
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
