Willkommen, Gast
Benutzername: Passwort: Angemeldet bleiben:

THEMA: Error in tokens CSV archive

Error in tokens CSV archive 7 Monate 8 Stunden her #99972

  • soyvik
  • soyviks Avatar
  • OFFLINE
  • Fresh Lemon
  • Beiträge: 19
  • Dank erhalten: 1
  • Karma: 0
Hello
I have recently made an upgrade to Limesurvey 2.00+ (build 130913) and I am experiencing an error when I try to export the tokens to a CSV archive.
I do the export as I have always made it and I get a file. However, when I open that file, it has the 32 first lines correct (with the correct information of my tokens) but from the 33th line I get the following text:

<!DOCTYPE html PUBLIC
"-//W3C//DTD XHTML 1.0 Transitional//EN""
"www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"">
<html xmlns="www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html
<title>Internal Server Error</title>
<style type="text/css">
/*<![CDATA[*/
body {font-family:"Verdana"
h1 { font-family:"Verdana"
h2 { font-family:"Verdana"
h3 {font-family:"Verdana"
p {font-family:"Verdana"
.version {color: gray
/*]]>*/
</style>
</head>
<body>
<h1>Internal Server Error</h1>
<h2>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.</h2>
<p>
An internal error occurred while the Web server was processing your request.
Please contact the webmaster to report this problem.
</p>
<p>
Thank you.
</p>
<div class="version">
2013-09-20 09:47:06 </div>
</body>
</html>


Does anyone know what is happening? How can I fix it?
Thank you
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Error in tokens CSV archive 7 Monate 8 Stunden her #99976

  • DenisChenu
  • DenisChenus Avatar
  • OFFLINE
  • Moderator Lime
  • Beiträge: 5854
  • Dank erhalten: 716
  • Karma: 222
Hi,

Did you use the last version AND the last build? Carsten put a lot of fix for this.

If yes : please fill a bug report
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Error in tokens CSV archive 7 Monate 6 Stunden her #99984

  • soyvik
  • soyviks Avatar
  • OFFLINE
  • Fresh Lemon
  • Beiträge: 19
  • Dank erhalten: 1
  • Karma: 0
Yes, as I said, I have installed the last build (build 130913).
We have fixed the problem by adding the following text:

$pdo->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, true);

in the line 436 of the file: limesurvey/framework/core/CDbconnection.php

The problem seems to be related to the release of MySql, so this solution could not be useful for everyone.
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Error in tokens CSV archive 6 Monate 4 Wochen her #100000

  • DenisChenu
  • DenisChenus Avatar
  • OFFLINE
  • Moderator Lime
  • Beiträge: 5854
  • Dank erhalten: 716
  • Karma: 222
soyvik schrieb:
Yes, as I said, I have installed the last build (build 130913).
We have fixed the problem by adding the following text:

$pdo->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, true);

in the line 436 of the file: limesurvey/framework/core/CDbconnection.php

The problem seems to be related to the release of MySql, so this solution could not be useful for everyone.
Please: can you post a bug report ?
It can be fixed in next release for all user.

Denis
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Error in tokens CSV archive 6 Monate 4 Wochen her #100032

  • soyvik
  • soyviks Avatar
  • OFFLINE
  • Fresh Lemon
  • Beiträge: 19
  • Dank erhalten: 1
  • Karma: 0
Where should I post the bug?
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Error in tokens CSV archive 6 Monate 3 Wochen her #100072

  • DenisChenu
  • DenisChenus Avatar
  • OFFLINE
  • Moderator Lime
  • Beiträge: 5854
  • Dank erhalten: 716
  • Karma: 222
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Error in tokens CSV archive 6 Monate 3 Wochen her #100154

  • soyvik
  • soyviks Avatar
  • OFFLINE
  • Fresh Lemon
  • Beiträge: 19
  • Dank erhalten: 1
  • Karma: 0
Done!
Der Administrator hat öffentliche Schreibrechte deaktiviert.
Folgende Benutzer bedankten sich: DenisChenu
Moderatoren: ITEd
Ladezeit der Seite: 0.151 Sekunden
Donation Image