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 |