View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 06576 | Bug reports | Installation | public | 2012-09-21 13:36 | 2012-10-07 12:08 |
| Reporter | Assigned To | c_schmitz | |||
| Priority | urgent | Severity | crash | ||
| Status | closed | Resolution | unable to reproduce | ||
| Product Version | 2.00+ | ||||
| Summary | 06576: 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. | ||||
| Tags | No tags attached. | ||||
| Bug heat | 2 | ||||
| Complete LimeSurvey version number (& build) | 120920 | ||||
| I will donate to the project if issue is resolved | Yes | ||||
| Browser | |||||
| Database type & version | MySQL 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 Version | PHP 5.2.0-8+etch16 | ||||
| Git branch / Pull Request URL | |||||
|
I will need the original database (the one you upgrade from) to debug this. Can you send it to (email address removed), please? |
|
|
Pretty please? |
|
|
Closed due to missing feedback. |
|
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2012-09-21 13:36 |
|
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 |