View Issue Details

This issue affects 1 person(s).
 0
IDProjectCategoryView StatusLast Update
03584Bug reportsInstallationpublic2009-08-19 12:33
Reporteruser4284Assigned Touser372 
PrioritynormalSeveritypartial_block 
Status closedResolutionfixed 
Product Version1.85+ 
Fixed in Version1.85+ 
Summary03584: SQL Error when trying to Export Results to Application
Description

[Microsoft][ODBC SQL Server Driver][SQL Server]Column 'lime_labels.lid' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.:select a.code, l.lid from lime_answers as a, lime_labels as l where qid=11 AND (l.lid =1) and a.language='en' group by a.code order by a.code

TagsNo tags attached.
Bug heat0
Complete LimeSurvey version number (& build)
I will donate to the project if issue is resolved
Browser
Database type & versionSQL Server 2005
Server OS (if known)Windows Server 2003
Webserver software & version (if known)IIS 6
PHP Version5.3.0
Git branch / Pull Request URL

Users monitoring this issue

There are no users monitoring this issue.

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2009-08-18 17:22 user4284 New Issue
2009-08-18 17:22 user4284 Status new => assigned
2009-08-18 17:22 user4284 Assigned To => user372
2009-08-18 17:22 user4284 Database & DB-Version => SQL Server 2005
2009-08-18 17:22 user4284 Operating System (Server) => Windows Server 2003
2009-08-18 17:22 user4284 Webserver => IIS 6
2009-08-18 17:22 user4284 PHP Version => 5.3.0
2009-08-19 00:56 c_schmitz Status assigned => resolved
2009-08-19 00:56 c_schmitz Fixed in Version => 1.85+
2009-08-19 00:56 c_schmitz Resolution open => fixed
2009-08-19 12:33 c_schmitz Status resolved => closed