08925: Exporting a filtered list results in SQL Error - LimeSurvey bugs and feature requests

This bug affects 1 person(s).

ID	Project	Category	View Status	Date Submitted	Last Update

08925	Bug reports	Central participant database	public	2014-04-01 13:52	2014-04-14 23:02

Reporter	rom	Assigned To	c_schmitz
Priority	normal	Severity	partial_block
Status	closed	Resolution	fixed
Product Version	2.05+
Fixed in Version	2.05+

Summary	08925: Exporting a filtered list results in SQL Error
Description	When exporting a filtered list with multiple attributes to CSV a SQL Error appears: Internal Server Error CDbCommand failed to execute the SQL statement: SQLSTATE[HY093]: Invalid parameter number: no parameters were bound
Steps To Reproduce	-Create several attributes in CPD -Create Dummy tokens with attribute content -filter some of those dummy tokens by attribute content -export to csv -> SQL Error
Tags	No tags attached.

Bug heat	6
Complete LimeSurvey version number (& build)	Build 2.05
I will donate to the project if issue is resolved	No
Browser	Chrome
Database type & version	MYSQL
Server OS (if known)	Linux
Webserver software & version (if known)	APACHE
PHP Version	5.3.x

User List	rom

rom 2014-04-01 14:06 reporter ~29635	Build No. is 140320

c_schmitz 2014-04-14 14:49 administrator ~29735	Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=14135

c_schmitz 2014-04-14 16:36 administrator ~29748	Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=14143

c_schmitz 2014-04-14 16:53 administrator ~29752	Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=14153

c_schmitz 2014-04-14 23:02 administrator ~29762	2.05+ Build 140414 released

LimeSurvey: master fd87ca27 2014-04-14 14:50 c_schmitz Details Diff	Fixed issue 08925: Exporting a filtered list results in SQL error	Affected Issues 08925
	mod - application/controllers/admin/participantsaction.php	Diff File
	mod - application/models/Participant.php	Diff File
	mod - application/models/ParticipantAttributeName.php	Diff File
	mod - scripts/admin/participantdisplay.js	Diff File
LimeSurvey: master 6f2bd456 2014-04-14 14:50 c_schmitz Details Diff	Fixed issue 08925: Exporting a filtered list results in SQL error	Affected Issues 08925
	mod - application/controllers/admin/participantsaction.php	Diff File
	mod - application/models/Participant.php	Diff File
	mod - application/models/ParticipantAttributeName.php	Diff File
	mod - scripts/admin/participantdisplay.js	Diff File

Date Modified	Username	Field	Change
2014-04-01 13:52	rom	New Issue
2014-04-01 13:52	rom	Issue Monitored: rom
2014-04-01 14:06	rom	Note Added: 29635
2014-04-08 09:46	c_schmitz	Assigned To	=> c_schmitz
2014-04-08 09:46	c_schmitz	Status	new => assigned
2014-04-14 14:49	c_schmitz	Changeset attached	=> LimeSurvey master fd87ca27
2014-04-14 14:49	c_schmitz	Note Added: 29735
2014-04-14 14:49	c_schmitz	Resolution	open => fixed
2014-04-14 14:50	c_schmitz	Status	assigned => resolved
2014-04-14 14:50	c_schmitz	Fixed in Version	=> 2.05+
2014-04-14 16:36	c_schmitz	Changeset attached	=> LimeSurvey master 6f2bd456
2014-04-14 16:36	c_schmitz	Note Added: 29748
2014-04-14 16:53	c_schmitz	Changeset attached	=> LimeSurvey master 6f2bd456
2014-04-14 16:53	c_schmitz	Note Added: 29752
2014-04-14 23:02	c_schmitz	Note Added: 29762
2014-04-14 23:02	c_schmitz	Status	resolved => closed
2021-08-03 19:38	guest	Bug heat	4 => 6