Details
-
Bug
-
Resolution: Fixed
-
High
-
4.7.0-dev
-
None
-
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
- relates to
-
EZP-19396 fetch_by_starrating group by owner does not work in PostgreSQL/Oracle
- Closed