View Issue Details

This bug affects 1 person(s).
 4
IDProjectCategoryView StatusLast Update
04381Bug reportsOtherpublic2010-06-08 21:51
Reporterthenbrent Assigned Toc_schmitz  
PrioritynormalSeverityblock 
Status closedResolutionfixed 
Product Version1.90b 
Target Version1.90RC1Fixed in Version1.90RC1 
Summary04381: Variety of crashes with MS SQL due to "cannot be compared or sorted" error
Description

When trying to use a "Multiple Option" question type, Limesurvey crashes and I receive the error:
The data types text and varchar are incompatible in the equal to operator.:SELECT qid,attribute FROM [question_attributes] WHERE value=lower('11')

None of the "Multiple options" question types work; however, other question types appear to be working fine.

I can not add default answer for any of the "Multiple options" question types either.

When trying to set conditions for a question, Limesurvey crashes and I receive the error:
The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.:SELECT * FROM questions WHERE parent_qid=100 AND language='en' ORDER BY question_order, question

I'm using MS SQL Server 10 running on Windows Server 2008 Standard.

Steps To Reproduce

Upgrade to 1.90 beta 2. Import survey from 1.82 which includes questions with "Multiple options" and click "Preview Question" or "Set Conditions".

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)8745
I will donate to the project if issue is resolved
BrowserFirefox, Chrome, IE
Database type & versionMS SQL Server 10
Server OS (if known)Windows Server 2008
Webserver software & version (if known)IIS 7
PHP Version5

Users monitoring this issue

There are no users monitoring this issue.

Activities

thenbrent

thenbrent

2010-06-01 06:10

reporter   ~12046

An update. I'm not sure if this is related, but I'm not able to "Edit Answer Options" for "Multiple options" questions like I can for radio.

machaven

machaven

2010-06-04 09:52

reporter   ~12143

Just a note, Multiple choice questions use subquestions. The answer stored is in fact a yes/no to whether it was selected.

Issue History

Date Modified Username Field Change
2010-06-01 03:53 thenbrent New Issue
2010-06-01 03:53 thenbrent Status new => assigned
2010-06-01 03:53 thenbrent Assigned To => user372
2010-06-01 06:10 thenbrent Note Added: 12046
2010-06-01 14:50 Mazi Assigned To user372 => c_schmitz
2010-06-01 14:51 Mazi Target Version => 1.90RC1
2010-06-02 16:20 c_schmitz Status assigned => resolved
2010-06-02 16:20 c_schmitz Fixed in Version => 1.90RC1
2010-06-02 16:20 c_schmitz Resolution open => fixed
2010-06-04 09:52 machaven Note Added: 12143
2010-06-08 21:51 c_schmitz Status resolved => closed