View Issue Details

This bug affects 1 person(s).
 12
IDProjectCategoryView StatusLast Update
06671Bug reportsSurvey editingpublic2012-10-14 10:56
Reporterarnaudbore Assigned Toc_schmitz  
PriorityhighSeveritypartial_block 
Status closedResolutionfixed 
Product Version2.00+ 
Fixed in Version2.00+ 
Summary06671: Impossible to import correctly a group of question
Description

After export a group of question if I import this one it told me that everything worked fine but I'm not able to have access to the questions of this group of question.

TagsNo tags attached.
Attached Files
limesurvey_group_62.lsg (16,295 bytes)
Bug heat12
Complete LimeSurvey version number (& build)121006
I will donate to the project if issue is resolvedNo
BrowserChrome
Database type & versionVer 14.14 Distrib 5.5.25
Server OS (if known)Open Suse
Webserver software & version (if known)apache
PHP VersionPHP5.3.8

Users monitoring this issue

Tdoek, Holzhauer

Activities

c_schmitz

c_schmitz

2012-10-10 13:51

administrator   ~21166

Please attach the .lsg file of the group you are trying to import.

arnaudbore

arnaudbore

2012-10-10 14:18

reporter   ~21173

File attached...Thank you

Holzhauer

Holzhauer

2012-10-10 17:43

reporter   ~21181

Last edited: 2012-10-10 17:45

I also had problems importing groups and their questions by .lsg files. Groups got inserted but questions where assigned gid=0 and thus did not appear. I found that in import_helper.php

Yii::apps()->db->getCommandBuilder()->getLastInsertID('{{groups}}');

returns 0. However,

Yii::app()->db->getLastInsertID('{{groups}}');

yields the correct gid. The same is true for requesting last inserted qid. I just removed the "getCommandBuilder()->" part and it works. I don't know what the use of getCommandBuilder() is...

c_schmitz

c_schmitz

2012-10-11 13:33

administrator   ~21214

I cannot reproduce the issue here. Please update to the latest build and check if the error persists.

Tdoek

Tdoek

2012-10-11 13:48

reporter   ~21215

I also have troubles with importing a question group with corresponding questions. Import log displays no erros and reports that all questions are imported, however the imported question group does not contain any questions after import..

I've just updated to build 121011 for the advanced multilingual settings problem. (Thanks for solving!)

c_schmitz

c_schmitz

2012-10-11 14:17

administrator   ~21216

Tdoek:

Can you send a dump of your database and the lsg file you are trying to import (please describe also in which survey you are trying to import it) to carsten.schmitz@limesurvey.org ?

c_schmitz

c_schmitz

2012-10-11 16:15

administrator   ~21241

Holzhauer, it seems to be a PHP issue. What PHP version are you running?

Holzhauer

Holzhauer

2012-10-11 18:52

reporter   ~21244

I'm using PHP 5.4.7 and MySQL 5.5.25

c_schmitz

c_schmitz

2012-10-11 18:59

administrator   ~21245

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

c_schmitz

c_schmitz

2012-10-11 19:00

administrator   ~21246

Last edited: 2012-10-11 19:01

I was able to reproduce by updating to PHP 5.3.8 and MySQL 5.5. Seems to be related to a certain mySQL/PHP/PDO configuration - hard to say which one. Implemented a workaround which works cross-DB

arnaudbore

arnaudbore

2012-10-11 19:35

reporter   ~21247

Great work ! Thank you ! It works for me !

c_schmitz

c_schmitz

2012-10-12 10:46

administrator   ~21255

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

c_schmitz

c_schmitz

2012-10-13 08:03

administrator   ~21287

2.00+ Build 121013 released. Please update.

c_schmitz

c_schmitz

2012-10-14 10:56

administrator   ~21296

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

Related Changesets

LimeSurvey: master cca22a36

2012-10-11 09:59:09

c_schmitz

