Welcome, Guest
Username: Password: Remember me

TOPIC: Trouble copying or importing survey

Trouble copying or importing survey 4 years 3 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 2 years 9 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 2 years 9 months ago #86946

  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • Moderator Lime
  • Posts: 7472
  • Thank you received: 1019
  • Karma: 295
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: 2 years 9 months ago by DenisChenu. Reason: lik to DL files
The administrator has disabled public write access.

Trouble copying or importing survey 2 years 9 months ago #86969

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

Trouble copying or importing survey 2 years 9 months ago #86978

  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • Moderator Lime
  • Posts: 7472
  • Thank you received: 1019
  • Karma: 295
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.137 seconds