View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 6
IDProjectCategoryView StatusDate SubmittedLast Update
06963Bug reportsSurvey participants (Tokens)public2012-11-26 17:272012-12-04 13:16
Reporterlimalemon Assigned Tomdekker  
PriorityhighSeverityblock 
Status closedResolutionfixed 
Product Version2.00+ 
Fixed in Version2.00+ 
Summary06963: error 2014 (unbuffered queries) after submiting survey
Description

Applied patch http://bugs.limesurvey.org/view.php?id=6961 and after filling the survey I got the following error:

Error executing query in dbExecuteAssoc: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 SQL statement executed was: UPDATE lime_tokens_234391 SET usesleft=usesleft-1, completed='2012-11-26 17:08' WHERE token='12345'

Steps To Reproduce

Fill the survey (token based).

Submit the survey.

TagsNo tags attached.
Bug heat6
Complete LimeSurvey version number (& build)121121
I will donate to the project if issue is resolvedNo
Browserany
Database type & versionmySQL 5.0.22
Server OS (if known)Red Hat
Webserver software & version (if known)Apache/2.2.3
PHP Version5.1.6

Users monitoring this issue

There are no users monitoring this issue.

Activities

mdekker

mdekker

2012-11-26 18:57

reporter   ~22548

could you please attach a full error log to this report too? it helps us debug as we are not able to reproduce this error due to different configuration
limalemon

limalemon

2012-11-26 20:04

reporter   ~22550

That error in the description is the only error I had, I have no other information other than that.
mdekker

mdekker

2012-11-27 09:31

reporter   ~22598

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

mdekker

2012-11-27 09:43

reporter   ~22601

Please check the file from master (the last one) to see if it fixes your problem.

http://github.com/LimeSurvey/LimeSurvey/tree/6f1dbce53fe4841e4eb6947e7a31760a6011a1b2/application/helpers/frontend_helper.php
c_schmitz

c_schmitz

2012-12-04 13:16

administrator   ~22874

LimeSurvey 2.0+ build 121204 released.

Related Changesets

LimeSurvey: 2.1 7880f377

2012-11-27 08:29:52

mdekker

Details Diff 		Fixed 06963: error 2014 (unbuffered queries) after submiting survey Affected Issues
06963
mod - application/helpers/frontend_helper.php Diff File

LimeSurvey: master 6f1dbce5

2012-11-27 08:42:00

mdekker

Details Diff 		6963: error 2014 (unbuffered queries) after submiting survey Affected Issues
06963
mod - application/helpers/frontend_helper.php Diff File

Issue History

Date Modified Username Field Change
2012-11-26 17:27 limalemon New Issue
2012-11-26 18:56 mdekker Assigned To => mdekker
2012-11-26 18:56 mdekker Status new => assigned
2012-11-26 18:57 mdekker Note Added: 22548
2012-11-26 20:04 limalemon Note Added: 22550
2012-11-27 09:31 mdekker Changeset attached => LimeSurvey 2.1 7880f377
2012-11-27 09:31 mdekker Note Added: 22598
2012-11-27 09:31 mdekker Resolution open => fixed
2012-11-27 09:42 mdekker Changeset attached => LimeSurvey master 6f1dbce5
2012-11-27 09:43 mdekker Note Added: 22601
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: 22874
2012-12-04 13:16 c_schmitz Status resolved => closed
2016-12-08 10:39 c_schmitz Category Tokens => Survey participants (Tokens)