View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
06671 | Bug reports | Survey editing | public | 2012-10-09 17:40 | 2012-10-14 10:56 |
Reporter | arnaudbore | Assigned To | c_schmitz | ||
Priority | high | Severity | partial_block | ||
Status | closed | Resolution | fixed | ||
Product Version | 2.00+ | ||||
Fixed in Version | 2.00+ | ||||
Summary | 06671: 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. | ||||
Tags | No tags attached. | ||||
Attached Files | |||||
Bug heat | 12 | ||||
Complete LimeSurvey version number (& build) | 121006 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | Chrome | ||||
Database type & version | Ver 14.14 Distrib 5.5.25 | ||||
Server OS (if known) | Open Suse | ||||
Webserver software & version (if known) | apache | ||||
PHP Version | PHP5.3.8 | ||||
Please attach the .lsg file of the group you are trying to import. |
|
File attached...Thank you |
|
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... |
|
I cannot reproduce the issue here. Please update to the latest build and check if the error persists. |
|
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!) |
|
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 (email address removed) ? |
|
Holzhauer, it seems to be a PHP issue. What PHP version are you running? |
|
I'm using PHP 5.4.7 and MySQL 5.5.25 |
|
Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=9740 |
|
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 |
|
Great work ! Thank you ! It works for me ! |
|
Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=9743 |
|
2.00+ Build 121013 released. Please update. |
|
Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=9758 |
|
LimeSurvey: master cca22a36 2012-10-11 11:59 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 03:45 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 03:56 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 |
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 |