View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
14137 | Bug reports | RemoteControl | public | 2018-10-09 14:54 | 2019-05-23 19:15 |
Reporter | arjereza | Assigned To | DenisChenu | ||
Priority | none | Severity | minor | ||
Status | closed | Resolution | fixed | ||
Product Version | 3.13.x | ||||
Fixed in Version | 3.17.x | ||||
Summary | 14137: 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 |
| ||||
Additional Information | I have traced the error to the Yii framework. framework\db\ar\CActiveRecord.php On "insert" function. Line 1073 | ||||
Tags | No tags attached. | ||||
Bug heat | 6 | ||||
Complete LimeSurvey version number (& build) | limesurvey3.14.8+180829 and limesurvey3.15.0+181008 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | Chorme and Firefox | ||||
Database type & version | MS SQL 2012 | ||||
Server OS (if known) | Windows 10 | ||||
Webserver software & version (if known) | XAMPP v3.2.2 | ||||
PHP Version | PHP Version 7.2.9 | ||||
https://github.com/LimeSurvey/LimeSurvey/commit/52add8335a94197041786e728891582c7551183c Then : can close at «Won't fix» |
|
So no remote control features for MS SQL users which want to use DB based session handling? |
|
As said: DB based session handling never worked and is currently not available for MS SQL |
|
Yii framework bug when using remote control then inserting Session into MS SQL database is fixed |
|
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 | |
2019-03-18 16:56 | Mazi | Note Added: 51038 | |
2019-05-23 15:46 | c_schmitz | Note Added: 52090 | |
2019-05-23 15:46 | c_schmitz | Status | assigned => closed |
2019-05-23 15:46 | c_schmitz | Resolution | open => no change required |
2019-05-23 19:14 | DenisChenu | Assigned To | c_schmitz => DenisChenu |
2019-05-23 19:14 | DenisChenu | Status | closed => resolved |
2019-05-23 19:14 | DenisChenu | Fixed in Version | => 3.17.x |
2019-05-23 19:14 | DenisChenu | Note Added: 52097 | |
2019-05-23 19:15 | DenisChenu | Status | resolved => closed |
2019-05-23 19:15 | DenisChenu | Resolution | no change required => fixed |