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)

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

        Issue Links

          Activity

          Hide
          Vidar Langseid added a comment -

          All automated ezsurey tests fail due to this problem.

          Show
          Vidar Langseid added a comment - All automated ezsurey tests fail due to this problem.
          Hide
          Gaetano Giunta added a comment -

          most likely affecting oracle too (is there not already an issue for it?)

          Show
          Gaetano Giunta added a comment - most likely affecting oracle too (is there not already an issue for it?)

            People

            • Assignee:
              unknown
              Reporter:
              Vidar Langseid
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated: