Willkommen, Gast
Benutzername: Passwort: Angemeldet bleiben:

THEMA: CDbException when accessing survey

CDbException when accessing survey 1 Jahr 11 Monate her #89083

  • limalemon
  • limalemons Avatar
  • OFFLINE
  • Fresh Lemon
  • Beiträge: 10
  • Karma: 0
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.
Anhang:
Letzte Änderung: 1 Jahr 11 Monate her von limalemon. Begründung: the attachement didn't stick
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Re: CDbException when accessing survey 1 Jahr 11 Monate her #89087

  • mdekker
  • mdekkers Avatar
  • OFFLINE
  • LimeSurvey Team
  • Beiträge: 341
  • Dank erhalten: 68
  • Karma: 38
Could you please enter a report in our bugtracker? Post back a link to the bugreport here for reference.
---
Menno Dekker
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Re: CDbException when accessing survey 1 Jahr 11 Monate her #89101

  • limalemon
  • limalemons Avatar
  • OFFLINE
  • Fresh Lemon
  • Beiträge: 10
  • Karma: 0
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Re: CDbException when accessing survey 1 Jahr 11 Monate her #89123

  • limalemon
  • limalemons Avatar
  • OFFLINE
  • Fresh Lemon
  • Beiträge: 10
  • Karma: 0
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
Der Administrator hat öffentliche Schreibrechte deaktiviert.
Moderatoren: ITEd
Ladezeit der Seite: 0.175 Sekunden
Donation Image