View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
03889 | Bug reports | Other | public | 2009-11-23 15:23 | 2009-12-11 12:16 |
Reporter | Assigned To | c_schmitz | |||
Priority | normal | Severity | partial_block | ||
Status | closed | Resolution | fixed | ||
Product Version | 1.86 | ||||
Fixed in Version | 1.87RC5 | ||||
Summary | 03889: 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 | ||||
Tags | No tags attached. | ||||
Bug heat | 4 | ||||
Complete LimeSurvey version number (& build) | 7697 | ||||
I will donate to the project if issue is resolved | |||||
Browser | IE8 | ||||
Database type & version | SQL Server 2005 | ||||
Server OS (if known) | Windows Server 2003 | ||||
Webserver software & version (if known) | IIS | ||||
PHP Version | 5.3 | ||||
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. |
|
@ ScotchPT: please provide feedback or we'll close that ticket - THX! |
|
@ c_schmitz: I don't have MSSQL - do you think this error is already fixed in the current development branch? |
|
Bug was still there. Fixed in RC5. |
|
Date Modified | Username | Field | Change |
---|---|---|---|
2009-11-23 15:23 |
|
New Issue | |
2009-11-23 15:23 |
|
Status | new => assigned |
2009-11-23 15:23 |
|
Assigned To | => user372 |
2009-11-23 15:23 |
|
LimeSurvey build number | => 7697 |
2009-11-23 15:23 |
|
Browser | => IE8 |
2009-11-23 15:23 |
|
Database & DB-Version | => SQL Server 2005 |
2009-11-23 15:23 |
|
Operating System (Server) | => Windows Server 2003 |
2009-11-23 15:23 |
|
Webserver | => IIS |
2009-11-23 15:23 |
|
PHP Version | => 5.3 |
2009-11-23 15:46 |
|
Note Added: 10221 | |
2009-11-23 15:46 |
|
Status | assigned => feedback |
2009-12-03 23:38 |
|
Note Added: 10433 | |
2009-12-11 02:20 |
|
Note Added: 10534 | |
2009-12-11 02:21 |
|
Status | feedback => assigned |
2009-12-11 02:21 |
|
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) |