How is the Token field in Survey table selected

More
4 years 1 month ago #92412 by aukevann
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

Please Log in to join the conversation.

More
4 years 1 month ago #92447 by DenisChenu
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

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).
An error happen ? Before make a new topic : remind the Debug mode .

Please Log in to join the conversation.

More
4 years 1 month ago #92488 by aukevann
Thanks Denis, upgrading to the latest version fixed the problem.
Regards,
Auke

Please Log in to join the conversation.