View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 2
IDProjectCategoryView StatusDate SubmittedLast Update
06476Bug reportsResponse browsingpublic2012-08-13 03:312012-08-16 10:23
Reporteruser21253Assigned Toc_schmitz  
PrioritynormalSeverityblock 
Status closedResolutionfixed 
Product Version1.92+ 
Target Version2.00RC9Fixed in Version2.00RC9 
Summary06476: mssqlnative and TEXT/NTEXT fields failing on equality test. SQLState: 42000 Error Code: 306
Description

When accessing the admin.php?action=dataentry screen, I get this:
SQLState: 42000 Error Code: 306 Message: [Microsoft][SQL Server Native Client 10.0][SQL Server]The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator. :SELECT FROM [lime_questions] WHERE parent_qid=61 AND language='en' ORDER BY question_order, question
Config: "mssqlnative"
When using "odbc_mssql", the error is similar:
[Microsoft][ODBC SQL Server Driver][SQL Server]The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.:SELECT FROM [lime_questions] WHERE parent_qid=61 AND language='en' ORDER BY question_order, question

Steps To Reproduce

Use SQLSRV2 driver with SQL Server 05
Access the data entry screen

Additional Information

If I change the fields to VARCHAR(MAX), the problem is temporarily solved.

TagsNo tags attached.
Bug heat2
Complete LimeSurvey version number (& build)120801
I will donate to the project if issue is resolvedNo
BrowserAny
Database type & versionSQL Server 2005. DB is in 2005 (90) Mode
Server OS (if known)2003 32-bit / IIS6 / FastCGI
Webserver software & version (if known)IIS 6.0
PHP Version5.3.15 NTS VC9, SQLSRV2 Driver: 2.0.1802.200 NTS VC9

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2012-08-13 10:30

administrator   ~20381

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=9344
c_schmitz

c_schmitz

2012-08-16 10:23

administrator   ~20449

Version 2.00 RC 9 released.

Related Changesets

LimeSurvey: master 4426331f

2012-08-13 01:30:03

c_schmitz

Details Diff 		Fixed issue 06476: Error in data entry when using multiple choice with comment questions and MSSQL Affected Issues
06476
mod - admin/dataentry.php Diff File

Issue History

Date Modified Username Field Change
2012-08-13 03:31 user21253 New Issue
2012-08-13 03:32 user21253 Issue Monitored: user21253
2012-08-13 10:28 c_schmitz Assigned To => c_schmitz
2012-08-13 10:28 c_schmitz Status new => assigned
2012-08-13 10:30 c_schmitz Changeset attached => LimeSurvey master 4426331f
2012-08-13 10:30 c_schmitz Note Added: 20381
2012-08-13 10:30 c_schmitz Resolution open => fixed
2012-08-13 10:30 c_schmitz Status assigned => resolved
2012-08-13 10:30 c_schmitz Fixed in Version => 2.00RC9
2012-08-15 00:22 c_schmitz Target Version => 2.00RC9
2012-08-16 10:23 c_schmitz Note Added: 20449
2012-08-16 10:23 c_schmitz Status resolved => closed