04349: Can't import .LSQ question - LimeSurvey bugs and feature requests

This bug affects 1 person(s).

ID	Project	Category	View Status	Date Submitted	Last Update

04349	Bug reports	Import/Export	public	2010-05-18 17:40	2010-06-08 21:51

Reporter	Mazi	Assigned To	c_schmitz
Priority	normal	Severity	partial_block
Status	closed	Resolution	fixed
Product Version	1.90b
Target Version	1.90RC1	Fixed in Version	1.90RC1

Summary	04349: Can't import .LSQ question
Description	When I try to import the attached question at an existing survey no data is imported: "Success File upload succeeded. Reading file.. Success Question import summary `* Questions: * Subquestions: * Answers: * Question attributes:` Question import is complete."
Steps To Reproduce	Import the attached question at an existing survey.
Additional Information	When clicking the "go to question" button no QID is added to the link so you don't get to that - probably not existing - question.
Tags	No tags attached.
Attached Files	limesurvey_question_5.lsq (11,219 bytes) limesurvey_question_776.csv (7,962 bytes) # LimeSurvey Question Dump # DBVersion 138 # This is a dumped question from the LimeSurvey Script # http://www.limesurvey.org/ # Do not change this header! # # QUESTIONS TABLE # "qid","sid","gid","type","title","question","preg","help","other","mandatory","lid","lid1","question_order","language" "776","85421","175",":","Test","8. Wenn Sie mit einer neuen Aufgabe konfrontiert werden,<b> auf welche Informationsquellen / Ansprechpartner greifen Sie bei den folgenden Arbeitsschritten meistens zurück</b>?","","","N","N","22","0","1","de" "776","85421","175",":","Test","8. Being confronted with a new task, what <b>points of reference and information sources do you tend to turn to most, when you engage in the following activities</b>?<b> </b>","","","N","N","22","0","1","en" # # ANSWERS TABLE # "qid","code","answer","default_value","sortorder","assessment_value","language" "776","8_EWI","<div align=""left""><b>Externe<br>Wikis  </b><img width=""14"" height=""14"" alt="""" src=""/survey/upload/surveys/85421/icon_q.gif"" title=""z.B. Wikipedia, Wiktionary, Wikiquote, Wikihow"" /></div>","N","8","0","de" "776","8_EWI","<div align=""left""><b>External<br>Wikis  </b><img width=""14"" height=""14"" alt="""" src=""/survey/upload/surveys/85421/icon_q.gif"" title=""e.g. Wikipedia, Wiktionary, Wikiquote, Wikihow"" /></div>","N","8","0","en" "776","8_FIS","<div align=""left""><b>Fachbezogene<br>Internetseiten  </b><img width=""14"" height=""14"" title=""z.B. Forrester, Gartner, SAP Glossary, Kunden-Webseite, dict.leo.org"" src=""/survey/upload/surveys/85421/icon_q.gif"" alt="""" /></div>","N","7","0","de" "776","8_FIS","<div align=""left""><b>Factual<br>Internet Sites  </b><img width=""14"" height=""14"" title=""e.g. Forrester, Gartner, SAP glossary, client homepage, dict.leo.org"" src=""/survey/upload/surveys/85421/icon_q.gif"" alt="""" /></div>","N","7","0","en" "776","8_IKS","<div align=""left""><b>Intranet<br>Wissensquellen  </b><img width=""14"" height=""14"" alt="""" src=""/urvey/upload/surveys/85421/icon_q.gif"" title=""z.B. kX. myResearch, Offerings, ADM"" /></div>","N","4","0","de" "776","8_IKS","<div align=""left""><b>Intranet Knowledge<br>Sources  </b><img width=""14"" height=""14"" alt="""" src=""/survey/upload/surveys/85421/icon_q.gif"" title=""e.g. kX. myResearch, Offerings, ADM"" /></div>","N","4","0","en" "776","8_ISE","<div align=""left""><b>Internet<br>Suchmaschinen  </b><img width=""14"" height=""14"" alt="""" src=""/survey/upload/surveys/85421/icon_q.gif"" title=""z.B. Google, Google Scholar, Yahoo, Bing""></div>","N","6","0","de" "776","8_ISE","<div align=""left""><b>Internet<br>Search Engines  </b><img width=""14"" height=""14"" alt="""" src=""/survey/upload/surveys/85421/icon_q.gif"" title=""e.g. Google, Google Scholar, Yahoo, Bing""></div>","N","6","0","en" "776","8_ITS","<div align=""left""><b>Trainingskurse/<br>-unterlagen  </b><img width=""14"" height=""14"" title=""z.B. Präsenzkurse, myLearning"" src=""/survey/upload/surveys/85421/icon_q.gif"" alt="""" /></div></b>","N","9","0","de" "776","8_ITS","<div align=""left""><b>Instructed<br>Training Sources  </b><img width=""14"" height=""14"" title=""e.g. Classroom, myLearning"" src=""/survey/upload/surveys/85421/icon_q.gif"" alt="""" /></div>","N","9","0","en" "776","8_PCS","<div align=""left""><b>Persönliche<br>Kontakte  </b><img width=""14"" height=""14"" alt="""" src=""/survey/upload/surveys/85421/icon_q.gif"" title=""z.B. Kollegen, Vorgesetzte, Kunden, Bekannte""></div></b>","N","11","0","de" "776","8_PCS","<div align=""left""><b>Personal<br>Contact Source  </b><img width=""14"" height=""14"" alt="""" src=""/survey/upload/surveys/85421/icon_q.gif"" title=""e.g. Colleagues, Supervisors, Clients, Friends""></div>","N","11","0","en" "776","8_PFS","<div align=""left""><b>Fachbezogene<br>Druckerzeugnisse  </b><img width=""14"" height=""14"" title=""z.B. Bücher, Zeitungen, Journale, Hanbücher, Books 24x7"" src=""/survey/upload/surveys/85421/icon_q.gif"" alt="""" /></div></b>","N","2","0","de" "776","8_PFS","<div align=""left""><b>Printed<br>Factual Sources  </b><img width=""14"" height=""14"" title=""e.g. Books, Newspapers, Journals, Handbooks, Books 24x7"" src=""/survey/upload/surveys/85421/icon_q.gif"" alt="""" /></div>","N","2","0","en" "776","8_PHD","<div align=""left""><b>Eigene Festplatte/<br>Team Sharepoint</b><br></div>","N","1","0","de" "776","8_PHD","<div align=""left""><b>Personal Hard Drive /<br>Team Sharepoint</b></div>","N","1","0","en" "776","8_SIS","<div align=""left""><b>Soziale<br>Intranetseiten  </b><img width=""14"" height=""14"" alt="""" src=""/survey/upload/surveys/85421/icon_q.gif"" title=""z.B. Encyclopedia, People Pages, CoPs, Groups""></div></b>","N","5","0","de" "776","8_SIS","<div align=""left""><b>Social<br>Intranet Sites  </b><img width=""14"" height=""14"" alt="""" src=""/survey/upload/surveys/85421/icon_q.gif"" title=""e.g. Encyclopedia, People Pages, CoPs, Groups""></div>","N","5","0","en" "776","8_SNS","<div align=""left""><b>Soziale<br>Netzwerkseiten  </b><img width=""14"" height=""14"" alt="""" src=""/survey/upload/surveys/85421/icon_q.gif"" title=""z.B. Facebook, LinkedIn, Orkut, Xing""></div>","N","10","0","de" "776","8_SNS","<div align=""left""><b>Social<br>Networking Sites  </b><img width=""14"" height=""14"" alt="""" src=""/survey/upload/surveys/85421/icon_q.gif"" title=""e.g. Facebook, LinkedIn, Orkut, Xing""></div>","N","10","0","en" "776","8_SSS","<div align=""left""><b>Soziale Austausch-<br>Plattformen  </b><img width=""14"" height=""14"" alt="""" src=""/survey/upload/surveys/85421/icon_q.gif"" title=""z.B. Youtube, Slideshare, Delicious, Blogs, Twitter""></div>","N","3","0","de" "776","8_SSS","<div align=""left""><b>Social<br>Sharing Sites  </b><img width=""14"" height=""14"" alt="""" src=""/survey/upload/surveys/85421/icon_q.gif"" title=""e.g. Youtube, Slideshare, Delicious, Blogs, Twitter""></div>","N","3","0","en" # # LABELSETS TABLE # "lid","label_name","languages" "22","Test","en de" # # LABELS TABLE # "lid","code","title","sortorder","language","assessment_value" "22","UTT","<img width=""90"" height=""65"" alt="""" src=""/survey/upload/labels/15/Activity1.gif"" />","1","de","1" "22","UTT","<img width=""90"" height=""65"" alt="""" src=""/survey/upload/labels/15/Activity1.gif"" />","1","en","1" "22","GAO","<img width=""90"" height=""65"" alt="""" src=""/survey/upload/labels/15/Activity2.gif"" />","2","de","2" "22","GAO","<img width=""90"" height=""65"" alt="""" src=""/survey/upload/labels/15/Activity2.gif"" />","2","en","2" "22","CAS","<img width=""90"" height=""65"" alt="""" src=""/survey/upload/labels/15/Activity3.gif"" />","3","de","3" "22","CAS","<img width=""90"" height=""65"" alt="""" src=""/survey/upload/labels/15/Activity3.gif"" />","3","en","3" "22","ETG","<img width=""90"" height=""65"" alt="""" src=""/survey/upload/labels/15/Activity4.gif"" />","4","de","4" "22","ETG","<img width=""90"" height=""65"" alt="""" src=""/survey/upload/labels/15/Activity4.gif"" />","4","en","4" "22","CAA","<img width=""90"" height=""65"" alt="""" src=""/survey/upload/labels/15/Activity5.gif"" />","5","de","5" "22","CAA","<img width=""90"" height=""65"" alt="""" src=""/survey/upload/labels/15/Activity5.gif"" />","5","en","5" "22","ETR","<img width=""90"" height=""65"" alt="""" src=""/survey/upload/labels/15/Activity6.gif"" />","6","de","1" "22","ETR","<img width=""90"" height=""65"" alt="""" src=""/survey/upload/labels/15/Activity6.gif"" />","6","en","1" # # QUESTION_ATTRIBUTES TABLE # "qaid","qid","attribute","value" "409","776","random_order","1" "410","776","multiflexible_checkbox","1" "411","776","multiflexible_step","2" "412","776","multiflexible_min","10" "413","776","multiflexible_max","20" limesurvey_question_776.csv (7,962 bytes)

