Welcome, Guest
Username: Password: Remember me

TOPIC: query buffer issue when testing a survey

query buffer issue when testing a survey 1 year 9 months ago #90586

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.
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.085 seconds
Donation Image