View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
06043Bug reportsInstallationpublic2012-04-24 06:232012-05-01 11:56
ReporterPDATechSupport Assigned Toc_schmitz  
PrioritynormalSeveritypartial_block 
Status closedResolutionfixed 
Product Version1.92+ 
Fixed in Version1.92+ 
Summary06043: Errors Creating Surveys in 1.92 with Sql Server 2008 R2 Backend
Description

Hi,

I have multiple instances of LimeSurvey running on our server (WS 2008 R2) and using Sql Server 2008 R2 for the database. I wanted to try installing the 1.92. After installing and getting to the main screen, whenever i try to create a survey or import a survey, I get this message

"[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 [su_question_attributes] as a, [su_questions] as b where a.qid=b.qid order by a.qid, a.attribute"

So, I thought I would try to install 1.91 first and then upgrade to 1.92. So, I installed 1.91 and no issues, i.e., could create surveys no problem. However, when I upgraded to 1.92, I got the same message after it asked if it could update the database:

The LimeSurvey database is being upgraded (2012-04-23 22:14:23) .Please be patient...

. . . . . . . . . . . . . . . . . . . . . . . . [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 [su_question_attributes] as a, [su_questions] as b where a.qid=b.qid order by a.qid, a.attribute

The user has full rights over the database. There seems some issue with 1.92 and the SQL database but I'm not sure what it is.

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)120418
I will donate to the project if issue is resolvedYes
Browser
Database type & versionSQL SERVER 2008 R2 Enterprise
Server OS (if known)Windows Server 2008
Webserver software & version (if known)IIS 7
PHP Version5.2.17

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2012-04-24 14:32

administrator   ~18467

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

c_schmitz

2012-04-24 14:33

administrator   ~18468

We are looking forward to your donation!
PDATechSupport

PDATechSupport

2012-04-24 16:22

reporter   ~18472

Last edited: 2012-04-24 18:31

Hi. I uninstalled the database, pasted over the new LimeExpressionManager file that you updated. I then set up the database again using the LimeSurvey install files and still get the same errors:

[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 [su_question_attributes] as a, [su_questions] as b where a.qid=b.qid and b.sid=11162 and a.language='en' and b.language='en' order by a.qid, a.attribute

Thanks so much for your support, I really appreciate it.
c_schmitz

c_schmitz

2012-04-25 12:26

administrator   ~18476

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

c_schmitz

2012-04-25 12:26

administrator   ~18477

Sorry, left on obsolete line in. Please try again now.
c_schmitz

c_schmitz

2012-05-01 11:56

administrator   ~18513

New 1.92+ build released

Related Changesets

LimeSurvey: master abd5075b

2012-04-24 05:32:35

c_schmitz

Details Diff 		Fixed issue 06043: Errors creating surveys in MSSQL Affected Issues
06043
mod - classes/expressions/LimeExpressionManager.php Diff File

LimeSurvey: master e810c211

2012-04-25 03:26:03

c_schmitz

Details Diff 		Fixed issue 06043: Errors creating surveys in MSSQL Affected Issues
06043
mod - classes/expressions/LimeExpressionManager.php Diff File

Issue History

Date Modified Username Field Change
2012-04-24 06:23 PDATechSupport New Issue
2012-04-24 06:28 PDATechSupport Issue Monitored: PDATechSupport
2012-04-24 06:28 PDATechSupport Issue End Monitor: PDATechSupport
2012-04-24 14:16 c_schmitz Assigned To => c_schmitz
2012-04-24 14:16 c_schmitz Status new => assigned
2012-04-24 14:32 c_schmitz Changeset attached => LimeSurvey master abd5075b
2012-04-24 14:32 c_schmitz Note Added: 18467
2012-04-24 14:32 c_schmitz Resolution open => fixed
2012-04-24 14:33 c_schmitz Note Added: 18468
2012-04-24 14:33 c_schmitz Status assigned => resolved
2012-04-24 14:33 c_schmitz Fixed in Version => 1.92+
2012-04-24 16:22 PDATechSupport Note Added: 18472
2012-04-24 16:22 PDATechSupport Status resolved => feedback
2012-04-24 16:22 PDATechSupport Resolution fixed => reopened
2012-04-24 18:27 PDATechSupport Note Edited: 18472
2012-04-24 18:31 PDATechSupport Note Edited: 18472
2012-04-25 12:26 c_schmitz Changeset attached => LimeSurvey master e810c211
2012-04-25 12:26 c_schmitz Note Added: 18476
2012-04-25 12:26 c_schmitz Note Added: 18477
2012-04-25 12:26 c_schmitz Status feedback => resolved
2012-04-25 12:26 c_schmitz Resolution reopened => fixed
2012-05-01 11:56 c_schmitz Note Added: 18513
2012-05-01 11:56 c_schmitz Status resolved => closed