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

(tc-460)(eZ Flow) Adding a "Top rated" block on eZ Flow raises an error in PostgreSQL

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: High
    • Resolution: Fixed
    • Affects Version/s: 4.7.0-dev
    • Labels:
      None
    • Environment:

      Operating System: Internet Explorer 9.0.8112.16421
      PHP Version: 5.3.3
      Database and version: PostgreSQL (8.4.8)
      Browser (and version): Firefox 11.0

      Description

      Hi,

      when i add a "Top Rated" block on eZ Flow, in PostgreSQL, an error is raised in debug.

      Error: eZTemplate 	Apr 05 2012 15:59:19
      
      No such attribute for array(1): source_node_id
      Choose one of following: limit
      
      Warning: PHP: E_WARNING 	Apr 05 2012 15:59:20
      
      pg_query(): Query failed: ERROR:  column "ezcontentobject.contentclass_id" must appear in the GROUP BY clause or be used in an aggregate function
      LINE 2:                              ezcontentobject.*, ezcontentobj...
                                           ^ in /var/www/ezp/.run/lib/ezdb/classes/ezpostgresqldb.php on line 211
      
      Error: eZPostgreSQLDB 	Apr 05 2012 15:59:20
      
      Error: error executing query: SELECT
                                   ezcontentobject.*, ezcontentobject_tree.*,
                                   AVG( ezstarrating.rating_average ) as rating,
                                   SUM( ezstarrating.rating_count ) as rating_count,
                                   ezcontentclass.serialized_name_list as class_serialized_name_list,
                                   ezcontentclass.identifier as class_identifier,
                                   ezcontentclass.is_container as is_container
                                   , ezcontentobject_name.name as name,  ezcontentobject_name.real_translation 
                                   
                                  FROM
                                   ezcontentobject_tree,
                                   ezcontentobject_tree owner_tree,
                                   ezcontentclass
                                   
                                   , ezcontentobject_name 
                                   
                                   
                                   ,ezcontentobject
                                   , ezstarrating
                                  WHERE
                                   
                                   ezstarrating.contentobject_id = ezcontentobject.id AND
                                   ezcontentobject.id = ezcontentobject_tree.contentobject_id AND
                                   ezcontentobject.owner_id = owner_tree.contentobject_id AND
                                   owner_tree.node_id = owner_tree.main_node_id AND
                                   ezcontentclass.version=0 AND
                                   ezcontentclass.id = ezcontentobject.contentclass_id AND
                                   
                                   
                                   
      	                          ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
                                         ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and 
       ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
           ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
         + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) )
         <
           ( ezcontentobject_name.language_id & 1 )
         + ( ( ezcontentobject_name.language_id & 2 ) )
       ) 
      
      	                         AND ezcontentobject_tree.is_invisible = 0
      	                         
      	                          AND 
       ezcontentobject.language_mask & 3 > 0 
      
                                  GROUP BY ezcontentobject_tree.node_id
                                  ORDER BY rating DESC
      LIMIT 0: ERROR:  column "ezcontentobject.contentclass_id" must appear in the GROUP BY clause or be used in an aggregate function
      LINE 2:                              ezcontentobject.*, ezcontentobj...
                                           ^
      
      Error: ezsrRatingObject::fetchNodeByRating 	Apr 05 2012 15:59:20
      
      The ezstarrating table seems to be missing,
                                contact your administrator
      

      Note: the ezstarrating table is present in my db.
      contentobject_attribute_id | contentobject_id | rating_average | rating_count

      Steps to reproduce
      Enter on eZ Flow
      Edit the frontpage
      Add a "Top Rated" block
      Click on "Send for Publishing" button
      

      The error happens when we click the "Send for Publishing" button

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              dp@ez.no Damien Pobel (eZ)
              Reporter:
              pcardiga Paulo Cardiga
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: