View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 6
IDProjectCategoryView StatusDate SubmittedLast Update
04649Bug reportsImport/Exportpublic2010-10-05 10:592010-10-13 16:22
Reporterppuls Assigned Toc_schmitz  
PrioritynormalSeveritypartial_block 
Status closedResolutionfixed 
Product Version1.90+ 
Fixed in Version1.90+ 
Summary04649: Survey migration from 1.85+ (7523) to 1.90+ Build 9160
Description

If a survey has defined a default value in the answers table ("Y") of the 1.85+ survey, they can not be exported and reimported into 1.90+ without information loss. this seems to be the case, because in 1.90+ there is a separate default value table, that did not exist in the older version. there every answer could have been a default just by changing the "N" to a "Y" in the appropriate posistion.

Steps To Reproduce
  • Define a Survey in LS1.85+ with a question (radio button) that allows you to set an answer as default
  • Set at least one answer as default
  • export as csv
  • import this csv into LS1.90+
    ->Errror:

Error: Failed to insert defaultvalue
INSERT INTO ls3_defaultvalues ( QID, LANGUAGE, DEFAULTVALUE ) VALUES ( null, 'en', 'Whatever' )
Column 'qid' cannot be null

Additional Information

if i change the "Y" to "N" manually in the csv and import the same file, all goes well.

TagsNo tags attached.
Attached Files
limesurvey_survey_28579.csv (7,753 bytes)
Bug heat6
Complete LimeSurvey version number (& build)9160
I will donate to the project if issue is resolved
BrowserSafari Version 5.0.2 (5533.18.5)
Database type & versionMySQL - 5.0.45
Server OS (if known)(Linux/SUSE)
Webserver software & version (if known)Apache/2.2.4
PHP Version5.9.2

Users monitoring this issue

ppuls

Activities

c_schmitz

c_schmitz

2010-10-05 23:13

administrator   ~13007

Can you please attach the sample survey that create this problems?
ppuls

ppuls

2010-10-07 10:33

reporter   ~13021

HI!
i uploaded an export file, but due to NDA restrictions i had to neutralize it. so every question says "text" now. and i have shortened it to the important part, as i did't want to put "text" in every line and didn't want you to have to work through irrelevant lines of code. hope this helps.
cheers,

phil
c_schmitz

c_schmitz

2010-10-08 17:06

administrator   ~13046

Fixed in rev 9191
ppuls

ppuls

2010-10-11 16:53

reporter   ~13072

looking forward to the new release!

thx! keep up thespirit, you are amazing!

cheers,

Philipp
c_schmitz

c_schmitz

2010-10-13 16:22

administrator   ~13120

Released in latest Plus version

Issue History

Date Modified Username Field Change
2010-10-05 10:59 ppuls New Issue
2010-10-05 11:00 ppuls Issue Monitored: ppuls
2010-10-05 23:13 c_schmitz Note Added: 13007
2010-10-05 23:13 c_schmitz Assigned To => c_schmitz
2010-10-05 23:13 c_schmitz Status new => feedback
2010-10-07 10:31 ppuls File Added: limesurvey_survey_28579.csv
2010-10-07 10:33 ppuls Note Added: 13021
2010-10-07 10:33 ppuls Status feedback => assigned
2010-10-08 17:06 c_schmitz Note Added: 13046
2010-10-08 17:06 c_schmitz Status assigned => resolved
2010-10-08 17:06 c_schmitz Fixed in Version => 1.90+
2010-10-08 17:06 c_schmitz Resolution open => fixed
2010-10-11 16:53 ppuls Note Added: 13072
2010-10-13 16:22 c_schmitz Note Added: 13120
2010-10-13 16:22 c_schmitz Status resolved => closed
2021-08-03 17:49 guest Bug heat 4 => 6