Check out the LimeSurvey source code on GitHub!

Problems with copying a survey

More
4 years 10 months ago #79322 by IDA
Hi!
This is the first time I use LimeSurvey. Now I want to copy my finished survey to have several versions. But every time I tried to copy it this error occurs: "Fehler: Failed to insert data
INSERT INTO lime_questions ( PARENT_QID, SID, GID, TYPE, TITLE, QUESTION, PREG, HELP, OTHER, MANDATORY, QUESTION_ORDER, LANGUAGE, SCALE_ID, SAME_DEFAULT ) VALUES ( 8086, 29648, null, 'Q', 'Z1', 'Lernziel 1', '', '', 'N', '', 2, 'de', 0, 0 )
Column 'gid' cannot be null"
What did I do wrong?
Thanks for helping!

Please Log in to join the conversation.

More
4 years 10 months ago #79332 by Mazi
1. Which Limesurvey version do you use?

2. Can you try to re-create question # 8086 of survey 29648 which should read "Lernziel 1"?

3. What happens if you export the survey and try to import the attached file?

4. Alternatively note the group ID of that question and export the survey. Check the exported file for question ID #8086 and try to replace the maybe empty group ID value and then try to import the file.


Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)survey-consulting.com'"

Please Log in to join the conversation.

More
4 years 9 months ago #79459 by IDA
Sorry, that I forgot to note the version. It's Version 1.91+ Build 11232.
The same error occurs if I try to export and import the survey.
I recreated the questions you mentioned but now it's the same error for another question. If I recreate this one too, it's again the same error for another question. Does this mean I have to recreate the whole survey?
Thanks again for your help!

Please Log in to join the conversation.

More
4 years 9 months ago #79460 by IDA
Oh, I recreated a couple more questions and now it is possible to copy the survey.
Thank you very much!

Please Log in to join the conversation.

More
4 years 9 months ago #79474 by Mazi

IDA wrote: Oh, I recreated a couple more questions and now it is possible to copy the survey.
Thank you very much!

You're welcome :-)

If our hints have been helpful and you enjoy limesurvey please consider a donation to give Limesurvey a future .
We do all this in our free time and you don't have to pay a penny for this software.

Without your help we can't keep this project alive.


Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)survey-consulting.com'"

Please Log in to join the conversation.

Imprint                   Privacy policy         General Terms & Conditions         Revocation information and revocation form