View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
09134 | Bug reports | Other | public | 2014-07-07 11:34 | 2014-07-23 17:25 |
Reporter | aesteban | Assigned To | DenisChenu | ||
Priority | normal | Severity | partial_block | ||
Status | closed | Resolution | fixed | ||
Product Version | 2.05+ | ||||
Fixed in Version | 2.05+ | ||||
Summary | 09134: Database error when trying to reload survey data | ||||
Description | Database error when trying to reload survey data. This limesurvey instance has just been upgraded from version 2.00+ to 2.05+ | ||||
Steps To Reproduce | 1.- Fill out partially a survey Internal Server Error An internal error occurred while the Web server was processing your request. Please contact the webmaster to report this problem. Thank you. | ||||
Additional Information | IMPORTANT: This limesurvey instance has just been upgraded from version 2.00+ to 2.05+. SQL structure upgrade was successfully executed after first login. | ||||
Tags | No tags attached. | ||||
Attached Files | |||||
Bug heat | 22 | ||||
Complete LimeSurvey version number (& build) | 140703 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | Chromium | ||||
Database type & version | Mysql 5.1 | ||||
Server OS (if known) | RHEL 6.5 | ||||
Webserver software & version (if known) | Apache 2.2.15 | ||||
PHP Version | php 5.3.3 | ||||
has duplicate | 09144 | closed | DenisChenu | Loading unfinished survey is not possible |
Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=14323 |
|
@Carsten : can you test with mssql ? Without CAST if possible. |
|
Hey DenisChenu. I am facing a similar issue to this. I get the same error except for the last line - I get: AND lime_saved_control.access_code = 'b1f4f9a523e36fd969f4573e25af4540'' at line 5 I am using Lime Survey Version 2.05+ Build 140703 From the Issue History it looks like the issue is fixed in 2.05+. Is it a case of waiting for 2.06 or it should be in 2.05 and I have something else a miss. Thank you heaps in advance. Dean |
|
Hi, resolved : fixed in GIT version, but last release don't have the fix. Then you can : apply same fix in the actual release or download the last GIT version and update all files. |
|
Hi, !!! After the update (I downloaded and copyed both files) it's impossible to pass to the second page of the survey. ^_^ Solved overwriting the original files with the GitHub Files. !!! After the second update the program doesn't load partyally answered pages. I'm using limesurvey 2.05+ build 140703 Thank you in advance. Antonio. |
|
2.05+ Build 140717 released |
|
LimeSurvey: master e86b028c 2014-07-09 17:17 Details Diff |
Fixed issue 09134: Database error when trying to reload survey data Dev: just using Yii Dev: Think mssql with Yii don't need CAST |
Affected Issues 09134 |
|
mod - application/controllers/survey/index.php | Diff File | ||
mod - application/helpers/frontend_helper.php | Diff File |
Date Modified | Username | Field | Change |
---|---|---|---|
2014-07-07 11:34 | aesteban | New Issue | |
2014-07-07 11:34 | aesteban | File Added: survey_archive_961684.lsa | |
2014-07-07 11:35 | aesteban | Issue Monitored: aesteban | |
2014-07-07 19:05 | DenisChenu | Assigned To | => DenisChenu |
2014-07-07 19:05 | DenisChenu | Status | new => assigned |
2014-07-09 14:50 | stevelegare | Issue Monitored: stevelegare | |
2014-07-09 17:18 | DenisChenu | Changeset attached | => LimeSurvey master e86b028c |
2014-07-09 17:18 | DenisChenu | Note Added: 30282 | |
2014-07-09 17:18 | DenisChenu | Resolution | open => fixed |
2014-07-09 17:18 | DenisChenu | Status | assigned => resolved |
2014-07-09 17:18 | DenisChenu | Fixed in Version | => 2.05+ |
2014-07-09 17:18 | DenisChenu | Note Added: 30283 | |
2014-07-15 08:50 | MOQ | Note Added: 30296 | |
2014-07-15 13:45 | DenisChenu | Note Added: 30297 | |
2014-07-15 16:06 | DenisChenu | Relationship added | has duplicate 09144 |
2014-07-15 16:19 | cosimop | Issue Monitored: cosimop | |
2014-07-17 14:19 |
|
Note Added: 30313 | |
2014-07-23 17:25 | c_schmitz | Note Added: 30324 | |
2014-07-23 17:25 | c_schmitz | Status | resolved => closed |
2021-08-02 23:38 | guest | Bug heat | 14 => 22 |