query buffer issue when testing a survey

More
4 years 6 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.

Did you already participate in our customer survey?

Don't miss your chance for great prices.

Please click here to participate:

Start now

Start now!

Just create your account and start using Limesurvey today.

Register now