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

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

Thanks Denis, upgrading to the latest version fixed the problem.
Regards,
Auke