View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
12675 | Bug reports | Import/Export | public | 2017-09-15 10:28 | 2018-01-24 17:33 |
Reporter | Nickko | Assigned To | c_schmitz | ||
Priority | none | Severity | minor | ||
Status | closed | Resolution | unable to reproduce | ||
Product Version | 2.67.x | ||||
Summary | 12675: Error 1062 Duplicate entry when importing a question | ||||
Description | I export a question from a survey to importing it in another survey on the same server. CDbCommand n'a pas pu exécuter la commande SQL: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '5853-0-en--0' for key 'PRIMARY' Une erreur interne est apparue lorsque le serveur web traitait votre requete. Veuillez contacter the webmaster pour signaler ce problème. Merci. 2017-09-15 10:26:27 | ||||
Steps To Reproduce | I export a question from a survey to importing it in another survey on the same server. | ||||
Additional Information | At least, Limesurvey must send an error, not the server returning error 500 | ||||
Tags | No tags attached. | ||||
Attached Files | |||||
Bug heat | 4 | ||||
Complete LimeSurvey version number (& build) | Version 2.67.3+170728 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | Chrome, Safari, Edge | ||||
Database type & version | MySQL 263 | ||||
Server OS (if known) | OVH shared | ||||
Webserver software & version (if known) | OVH shared | ||||
PHP Version | 7 | ||||
Which version was used to export this question? |
|
The same as for the import : Version 2.67.3+170728 |
|
The file looks manipulated to me. I just did a test export with 2.67.3 and the header looks like this: <document> You file looks like this <?xml version="1.0" encoding="UTF-8"?> Note the missing SID field. |
|
I am closing this issue because there is something wrong with the import file, not with the import |
|
Date Modified | Username | Field | Change |
---|---|---|---|
2017-09-15 10:28 | Nickko | New Issue | |
2017-09-15 10:28 | Nickko | File Added: limesurvey_question_4863.lsq | |
2018-01-24 17:01 | c_schmitz | Assigned To | => c_schmitz |
2018-01-24 17:01 | c_schmitz | Status | new => feedback |
2018-01-24 17:01 | c_schmitz | Note Added: 46039 | |
2018-01-24 17:16 | Nickko | Note Added: 46040 | |
2018-01-24 17:16 | Nickko | Status | feedback => assigned |
2018-01-24 17:30 | c_schmitz | Note Added: 46041 | |
2018-01-24 17:33 | c_schmitz | Status | assigned => closed |
2018-01-24 17:33 | c_schmitz | Resolution | open => unable to reproduce |
2018-01-24 17:33 | c_schmitz | Note Added: 46042 |