View Issue Details

Related ChangesetsJump to NotesJump to History
This issue affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
10358Bug reportsSurvey editingpublic2016-02-09 14:192016-03-07 11:49
Reporterollehar Assigned ToLouisGac 
PrioritynormalSeverityminor 
Status closedResolutionfixed 
Product Version2.50.x 
Target Version2.50.xFixed in Version2.50.x 
Summary10358: Can't search questions with both free text and group
Description

CDbCommand failed to execute the SQL statement: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens. The SQL statement executed was: SELECT COUNT(*) FROM "lime_questions" "t" LEFT JOIN lime_groups AS groups ON ( groups.gid = t.gid AND t.language = groups.language AND groups.sid = t.sid) WHERE (((t.sid=:surveyid AND t.language=:language AND parent_qid=0) AND (groups.group_name = :group_name)) AND (title LIKE :ycp1)) OR (((t.sid=:surveyid AND t.language=:language AND parent_qid=0) AND (groups.group_name = :group_name)) AND (question LIKE :ycp2))

/var/www/lime25/limesurvey/framework/db/CDbCommand.php(543)

Steps To Reproduce

Go to "List questions"
Search for '123' and a specific group
Exception thrown

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)latest
I will donate to the project if issue is resolvedNo
Browser
Database type & version-
Server OS (if known)-
Webserver software & version (if known)-
PHP Version-

Users monitoring this issue

There are no users monitoring this issue.

Activities

LouisGac

LouisGac

2016-02-11 19:06

developer   ~34943

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

c_schmitz

2016-03-07 11:49

administrator   ~36039

Version 2.50+ Build 160307 released

Related Changesets

LimeSurvey: master 2cdbc842

2016-02-11 19:06

LouisGac


Details Diff		 Fixed issue 10358: can search question with question group Affected Issues
10358
mod - application/controllers/survey/index.php Diff File
mod - application/models/Question.php Diff File

Issue History

Date Modified Username Field Change
2016-02-09 14:19 ollehar New Issue
2016-02-09 14:19 ollehar Status new => assigned
2016-02-09 14:19 ollehar Assigned To => LouisGac
2016-02-11 19:06 LouisGac Changeset attached => LimeSurvey master 2cdbc842
2016-02-11 19:06 LouisGac Note Added: 34943
2016-02-11 19:06 LouisGac Resolution open => fixed
2016-02-11 19:06 LouisGac Status assigned => feedback
2016-03-03 19:28 LouisGac Status feedback => resolved
2016-03-07 11:48 c_schmitz Fixed in Version => 2.5
2016-03-07 11:49 c_schmitz Note Added: 36039
2016-03-07 11:49 c_schmitz Status resolved => closed
2019-11-01 17:25 c_schmitz Category Survey design => Survey editing