On Thu, May 21, 2020 at 11:25 PM Madhukar Bhosale <bhosale.ma...@gmail.com>
wrote:

> Hi,
>
>
>
> Below are the logs, when I hit search in history and using guacamole 1.1.0
> version.
>
>
>
> 11:51:48.899 [https-openssl-apr-8443-exec-6] ERROR
> o.a.g.rest.RESTExceptionMapper - Unexpected internal error:
>
> ### Error querying database.  Cause:
> com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near
> 'username'.
>
> ### The error may exist in
> org/apache/guacamole/auth/jdbc/connection/ConnectionRecordMapper.xml
>
> ### The error may involve defaultParameterMap
>
> ### The error occurred while setting parameters
>
> ### SQL: SELECT TOP (?)
> [guacamole_connection_history].connection_id,
> [guacamole_connection_history].connection_name,
> [guacamole_connection_history].remote_host,
> [guacamole_connection_history].sharing_profile_id,
> [guacamole_connection_history].sharing_profile_name,
> [guacamole_connection_history].user_id,
> [guacamole_connection_history].username,
> [guacamole_connection_history].start_date,
>   [guacamole_connection_history].end_date         FROM
> [guacamole_connection_history]                    WHERE
> (                  [guacamole_connection_history].user_id IN
> (                     SELECT user_id                     FROM
> [guacamole_user]                     WHERE POSITION(? IN username) >
> 0                 )                  OR
> [guacamole_connection_history].connection_id IN (
> SELECT connection_id                     FROM
> [guacamole_connection]                     WHERE POSITION(? IN
> connection_name) > 0                 )
> )                                                  ORDER BY
> [guacamole_connection_history].start_date               DESC
>
> ### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect
> syntax near 'username'.
>

This has been fixed for the upcoming release:

https://issues.apache.org/jira/browse/GUACAMOLE-870

- Mike

Reply via email to