Hi,

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 survey_xxxxx.id 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.

Hello,

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

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.

cheers

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.