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 |