View Issue Details

This bug affects 1 person(s).
 4
IDProjectCategoryView StatusLast Update
03889Bug reportsOtherpublic2009-12-11 12:16
Reporteruser667Assigned Toc_schmitz  
PrioritynormalSeveritypartial_block 
Status closedResolutionfixed 
Product Version1.86 
Fixed in Version1.87RC5 
Summary03889: Exporting Results to xls
Description

When exporting the results from a survey i get always the same error: [Microsoft][ODBC SQL Server Driver][SQL Server]Column 'lime_answers.qid' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.:select a., l., t.label_name as labeltitle from lime_answers as a, lime_labels as l, lime_labelsets as t where a.code='1' and qid=10 AND l.lid = 7 AND a.language='pt' AND t.lid=7 group by l.lid

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)7697
I will donate to the project if issue is resolved
BrowserIE8
Database type & versionSQL Server 2005
Server OS (if known)Windows Server 2003
Webserver software & version (if known)IIS
PHP Version5.3

Users monitoring this issue

There are no users monitoring this issue.

Activities

user372

2009-11-23 15:46

  ~10221

On my knowledge this issue has already been fixed ==> upgrade to the latest version v1.87RC2 or later and tell us, if you can still reproduce the problem.

user372

2009-12-03 23:38

  ~10433

@ ScotchPT: please provide feedback or we'll close that ticket - THX!

user372

2009-12-11 02:20

  ~10534

@ c_schmitz: I don't have MSSQL - do you think this error is already fixed in the current development branch?

c_schmitz

c_schmitz

2009-12-11 12:12

administrator   ~10541

Bug was still there. Fixed in RC5.

Issue History

Date Modified Username Field Change
2009-11-23 15:23 user667 New Issue
2009-11-23 15:23 user667 Status new => assigned
2009-11-23 15:23 user667 Assigned To => user372
2009-11-23 15:23 user667 LimeSurvey build number => 7697
2009-11-23 15:23 user667 Browser => IE8
2009-11-23 15:23 user667 Database & DB-Version => SQL Server 2005
2009-11-23 15:23 user667 Operating System (Server) => Windows Server 2003
2009-11-23 15:23 user667 Webserver => IIS
2009-11-23 15:23 user667 PHP Version => 5.3
2009-11-23 15:46 user372 Note Added: 10221
2009-11-23 15:46 user372 Status assigned => feedback
2009-12-03 23:38 user372 Note Added: 10433
2009-12-11 02:20 user372 Note Added: 10534
2009-12-11 02:21 user372 Status feedback => assigned
2009-12-11 02:21 user372 Assigned To user372 => c_schmitz
2009-12-11 12:12 c_schmitz Note Added: 10541
2009-12-11 12:12 c_schmitz Status assigned => resolved
2009-12-11 12:12 c_schmitz Fixed in Version => 1.87RC5
2009-12-11 12:12 c_schmitz Resolution open => fixed
2009-12-11 12:16 c_schmitz Status resolved => closed
2010-05-06 10:27 c_schmitz Category Import / Export => (No Category)