View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 05574 | Bug reports | Print View | public | 2011-11-11 20:51 | 2012-01-24 21:20 |
| Reporter | dcamacho | Assigned To | c_schmitz | ||
| Priority | low | Severity | trivial | ||
| Status | closed | Resolution | fixed | ||
| Product Version | 1.91+ | ||||
| Fixed in Version | 1.91+ | ||||
| Summary | 05574: Error Database Select | ||||
| Description | ERROR: column "lime_conditions.cfieldname" must appear in the GROUP BY clause or be used in an aggregate function:SELECT cqid, method, cfieldname, value FROM "lime_conditions" WHERE "lime_conditions".qid=52 AND "lime_conditions".scenario=1 group by cqid, method ORDER BY cqid | ||||
| Steps To Reproduce | Select Survey | ||||
| Additional Information | DataBase Postgres | ||||
| Tags | No tags attached. | ||||
| Attached Files | |||||
| Bug heat | 4 | ||||
| Complete LimeSurvey version number (& build) | 11343 | ||||
| I will donate to the project if issue is resolved | No | ||||
| Browser | |||||
| Database type & version | Postgres 8.3.7 | ||||
| Server OS (if known) | Freebsd | ||||
| Webserver software & version (if known) | APACHE | ||||
| PHP Version | PHP 5.3.0 | ||||
| Git branch / Pull Request URL | |||||
|
Please try the attached file and let me know if this fixes the issue. |
|
|
This work very well |
|
|
Fixed in rev 11357 |
|
|
New 1.91+ version released. |
|
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2011-11-11 20:51 | dcamacho | New Issue | |
| 2011-11-11 22:38 | c_schmitz | Assigned To | => c_schmitz |
| 2011-11-11 22:38 | c_schmitz | Status | new => assigned |
| 2011-11-11 22:38 | c_schmitz | File Added: printablesurvey.php | |
| 2011-11-11 22:39 | c_schmitz | Note Added: 16660 | |
| 2011-11-11 22:39 | c_schmitz | Status | assigned => feedback |
| 2011-11-11 23:09 | dcamacho | Note Added: 16662 | |
| 2011-11-11 23:09 | dcamacho | Status | feedback => assigned |
| 2011-11-11 23:56 | c_schmitz | Note Added: 16663 | |
| 2011-11-11 23:56 | c_schmitz | Status | assigned => resolved |
| 2011-11-11 23:56 | c_schmitz | Fixed in Version | => 1.91+ |
| 2011-11-11 23:56 | c_schmitz | Resolution | open => fixed |
| 2012-01-24 21:20 | c_schmitz | Note Added: 16962 | |
| 2012-01-24 21:20 | c_schmitz | Status | resolved => closed |