Details
-
Bug
-
Resolution: Obsolete
-
Medium
-
4.3.0rc1
-
None
-
Operating System: PostGresSQL
Description
Timing: Mar 29 2010 19:26:23 Module start 'lightbox' Warning: PHP: E_WARNING Mar 29 2010 19:26:23 pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR: column "ezlightbox.name" must appear in the GROUP BY clause or be used in an aggregate function LINE 2: ... FROM ezlightbox WHERE owner_id=14 ORDER BY name DESC ^ in /var/www/apache2php52/ezppostgres/.run/lib/ezdb/classes/ezpostgresqldb.php on line 175 Error: eZPostgreSQLDB Mar 29 2010 19:26:23 Error: error executing query: SELECT count( id ) AS count FROM ezlightbox WHERE owner_id=14 ORDER BY name DESC ERROR: column "ezlightbox.name" must appear in the GROUP BY clause or be used in an aggregate function LINE 2: ... FROM ezlightbox WHERE owner_id=14 ORDER BY name DESC ^ Error: eZDBInterface::commit TRANSID-75275032fb950c5e67dc807a4ea57b85 Mar 29 2010 19:26:23 Transaction in progress failed due to DB error, transaction was rollbacked. Transaction ID is TRANSID-75275032fb950c5e67dc807a4ea57b85.
Steps to reproduce
Try to create a new lightbox, it will prompt for the name, and when you press submit experience the error