Error in tokens CSV archive

Plus d'informations
il y a 3 ans 10 mois #99972 par soyvik
soyvik a créé le sujet : 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

Connexion pour participer à la conversation.

Plus d'informations
il y a 3 ans 10 mois #99976 par DenisChenu
DenisChenu a répondu au sujet : 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 .

Connexion pour participer à la conversation.

Plus d'informations
il y a 3 ans 10 mois #99984 par soyvik
soyvik a répondu au sujet : 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.

Connexion pour participer à la conversation.

Plus d'informations
il y a 3 ans 10 mois #100000 par DenisChenu
DenisChenu a répondu au sujet : Error in tokens CSV archive

soyvik écrit: 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 .

Connexion pour participer à la conversation.

Plus d'informations
il y a 3 ans 10 mois #100032 par soyvik
soyvik a répondu au sujet : Error in tokens CSV archive
Where should I post the bug?

Connexion pour participer à la conversation.

Plus d'informations
il y a 3 ans 10 mois #100072 par DenisChenu
DenisChenu a répondu au sujet : 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 .

Connexion pour participer à la conversation.

Plus d'informations
il y a 3 ans 9 mois #100154 par soyvik
soyvik a répondu au sujet : Error in tokens CSV archive
Done!
Les utilisateur(s) suivant ont remercié: DenisChenu

Connexion pour participer à la conversation.

Avez-vous déjà participé à notre enquête auprès des clients?

Ne manquez pas votre chance à des prix incroyables.

S'il vous plaît cliquez ici pour participer:

Commencer

Commencez dès maintenant !

Créez simplement un compte et commencez à utiliser LimeSurvey dès aujourd'hui.

Inscrivez-vous maintenant