Error in tokens CSV archive

Mehr
4 Jahre 4 Monate her #99972 von soyvik
soyvik erstellte das Thema Error in tokens CSV archive
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

Bitte Anmelden um an der Konversation teilzunehmen.

Mehr
4 Jahre 4 Monate her #99976 von DenisChenu
DenisChenu antwortete auf das Thema: Error in tokens CSV archive
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

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).
An error happen ? Before make a new topic : remind the Debug mode .

Bitte Anmelden um an der Konversation teilzunehmen.

Mehr
4 Jahre 4 Monate her #99984 von soyvik
soyvik antwortete auf das Thema: Error in tokens CSV archive
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.

Bitte Anmelden um an der Konversation teilzunehmen.

Mehr
4 Jahre 4 Monate her #100000 von DenisChenu
DenisChenu antwortete auf das Thema: Error in tokens CSV archive

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

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).
An error happen ? Before make a new topic : remind the Debug mode .

Bitte Anmelden um an der Konversation teilzunehmen.

Mehr
4 Jahre 3 Monate her #100032 von soyvik
soyvik antwortete auf das Thema: Error in tokens CSV archive
Where should I post the bug?

Bitte Anmelden um an der Konversation teilzunehmen.

Mehr
4 Jahre 3 Monate her #100072 von DenisChenu
DenisChenu antwortete auf das Thema: Error in tokens CSV archive

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).
An error happen ? Before make a new topic : remind the Debug mode .

Bitte Anmelden um an der Konversation teilzunehmen.

Mehr
4 Jahre 3 Monate her #100154 von soyvik
soyvik antwortete auf das Thema: Error in tokens CSV archive
Done!
Folgende Benutzer bedankten sich: DenisChenu

Bitte Anmelden um an der Konversation teilzunehmen.

Jetzt loslegen!

Melden Sie sich jetzt an, und erstellen Sie in wenigen Minuten Ihre erste Umfrage.

Account einrichten

Abonnieren Sie unseren Newsletter

Abonnieren Sie unseren Newsletter für alle Neuigkeiten rund um LimeSurvey
captcha