View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
09132 | Bug reports | RemoteControl | public | 2014-07-04 15:25 | 2014-09-11 01:36 |
Reporter | jalpesh | Assigned To | c_schmitz | ||
Priority | high | Severity | crash | ||
Status | closed | Resolution | fixed | ||
Product Version | 2.05+ | ||||
Fixed in Version | 2.05+ | ||||
Summary | 09132: Not able to connect Remote API, it throw "Request error: CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]" Error | ||||
Description | Hi, I am using LimeSurvey 2.0.5 and MSSQL (SQL Server 2008 R2 ). I have install LimeSurvey on Linux machine. LimeSurvey work fine but when i connect through API it throw following error. "Request error: CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 102 General SQL Server error: Check messages from the SQL Server [102] (severity 15) [(null)]" | ||||
Steps To Reproduce | When i debug this issue in code, i found following code which case problem. if($sDatabasetype=='sqlsrv' || $sDatabasetype=='mssql' || $sDatabasetype=='dblib') Some More information, | ||||
Additional Information | PHP Code:- <?php define( 'LS_BASEURL', 'http://10.10.65.171/lime'); $rt = new jsonRPCClient( LS_BASEURL . LS_REMOTEURL); try{ ";print_r($rt->list_users($sSessionKey));print ""; } else{ print "in else"; } }catch(exception $e){ | ||||
Tags | No tags attached. | ||||
Bug heat | 4 | ||||
Complete LimeSurvey version number (& build) | Version 2.05+ | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | Mozilla | ||||
Database type & version | MSSQL (SQL Server 2008 R2 ) | ||||
Server OS (if known) | Linux | ||||
Webserver software & version (if known) | Apache | ||||
PHP Version | 5.3.3 | ||||
LimeSurvey on Linux and DB on MSSQL is always asking for problems ;). Have you configured FreeTDS to use the proper protocol version? |
|
Yes, I did try all. I have change tds version as following But still not working. I am facing same issue as above. Let me know if you want me try some other solution. |
|
Yes, I was able to reproduce it and the way you fixed it was all right. Thank you! |
|
Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=14460 |
|
2.05 Build 140911 released. |
|
Date Modified | Username | Field | Change |
---|---|---|---|
2014-07-04 15:25 | jalpesh | New Issue | |
2014-07-04 15:27 | jalpesh | Issue Monitored: jalpesh | |
2014-07-04 15:31 | jalpesh | Issue End Monitor: jalpesh | |
2014-07-24 11:51 | c_schmitz | Assigned To | => c_schmitz |
2014-07-24 11:51 | c_schmitz | Status | new => assigned |
2014-07-24 13:08 | c_schmitz | Note Added: 30342 | |
2014-07-24 13:08 | c_schmitz | Status | assigned => feedback |
2014-07-24 13:10 | c_schmitz | Note Edited: 30342 | |
2014-07-28 15:43 | jalpesh | Note Added: 30364 | |
2014-07-28 15:43 | jalpesh | Status | feedback => assigned |
2014-09-08 23:01 | c_schmitz | Note Added: 30502 | |
2014-09-08 23:01 | c_schmitz | Status | assigned => resolved |
2014-09-08 23:01 | c_schmitz | Fixed in Version | => 2.05+ |
2014-09-08 23:01 | c_schmitz | Resolution | open => fixed |
2014-09-08 23:03 | c_schmitz | Changeset attached | => LimeSurvey master 7de185eb |
2014-09-08 23:03 | c_schmitz | Note Added: 30503 | |
2014-09-11 01:36 | c_schmitz | Note Added: 30559 | |
2014-09-11 01:36 | c_schmitz | Status | resolved => closed |