Check out the LimeSurvey source code on GitHub!

Distinct on text field Error after update to version 1.92+ buildnumber 120418

4 years 10 months ago #79468 by tlvernon
the LimeSurvey website i have was set to auto update and last week it tried to do just that. it updated to version 1.92 buildnumber 120418 and db version 155.
After the update i get the error below when selecting a suvey to display. any suggestions?

[Microsoft][ODBC SQL Server Driver][SQL Server]The text data type cannot be selected as DISTINCT because it is not comparable.:select distinct a.qid, a.attribute, a.value from [lime_question_attributes] as a, [lime_questions] as b where a.qid=b.qid and b.sid=11223 and a.language='en' and b.language='en' order by a.qid, a.attribute

Please Log in to join the conversation.

4 years 10 months ago #79470 by Mazi
There has been another release yesterday with some MS SQL server fixes. Please check fi that solves your problem and if not, please open a ticket at the Bugtracker and...
  1. Give as much information as possible
  2. Attach your survey. You can mark your ticket "private" so that only the developers will be able to take a look at it.
  3. Provide step-by-step instructions how to reproduce the problem.
  4. If possible/helpful please provide screenshots

Afterwards please post the link to the Bugtracker so we can follow the progress.


Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)'"

Please Log in to join the conversation.

Imprint                   Privacy policy         General Terms & Conditions         Revocation information and revocation form