View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 10386 | Bug reports | Survey editing | public | 2016-02-11 12:55 | 2016-03-07 11:49 |
| Reporter | catdevrandom | Assigned To | |||
| Priority | normal | Severity | minor | ||
| Status | closed | Resolution | fixed | ||
| Product Version | 2.50.x | ||||
| Fixed in Version | 2.50.x | ||||
| Summary | 10386: Unable to edit text of answer option: SQL error "Integrity constraint violation" | ||||
| Description | After activating a survey, it is not possible to edit the text of the questions anymore via the interface. Trying to do so returns the following error: "Internal Server Error CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '7--en-0' for key 'PRIMARY' An internal error occurred while the Web server was processing your request. Please contact the webmaster to report this problem. Thank you." | ||||
| Steps To Reproduce | Import the attached .lss file. | ||||
| Additional Information | Affects Version 2.50+, at least Builds 160204 and 160210. | ||||
| Tags | No tags attached. | ||||
| Attached Files | |||||
| Bug heat | 4 | ||||
| Complete LimeSurvey version number (& build) | 160210 | ||||
| I will donate to the project if issue is resolved | No | ||||
| Browser | Firefox 43.0.4 | ||||
| Database type & version | MySQL 5.6.25 | ||||
| Server OS (if known) | Ubuntu 12.04.5 LTS Linux 3.1.9-vs2.3.2.5vs2.3.2.5+ SMP x86_64 GNU/Linux | ||||
| Webserver software & version (if known) | Apache 2.2.31-2 | ||||
| PHP Version | 5.6.10 | ||||
 |
Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=17338 |
 |
Version 2.50+ Build 160307 released |
|
LimeSurvey: master a242120e 2016-02-11 17:55:35
|
Fixed issue 10386: possible again to to edit text of answer option in active survey |
Affected Issues 10386 |
|
| mod - application/controllers/survey/index.php | Diff File | ||
| mod - application/helpers/SurveyRuntimeHelper.php | Diff File | ||
| mod - application/models/Answer.php | Diff File | ||
| mod - application/views/admin/survey/Question/answerOptions_view.php | Diff File | ||
| mod - templates/default/scripts/template.js | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2016-02-11 12:55 | catdevrandom | New Issue | |
| 2016-02-11 12:55 | catdevrandom | File Added: limesurvey_survey_224171.lss | |
| 2016-02-11 15:49 | ollehar | Assigned To | => ollehar |
| 2016-02-11 15:49 | ollehar | Status | new => assigned |
| 2016-02-11 17:06 | ollehar | Assigned To | ollehar => LouisGac |
| 2016-02-11 18:55 |
|
Changeset attached | => LimeSurvey master a242120e |
| 2016-02-11 18:55 |
|
Note Added: 34938 | |
| 2016-02-11 18:55 |
|
Resolution | open => fixed |
| 2016-02-11 18:55 |
|
Status | assigned => feedback |
| 2016-03-03 19:28 |
|
Status | feedback => resolved |
| 2016-03-07 11:48 | c_schmitz | Fixed in Version | => 2.5 |
| 2016-03-07 11:49 | c_schmitz | Note Added: 36038 | |
| 2016-03-07 11:49 | c_schmitz | Status | resolved => closed |
| 2019-11-01 17:25 | c_schmitz | Category | Survey design => Survey editing |
