Details
-
Bug
-
Resolution: Won't Fix
-
Medium
-
4.6.0
-
None
Description
If you create a survey, submit a survey and then click on the "Survey" tab in admin ( /survey/list/ ) you'll get this SQL error and warning
Warning: PHP: E_WARNING Feb 03 2012 14:43:47 pg_query(): Query failed: ERROR: column "ezcontentobject.id" must appear in the GROUP BY clause or be used in an aggregate function LINE 8: ORDER BY ezcontentobject.id DESC, ezconten... ^ in /var/www/ezp/.run/lib/ezdb/classes/ezpostgresqldb.php on line 202 Error: eZPostgreSQLDB Feb 03 2012 14:43:47 Error: error executing query: SELECT count(ezcontentobject.id) AS count FROM ezsurvey, ezcontentobject, ezcontentobject_attribute WHERE ezcontentobject_attribute.data_type_string='ezsurvey' AND ezsurvey.id=ezcontentobject_attribute.data_int AND ezcontentobject_attribute.contentobject_id=ezcontentobject.id AND ezcontentobject.current_version=ezcontentobject_attribute.version AND ezcontentobject.status=1 ORDER BY ezcontentobject.id DESC, ezcontentobject.current_version DESC: ERROR: column "ezcontentobject.id" must appear in the GROUP BY clause or be used in an aggregate function LINE 8: ORDER BY ezcontentobject.id DESC, ezconten...