Details Diff
Fixed issue 06671: Impossible to import correctly a group of question
Dev getCommandBuilder()->getLastInsertID('<sometablename>') does not work reliably on MySQL. Added getLastInsertID helper function
Affected Issues
06671
mod - application/controllers/RegisterController.php Diff File
mod - application/controllers/admin/dataentry.php Diff File
mod - application/controllers/admin/labels.php Diff File
mod - application/helpers/admin/import_helper.php Diff File
mod - application/helpers/common_helper.php Diff File
mod - application/libraries/Save.php Diff File
mod - application/models/ParticipantAttributeNames.php Diff File
mod - application/models/Participants.php Diff File
mod - application/models/User_groups.php Diff File

LimeSurvey: master 8d332290

2012-10-12 01:45:35

c_schmitz

Details Diff
Fixed issue 06671: Impossible to import correctly a group of question
Dev getCommandBuilder()->getLastInsertID('<sometablename>') does not work reliably on MySQL. Added getLastInsertID helper function
Affected Issues
06671
mod - application/controllers/admin/dataentry.php Diff File
mod - application/helpers/common_helper.php Diff File
mod - application/views/admin/survey/QuestionGroups/import_view.php Diff File

LimeSurvey: master 47646101

2012-10-14 01:56:01

c_schmitz

Details Diff
Fixed issue 06671: Impossible to import correctly a group of question
Fixed issue 06695: Error when trying to create a new user group
Affected Issues
06671, 06695
mod - application/helpers/common_helper.php Diff File

Issue History

Date Modified Username Field Change
2012-10-09 17:40 arnaudbore New Issue
2012-10-10 13:51 c_schmitz Note Added: 21166
2012-10-10 13:51 c_schmitz Assigned To => c_schmitz
2012-10-10 13:51 c_schmitz Status new => feedback
2012-10-10 14:17 arnaudbore File Added: limesurvey_group_62.lsg
2012-10-10 14:18 arnaudbore Note Added: 21173
2012-10-10 14:18 arnaudbore Status feedback => assigned
2012-10-10 17:43 Holzhauer Note Added: 21181
2012-10-10 17:45 Holzhauer Note Edited: 21181
2012-10-10 17:45 Holzhauer Issue Monitored: Holzhauer
2012-10-11 13:00 Tdoek Issue Monitored: Tdoek
2012-10-11 13:33 c_schmitz Note Added: 21214
2012-10-11 13:33 c_schmitz Status assigned => feedback
2012-10-11 13:48 Tdoek Note Added: 21215
2012-10-11 14:17 c_schmitz Note Added: 21216
2012-10-11 16:15 c_schmitz Note Added: 21241
2012-10-11 18:52 Holzhauer Note Added: 21244
2012-10-11 18:59 c_schmitz Changeset attached => LimeSurvey master cca22a36
2012-10-11 18:59 c_schmitz Note Added: 21245
2012-10-11 18:59 c_schmitz Resolution open => fixed
2012-10-11 19:00 c_schmitz Note Added: 21246
2012-10-11 19:00 c_schmitz Status feedback => resolved
2012-10-11 19:00 c_schmitz Fixed in Version => 2.00+
2012-10-11 19:01 c_schmitz Note Edited: 21246
2012-10-11 19:35 arnaudbore Note Added: 21247
2012-10-12 10:46 c_schmitz Changeset attached => LimeSurvey master 8d332290
2012-10-12 10:46 c_schmitz Note Added: 21255
2012-10-13 08:03 c_schmitz Note Added: 21287
2012-10-13 08:03 c_schmitz Status resolved => closed
2012-10-14 10:56 c_schmitz Changeset attached => LimeSurvey master 47646101
2012-10-14 10:56 c_schmitz Note Added: 21296
2019-11-01 17:25 c_schmitz Category Survey design => Survey editing
2021-08-03 05:38 guest Bug heat 8 => 12