View Issue Details

Jump to NotesJump to History
This issue affects 1 person(s).
 6
IDProjectCategoryView StatusDate SubmittedLast Update
08192Bug reportsImport/Exportpublic2013-09-26 10:382013-11-07 12:12
Reportersoyvik Assigned Toc_schmitz  
PrioritynormalSeverityminor 
Status closedResolutionunable to reproduce 
Summary08192: Error in tokens CSV archive
Description

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>


An internal error occurred while the Web server was processing your request.
Please contact the webmaster to report this problem.



Thank you.


<div class="version">
2013-09-20 09:47:06 </div>
</body>
</html>

Additional Information

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.

TagsNo tags attached.
Bug heat6
Complete LimeSurvey version number (& build)
I will donate to the project if issue is resolved
Browser
Database type & version
Server OS (if known)
Webserver software & version (if known)
PHP Version
Git branch / Pull Request URL

Users monitoring this issue

There are no users monitoring this issue.

Activities

DenisChenu

DenisChenu

2013-10-03 14:39

developer   ~26502

Please build number
c_schmitz

c_schmitz

2013-10-11 21:34

administrator   ~26749

What build number and version did this affect?
c_schmitz

c_schmitz

2013-10-21 08:41

administrator   ~26860

Feedback please?
soyvik

soyvik

2013-10-24 08:55

reporter   ~26976

As it is said in the description it is Limesurvey 2.00+ (build 130913).
c_schmitz

c_schmitz

2013-10-24 10:10

administrator   ~26978

Please activate debug mode in /application/config/config.php and you should get a more detailed error now. Please attach the resulting html file to this bug report. Thank you!
c_schmitz

c_schmitz

2013-10-29 22:40

administrator   ~27020

Feedback please?
c_schmitz

c_schmitz

2013-11-07 12:12

administrator   ~27110

Closed due to missing feedback.

Issue History

Date Modified Username Field Change
2013-09-26 10:38 soyvik New Issue
2013-10-03 14:39 DenisChenu Project Feature requests => Bug reports
2013-10-03 14:39 DenisChenu Note Added: 26502
2013-10-11 21:34 c_schmitz Note Added: 26749
2013-10-11 21:34 c_schmitz Assigned To => c_schmitz
2013-10-11 21:34 c_schmitz Status new => feedback
2013-10-21 08:41 c_schmitz Note Added: 26860
2013-10-24 08:55 soyvik Note Added: 26976
2013-10-24 08:55 soyvik Status feedback => assigned
2013-10-24 10:10 c_schmitz Note Added: 26978
2013-10-24 10:10 c_schmitz Status assigned => feedback
2013-10-29 22:40 c_schmitz Note Added: 27020
2013-11-07 12:12 c_schmitz Note Added: 27110
2013-11-07 12:12 c_schmitz Status feedback => closed
2013-11-07 12:12 c_schmitz Resolution open => unable to reproduce