View Issue Details

This bug affects 1 person(s).
 6
IDProjectCategoryView StatusLast Update
11886Bug reportsImport/Exportpublic2016-11-11 13:18
ReporterDenisChenu Assigned ToDenisChenu  
PrioritynoneSeverityminor 
Status closedResolutionfixed 
Product Version2.55.x 
Fixed in Version2.55.x 
Summary11886: lsq file bug import
Description

When i import the included lsq file in a fr/en survey : survey is broken and can not be activated

Steps To Reproduce
  • Import limesurvey_survey_littleSurveyForImport.lss : 2 language : fr/en
  • In this survey : import limesurvey_question_brokeWhenImport.lsq (en/fr)
  • See the error (why ?)
  • Try to activate survey : show a loink to a question (no answer question)
  • Click on link : white page
  • Try data integrity, and try agin activate : same think
Additional Information

Seems to have different bug :

  1. code seems to be OK
    <rows>
    <row>
    <qid><![CDATA[2512]]></qid>
    <parent_qid><![CDATA[0]]></parent_qid>
    <sid><![CDATA[494266]]></sid>
    <gid><![CDATA[121]]></gid>
    <type><![CDATA[L]]></type>
    <title><![CDATA[Q23]]></title>
    <question><![CDATA[<strong>The following questions will only be used for statistics.</strong>
    <p>You are…</p>
    ]]></question>
    .......
    </row>
    <row>
    <qid><![CDATA[2512]]></qid>
    <parent_qid><![CDATA[0]]></parent_qid>
    <sid><![CDATA[494266]]></sid>
    <gid><![CDATA[121]]></gid>
    <type><![CDATA[L]]></type>
    <title><![CDATA[Q23]]></title>
    <question><![CDATA[<p><strong>Les prochaines questions ne seront utilisées qu’à des fins statistiques.</strong></p>

<p>Vous êtes :</p>
]]></question>
.......
</row>
</rows>

  1. Check data integrity must fix issue

  2. Page can not be white

TagsNo tags attached.
Attached Files
WhenEdit.png (31,141 bytes)   
WhenEdit.png (31,141 bytes)   
WhenView.png (43,150 bytes)   
WhenView.png (43,150 bytes)   
Bug heat6
Complete LimeSurvey version number (& build)20161108
I will donate to the project if issue is resolvedNo
Browsernot relevant
Database type & versionnot relevant
Server OS (if known)not relevant
Webserver software & version (if known)not relevant
PHP Versionnot relevant

Relationships

related to 11892 closedDenisChenu Copying question looses subquestions 

Users monitoring this issue

There are no users monitoring this issue.

Activities

DenisChenu

DenisChenu

2016-11-08 08:48

developer   ~41768

Arg !!!!

Sometimes work, sometimes don't work .....

DenisChenu

DenisChenu

2016-11-08 08:54

developer   ~41769

Last edited: 2016-11-08 09:09

OK , got it : question code are not the same when import is done.

See screenshots:

  • 1st : survey is en/fr : code are not reset for 1st lang, reset for 2nd
  • 2nd : survey is fr/en : code are reset (even if not needed) for 1st lang, not for second.

Another strange think : code when edit and when viea are different

There are surely same error for group too : we don't take "question code of 1st language" in account.

Then : if "base language" is import 1st : OK : questions seems to be OK (but is broken in DB)
if base language is not first : broken ?

DenisChenu

DenisChenu

2016-11-08 09:27

developer   ~41770

OK : bug can appear if Base language is not imported : for this : must be:

  • Base language are second in lsq
  • randomChars(5) return a bad code (for example 1abcd : start with number)
tammo

tammo

2016-11-10 17:24

developer   ~41828

\application\helpers\expressions\em_manager_helper.php(6620)

foreach($sgqas as $sgqa)

Is indicated as error in my case (after copying question)

Stack trace:

