Welcome, Guest
Username: Password: Remember me

TOPIC: duplicate entries in answer database

duplicate entries in answer database 3 years 1 month ago #66343

  • shorshe
  • shorshe's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 15
  • Thank you received: 1
  • Karma: 0
Hi Limes!

Im using Version 1.91+ Build 11026 of Limesurvey. We use LS as a feedback-Tool.
The Survey was initially created 3 years ago an is imported to newer versions of LS as needed.
We collected about 1600 Surveys this year. Lateley something strange ist happening. Sometimes a survey is filled out, but two entries appear in the database. Even the confimation-email has the survey results doubled.
Any Ideas anyone
Last Edit: 3 years 1 month ago by shorshe.
The administrator has disabled public write access.

Re: duplicate entries in answer database 3 years 1 month ago #66344

  • Mazi
  • Mazi's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 5423
  • Thank you received: 307
  • Karma: 252
It is really hard to say what might go wrong here. Do you have any further hint?

1. Is is browser related?
2. Does the user maybe press the back button or something?
3. Do you use tokens?
4. Are there any differences between the two data sets?
5. Is there anything suspicions at the server's error log?
6. Are any other warnings shown?
7. Did user use the "save" feature to return to the survey later?
8. Does the problem only show up at this one survey?
9. Did you try to build the survey from scratch (or parts of it)? If so, could you reproduce the problem?

Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)limesurvey.org'"
The administrator has disabled public write access.
The following user(s) said Thank You: shorshe

Re: duplicate entries in answer database 3 years 1 month ago #66353

  • shorshe
  • shorshe's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 15
  • Thank you received: 1
  • Karma: 0
Wow Thanks for your fast answer mazi.
1. Is is browser related?
Ist there a way to check the browser version at the time a survey is taken?
2. Does the user maybe press the back button or something?
Maybe, would this be a problem?
3. Do you use tokens?
Yes we use unique tokens for every paticipant. Token is identical in the duplicate entries.
4. Are there any differences between the two data sets?
nope... completely identical
---EDIT---
Except the timestamp for "invitation sent" is different. This is interesting...
---/EDIT---
--- EDIT2---
The timestamp for completing the survey is the same...
If somehow 2 Identical Users are created, with the same token. Would this trigger a doupilcate survey result, as the user fills out the survey?
----/EDIT2----
5. Is there anything suspicions at the server's error log?
Everything seems normal
6. Are any other warnings shown?
no
7. Did user use the "save" feature to return to the survey later?
May, be... is there a way to check this?
8. Does the problem only show up at this one survey?
Problem only shows up in this survey. But not right from the start. The first 900 were ok
9. Did you try to build the survey from scratch (or parts of it)? If so, could you reproduce the problem?
No i didn't but we ned the database to span at least one year.
Last Edit: 3 years 1 month ago by shorshe.
The administrator has disabled public write access.

Re: duplicate entries in answer database 3 years 1 month ago #66366

  • Mazi
  • Mazi's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 5423
  • Thank you received: 307
  • Karma: 252
@1: You'd have to ask the users which are confronted with the problem. The browser version is not tracked.

@2: Usually pressing the back button should not cause any problems but it might be a hint to a not yet identified bug.

@3/4: This probably causes the problem.
a) Please check if each token exists only once at the token section.
b) Can you reproduce the problem when creating two identical tokens.
c) Under which circumstances are you able to create duplicate tokens at all? There should be a check for this

@7: You'd have to ask them.

So I guess the duplicate tokens cause the problem...

Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)limesurvey.org'"
The administrator has disabled public write access.
The following user(s) said Thank You: shorshe

Re: duplicate entries in answer database 3 years 1 month ago #67002

  • shorshe
  • shorshe's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 15
  • Thank you received: 1
  • Karma: 0
Hi!

Error was caused by one admin. I could work out a solution.

We import users via CSV. Checking for duplicates is off, because a user can get multiple mails during the year. (checking for duplicates was limited to email in earlyer Version, if i remember correctly)

We check for duplicate tokens now, to prevent this from happening.
The administrator has disabled public write access.

Re: duplicate entries in answer database 3 years 1 month ago #67009

  • Mazi
  • Mazi's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 5423
  • Thank you received: 307
  • Karma: 252
You're welcome!

If our hints have been helpful and you enjoy limesurvey please consider a donation to the team .
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)limesurvey.org'"
The administrator has disabled public write access.

Re: duplicate entries in answer database 2 years 3 months ago #84557

  • kamy
  • kamy's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 13
  • Karma: 0
hi shorshe:

We're experiencing the same issue as you.
Did you even find the cause of duplicate entries?
or did you find a solution?

tx
The administrator has disabled public write access.

Re: duplicate entries in answer database 2 years 3 months ago #84558

  • shorshe
  • shorshe's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 15
  • Thank you received: 1
  • Karma: 0
Yes, I could resolve the issue as detailed in my last post in this thread.
Do you have any Questions regarding my solution?
The administrator has disabled public write access.

Re: duplicate entries in answer database 2 years 3 months ago #84559

  • kamy
  • kamy's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 13
  • Karma: 0
Oops ! I must have missed your entry.
In any case, that solution does not apply to us.

It seems our issue is with users going back a step with browser button, on the lovely IE7 :)

tx for quick reply though.
The administrator has disabled public write access.

Re: duplicate entries in answer database 2 years 3 months ago #84562

  • Mazi
  • Mazi's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 5423
  • Thank you received: 307
  • Karma: 252
kamy, please explain the problem in detail and let us know which Limesurvey version you are using.

Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)limesurvey.org'"
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.126 seconds
Donation Image