Welcome, Guest
Username: Password: Remember me

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

Distinct on text field Error after update to version 1.92+ buildnumber 120418 2 years 6 months ago #79468

  • tlvernon
  • tlvernon's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 2
  • Karma: 0
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
The administrator has disabled public write access.

Re: Distinct on text field Error after update to version 1.92+ buildnumber 120418 2 years 6 months ago #79470

  • Mazi
  • Mazi's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 5423
  • Thank you received: 307
  • Karma: 252
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.

Thanks!

Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)limesurvey.org'"
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.107 seconds
Donation Image