View Issue Details

IDProjectCategoryView StatusLast Update
14137Bug reports[All Projects] RemoteControlpublic2018-10-19 16:37
ReporterarjerezaAssigned Toc_schmitz 
PrioritynoneSeverityminor 
Status assignedResolutionopen 
Product Version3.13.x 
Target VersionFixed in Version 
Summary14137: Yii framework bug when using remote control then inserting Session into MS SQL database
Description

When using MS SQL as the server database, I encountered a bug when calling the method get_session_key using remote control.

I have been receiving the following error:

"Request error: CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: [Microsoft][ODBC Driver 11 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
  1. Use MS SQL as server database.
  2. Enable remote control interface.
  3. Call RPC Client method get_session_key().
Additional Information

I have traced the error to the Yii framework.

framework\db\ar\CActiveRecord.php

On "insert" function. Line 1073

TagsNo tags attached.
Complete LimeSurvey version number (& build)limesurvey3.14.8+180829 and limesurvey3.15.0+181008
I will donate to the project if issue is resolvedNo
BrowserChorme and Firefox
Database & DB-VersionMS SQL 2012
Server OS (if known)Windows 10
Webserver software & version (if known)XAMPP v3.2.2
PHP VersionPHP Version 7.2.9

Activities

DenisChenu

DenisChenu

2018-10-19 16:37

developer   ~49378

Last edited: 2018-10-19 16:37

View 2 revisions

https://github.com/LimeSurvey/LimeSurvey/commit/52add8335a94197041786e728891582c7551183c

Then : can close at «Won't fix»

Issue History

Date Modified Username Field Change
2018-10-09 14:54 arjereza New Issue
2018-10-19 16:36 DenisChenu Assigned To => c_schmitz
2018-10-19 16:36 DenisChenu Status new => assigned
2018-10-19 16:37 DenisChenu Note Added: 49378
2018-10-19 16:37 DenisChenu Note Edited: 49378 View Revisions