Check out the LimeSurvey source code on GitHub!
Welcome, Guest
Username: Password:

TOPIC: tables survey_xxxxx and token_xxxxx mis-match?

tables survey_xxxxx and token_xxxxx mis-match? 6 years 2 weeks ago #52291

  • nobs
  • nobs's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 2
  • Karma: 0
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.
The administrator has disabled public write access.

tables survey_xxxxx and token_xxxxx mis-match? 6 years 2 weeks ago #52294

  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • Moderator Lime
  • Posts: 9572
  • Thank you received: 1374
  • Karma: 390
Hello,

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 (use private message).
The administrator has disabled public write access.

tables survey_xxxxx and token_xxxxx mis-match? 6 years 2 weeks ago #52300

  • nobs
  • nobs's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 2
  • Karma: 0
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
The administrator has disabled public write access.

tables survey_xxxxx and token_xxxxx mis-match? 6 years 2 weeks ago #52373

  • Mazi
  • Mazi's Avatar
  • Offline
  • LimeSurvey Team
  • Posts: 6028
  • Thank you received: 373
  • Karma: 260
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)survey-consulting.com'"
The administrator has disabled public write access.
Time to create page: 0.462 seconds
Imprint                   Privacy policy         General Terms & Conditions         Revocation information and revocation form