View Issue Details

This bug affects 1 person(s).
 2
IDProjectCategoryView StatusLast Update
09633Bug reportsSurvey editingpublic2015-05-20 11:11
ReporterMulder1 Assigned Toc_schmitz  
PrioritynormalSeverityminor 
Status closedResolutionfixed 
Product Version2.05+ 
Fixed in Version2.05+ 
Summary09633: 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
  1. Create a survey
  2. Create a group
  3. Create a question of type 'Multiple choice'
  4. Add more than 1 questions and save them. The error appears.
TagsNo tags attached.
Attached Files
Bug heat2
Complete LimeSurvey version number (& build)Build 150310
I will donate to the project if issue is resolvedNo
BrowserAll (Explorer, Chome, Firefox)
Database type & versionMicrosoft 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 VersionPHP 5.3.23

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2015-05-17 20:10

administrator   ~32212

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=15183

c_schmitz

c_schmitz

2015-05-17 20:11

administrator   ~32213

Fix committed to 2.06 branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=15184

c_schmitz

c_schmitz

2015-05-20 11:11

administrator   ~32239

Version 2.05+ Build 150520 released.

Related Changesets

LimeSurvey: master 4fae5d05

2015-05-17 18:09:13

c_schmitz

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 18:09:13

c_schmitz

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

Issue History

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