View Issue Details

This bug affects 1 person(s).
 2
IDProjectCategoryView StatusLast Update
07281Bug reportsConditionspublic2013-02-19 11:13
Reporterreslogic Assigned Toc_schmitz  
PrioritynormalSeverityblock 
Status closedResolutionfixed 
Product Version2.00+ 
Fixed in Version2.00+ 
Summary07281: SQL Crash when entering condition screen for multiple choice questions (resolution below)
Description

SQL Crash when entering condition screen for multiple choice questions

Steps To Reproduce

create an array question, enter conditions screen. Caused by attempt to pass named parameter for two parameter values. resolution below:

Additional Information

resolution:

in conditionsaction.php file.

replace the following
AND q.language=:lang
AND sq.language=:lang
With
AND q.language=:lang1
AND sq.language=:lang2

and additionally, replace
->bindParam(":lang", $sLanguage, PDO::PARAM_STR)
with
->bindParam(":lang1", $sLanguage, PDO::PARAM_STR)
->bindParam(":lang2", $sLanguage, PDO::PARAM_STR)

TagsNo tags attached.
Bug heat2
Complete LimeSurvey version number (& build)130206
I will donate to the project if issue is resolvedNo
BrowserAll
Database type & versionSQL Server 2008 R2
Server OS (if known)Windows
Webserver software & version (if known)IIS 7
PHP Version5

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2013-02-13 22:09

administrator   ~24055

Thank you - good catch!

c_schmitz

c_schmitz

2013-02-13 22:11

administrator   ~24056

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=11629

c_schmitz

c_schmitz

2013-02-19 11:13

administrator   ~24166

2.00 Build 130219 released

Related Changesets

LimeSurvey: master 768936f1

2013-02-13 21:10:40

c_schmitz

Details Diff
Fixed issue 07281: SQL error when entering condition screen for multiple choice questions and using MSSQL Affected Issues
07281
mod - application/controllers/admin/conditionsaction.php Diff File

Issue History

Date Modified Username Field Change
2013-02-08 12:51 reslogic New Issue
2013-02-13 22:05 c_schmitz Assigned To => c_schmitz
2013-02-13 22:05 c_schmitz Status new => assigned
2013-02-13 22:09 c_schmitz Note Added: 24055
2013-02-13 22:09 c_schmitz Status assigned => resolved
2013-02-13 22:09 c_schmitz Fixed in Version => 2.00+
2013-02-13 22:09 c_schmitz Resolution open => fixed
2013-02-13 22:11 c_schmitz Changeset attached => LimeSurvey master 768936f1
2013-02-13 22:11 c_schmitz Note Added: 24056
2013-02-19 11:13 c_schmitz Note Added: 24166
2013-02-19 11:13 c_schmitz Status resolved => closed