Check out the LimeSurvey source code on GitHub!

tables survey_xxxxx and token_xxxxx mis-match?

6 years 3 months ago #52291 by nobs

We have been using Limesurvey 1.85 since 2007 with no major issues (for us at least). Recently we have been trying to put together an online survey system where the tokens are generated by an external (PHP5 based application). This external application creates a token table "token_xxxxx" for a survey if one doesn't exist already and populates the fields with the required token data. The unique token is generated by applying md5 to some unique data and picking a random sequence of 17 characters. This works perfectly well.

Now, when a user takes a survey with the token generated above, the answers are recorded in the "survey_xxxxx" table. Which works well too. However, when matching the tokens (in token_xxxxx) with the survey answer (in survey_xxxxx) we use match the token_xxxxx.tid field against the fields which doesn't work all the time.

My question is - how does LimeSurvey associate/match records in the two tables?

Thanks for any/all views/answers.
Please let us know if we've missed any information above.

Please Log in to join the conversation.

6 years 3 months ago #52294 by DenisChenu

If you put survey no anonymous, it's the 'token' in the survey_xxxxxx table.


Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).

Please Log in to join the conversation.

6 years 3 months ago #52300 by nobs
Thanks Shnoulle,

That makes sense, now that I think of it. I'll try that and get back here on what came out of it.


Please Log in to join the conversation.

6 years 3 months ago #52373 by Mazi
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)'"

Please Log in to join the conversation.

Imprint                   Privacy policy         General Terms & Conditions         Revocation information and revocation form