#0
+
D:\Dropbox\sites\drupal\hoofdtoegang\limegit.toolsforresearch.com\public_html\application\helpers\expressions\em_manager_helper.php(5914): LimeExpressionManager->_ValidateQuestion(30, true)
#1
+
D:\Dropbox\sites\drupal\hoofdtoegang\limegit.toolsforresearch.com\public_html\application\helpers\expressions\em_manager_helper.php(5822): LimeExpressionManager->_ValidateGroup(3, true)
#2
+
D:\Dropbox\sites\drupal\hoofdtoegang\limegit.toolsforresearch.com\public_html\application\helpers\expressions\em_manager_helper.php(5576): LimeExpressionManager->_ValidateSurvey(true)
#3
+
D:\Dropbox\sites\drupal\hoofdtoegang\limegit.toolsforresearch.com\public_html\application\helpers\SurveyRuntimeHelper.php(117): LimeExpressionManager::JumpTo(1, false, false, true)
#4
+
D:\Dropbox\sites\drupal\hoofdtoegang\limegit.toolsforresearch.com\public_html\application\controllers\survey\index.php(658): SurveyRuntimeHelper->run("459676", array("surveyid" => "459676", "thissurvey" => array("template" => "default", "language" => "en", "sid" => "459676", "owner_id" => "1", ...), "thisstep" => null, "tokensexist" => 0, ...))
#5
+
D:\Dropbox\sites\drupal\hoofdtoegang\limegit.toolsforresearch.com\public_html\application\controllers\survey\index.php(73): index->action()
#6
+
D:\Dropbox\sites\drupal\hoofdtoegang\limegit.toolsforresearch.com\public_html\framework\web\actions\CAction.php(76): index->run()
#7
+
D:\Dropbox\sites\drupal\hoofdtoegang\limegit.toolsforresearch.com\public_html\framework\web\CController.php(308): CAction->runWithParams(array("sid" => "459676", "newtest" => "Y", "lang" => "en"))
#8
+
D:\Dropbox\sites\drupal\hoofdtoegang\limegit.toolsforresearch.com\public_html\framework\web\CController.php(286): CController->runAction(index)
#9
+
D:\Dropbox\sites\drupal\hoofdtoegang\limegit.toolsforresearch.com\public_html\framework\web\CController.php(265): CController->runActionWithFilters(index, array())
#10
+
D:\Dropbox\sites\drupal\hoofdtoegang\limegit.toolsforresearch.com\public_html\framework\web\CWebApplication.php(282): CController->run("index")
#11
+
D:\Dropbox\sites\drupal\hoofdtoegang\limegit.toolsforresearch.com\public_html\framework\web\CWebApplication.php(141): CWebApplication->runController("survey/index/sid/459676/newtest/Y/lang/en")
#12
+
D:\Dropbox\sites\drupal\hoofdtoegang\limegit.toolsforresearch.com\public_html\framework\base\CApplication.php(185): CWebApplication->processRequest()
#13
+
D:\Dropbox\sites\drupal\hoofdtoegang\limegit.toolsforresearch.com\public_html\index.php(214): CApplication->run()

DenisChenu

DenisChenu

2016-11-10 17:43

developer   ~41829

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

DenisChenu

DenisChenu

2016-11-10 17:45

developer   ~41830

In group : there are no option to 'fix title' then bug never happen (question is not imported ).

c_schmitz

c_schmitz

2016-11-11 13:18

administrator   ~41850

Version 2.55.3 released

Related Changesets

LimeSurvey: master 3fbe4b27

2016-11-10 17:39:48

DenisChenu

Details Diff
Fixed issue 11886: lsq file bug import
Dev: validate('title') and get the new title for another row
Dev: create a model function (to be used in survey and group import too
Affected Issues
11886
mod - application/controllers/admin/questions.php Diff File
mod - application/helpers/admin/import_helper.php Diff File
mod - application/models/Question.php Diff File
mod - application/views/admin/survey/Question/import_view.php Diff File

Issue History

Date Modified Username Field Change
2016-11-08 08:39 DenisChenu New Issue
2016-11-08 08:39 DenisChenu File Added: limesurvey_survey_brokenSurveyAfterImport.lss
2016-11-08 08:39 DenisChenu File Added: limesurvey_question_brokeWhenImport.lsq
2016-11-08 08:40 DenisChenu File Added: limesurvey_survey_littleSurveyForImport.lss
2016-11-08 08:43 DenisChenu File Deleted: limesurvey_survey_littleSurveyForImport.lss
2016-11-08 08:46 DenisChenu File Added: limesurvey_survey_littleSurveyForImport.lss
2016-11-08 08:48 DenisChenu Note Added: 41768
2016-11-08 08:54 DenisChenu Note Added: 41769
2016-11-08 08:54 DenisChenu File Added: Capture du 2016-11-08 08-53-50.png
2016-11-08 08:57 DenisChenu Note Edited: 41769
2016-11-08 09:01 DenisChenu File Added: Capture du 2016-11-08 09-00-53.png
2016-11-08 09:08 DenisChenu Note Edited: 41769
2016-11-08 09:09 DenisChenu Note Edited: 41769
2016-11-08 09:09 DenisChenu File Added: WhenEdit.png
2016-11-08 09:09 DenisChenu File Added: WhenView.png
2016-11-08 09:27 DenisChenu Note Added: 41770
2016-11-10 10:30 DenisChenu Relationship added related to 11892
2016-11-10 17:24 tammo Note Added: 41828
2016-11-10 17:40 DenisChenu Assigned To => DenisChenu
2016-11-10 17:40 DenisChenu Status new => assigned
2016-11-10 17:43 DenisChenu Changeset attached => LimeSurvey master 3fbe4b27
2016-11-10 17:43 DenisChenu Note Added: 41829
2016-11-10 17:43 DenisChenu Resolution open => fixed
2016-11-10 17:44 DenisChenu Status assigned => resolved
2016-11-10 17:44 DenisChenu Fixed in Version => 2.55.x
2016-11-10 17:45 DenisChenu Note Added: 41830
2016-11-11 13:18 c_schmitz Note Added: 41850
2016-11-11 13:18 c_schmitz Status resolved => closed