View Issue Details

This bug affects 1 person(s).
 4
IDProjectCategoryView StatusLast Update
17646Bug reportsImport/Exportpublic2021-11-22 17:10
ReporterGuernseyResearch Assigned Togalads  
PrioritynoneSeveritycrash 
Status assignedResolutionopen 
Product Version5.x 
Summary17646: Cannot import version 3 lsq file in to LS5
DescriptionTrying to take the export of a question from LS3 Version 3.27.19+210928 which is an lsq file
and import it into a new survey on LS5 Version 5.1.14+210927
Sometimes it does the import and them gives an error. Sometimes it just gives the error. Depends on the question type.
500 error is shown in attached
Steps To ReproduceSteps to reproduce
------------------------------
Export a question from LS3, import into LS5

Expected result
-------------------------
question should import

Actual result
-----------------
In some cases it does import, other questions do not, but always it gives a 500 error.

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)Version 5.1.14+210927
I will donate to the project if issue is resolvedNo
BrowserFirefox
Database type & versionmysqlnd 5.0.12-dev
Server OS (if known)
Webserver software & version (if known)Apache HTTP Server 2.4.49
PHP VersionPHP Version 7.3.30

Users monitoring this issue

User List There are no users monitoring this issue.

Activities

GuernseyResearch

GuernseyResearch

2021-10-01 17:45

reporter  

Error on question import.png (31,487 bytes)   
Error on question import.png (31,487 bytes)   
GuernseyResearch

GuernseyResearch

2021-10-01 17:57

reporter   ~66733

More information. If you uncheck the three boxes the import works, but puts the question into the wrong group.
import2.jpg (27,689 bytes)   
import2.jpg (27,689 bytes)   
galads

galads

2021-10-05 17:49

administrator   ~66752

Last edited: 2021-11-22 17:10

I am able to import a question from LS3 into LS5. Can you specify the question type? If possible attach a .lsq file for further testing
GuernseyResearch

GuernseyResearch

2021-10-05 18:06

reporter   ~66753

Last edited: 2021-11-22 17:10

The problem appears with ALL question types. IF you uncheck the boxes the error does not appear and the import works. HOWEVER, it does not put the imported question into the proper group.
limesurvey_question_3989.lsq (13,905 bytes)   
<?xml version="1.0" encoding="UTF-8"?>
<document>
 <LimeSurveyDocType>Question</LimeSurveyDocType>
 <DBVersion>365</DBVersion>
 <languages>
  <language>fr</language>
  <language>de</language>
  <language>ru</language>
  <language>en</language>
 </languages>
 <questions>
  <fields>
   <fieldname>qid</fieldname>
   <fieldname>parent_qid</fieldname>
   <fieldname>sid</fieldname>
   <fieldname>gid</fieldname>
   <fieldname>type</fieldname>
   <fieldname>title</fieldname>
   <fieldname>question</fieldname>
   <fieldname>preg</fieldname>
   <fieldname>help</fieldname>
   <fieldname>other</fieldname>
   <fieldname>mandatory</fieldname>
   <fieldname>question_order</fieldname>
   <fieldname>language</fieldname>
   <fieldname>scale_id</fieldname>
   <fieldname>same_default</fieldname>
   <fieldname>relevance</fieldname>
   <fieldname>modulename</fieldname>
  </fields>
  <rows>
   <row>
    <qid><![CDATA[3989]]></qid>
    <parent_qid><![CDATA[0]]></parent_qid>
    <sid><![CDATA[831819]]></sid>
    <gid><![CDATA[150]]></gid>
    <type><![CDATA[F]]></type>
    <title><![CDATA[Q30]]></title>
    <question><![CDATA[<span style="font-size:18px;">Wie lange dauert üblicherweise die Entscheidung, eine neue Version einer aktuellen VMware-Software zu kaufen?</span>]]></question>
    <preg/>
    <help/>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[Y]]></mandatory>
    <question_order><![CDATA[35]]></question_order>
    <language><![CDATA[de]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
    <modulename/>
   </row>
   <row>
    <qid><![CDATA[3989]]></qid>
    <parent_qid><![CDATA[0]]></parent_qid>
    <sid><![CDATA[831819]]></sid>
    <gid><![CDATA[150]]></gid>
    <type><![CDATA[F]]></type>
    <title><![CDATA[Q30]]></title>
    <question><![CDATA[<span style="font-size:18px;">Typically how long does it take to make a decision to upgrade from one version to another, purchase additional licenses, more CPUs, more users, more capability, additional products?</span>]]></question>
    <preg/>
    <help/>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[Y]]></mandatory>
    <question_order><![CDATA[33]]></question_order>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
    <modulename/>
   </row>
   <row>
    <qid><![CDATA[3989]]></qid>
    <parent_qid><![CDATA[0]]></parent_qid>
    <sid><![CDATA[831819]]></sid>
    <gid><![CDATA[150]]></gid>
    <type><![CDATA[F]]></type>
    <title><![CDATA[Q30]]></title>
    <question><![CDATA[<p><span style="font-size:18px;">En général, combien de temps faut-il pour prendre une décision de mettre à jour la version VMware existante vers une nouvelle version ?</span></p>
]]></question>
    <preg/>
    <help/>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[Y]]></mandatory>
    <question_order><![CDATA[35]]></question_order>
    <language><![CDATA[fr]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
    <modulename/>
   </row>
   <row>
    <qid><![CDATA[3989]]></qid>
    <parent_qid><![CDATA[0]]></parent_qid>
    <sid><![CDATA[831819]]></sid>
    <gid><![CDATA[150]]></gid>
    <type><![CDATA[F]]></type>
    <title><![CDATA[Q30]]></title>
    <question><![CDATA[<span style="font-size:18px;">Насколько быстро обычно происходит процесс принятия решения об существлении модернизации существующего программного обеспечения, покупке дополнительных лицензий, увеличении процессорных мощностей, увеличении количества обслуживаемых пользователей и т.п.?</span>]]></question>
    <preg/>
    <help/>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[Y]]></mandatory>
    <question_order><![CDATA[35]]></question_order>
    <language><![CDATA[ru]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
    <modulename/>
   </row>
  </rows>
 </questions>
 <subquestions>
  <fields>
   <fieldname>qid</fieldname>
   <fieldname>parent_qid</fieldname>
   <fieldname>sid</fieldname>
   <fieldname>gid</fieldname>
   <fieldname>type</fieldname>
   <fieldname>title</fieldname>
   <fieldname>question</fieldname>
   <fieldname>preg</fieldname>
   <fieldname>help</fieldname>
   <fieldname>other</fieldname>
   <fieldname>mandatory</fieldname>
   <fieldname>question_order</fieldname>
   <fieldname>language</fieldname>
   <fieldname>scale_id</fieldname>
   <fieldname>same_default</fieldname>
   <fieldname>relevance</fieldname>
   <fieldname>modulename</fieldname>
  </fields>
  <rows>
   <row>
    <qid><![CDATA[4063]]></qid>
    <parent_qid><![CDATA[3989]]></parent_qid>
    <sid><![CDATA[831819]]></sid>
    <gid><![CDATA[150]]></gid>
    <type><![CDATA[F]]></type>
    <title><![CDATA[N1]]></title>
    <question><![CDATA[Zeit]]></question>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[N]]></mandatory>
    <question_order><![CDATA[1]]></question_order>
    <language><![CDATA[de]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
    <modulename/>
   </row>
   <row>
    <qid><![CDATA[4063]]></qid>
    <parent_qid><![CDATA[3989]]></parent_qid>
    <sid><![CDATA[831819]]></sid>
    <gid><![CDATA[150]]></gid>
    <type><![CDATA[F]]></type>
    <title><![CDATA[N1]]></title>
    <question><![CDATA[Time]]></question>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[N]]></mandatory>
    <question_order><![CDATA[15]]></question_order>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
    <modulename/>
   </row>
   <row>
    <qid><![CDATA[4063]]></qid>
    <parent_qid><![CDATA[3989]]></parent_qid>
    <sid><![CDATA[831819]]></sid>
    <gid><![CDATA[150]]></gid>
    <type><![CDATA[F]]></type>
    <title><![CDATA[N1]]></title>
    <question><![CDATA[Temps]]></question>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[N]]></mandatory>
    <question_order><![CDATA[1]]></question_order>
    <language><![CDATA[fr]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
    <modulename/>
   </row>
   <row>
    <qid><![CDATA[4063]]></qid>
    <parent_qid><![CDATA[3989]]></parent_qid>
    <sid><![CDATA[831819]]></sid>
    <gid><![CDATA[150]]></gid>
    <type><![CDATA[F]]></type>
    <title><![CDATA[N1]]></title>
    <question><![CDATA[Время принятия решения]]></question>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[N]]></mandatory>
    <question_order><![CDATA[1]]></question_order>
    <language><![CDATA[ru]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
    <modulename/>
   </row>
  </rows>
 </subquestions>
 <answers>
  <fields>
   <fieldname>qid</fieldname>
   <fieldname>code</fieldname>
   <fieldname>answer</fieldname>
   <fieldname>sortorder</fieldname>
   <fieldname>assessment_value</fieldname>
   <fieldname>language</fieldname>
   <fieldname>scale_id</fieldname>
  </fields>
  <rows>
   <row>
    <qid><![CDATA[3989]]></qid>
    <code><![CDATA[N1]]></code>
    <answer><![CDATA[Weniger als 3 Monate]]></answer>
    <sortorder><![CDATA[1]]></sortorder>
    <assessment_value><![CDATA[0]]></assessment_value>
    <language><![CDATA[de]]></language>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <qid><![CDATA[3989]]></qid>
    <code><![CDATA[N2]]></code>
    <answer><![CDATA[3 bis 6 Monate]]></answer>
    <sortorder><![CDATA[2]]></sortorder>
    <assessment_value><![CDATA[0]]></assessment_value>
    <language><![CDATA[de]]></language>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <qid><![CDATA[3989]]></qid>
    <code><![CDATA[N3]]></code>
    <answer><![CDATA[6 Monate bis 1 Jahr]]></answer>
    <sortorder><![CDATA[3]]></sortorder>
    <assessment_value><![CDATA[0]]></assessment_value>
    <language><![CDATA[de]]></language>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <qid><![CDATA[3989]]></qid>
    <code><![CDATA[N4]]></code>
    <answer><![CDATA[1 bis 2 Jahre]]></answer>
    <sortorder><![CDATA[4]]></sortorder>
    <assessment_value><![CDATA[0]]></assessment_value>
    <language><![CDATA[de]]></language>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <qid><![CDATA[3989]]></qid>
    <code><![CDATA[N5]]></code>
    <answer><![CDATA[Mehr als 2 Jahre]]></answer>
    <sortorder><![CDATA[5]]></sortorder>
    <assessment_value><![CDATA[0]]></assessment_value>
    <language><![CDATA[de]]></language>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <qid><![CDATA[3989]]></qid>
    <code><![CDATA[N1]]></code>
    <answer><![CDATA[Less than 3 months]]></answer>
    <sortorder><![CDATA[1]]></sortorder>
    <assessment_value><![CDATA[0]]></assessment_value>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <qid><![CDATA[3989]]></qid>
    <code><![CDATA[N2]]></code>
    <answer><![CDATA[3 months to six months]]></answer>
    <sortorder><![CDATA[2]]></sortorder>
    <assessment_value><![CDATA[0]]></assessment_value>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <qid><![CDATA[3989]]></qid>
    <code><![CDATA[N3]]></code>
    <answer><![CDATA[6 months to a year]]></answer>
    <sortorder><![CDATA[3]]></sortorder>
    <assessment_value><![CDATA[0]]></assessment_value>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <qid><![CDATA[3989]]></qid>
    <code><![CDATA[N4]]></code>
    <answer><![CDATA[1-2 years]]></answer>
    <sortorder><![CDATA[4]]></sortorder>
    <assessment_value><![CDATA[0]]></assessment_value>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <qid><![CDATA[3989]]></qid>
    <code><![CDATA[N5]]></code>
    <answer><![CDATA[More than 2 years]]></answer>
    <sortorder><![CDATA[5]]></sortorder>
    <assessment_value><![CDATA[0]]></assessment_value>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <qid><![CDATA[3989]]></qid>
    <code><![CDATA[N1]]></code>
    <answer><![CDATA[Moins de 3 mois]]></answer>
    <sortorder><![CDATA[1]]></sortorder>
    <assessment_value><![CDATA[0]]></assessment_value>
    <language><![CDATA[fr]]></language>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <qid><![CDATA[3989]]></qid>
    <code><![CDATA[N2]]></code>
    <answer><![CDATA[Trois mois à six mois]]></answer>
    <sortorder><![CDATA[2]]></sortorder>
    <assessment_value><![CDATA[0]]></assessment_value>
    <language><![CDATA[fr]]></language>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <qid><![CDATA[3989]]></qid>
    <code><![CDATA[N3]]></code>
    <answer><![CDATA[6 mois à un an]]></answer>
    <sortorder><![CDATA[3]]></sortorder>
    <assessment_value><![CDATA[0]]></assessment_value>
    <language><![CDATA[fr]]></language>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <qid><![CDATA[3989]]></qid>
    <code><![CDATA[N4]]></code>
    <answer><![CDATA[1 - 2 ans]]></answer>
    <sortorder><![CDATA[4]]></sortorder>
    <assessment_value><![CDATA[0]]></assessment_value>
    <language><![CDATA[fr]]></language>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <qid><![CDATA[3989]]></qid>
    <code><![CDATA[N5]]></code>
    <answer><![CDATA[Plus de 2 ans]]></answer>
    <sortorder><![CDATA[5]]></sortorder>
    <assessment_value><![CDATA[0]]></assessment_value>
    <language><![CDATA[fr]]></language>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <qid><![CDATA[3989]]></qid>
    <code><![CDATA[N1]]></code>
    <answer><![CDATA[Менее 3-х месяцев]]></answer>
    <sortorder><![CDATA[1]]></sortorder>
    <assessment_value><![CDATA[0]]></assessment_value>
    <language><![CDATA[ru]]></language>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <qid><![CDATA[3989]]></qid>
    <code><![CDATA[N2]]></code>
    <answer><![CDATA[от 3-х до 6-ти месяцев]]></answer>
    <sortorder><![CDATA[2]]></sortorder>
    <assessment_value><![CDATA[0]]></assessment_value>
    <language><![CDATA[ru]]></language>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <qid><![CDATA[3989]]></qid>
    <code><![CDATA[N3]]></code>
    <answer><![CDATA[от 6 месяцев до года]]></answer>
    <sortorder><![CDATA[3]]></sortorder>
    <assessment_value><![CDATA[0]]></assessment_value>
    <language><![CDATA[ru]]></language>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <qid><![CDATA[3989]]></qid>
    <code><![CDATA[N4]]></code>
    <answer><![CDATA[1-2 года]]></answer>
    <sortorder><![CDATA[4]]></sortorder>
    <assessment_value><![CDATA[0]]></assessment_value>
    <language><![CDATA[ru]]></language>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <qid><![CDATA[3989]]></qid>
    <code><![CDATA[N5]]></code>
    <answer><![CDATA[Более 2-х лет]]></answer>
    <sortorder><![CDATA[5]]></sortorder>
    <assessment_value><![CDATA[0]]></assessment_value>
    <language><![CDATA[ru]]></language>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
  </rows>
 </answers>
</document>
limesurvey_question_3989.lsq (13,905 bytes)   
galads

galads

2021-10-06 11:25

administrator   ~66763

Last edited: 2021-11-22 17:10

The question here is: 1. when you uncheck the box "rename question code if it exists", and then the code is already used by another question, what should happen?

If I uncheck the boxes, I get the error because the question code is already in use by another question and it must be unique.

I agree there should be a message "saying the actual problem" instead of the 500 internal server error.

Issue History

Date Modified Username Field Change
2021-10-01 17:45 GuernseyResearch New Issue
2021-10-01 17:45 GuernseyResearch File Added: Error on question import.png
2021-10-01 17:57 GuernseyResearch Note Added: 66733
2021-10-01 17:57 GuernseyResearch File Added: import2.jpg
2021-10-01 17:57 GuernseyResearch Bug heat 0 => 2
2021-10-04 08:14 galads Assigned To => galads
2021-10-04 08:14 galads Status new => acknowledged
2021-10-05 17:49 galads Note Added: 66752
2021-10-05 17:49 galads Bug heat 2 => 4
2021-10-05 17:49 galads Status acknowledged => feedback
2021-10-05 18:06 GuernseyResearch Note Added: 66753
2021-10-05 18:06 GuernseyResearch File Added: limesurvey_question_3989.lsq
2021-10-05 18:06 GuernseyResearch Status feedback => assigned
2021-10-06 11:25 galads Note Added: 66763