View Issue Details

This bug affects 1 person(s).
 10
IDProjectCategoryView StatusLast Update
10456Bug reportsSurvey participants (Tokens)public2016-02-29 17:22
Reportermaxersloan Assigned Toc_schmitz  
PrioritynormalSeverityminor 
Status closedResolutionunable to reproduce 
Product Version2.50.x 
Summary10456: Survey crash upon submission, causing token table/response table mismatch
Description

I have noticed that my token-based surveys have recently been experiencing issues when a respondent clicks "Submit" at the end of the survey. Once they click submit, they get a "500 Server Error" message. Then when I go to the response table, I see it says that they completed the survey and all their data was recorded correctly. However, when I go to the token table, it says that token has NOT completed the survey. This causes people to get reminder emails when they actually have already completed the survey. When they get reminders and they click the link, they can then fill out a NEW survey, which successfully records in the response table, despite the general settings saying (1) persistence is on, and (2) that one token cannot have more than one response.

Steps To Reproduce
  1. Create token-based survey in 2.50+ Build 160213 (supposedly the most recent stable version, according to comfortupdate)

  2. Send a few invites to yourself

  3. Take the surveys. It may take 3 or 4 attempts before you see the error.

  4. Compare the token table and the response table to see if there is a mismatch.

Additional Information

I have attached the survey I have been using to test. But I have also reproduced this issue with a simple, 1-question survey.

TagsNo tags attached.
Attached Files
Bug heat10
Complete LimeSurvey version number (& build)160213
I will donate to the project if issue is resolvedNo
BrowserChrome & IE
Database type & version?
Server OS (if known)?
Webserver software & version (if known)?
PHP Version5.6.17

Users monitoring this issue

There are no users monitoring this issue.

Activities

LouisGac

LouisGac

2016-02-15 17:53

developer   ~35154

Is this problem specific to 2.5 ?

maxersloan

maxersloan

2016-02-15 18:06

reporter   ~35159

I believe so. I have another installation (2.00 Build 131107) and I have never had this issue there. I have reproduced this error on 2.50 Build 160213 (the version I listed above) as well as 2.06 Build 160129.

maxersloan

maxersloan

2016-02-15 18:51

reporter   ~35167

I discovered another issue and I think it is related to this one, so I'll post here:

When testing this issue, I also found that when I would click on a survey URL (in the invitation email), it gives a token mismatch error, saying "The token you provided doesn't match the one in your session." This is a major problem, especially since LimeSurvey is the one assigning tokens and creating the survey links.

DenisChenu

DenisChenu

2016-02-16 12:41

developer   ~35218

The token you provided doesn't match the one in your session. : it's not an issuie : you start a survey with a token,
Don't reset survey
We need to show the information.

In 2.06 : you have a link to start survey again, maybe we need to link :

  • Start a new survey with the new token (newtest=Y)
  • Come back to the survey with the old token (and reload response)

But it's more a new feature

maxersloan

maxersloan

2016-02-16 14:19

reporter   ~35221

Sorry Denis, I don't understand your first point. Limesurvey is generating the tokens and assigning the links, so there should be no "token mismatch" issues when someone clicks the link in their email.

I can't help but think that has to be related to THIS token issue as well.

jelo

jelo

2016-02-18 00:34

partner   ~35369

@maxersloan: Denis is relating to your second issue. Not a good idea to mix two issues even if they related.

Try to reproduce your second issue while using the private mode of your browser.
In Chrome you can use the keyboard shortcut and press Ctrl + Shift + N (Windows, Linux, and Chrome OS) and ⌘ + Shift + N (Mac) to open an incognito window.

Copy the URL of the invitationlink into the private window and see if you still get the token mismatch.

Your first issue looks more like an issue with Limesurvey.
But database and webserver infos are missing. Still possible that it is a problem with some security settings or php.

maxersloan

maxersloan

2016-02-18 15:49

reporter   ~35412

Thanks, Jelo. Sorry for the mixup.

I'll try to reproduce 2nd issue and let you know the results.

Can you tell me where to find the info for database and webserver? I would have filled it in, but didn't know where to find it.

maxersloan

maxersloan

2016-02-22 21:27

reporter   ~35548

