View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
08844Bug reportsImport/Exportpublic2014-03-12 11:032014-03-20 14:52
Reporterbillboule Assigned Toc_schmitz  
PrioritynormalSeverityminor 
Status closedResolutionfixed 
Product Version2.05+ 
Fixed in Version2.05+ 
Summary08844: double import of the same question produce an error
Description

imagine you want 2 questions similar to toto.lsq

import toto.lsq
import toto.lsq (again... instead of copying the question)

you get an SQL error

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)Version 2.05+ Build 140302
I will donate to the project if issue is resolvedNo
Browser
Database type & version?
Server OS (if known)unix
Webserver software & version (if known)?
PHP Version?

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2014-03-19 09:21

administrator   ~29371

Please attach the .lsq file in question. Which error do you get exactly?

billboule

billboule

2014-03-19 09:29

reporter   ~29374

works with every question here

Internal Server Error
CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0-A1-en-0' for key 'PRIMARY'
c_schmitz

c_schmitz

2014-03-19 17:55

administrator   ~29422

Applied a fix - basic problem is that the question could not be imported for the following reasons:

Question codes must be unique.
Question codes must start with a letter and may only contain alphanumeric characters.

If you want to copy a question rather use the 'Copy question' icon.
c_schmitz

c_schmitz

2014-03-19 17:56

administrator   ~29423

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

c_schmitz

2014-03-20 14:52

administrator   ~29447

2.05+ Build 140320 released

Related Changesets

LimeSurvey: master 7f527098

2014-03-19 17:56

c_schmitz


Details Diff		 Fixed issue 08844: Double import of the same question produce a fatal error Affected Issues
08844
mod - application/helpers/admin/import_helper.php Diff File

Issue History

Date Modified Username Field Change
2014-03-12 11:03 billboule New Issue
2014-03-19 09:21 c_schmitz Note Added: 29371
2014-03-19 09:21 c_schmitz Assigned To => c_schmitz
2014-03-19 09:21 c_schmitz Status new => feedback
2014-03-19 09:22 c_schmitz Severity feature => minor
2014-03-19 09:29 billboule Note Added: 29374
2014-03-19 09:29 billboule Status feedback => assigned
2014-03-19 17:55 c_schmitz Note Added: 29422
2014-03-19 17:56 c_schmitz Changeset attached => LimeSurvey master 7f527098
2014-03-19 17:56 c_schmitz Note Added: 29423
2014-03-19 17:56 c_schmitz Resolution open => fixed
2014-03-19 17:56 c_schmitz Status assigned => resolved
2014-03-19 17:56 c_schmitz Fixed in Version => 2.05+
2014-03-20 14:52 c_schmitz Note Added: 29447
2014-03-20 14:52 c_schmitz Status resolved => closed