On Thu, May 21, 2020 at 11:25 PM Madhukar Bhosale <[email protected]> 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
