View Issue Details

This issue affects 1 person(s).
 2
IDProjectCategoryView StatusLast Update
06576Bug reportsInstallationpublic2012-10-07 12:08
Reporteruser21808Assigned Toc_schmitz  
PriorityurgentSeveritycrash 
Status closedResolutionunable to reproduce 
Product Version2.00+ 
Summary06576: MySQL Error "Cannot execute queries while other unbuffered queries are active" after upgrade from 1.92+
Description

I just upgraded from Version 1.92+ Build 120909 following http://docs.limesurvey.org/tiki-index.php?page=Upgrading+from+a+previous+version#The_quick_way_for_minor_version_changes_ (only that I copied uploads/ and config.php into the new Limesurvey directory and then moved the old one out of the way and the new one into place). This is the error I got during the installation script in the "upgrading database" step:

Internal Server Error

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.

My surveys are all shown on the new admin screen but when I check the database integrity the same error occurs. Worst of all, the error is everything one sees when clicking on one of the survey URLs to fill in a questionnaire.

TagsNo tags attached.
Bug heat2
Complete LimeSurvey version number (& build)120920
I will donate to the project if issue is resolvedYes
Browser
Database type & versionMySQL Ver 14.12 Distrib 5.0.32
Server OS (if known)Linux 2.6.18-6
Webserver software & version (if known)lighttpd 1.4.29
PHP VersionPHP 5.2.0-8+etch16
Git branch / Pull Request URL

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2012-09-24 11:07

administrator   ~20772

I will need the original database (the one you upgrade from) to debug this. Can you send it to (email address removed), please?

c_schmitz

c_schmitz

2012-09-27 08:50

administrator   ~20836

Pretty please?

c_schmitz

c_schmitz

2012-10-07 12:08

administrator   ~21103

Closed due to missing feedback.

Issue History

Date Modified Username Field Change
2012-09-21 13:36 user21808 New Issue
2012-09-24 11:07 c_schmitz Note Added: 20772
2012-09-24 11:07 c_schmitz Assigned To => c_schmitz
2012-09-24 11:07 c_schmitz Status new => feedback
2012-09-27 08:50 c_schmitz Note Added: 20836
2012-10-07 12:08 c_schmitz Note Added: 21103
2012-10-07 12:08 c_schmitz Status feedback => closed
2012-10-07 12:08 c_schmitz Resolution open => unable to reproduce