View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
05574Bug reportsPrint Viewpublic2011-11-11 20:512012-01-24 21:20
Reporterdcamacho Assigned Toc_schmitz  
PrioritylowSeveritytrivial 
Status closedResolutionfixed 
Product Version1.91+ 
Fixed in Version1.91+ 
Summary05574: 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
Printable Version

Additional Information

DataBase Postgres

TagsNo tags attached.
Attached Files
printablesurvey.php (102,485 bytes)
Bug heat4
Complete LimeSurvey version number (& build)11343
I will donate to the project if issue is resolvedNo
Browser
Database type & versionPostgres 8.3.7
Server OS (if known)Freebsd
Webserver software & version (if known)APACHE
PHP VersionPHP 5.3.0

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2011-11-11 22:39

administrator   ~16660

Please try the attached file and let me know if this fixes the issue.
dcamacho

dcamacho

2011-11-11 23:09

reporter   ~16662

This work very well
c_schmitz

c_schmitz

2011-11-11 23:56

administrator   ~16663

Fixed in rev 11357
c_schmitz

c_schmitz

2012-01-24 21:20

administrator   ~16962

New 1.91+ version released.

Issue History

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