View Issue Details

Jump to NotesJump to History
This issue affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
14687Bug reportsRemoteControlpublic2019-03-25 17:492019-03-25 19:03
Reporterckle Assigned ToDenisChenu  
PrioritynoneSeverityminor 
Status closedResolutionduplicate 
Product Version3.16.x 
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
Bug heat4
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 type & 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

Relationships

Relationship GraphDependency Graph
duplicate of 13950 closedDenisChenu SQL Error when saving a response or getting a session token via API 

Users monitoring this issue

ckle

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 17:50 ckle Issue Monitored: ckle
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
2021-08-02 18:50 guest Bug heat 2 => 4