Bug heat	2
Complete LimeSurvey version number (& build)	8888
I will donate to the project if issue is resolved
Browser	Firefox 3.6.3
Database type & version	MySQL 5
Server OS (if known)	Win 7
Webserver software & version (if known)	Apache 2.2
PHP Version	5.3.1

User List	There are no users monitoring this issue.

Mazi 2010-05-18 17:51 updater ~11861	I'm not sure if this is a related bug but when importing the attached .CSV file I get the following errors: "Deprecated: Function split() is deprecated in C:\xampp\htdocs\limeSOURCE\limesurvey_svn\common.php on line 6057 Notice: Undefined variable: answerrowdata in C:\xampp\htdocs\limeSOURCE\limesurvey_svn\admin\importquestion.php on line 528 Error: Failed to insert subquestion insert INTO `lime190_questions` (,parent_qid,title,question,question_order,language,scale_id) VALUES (, 515,'UTT','<img width=\"90\" height=\"65\" alt=\"\" src=\"/survey/upload/labels/15/Activity1.gif\" />','1','en',0) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'parent_qid,title,question,question_order,language,scale_id) ' at line 1" The deprecated notice shows up quite often. I have no problems when trying to import that file at LS 1.87.

Date Modified	Username	Field	Change
2010-05-18 17:40	Mazi	New Issue
2010-05-18 17:40	Mazi	Status	new => assigned
2010-05-18 17:40	Mazi	Assigned To	=> machaven
2010-05-18 17:40	Mazi	File Added: limesurvey_question_5.lsq
2010-05-18 17:41	Mazi	Summary	Can't import .LQ question => Can't import .LSQ question
2010-05-18 17:51	Mazi	Note Added: 11861
2010-05-18 17:51	Mazi	File Added: limesurvey_question_776.csv
2010-05-31 12:50	machaven	Assigned To	machaven => c_schmitz
2010-06-02 15:43	c_schmitz	Status	assigned => resolved
2010-06-02 15:43	c_schmitz	Fixed in Version	=> 1.90RC1
2010-06-02 15:43	c_schmitz	Resolution	open => fixed
2010-06-08 21:51	c_schmitz	Status	resolved => closed

View Issue Details

Users monitoring this issue

Activities

Issue History