Dependency Graph
View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
06501 | Bug reports | Import/Export | public | 2012-08-19 09:30 | 2012-09-20 14:12 |
Reporter | DenisChenu | Assigned To | DenisChenu | ||
Priority | normal | Severity | minor | ||
Status | closed | Resolution | fixed | ||
Product Version | 2.00RC9 | ||||
Fixed in Version | 2.00RC9 | ||||
Summary | 06501: Import excel with same title for 2 group make Duplicate entry | ||||
Description | If there are the same title for 2 group, exporting and importing the survey in excel format make integrity violation. CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '187-en' for key 'PRIMARY'. The SQL statement executed was: INSERT INTO import_helper line 4352 | ||||
Steps To Reproduce | Try to import excel survey file included | ||||
Additional Information | Same think for:
etc ... The problem is the test with $gname test : if $gename is same then take the old gid. | ||||
Tags | No tags attached. | ||||
Attached Files | |||||
Bug heat | 4 | ||||
Complete LimeSurvey version number (& build) | 120819 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | not relevant | ||||
Database type & version | Mysql 5 | ||||
Server OS (if known) | debian/linux | ||||
Webserver software & version (if known) | apache | ||||
PHP Version | PHP Version 5.3 | ||||
This is not a bug, but rather the way the Excel import was designed: http://docs.limesurvey.org/Excel+Survey+Structure#Limitations |
|
If it's a design issue, we have to test if there are integrity violation before inserting group. |
|
That's an option too. Either way, if the whole survey doesn't load properly, the user should get a message about why it failed to load, and the partially loaded survey should be deleted. |
|
Oups, bad bug number , see http://bugs.limesurvey.org/view.php?id=6502#c20527 For a quick and dirty fix. |
|
Fix committed to Yii branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=9387 |
|
LimeSurvey: Yii 11365e29 2012-08-19 10:46:43 Details Diff |
Fixed issue 06501 : Import excel with same title for 2 group make Duplicate entry Fixed issue : Import excel make multi sub question with the same code for additional langage Dev : put an error control on group insertion, don't change excel system : group title have to be the same Dev : use $gid in fullqname to have same code for question on different group. Dev : some warning for attribute or default value, don't delete the survey |
Affected Issues 06501 |
|
mod - application/helpers/admin/import_helper.php | Diff File |
Date Modified | Username | Field | Change |
---|---|---|---|
2012-08-19 09:30 | DenisChenu | New Issue | |
2012-08-19 09:30 | DenisChenu | File Added: limesurvey_survey_samegrouptitle.xls | |
2012-08-19 14:30 | TMSWhite | Note Added: 20521 | |
2012-08-19 14:30 | TMSWhite | Status | new => feedback |
2012-08-19 14:46 | DenisChenu | Note Added: 20524 | |
2012-08-19 14:46 | DenisChenu | Status | feedback => new |
2012-08-19 14:52 | TMSWhite | Note Added: 20526 | |
2012-08-19 14:59 | DenisChenu | Note Added: 20528 | |
2012-08-19 17:47 | DenisChenu | Assigned To | => DenisChenu |
2012-08-19 17:47 | DenisChenu | Status | new => assigned |
2012-08-19 19:50 | DenisChenu | Changeset attached | => LimeSurvey Yii 11365e29 |
2012-08-19 19:50 | DenisChenu | Note Added: 20532 | |
2012-08-19 19:50 | DenisChenu | Resolution | open => fixed |
2012-08-19 19:55 | DenisChenu | Status | assigned => resolved |
2012-08-19 19:55 | DenisChenu | Fixed in Version | => 2.00RC9 |
2012-09-20 14:12 | c_schmitz | Status | resolved => closed |