query buffer issue when testing a survey

More
4 years 9 months ago #90586 by scottshipman
scottshipman created the topic: query buffer issue when testing a survey
My dev instance of lime survey runs on MAMP, and works just fine. However, on my CENTOS6.2 version, I get
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: SELECT * FROM questions WHERE qid=2 AND LANGUAGE='en'

I have PHP 5.3.6 in MAMP and on my CENTOS server its php 5.3.3. Both versions are running the latest lime survey code (doing the 3 click update to get the latest).

I get this error when I Execute the Survey from the admin interface (the survey is active). The exact same survey on the dev instance works fine.

I have php-pdo.x86_64 running on the CENTOS server.

Please Log in to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now