[jira] [Commented] (GUACAMOLE-2088) User groups created within MySQL/MariaDB cannot be deleted

["Mike Jumper (Jira)" <ji...@apache.org>]

    [ 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)