Relationship Graph View Issue Dependency Graph
related to child of duplicate of

View Issue Details

IDProjectCategoryView StatusLast Update
14687Bug reports[All Projects] RemoteControlpublic2019-03-25 19:03
ReporterckleAssigned ToDenisChenu 
PrioritynoneSeverityminor 
Status closedResolutionduplicate 
Product Version3.16.x 
Target VersionFixed in Version 
Summary14687: Error while creating a session key (using Microsoft SQL Server)
Description

I've tried to create a session key with the RESTClient-Add-On for Firefox and other REST-Clients.
But i only get the following error:

CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Implicit conversion from data type nvarchar to varbinary(max) is not allowed. Use the CONVERT function to run this query.

Steps To Reproduce

In LimeSurvey

  1. Set RPC interface enabled to "JSON-RPC" and Save
    In REST-Client
  2. Method: POST
  3. URL: https://my.limesurvey.url/index.php?r=admin/remotecontrol
  4. Add the following Header: "Content-Type: application/json"
  5. Body: {"method":"get_session_key","params":["myadmin","mypassword"],"id":1}

The Response:
{"id":1,"result":null,"error":"CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Implicit conversion from data type nvarchar to varbinary(max) is not allowed. Use the CONVERT function to run this query."}

Tagsremote control, remotecontrol
Complete LimeSurvey version number (& build)Version 3.16.1+190314
I will donate to the project if issue is resolvedNo
BrowserFirefox 66.0.1 with RESTClient
Database & DB-VersionMicrosoft SQL Server 2017 14.0.3006.16
Server OS (if known)Windows NT 10.0 build 14393 (Windows Server 2016)
Webserver software & version (if known)Microsoft IIS 10.0
PHP Version7.0.21

Activities

DenisChenu

DenisChenu

2019-03-25 19:03

developer   ~51120

Currently RC broke with MSSQL.
A tested solution (and working) is (manually) updating data column at sessions table : see https://github.com/LimeSurvey/LimeSurvey/pull/1113

I have to test with real session (tested only with RC)

Issue History

Date Modified Username Field Change
2019-03-25 17:49 ckle New Issue
2019-03-25 17:50 ckle Tag Attached: remote control
2019-03-25 17:50 ckle Tag Attached: remotecontrol
2019-03-25 19:03 DenisChenu Note Added: 51120
2019-03-25 19:03 DenisChenu Relationship added duplicate of 13950
2019-03-25 19:03 DenisChenu Assigned To => DenisChenu
2019-03-25 19:03 DenisChenu Status new => closed
2019-03-25 19:03 DenisChenu Resolution open => duplicate