Welcome, Guest
Username: Password: Remember me

TOPIC: Trouble copying or importing survey

Trouble copying or importing survey 3 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.

Re: Trouble copying or importing survey 1 year 10 months ago #86930

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

Re: Trouble copying or importing survey 1 year 10 months ago #86946

  • DenisChenu
  • DenisChenu's Avatar
  • OFFLINE
  • Moderator Lime
  • Posts: 6256
  • Thank you received: 799
  • Karma: 239
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
Last Edit: 1 year 10 months ago by DenisChenu. Reason: lik to DL files
The administrator has disabled public write access.

Re: Trouble copying or importing survey 1 year 10 months ago #86969

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

Re: Trouble copying or importing survey 1 year 10 months ago #86978

  • DenisChenu
  • DenisChenu's Avatar
  • OFFLINE
  • Moderator Lime
  • Posts: 6256
  • Thank you received: 799
  • Karma: 239
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
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.119 seconds
Donation Image