Uploaded image for project: 'eZ Publish / Platform'
  1. eZ Publish / Platform
  2. EZP-19109

ezsurvey : Looking at the survey list generates a SQL error (postgres)

    XMLWordPrintable

    Details

      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...
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              vl Vidar Langseid
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: