How is the Token field in Survey table selected

More
4 years 5 months ago #92412 by aukevann
aukevann created the topic: How is the Token field in Survey table selected
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 5 months ago #92447 by DenisChenu
DenisChenu replied the topic: How is the Token field in Survey table selected
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 5 months ago #92488 by aukevann
aukevann replied the topic: How is the Token field in Survey table selected
Thanks Denis, upgrading to the latest version fixed the problem.
Regards,
Auke

Please Log in to join the conversation.

Did you already participate in our customer survey?

Don't miss your chance for great prices.

Please click here to participate:

Start now

Start now!

Just create your account and start using Limesurvey today.

Register now