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

        Activity

          People

            Unassigned Unassigned
            vl vl
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: