View Issue Details

This bug affects 1 person(s).
 8
IDProjectCategoryView StatusLast Update
17646Bug reportsImport/Exportpublic2022-01-05 09:34
ReporterGuernseyResearch Assigned Togabrieljenik  
PrioritynoneSeveritycrash 
Status closedResolutionfixed 
Product Version5.x 
Summary17646: Cannot import version 3 lsq file in to LS5
Description

Trying 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 Reproduce

Steps 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.
Attached Files
Error on question import.png (31,487 bytes)   
Error on question import.png (31,487 bytes)   
Bug heat8
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

There are no users monitoring this issue.

Activities

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

reporter   ~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

reporter   ~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.

gabrieljenik

gabrieljenik

2021-12-02 19:08

manager   ~67661

PR: https://github.com/LimeSurvey/LimeSurvey/pull/2168

There were two problems:

1) When importing questions with multiple languages, the XMLImportQuestion () method was not returning the qid correctly, so it failed to load the page after redirection.

2) The ticket also mentions that when the question was added, it was in the wrong group. It is partially true. The url of the Import Question button (in the topbar) did not include the GID, so it always opened the import page with group 1 selected in the dropdown. When importing, it is imported correctly into the group that was selected in the dropdown.

gabrieljenik

gabrieljenik

2021-12-03 21:19

manager   ~67672

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

LimeBot

LimeBot

2022-01-05 09:34

administrator   ~67909

Fixed in Release 5.2.5+211207

Related Changesets

LimeSurvey: master fbfebff6

2021-12-03 21:19:03

gabrieljenik


Committer: GitHub Details Diff
Fixed issue 17646: Cannot import version 3 lsq file in to LS5 (#2168) Affected Issues
17646
mod - application/extensions/TopbarWidget/views/includes/editQuestionTopbarLeft_view.php Diff File
mod - application/helpers/admin/import_helper.php Diff File

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
2021-11-22 17:10 ollehar Zoho Project Synchronization => |Yes|
2021-12-02 19:08 gabrieljenik Note Added: 67661
2021-12-02 19:08 gabrieljenik Bug heat 4 => 6
2021-12-03 21:19 gabrieljenik Changeset attached => LimeSurvey master fbfebff6
2021-12-03 21:19 gabrieljenik Note Added: 67672
2021-12-03 21:19 gabrieljenik Assigned To galads => gabrieljenik
2021-12-03 21:19 gabrieljenik Resolution open => fixed
2021-12-03 21:19 c_schmitz Status assigned => resolved
2022-01-05 09:34 LimeBot Zoho Project Synchronization Yes => |Yes|
2022-01-05 09:34 LimeBot Note Added: 67909
2022-01-05 09:34 LimeBot Status resolved => closed
2022-01-05 09:34 LimeBot Bug heat 6 => 8