Operating System: PostGresSQL
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
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.
Try to create a new lightbox, it will prompt for the name, and when you press submit experience the error
TC-163 (Teamroom)(Postgres) Creating a Lightbox in Postgres generates a DB error
ezteamroom : calendar doesn't work in postgresql
Fixed in ezlightbox(part of teamroom) trunk(0.8.0) and stable/0.7 in rev. 36
This issue has been automatically closed due to the lack of activity over a long period of time. It is very likely that it is obsolete, but if you think it is still valid, do not hesitate to reopen it and mention why.