Welcome, Guest
Username: Password: Remember me

TOPIC: tables survey_xxxxx and token_xxxxx mis-match?

tables survey_xxxxx and token_xxxxx mis-match? 3 years 5 months 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.

Re:tables survey_xxxxx and token_xxxxx mis-match? 3 years 5 months ago #52294

  • DenisChenu
  • DenisChenu's Avatar
  • OFFLINE
  • Moderator Lime
  • Posts: 5830
  • Thank you received: 711
  • Karma: 220
Hello,

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

:)
The administrator has disabled public write access.

Re:tables survey_xxxxx and token_xxxxx mis-match? 3 years 5 months 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.

Re:tables survey_xxxxx and token_xxxxx mis-match? 3 years 5 months ago #52373

  • Mazi
  • Mazi's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 5275
  • Thank you received: 289
  • Karma: 246
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)limesurvey.org'"
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.112 seconds
Donation Image