View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
04535 | Bug reports | Survey taking | public | 2010-08-16 15:02 | 2010-08-17 13:28 |
Reporter | Assigned To | c_schmitz | |||
Priority | normal | Severity | crash | ||
Status | closed | Resolution | fixed | ||
Product Version | 1.90+ | ||||
Fixed in Version | 1.90+ | ||||
Summary | 04535: SQL statement error | ||||
Description | [Microsoft][ODBC SQL Server Driver][SQL Server]The data types text and varchar are incompatible in the equal to operator.:SELECT qid,attribute FROM [lime_question_attributes] WHERE value='eng 44' | ||||
Steps To Reproduce | Normally, such an error will reproduce while running lime survey on SQL server | ||||
Additional Information | Indeed, the statement is from SQL server 2005 incorrect : Replacing line 3195 in qanda.php by $qaquery = "SELECT qid,attribute FROM ".db_table_name('question_attributes')." WHERE value LIKE '".strtolower($ia[2])."'"; will make it work. | ||||
Tags | No tags attached. | ||||
Bug heat | 2 | ||||
Complete LimeSurvey version number (& build) | 9046 | ||||
I will donate to the project if issue is resolved | |||||
Browser | |||||
Database type & version | SQL server 2005 | ||||
Server OS (if known) | Windows server 2003 | ||||
Webserver software & version (if known) | IIS6 | ||||
PHP Version | 5.2.14 | ||||
Date Modified | Username | Field | Change |
---|---|---|---|
2010-08-16 15:02 |
|
New Issue | |
2010-08-17 01:58 | c_schmitz | Assigned To | => c_schmitz |
2010-08-17 01:58 | c_schmitz | Status | new => assigned |
2010-08-17 12:20 | c_schmitz | Note Added: 12645 | |
2010-08-17 12:20 | c_schmitz | Status | assigned => resolved |
2010-08-17 12:20 | c_schmitz | Fixed in Version | => 1.90+ |
2010-08-17 12:20 | c_schmitz | Resolution | open => fixed |
2010-08-17 12:20 | c_schmitz | Note Edited: 12645 | |
2010-08-17 13:28 | c_schmitz | Status | resolved => closed |
2010-10-25 00:18 | c_schmitz | Category | Survey at Runtime => Survey taking |