Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Problem with imported surveys

  • wf_121
  • wf_121's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
3 years 6 months ago #204817 by wf_121
Problem with imported surveys was created by wf_121
Hello there,

Recently some of our users imported a bunch of surveys from one server to another (version 3.22.8), and they're having problems with the survey answer/responses, like in the following message (my translation):
Code:
An error happened while trying to save a response in the survey Test Survey - 181285
 
DATA TO BE INSERTED:
token: 1FvmzymHpdBzJwe
181285X281X5066: 8
181285X281X5065: N/A
181285X281X5064: N/A
181285X281X5067: N/A
181285X281X5066: 8
181285X281X5065: N/A
181285X281X5064: N/A
181285X281X5067: N/A
 
SQL CODE THAT PRESENTED THE ERROR:
 
 
ERROR MESSAGE:
It isn't possible to include the row in the survey table.

Looking at the database log, we've seen that there is a primary key constraint violation:

Code:
2020-09-01 11:32:18 -03 [39001]: [5-1] db=limesurvey,host=172.23.0.25,user=app_limesurvey,app=[unknown] ERROR:  23505: duplicate key value violates unique constraint "lime_survey_146198_pkey" 
2020-09-01 11:32:18 -03 [39001]: [6-1] db=limesurvey,host=172.23.0.25,user=app_limesurvey,app=[unknown] DETAIL:  Key (id)=(14) already exists.
2020-09-01 11:32:18 -03 [39001]: [7-1] db=limesurvey,host=172.23.0.25,user=app_limesurvey,app=[unknown] LOCATION:  _bt_check_unique, nbtinsert.c:534
2020-09-01 11:32:18 -03 [39001]: [8-1] db=limesurvey,host=172.23.0.25,user=app_limesurvey,app=[unknown] STATEMENT:  INSERT INTO "lime_survey_146198" ("startlanguage", "token", "datestamp", "startdate", "seed"

This happened for several surveys and is halting our production environment. Would someone have a suggestion to how to proceed?

Thanks!
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose