[
https://issues.apache.org/jira/browse/GUACAMOLE-2088?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17987884#comment-17987884
]
Michael edited comment on GUACAMOLE-2088 at 7/2/25 12:25 PM:
-------------------------------------------------------------
i have obtained the error log via sudo tail -f /opt/tomcat/logs/catalina.out
Note "test" is the group name.
22:21:37.781 [http-nio-8080-exec-1] 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 MySQL
server version for the right syntax to use near 'name = 'tests'' 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 MySQL server version for the right
syntax to use near 'name = 'tests'' at line 5
was (Author: JIRAUSER310100):
i have obtained the error log via sudo tail -f /opt/tomcat/logs/catalina.out
22:21:37.781 [http-nio-8080-exec-1] 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 MySQL
server version for the right syntax to use near 'name = 'tests'' 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 MySQL server version for the right
syntax to use near 'name = 'tests'' at line 5
> Groups - unable to delete
> -------------------------
>
> Key: GUACAMOLE-2088
> URL: https://issues.apache.org/jira/browse/GUACAMOLE-2088
> Project: Guacamole
> Issue Type: Bug
> Components: guacamole
> Affects Versions: 1.6.0
> Environment: Rocky Linux
> Reporter: Michael
> Priority: Minor
> 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)
