Welcome to the LimeSurvey Community Forum

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

Token table and response table not synchronized

  • maxersloan
  • maxersloan's Avatar Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
8 years 1 month ago #130596 by maxersloan
Hello,

I am running a token-based survey where LimeSurvey generated the tokens and I send out invitations/reminders via email. There are many responses that show "complete" in the response table but then that same response shows "incomplete" in the token table. Because of that, I have many clients that are upset because they've been getting reminder emails for surveys they have already completed. There are also cases where there are "incompletes" in the response table but then showing "complete" in the token table. This is an even bigger problem because now those people aren't getting reminder emails.

Has anyone had this problem before? Does anyone have a solution? Should I report as a bug?
The topic has been locked.
  • maxersloan
  • maxersloan's Avatar Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
8 years 1 month ago #130598 by maxersloan
Replied by maxersloan on topic Token table and response table not synchronized
Sorry. Forgot the essential details:

Version 2.06+
Build 160123

Also, it looks like people are accessing the survey more than once with the same token, even though I have "Allow multiple responses or update responses with one token?" set to NO and I also have persistence turned ON
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
8 years 1 month ago #130638 by DenisChenu
Replied by DenisChenu on topic Token table and response table not synchronized
Hi,

Seems strange ... Can you reproduce the 2 issue with a very little survey ?
Did you have some extra external plugin ?

Denis

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.
  • maxersloan
  • maxersloan's Avatar Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
8 years 1 month ago #130692 by maxersloan
Replied by maxersloan on topic Token table and response table not synchronized
Hi Denis,

I am trying to reproduce the issue now. There are no plugins. I will add 2 details:

1. I imported this survey structure from a previous version (Version 2.00+ Build 131107).
2. Respondents are reporting that when they go to click "Submit" at the end of the survey, an error message says that it did not go through (I haven't been able to get anyone to send a screengrab of the error). Then, when they try to take the survey again, it says their token has already been used. The good news is that their original response DOES get recorded, even though it says it didn't.... But this is creating some frustrated clients.....
The topic has been locked.
  • maxersloan
  • maxersloan's Avatar Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
8 years 1 month ago #130694 by maxersloan
Replied by maxersloan on topic Token table and response table not synchronized
More details:

I was able to reproduce the issues testing on a small scale survey. I tried importing from the old version as well as creating a brand new survey from scratch in the current version...

On the error messages. Here are the two that I have gotten when reproducing:

"The website cannot display the page
Most likely causes:
The website is under maintenance.
The website has a programming error"

Also there's this one:

500 Server Error
A misconfiguration on the server caused a hiccup. Check the server logs, fix the problem, then try again.
The topic has been locked.
  • maxersloan
  • maxersloan's Avatar Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
8 years 1 month ago #130728 by maxersloan
Replied by maxersloan on topic Token table and response table not synchronized
More details:

So I tested the survey in another installation (Version 2.05+ Build 141126) and had none of these issues. I tested on an imported survey as well as a "created-from-scratch" survey. So is it possible that this is just a bug with Version 2.06+ Build 160123???
The topic has been locked.
  • Mazi
  • Mazi's Avatar
  • Offline
  • Official LimeSurvey Partner
  • Official LimeSurvey Partner
More
8 years 1 month ago - 8 years 1 month ago #130737 by Mazi
It is definitely very helpful that you could track it down a little. Although such 500 server errors are usually very hard to track down and fix.

Here is the changelog for the latest release:
github.com/LimeSurvey/LimeSurvey/blob/ma...cs/release_notes.txt

When going back into the past I see no potential fix at a later version so that problem may still exist.
So next question is: Which commit may have pasted this issue? maxersloan, you could help by checking at which latest version that was still working.

Here is a potential commit which is token related and may have caused the problem (hard to guess without checking all details):
-Fixed issue #10197: token in return link can be invalid after saving survey (Denis Chenu)

Best regards/Beste Grüße,
Dr. Marcel Minke
Need Help? We offer professional Limesurvey support: survey-consulting.com
Contact: marcel.minke(at)survey-consulting.com
Last edit: 8 years 1 month ago by Mazi. Reason: added link
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
8 years 1 month ago #130738 by DenisChenu
Replied by DenisChenu on topic Token table and response table not synchronized

Mazi wrote: ....
-Fixed issue #10197: token in return link can be invalid after saving survey (Denis Chenu)

No,

It's just after save, you come back to a screen with a button 'return to survey' if the token have ~ inside : it's deleted. Very rare issue.

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.
  • Mazi
  • Mazi's Avatar
  • Offline
  • Official LimeSurvey Partner
  • Official LimeSurvey Partner
More
8 years 1 month ago #130748 by Mazi
Thanks for your feedback, Denis.

Max, can you test if the issue still exists with the latest 2.5 version (first stable release is pretty new)?

If so, please create a bug report and post the link here.

Best regards/Beste Grüße,
Dr. Marcel Minke
Need Help? We offer professional Limesurvey support: survey-consulting.com
Contact: marcel.minke(at)survey-consulting.com
The topic has been locked.
  • maxersloan
  • maxersloan's Avatar Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
8 years 1 month ago #131458 by maxersloan
Replied by maxersloan on topic Token table and response table not synchronized
Hi Mazi,

I was able to reproduce the issue in 2.50+ Build 160213. Here is the bug link:

bugs.limesurvey.org/view_all_bug_page.php
The topic has been locked.
  • Mazi
  • Mazi's Avatar
  • Offline
  • Official LimeSurvey Partner
  • Official LimeSurvey Partner
More
8 years 1 month ago #131473 by Mazi

maxersloan wrote: Hi Mazi,

I was able to reproduce the issue in 2.50+ Build 160213. Here is the bug link:

bugs.limesurvey.org/view_all_bug_page.php

Sorry, that lnk points to the bugtracker and no single ticket. Do you have a ticket ID for us?
Thanks!

Best regards/Beste Grüße,
Dr. Marcel Minke
Need Help? We offer professional Limesurvey support: survey-consulting.com
Contact: marcel.minke(at)survey-consulting.com
The topic has been locked.
  • maxersloan
  • maxersloan's Avatar Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
8 years 1 month ago #131474 by maxersloan
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose