CDbException when accessing survey

More
5 years 2 weeks ago - 5 years 2 weeks ago #89083 by limalemon
limalemon created the topic: CDbException when accessing survey
I'm using the latest version: Version 2.00+ Build 121121

And 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 server is: Apache/2.2.3 (Red Hat) DAV/2 PHP/5.1.6 Yii Framework/1.1.10

How can I solve this?

Thank you in advance.
Attachments:
Last Edit: 5 years 2 weeks ago by limalemon. Reason: the attachement didn't stick

Please Log in to join the conversation.

More
5 years 2 weeks ago #89087 by mdekker
mdekker replied the topic: CDbException when accessing survey
Could you please enter a report in our Bugtracker? Post back a link to the bugreport here for reference.

---
Menno Dekker

Please Log in to join the conversation.

More
5 years 2 weeks ago #89101 by limalemon
limalemon replied the topic: CDbException when accessing survey

Please Log in to join the conversation.

More
5 years 2 weeks ago #89123 by limalemon
limalemon replied the topic: CDbException when accessing survey
This seems to happen in several more places, I don't know if I need to report each in the bug tracker, I think that it needs to be sorted in a global way (if possible).

It happened in the survey access, check integrity, browse responses statistics and I fear it may happen in other places...

I read that a way to fix this is to activate the "BUFFERED_QUERY" flag at the queries that use the PDO (and cursor) to get results from mySQL: ilia.ws/archives/53-PDO_MySQL-Buffered-Query-Support.html

Please Log in to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now
Join our Newsletter!