Welcome, Guest
Username: Password: Remember me

TOPIC: How is the Token field in Survey table selected

How is the Token field in Survey table selected 1 year 7 months ago #92412

  • aukevann
  • aukevann's Avatar
  • OFFLINE
  • Senior Lime
  • Posts: 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
The administrator has disabled public write access.

Re: How is the Token field in Survey table selected 1 year 7 months ago #92447

  • DenisChenu
  • DenisChenu's Avatar
  • OFFLINE
  • Moderator Lime
  • Posts: 6338
  • Thank you received: 819
  • Karma: 243
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
The administrator has disabled public write access.

Re: How is the Token field in Survey table selected 1 year 7 months ago #92488

  • aukevann
  • aukevann's Avatar
  • OFFLINE
  • Senior Lime
  • Posts: 51
  • Karma: 1
Thanks Denis, upgrading to the latest version fixed the problem.
Regards,
Auke
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.102 seconds
Donation Image