View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 03584 | Bug reports | Installation | public | 2009-08-18 17:22 | 2009-08-19 12:33 |
| Reporter | Assigned To | ||||
| Priority | normal | Severity | partial_block | ||
| Status | closed | Resolution | fixed | ||
| Product Version | 1.85+ | ||||
| Fixed in Version | 1.85+ | ||||
| Summary | 03584: 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 | ||||
| Tags | No tags attached. | ||||
| Bug heat | 0 | ||||
| Complete LimeSurvey version number (& build) | |||||
| I will donate to the project if issue is resolved | |||||
| Browser | |||||
| Database type & version | SQL Server 2005 | ||||
| Server OS (if known) | Windows Server 2003 | ||||
| Webserver software & version (if known) | IIS 6 | ||||
| PHP Version | 5.3.0 | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2009-08-18 17:22 |
|
New Issue | |
| 2009-08-18 17:22 |
|
Status | new => assigned |
| 2009-08-18 17:22 |
|
Assigned To | => user372 |
| 2009-08-18 17:22 |
|
Database & DB-Version | => SQL Server 2005 |
| 2009-08-18 17:22 |
|
Operating System (Server) | => Windows Server 2003 |
| 2009-08-18 17:22 |
|
Webserver | => IIS 6 |
| 2009-08-18 17:22 |
|
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 |
