Willkommen, Gast
Benutzername: Passwort: Angemeldet bleiben:

THEMA: How is the Token field in Survey table selected

How is the Token field in Survey table selected 1 Jahr 7 Monate her #92412

  • aukevann
  • aukevanns Avatar
  • OFFLINE
  • Senior Lime
  • Beiträge: 51
  • Karma: 1
Hi,

I am not LimeSurvey developer so excuse my ignorance in how the system works.

I am upgrading from LimeSurvey 1.92 to 2.0 and run into some issues.
I have programmed some macro's in Excel to retrieve the data from the database. I select the data from the Lime_Token_[SID] Table and the Lime_Survey_[TID] by selecting the data with the same Token.

I found out that in 2.0 this does not work because the Token field in the Lime_Survey_[SID] table only contains the first 5 characters. I have solved this by selecting the 5 left characters of the token in the Lime_Token_[SID].

This now works for my test data but I need to be sure this keeps working.
How are the 5 characters in the Lime_Survey_[SID] table determined? Is this always the first 5 characters of the Token in the Token table? What happens if the system generated two tokens with the same first 5 characters?
(I have not done the statistics on this, sure it's a small chance but I want my software to work for sure :-) )

Any help greatly appreciated,
Auke
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Re: How is the Token field in Survey table selected 1 Jahr 7 Monate her #92447

  • DenisChenu
  • DenisChenus Avatar
  • OFFLINE
  • Moderator Lime
  • Beiträge: 6360
  • Dank erhalten: 824
  • Karma: 245
Hello,

There are a bug in first 2.0 release, what is you version build number ?

Token information in survey table must be set to varchar(36).

Denis
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Re: How is the Token field in Survey table selected 1 Jahr 7 Monate her #92488

  • aukevann
  • aukevanns Avatar
  • OFFLINE
  • Senior Lime
  • Beiträge: 51
  • Karma: 1
Thanks Denis, upgrading to the latest version fixed the problem.
Regards,
Auke
Der Administrator hat öffentliche Schreibrechte deaktiviert.
Moderatoren: ITEd
Ladezeit der Seite: 0.128 Sekunden
Donation Image