- Posts: 2
- Thank you received: 0
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
Error Importing a Survey
- offpiste.reese
- Topic Author
- Offline
- New Member
Less
More
2 years 1 month ago #225794
by offpiste.reese
Error Importing a Survey was created by offpiste.reese
Please help us help you and fill where relevant:
Your LimeSurvey version: LimeSurvey Cloud
Version 5.2.13
Own server or LimeSurvey hosting: Limesurvey Hosting
Survey theme/template: none
==================
I exported a survey from one instance of LimeSurvey cloud and modified the file, really just changed question text. I then tried to import into a different instance. I am getting the following error:500: Internal Server ErrorCDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '251-en' for key 'answer_l10ns_idx'
I have attached the file I am using.
Your LimeSurvey version: LimeSurvey Cloud
Version 5.2.13
Own server or LimeSurvey hosting: Limesurvey Hosting
Survey theme/template: none
==================
I exported a survey from one instance of LimeSurvey cloud and modified the file, really just changed question text. I then tried to import into a different instance. I am getting the following error:500: Internal Server ErrorCDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '251-en' for key 'answer_l10ns_idx'
I have attached the file I am using.
Please Log in to join the conversation.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13647
- Thank you received: 2491
2 years 1 month ago #225821
by DenisChenu
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
Replied by DenisChenu on topic Error Importing a Survey
The new export as TSV add 2 cilupmns id and related_id : this make more complicate to edit quetsion.
1. remove the 2 columns : id and related_id
2. Import and check if it work
3. If yes: PLEASE report the issue , TXT expport must stay an easy way to edit survey.
community.limesurvey.org/bug-tracker/
1. remove the 2 columns : id and related_id
2. Import and check if it work
3. If yes: PLEASE report the issue , TXT expport must stay an easy way to edit survey.
community.limesurvey.org/bug-tracker/
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
Please Log in to join the conversation.
- abc99
- Offline
- New Member
Less
More
- Posts: 1
- Thank you received: 0
1 year 7 months ago #231657
by abc99
Replied by abc99 on topic Error Importing a Survey
I have the same problem.
I had to edit some of the questions in Excel, which I believe is one of the use cases for the txt export. When importing after that, I get this error:
'CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '6616-es-AR-informal' for key 'ls53_answer_l10ns_idx'
I have already removed the id and related-id columns.
It would be very helpful, if the error message could contain some information about the offending line/question. I don't know what line in my txt file '6616-es-AR-informal' refers to.
I had to edit some of the questions in Excel, which I believe is one of the use cases for the txt export. When importing after that, I get this error:
'CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '6616-es-AR-informal' for key 'ls53_answer_l10ns_idx'
I have already removed the id and related-id columns.
It would be very helpful, if the error message could contain some information about the offending line/question. I don't know what line in my txt file '6616-es-AR-informal' refers to.
Please Log in to join the conversation.