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 | ||||
| Git branch / Pull Request URL | |||||
|
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 12:46 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 09:41 | DenisChenu | Relationship added | related to 06502 |
| 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 |