06961: CDbException unbuffered queries active when accessing survey or db analysis

This bug affects 1 person(s).

ID	Project	Category	View Status	Date Submitted	Last Update

06961	Bug reports	Survey participants (Tokens)	public	2012-11-26 16:09	2012-12-04 13:16

Reporter	limalemon	Assigned To	mdekker
Priority	normal	Severity	block
Status	closed	Resolution	fixed
Product Version	2.00+
Fixed in Version	2.00+

Summary	06961: CDbException unbuffered queries active when accessing survey or db analysis
Description	When I try to access the survey (via the link in the invitation email, or after inputing the token), I get the following error (also attached a save of the error I got): CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 2014 Cannot execute queries while other unbuffered queries are active. Consider using PDOStatement::fetchAll(). Alternatively, if your code is only ever going to run against mysql, you may enable query buffering by setting the PDO::MYSQL_ATTR_USE_BUFFERED_QUERY attribute The same error happens when I try to analyse the database.
Steps To Reproduce	Create survey; Lauch survey; Add tokens table; Add tokens; Send invitation email; Access survey URL. or: Click the analyse database button.
Tags	No tags attached.
Attached Files	CDbException.html.zip (5,259 bytes) CDbException-checkintegrity.html.zip (6,052 bytes)

Bug heat	6
Complete LimeSurvey version number (& build)	121121
I will donate to the project if issue is resolved	No
Browser	any
Database type & version	mySQL 5.0.22
Server OS (if known)	Red Hat
Webserver software & version (if known)	Apache/2.2.3
PHP Version	5.1.6

User List	There are no users monitoring this issue.

mdekker 2012-11-26 16:17 reporter ~22542	Could you please attach the error for check integrity (database)?

mdekker 2012-11-26 16:19 reporter ~22543	Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=10495

mdekker 2012-11-26 16:19 reporter ~22544	Fix committed to 2.1 branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=10496

mdekker 2012-11-26 16:20 reporter ~22545	Unable to test but partial fix (only for runtime) committed.

limalemon 2012-11-26 20:11 reporter ~22551	The error for the check integrity is the file that I just uploaded

mdekker 2012-11-26 21:31 reporter ~22555	Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=10499

mdekker 2012-11-26 21:32 reporter ~22556	can you check using the last file for checkintegrity.php?

mdekker 2012-11-27 09:27 reporter ~22596	Fix committed to 2.1 branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=10505

mdekker 2012-11-28 14:01 reporter ~22621	Please open a new issue if this error occurs in some other place. We need to fix all different statements, please attach the full error log like in this report as it really speeds up finding and fixing the erroneous statements.

c_schmitz 2012-12-04 13:16 administrator ~22875	LimeSurvey 2.0+ build 121204 released.

LimeSurvey: master e1079848 2012-11-26 16:19 mdekker Details Diff	Fixed 06961: CDbException unbuffered queries active when accessing survey or db analysis	Affected Issues 06961
	mod - application/controllers/survey/index.php	Diff File
	mod - application/helpers/database_helper.php	Diff File
LimeSurvey: 2.1 8acdca10 2012-11-26 16:19 mdekker Details Diff	Fixed 06961: CDbException unbuffered queries active when accessing survey or db analysis	Affected Issues 06961
	mod - application/controllers/survey/index.php	Diff File
	mod - application/helpers/database_helper.php	Diff File
LimeSurvey: master 160c5d25 2012-11-26 21:31 mdekker Details Diff	fixed 06961: CDbException unbuffered queries active when accessing survey or db analysis dev: seems that i only needed to remove old code that should have been removed anyway... merge error?	Affected Issues 06961
	mod - application/controllers/admin/checkintegrity.php	Diff File
LimeSurvey: 2.1 87bc38c4 2012-11-27 09:26 mdekker Details Diff	Fixed 06961: CDbException unbuffered queries active when accessing survey or db analysis	Affected Issues 06961
	mod - application/controllers/admin/checkintegrity.php	Diff File

Date Modified	Username	Field	Change
2012-11-26 16:09	limalemon	New Issue
2012-11-26 16:10	limalemon	File Added: CDbException.html.zip
2012-11-26 16:14	mdekker	Assigned To	=> mdekker
2012-11-26 16:14	mdekker	Status	new => assigned
2012-11-26 16:17	mdekker	Note Added: 22542
2012-11-26 16:18	mdekker	Summary	CDbException when accessing survey or db analysis => CDbException unbuffered queries active when accessing survey or db analysis
2012-11-26 16:19	mdekker	Changeset attached	=> LimeSurvey master e1079848
2012-11-26 16:19	mdekker	Note Added: 22543
2012-11-26 16:19	mdekker	Resolution	open => fixed
2012-11-26 16:19	mdekker	Changeset attached	=> LimeSurvey 2.1 8acdca10
2012-11-26 16:19	mdekker	Note Added: 22544
2012-11-26 16:20	mdekker	Note Added: 22545
2012-11-26 20:11	limalemon	File Added: CDbException-checkintegrity.html.zip
2012-11-26 20:11	limalemon	Note Added: 22551
2012-11-26 21:31	mdekker	Changeset attached	=> LimeSurvey master 160c5d25
2012-11-26 21:31	mdekker	Note Added: 22555
2012-11-26 21:32	mdekker	Note Added: 22556
2012-11-27 09:27	mdekker	Changeset attached	=> LimeSurvey 2.1 87bc38c4
2012-11-27 09:27	mdekker	Note Added: 22596
2012-11-28 14:01	mdekker	Note Added: 22621
2012-11-28 14:01	mdekker	Status	assigned => resolved
2012-11-28 14:01	mdekker	Fixed in Version	=> 2.00+
2012-12-04 13:16	c_schmitz	Note Added: 22875
2012-12-04 13:16	c_schmitz	Status	resolved => closed
2016-12-08 10:39	c_schmitz	Category	Tokens => Survey participants (Tokens)