Bienvenue, Invité
Nom d'utilisateur : Mot de passe : Se souvenir de moi

SUJET : CDbException when accessing survey

CDbException when accessing survey il y a 1 an 8 mois #89083

  • limalemon
  • Portrait de limalemon
  • Hors ligne
  • Fresh Lemon
  • Messages : 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.
Pièces jointes :
Dernière édition: il y a 1 an 8 mois par limalemon. Raison: the attachement didn't stick
L'administrateur a désactivé l'accès en écriture pour le public.

Re: CDbException when accessing survey il y a 1 an 8 mois #89087

  • mdekker
  • Portrait de mdekker
  • Hors ligne
  • LimeSurvey Team
  • Messages : 341
  • Remerciements reçus 68
  • Karma: 38
Could you please enter a report in our bugtracker? Post back a link to the bugreport here for reference.
---
Menno Dekker
L'administrateur a désactivé l'accès en écriture pour le public.

Re: CDbException when accessing survey il y a 1 an 8 mois #89101

  • limalemon
  • Portrait de limalemon
  • Hors ligne
  • Fresh Lemon
  • Messages : 10
  • Karma: 0
L'administrateur a désactivé l'accès en écriture pour le public.

Re: CDbException when accessing survey il y a 1 an 8 mois #89123

  • limalemon
  • Portrait de limalemon
  • Hors ligne
  • Fresh Lemon
  • Messages : 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
L'administrateur a désactivé l'accès en écriture pour le public.
Modérateurs: ITEd
Temps de génération de la page : 0.226 secondes
Donation Image