CDbException when accessing survey

More
4 years 4 months ago - 4 years 4 months ago #89083 by limalemon
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: 4 years 4 months ago by limalemon. Reason: the attachement didn't stick

Please Log in to join the conversation.

More
4 years 4 months ago #89087 by mdekker
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
4 years 4 months ago #89101 by limalemon

Please Log in to join the conversation.

More
4 years 4 months ago #89123 by limalemon
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.