View Issue Details

IDProjectCategoryView StatusLast Update
06961Bug reports[All Projects] Survey participants (Tokens)public2012-12-04 13:16
ReporterlimalemonAssigned Tomdekker 
PrioritynormalSeveritycrash 
Status closedResolutionfixed 
Product Version2.00+ 
Target VersionFixed in Version2.00+ 
Summary06961: CDbException unbuffered queries active when accessing survey or db analysis
DescriptionWhen 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 ReproduceCreate survey;
Lauch survey;
Add tokens table;
Add tokens;
Send invitation email;
Access survey URL.

or:

Click the analyse database button.
TagsNo tags attached.
Complete LimeSurvey version number (& build)121121
I will donate to the project if issue is resolvedNo
Browserany
Database & DB-VersionmySQL 5.0.22
Operating System (Server)Red Hat
Webserver software & versionApache/2.2.3
PHP Version5.1.6

Activities

limalemon

limalemon

2012-11-26 16:10

reporter  

CDbException.html.zip (5,259 bytes)
mdekker

mdekker

2012-11-26 16:17

developer   ~22542

Could you please attach the error for check integrity (database)?
mdekker

mdekker

2012-11-26 16:19

developer   ~22543

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

mdekker

2012-11-26 16:19

developer   ~22544

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

mdekker

2012-11-26 16:20

developer   ~22545

Unable to test but partial fix (only for runtime) committed.
limalemon

limalemon

2012-11-26 20:11

reporter  

CDbException-checkintegrity.html.zip (6,052 bytes)
limalemon

limalemon

2012-11-26 20:11

reporter   ~22551

The error for the check integrity is the file that I just uploaded
mdekker

mdekker

2012-11-26 21:31

developer   ~22555

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

mdekker

2012-11-26 21:32

developer   ~22556

can you check using the last file for checkintegrity.php?
mdekker

mdekker

2012-11-27 09:27

developer   ~22596

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

mdekker

2012-11-28 14:01

developer   ~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

c_schmitz

2012-12-04 13:16

administrator   ~22875

LimeSurvey 2.0+ build 121204 released.

Related Changesets

LimeSurvey: master e1079848

2012-11-26 15:19:15

mdekker

Details Diff
Fixed 06961: CDbException unbuffered queries active when accessing survey or db analysis
mod - application/controllers/survey/index.php Diff File
mod - application/helpers/database_helper.php Diff File

LimeSurvey: 2.1 8acdca10

2012-11-26 15:19:35

mdekker

Details Diff
Fixed 06961: CDbException unbuffered queries active when accessing survey or db analysis
mod - application/controllers/survey/index.php Diff File
mod - application/helpers/database_helper.php Diff File

LimeSurvey: master 160c5d25

2012-11-26 20:31:06

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?
mod - application/controllers/admin/checkintegrity.php Diff File

LimeSurvey: 2.1 87bc38c4

2012-11-27 08:26:52

mdekker

Details Diff
Fixed 06961: CDbException unbuffered queries active when accessing survey or db analysis
mod - application/controllers/admin/checkintegrity.php Diff File

Issue History

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)