View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
17646 | Bug reports | Import/Export | public | 2021-10-01 17:45 | 2022-01-05 09:34 |
Reporter | GuernseyResearch | Assigned To | gabrieljenik | ||
Priority | none | Severity | crash | ||
Status | closed | Resolution | fixed | ||
Product Version | 5.x | ||||
Summary | 17646: 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 | ||||
Steps To Reproduce | Steps to reproduceExport a question from LS3, import into LS5 Expected resultquestion should import Actual resultIn some cases it does import, other questions do not, but always it gives a 500 error. | ||||
Tags | No tags attached. | ||||
Attached Files | |||||
Bug heat | 8 | ||||
Complete LimeSurvey version number (& build) | Version 5.1.14+210927 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | Firefox | ||||
Database type & version | mysqlnd 5.0.12-dev | ||||
Server OS (if known) | |||||
Webserver software & version (if known) | Apache HTTP Server 2.4.49 | ||||
PHP Version | PHP Version 7.3.30 | ||||
More information. If you uncheck the three boxes the import works, but puts the question into the wrong group. |
|
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 |
|
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> |
|
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. |
|
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. |
|
Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=33023 |
|
Fixed in Release 5.2.5+211207 |
|
LimeSurvey: master fbfebff6 2021-12-03 22:19 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 |
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 |