Any update on where I can find the info you requested? Sorry--I'm not as savvy as I need to be on this stuff....

DenisChenu

DenisChenu

2016-02-23 08:12

developer   ~35556

Last edited: 2016-02-23 08:12

Hi,

For information on DB :
application/config/config.php : just the connectionString

And set debug at 2 : http://manual.limesurvey.org/Debug_mode

maxersloan

maxersloan

2016-02-23 15:43

reporter   ~35599

Here is the DB info:

'connectionString' => 'mysql:host=localhost;port=3306;dbname=datamax1_li6130;',

And I changed debug to 2

c_schmitz

c_schmitz

2016-02-23 15:58

administrator   ~35601

So if your redo the survey with debug set to 2, do you get a more differentiated error now?

maxersloan

maxersloan

2016-02-23 16:56

reporter   ~35604

My apologies. I gave the wrong DB information (I have 4 installations because I'm trying to work around these token issues).

The DB that corresponds to the installation referenced on this bug ticket is:

'connectionString' => 'mysql:host=localhost;port=3306;dbname=datamax1_limesurvey6d8;',

I was unable to get any error messages when taking the survey, which is great--but obviously not good for troubleshooting. However, I DID notice that the tokens that contained the "~" character had slightly different tokens in the links compared to the token table. For example, a token in the token table is "80FqfUrMBl~6OSR", however the token in the survey link is "80FqfUrMBl%7E6OSR". So it replaced "~" with "%7E".

DenisChenu

DenisChenu

2016-02-23 17:07

developer   ~35605

It don't explain the crash submission :/ . Here it's mysql.

But : maybe related to newtest=Y : token compare bugguy ?

maxersloan

maxersloan

2016-02-23 17:11

reporter   ~35606

Just to be clear, the character I'm referring to is a tilde--not a dash. It looks like the website changed it when I hit "add note", so it is showing up as a dash in my note, but I'm talking about the tilde (a wavy dash).

c_schmitz

c_schmitz

2016-02-29 17:17

administrator   ~35797

So if your redo the survey with debug set to 2, do you get a more differentiated error now?

maxersloan

maxersloan

2016-02-29 17:21

reporter   ~35799

Unfortunately, I'm no longer able to reproduce the error. I am not sure how/why it started working again....

c_schmitz

c_schmitz

2016-02-29 17:22

administrator   ~35800

Ok, no problem.

Issue History

Date Modified Username Field Change
2016-02-15 17:28 maxersloan New Issue
2016-02-15 17:28 maxersloan File Added: limesurvey_survey_492132.lss
2016-02-15 17:53 LouisGac Note Added: 35154
2016-02-15 18:06 maxersloan Note Added: 35159
2016-02-15 18:51 maxersloan Note Added: 35167
2016-02-15 20:19 Mazi Assigned To => c_schmitz
2016-02-15 20:19 Mazi Status new => assigned
2016-02-16 12:41 DenisChenu Note Added: 35218
2016-02-16 14:19 maxersloan Note Added: 35221
2016-02-18 00:34 jelo Note Added: 35369
2016-02-18 15:49 maxersloan Note Added: 35412
2016-02-22 21:27 maxersloan Note Added: 35548
2016-02-23 08:12 DenisChenu Note Added: 35556
2016-02-23 08:12 DenisChenu Note Edited: 35556
2016-02-23 15:43 maxersloan Note Added: 35599
2016-02-23 15:58 c_schmitz Note Added: 35601
2016-02-23 16:56 maxersloan Note Added: 35604
2016-02-23 17:07 DenisChenu Note Added: 35605
2016-02-23 17:11 maxersloan Note Added: 35606
2016-02-29 17:17 c_schmitz Note Added: 35797
2016-02-29 17:17 c_schmitz Status assigned => feedback
2016-02-29 17:21 maxersloan Note Added: 35799
2016-02-29 17:21 maxersloan Status feedback => assigned
2016-02-29 17:22 c_schmitz Note Added: 35800
2016-02-29 17:22 c_schmitz Status assigned => closed
2016-02-29 17:22 c_schmitz Resolution open => unable to reproduce
2016-12-08 10:39 c_schmitz Category Tokens => Survey participants (Tokens)