Check out the LimeSurvey source code on GitHub!
Welcome, Guest
Username: Password:

TOPIC: Trouble copying or importing survey

Trouble copying or importing survey 5 years 4 months ago #59497

  • drjlange
  • drjlange's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 1
  • Karma: 0
I have a non-active survey that I would like to copy in order to make multiple versions of it. When I try to use the copy feature I get the following error:

Error: Failed to insert data
INSERT INTO lms_questions ( PARENT_QID, SID, GID, TYPE, TITLE, QUESTION, PREG, HELP, OTHER, MANDATORY, QUESTION_ORDER, LANGUAGE, SCALE_ID, SAME_DEFAULT ) VALUES ( 1341, 78114, null, 'T', 'DrvDk', 'Drove drunk', '', '', 'N', '', 1, 'en', 0, 0 )
Column 'gid' cannot be null

It does make a new version, and the questions are present, but some of the items do not have their response options copied. I also get an error if I try exporting the survey and then importing it.

Help would be appreciated.
I'm using Version 1.91RC6 Build 9986

Thanks
The administrator has disabled public write access.

Trouble copying or importing survey 3 years 10 months ago #86930

  • kmiller760
  • kmiller760's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 7
  • Karma: 0
Did you resolve this? I just ran into the same thing.
The administrator has disabled public write access.

Trouble copying or importing survey 3 years 10 months ago #86946

  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • Moderator Lime
  • Posts: 9305
  • Thank you received: 1330
  • Karma: 386
drjlange wrote:
I'm using Version 1.91RC6 Build 9986
:whistle:

Please update to a non-release Candidate version.

2.0 or 1.92 or 1.91
Assistance on LimeSurvey forum and LimeSurvey core developpement are on my free time (Say thanks ?).
A bug not reported is a bug not corrected. | Please, read the documentation | La doc en français à besoin de vous
Last Edit: 3 years 10 months ago by DenisChenu. Reason: lik to DL files
The administrator has disabled public write access.

Trouble copying or importing survey 3 years 10 months ago #86969

  • kmiller760
  • kmiller760's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 7
  • Karma: 0
Uh oh.
I was already running 1.92.
Last Edit: 3 years 10 months ago by kmiller760.
The administrator has disabled public write access.

Trouble copying or importing survey 3 years 10 months ago #86978

  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • Moderator Lime
  • Posts: 9305
  • Thank you received: 1330
  • Karma: 386
kmiller760 wrote:
Uh oh.
I was already running 1.92.
Can yout test with "Check data integrity".

Seems there are an old question in your survey.

Denis
Assistance on LimeSurvey forum and LimeSurvey core developpement are on my free time (Say thanks ?).
A bug not reported is a bug not corrected. | Please, read the documentation | La doc en français à besoin de vous
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.230 seconds
Imprint                   Data Protection Statement                  Revocation information and revocation form