View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 09633 | Bug reports | Survey editing | public | 2015-05-14 11:58 | 2015-05-20 11:11 |
| Reporter | Mulder1 | Assigned To | c_schmitz | ||
| Priority | normal | Severity | minor | ||
| Status | closed | Resolution | fixed | ||
| Product Version | 2.05+ | ||||
| Fixed in Version | 2.05+ | ||||
| Summary | 09633: Error when you insert more than 1 subquestion in a question type 'Multiple choice' multilingual | ||||
| Description | When you insert more than 1 subquestion in a question type 'Multiple choice' multilingual a error appears. If you insert only 1 question the error doesn't appear. If you had already 1 question and you add a second or more subquestions the error appears. It seems that is because the system tries to insert a value in an autonumeric field. Error: CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot insert explicit value for identity column in table 'lime_questions' when IDENTITY_INSERT is set to OFF.. The SQL statement executed was: INSERT INTO [dbo].[lime_questions] ([parent_qid], [sid], [gid], [type], [title], [other], [scale_id], [same_default], [qid], [question_order], [question], [language]) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7, :yp8, :yp9, :yp10, :yp11). Bound with :yp0=30830, :yp1=355747, :yp2=1051, :yp3='T', :yp4='SQ002', :yp5='N', :yp6=0, :yp7=0, :yp8=30833, :yp9=2, :yp10='', :yp11='ca' Note: Our base language for the survey is spanish (es), the second is catalan (ca) | ||||
| Steps To Reproduce |
| ||||
| Tags | No tags attached. | ||||
| Attached Files | |||||
| Bug heat | 2 | ||||
| Complete LimeSurvey version number (& build) | Build 150310 | ||||
| I will donate to the project if issue is resolved | No | ||||
| Browser | All (Explorer, Chome, Firefox) | ||||
| Database type & version | Microsoft SQL Server 2008 | ||||
| Server OS (if known) | Windows Server 2008 R2 Enterprise | ||||
| Webserver software & version (if known) | Internet Information Services (Version 7.5.7600.16385) | ||||
| PHP Version | PHP 5.3.23 | ||||
|
Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=15183 |
|
|
Fix committed to 2.06 branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=15184 |
|
|
Version 2.05+ Build 150520 released. |
|
|
LimeSurvey: master 4fae5d05 2015-05-17 20:09 Details Diff |
Fixed issue 09633: Error when you insert subquestions in a multilingual survey on MSSQL |
Affected Issues 09633 |
|
| mod - application/controllers/admin/database.php | Diff File | ||
|
LimeSurvey: 2.06 84380d92 2015-05-17 20:09 Details Diff |
Fixed issue 09633: Error when you insert subquestions in a multilingual survey on MSSQL |
Affected Issues 09633 |
|
| mod - application/controllers/admin/database.php | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2015-05-14 11:58 | Mulder1 | New Issue | |
| 2015-05-14 11:58 | Mulder1 | File Added: limesurvey_survey_355747.lss | |
| 2015-05-17 19:40 | c_schmitz | Assigned To | => c_schmitz |
| 2015-05-17 19:40 | c_schmitz | Status | new => assigned |
| 2015-05-17 20:10 | c_schmitz | Changeset attached | => LimeSurvey master 4fae5d05 |
| 2015-05-17 20:10 | c_schmitz | Note Added: 32212 | |
| 2015-05-17 20:10 | c_schmitz | Resolution | open => fixed |
| 2015-05-17 20:11 | c_schmitz | Changeset attached | => LimeSurvey 2.06 84380d92 |
| 2015-05-17 20:11 | c_schmitz | Note Added: 32213 | |
| 2015-05-18 14:58 | c_schmitz | Status | assigned => resolved |
| 2015-05-18 14:58 | c_schmitz | Fixed in Version | => 2.05+ |
| 2015-05-20 11:11 | c_schmitz | Note Added: 32239 | |
| 2015-05-20 11:11 | c_schmitz | Status | resolved => closed |
| 2019-11-01 17:25 | c_schmitz | Category | Survey design => Survey editing |