Details
-
Bug
-
Resolution: Fixed
-
Medium
-
3.9.2
-
None
-
Operating System:
PHP Version: 4.4.7
Database and version: PostgreSQL 8.1.6
Browser (and version): Konqueror
Description
After installing the webin package, you'll get some sql errors when the setup wizard is finished when you are using PostgreSQL.
( ! ) Warning: pg_exec() [function.pg-exec]: Query failed: ERROR: column "ezcontentobject.id" must appear in the GROUP BY clause or be used in an aggregate function in /var/www/ez392psql/lib/ezdb/classes/ezpostgresqldb.php on line 164 Call Stack # Time Function Location 1 0.0002 {main}( ) ../index.php:0 2 0.0387 ezmodule->run( ) ../index.php:746 3 0.0389 ezprocess::run( ) ../ezmodule.php:1179 4 0.0390 ezprocess->runfile( ) ../ezprocess.php:51 5 0.0391 include( '/var/www/ez392psql/kernel/setup/ezsetup.php' ) ../ezprocess.php:74 6 0.0903 ezstepcreatesites->init( ) ../ezsetup.php:207 7 0.0997 ezstepcreatesites->initializepackage( ) ../ezstep_create_sites.php:190 8 218.5466 ezsitepostinstall( ) ../ezstep_create_sites.php:1310 9 219.5918 updateobject( ) ../install-scripts.php:171 10 219.5969 ezcontentobject::fetchlistcount( ) ../addobjectattributes.php:276 11 219.5970 ezpersistentobject::fetchobjectlist( ) ../ezcontentobject.php:913 12 219.5974 ezpostgresqldb->arrayquery( ) ../ezpersistentobject.php:803 13 219.5974 ezpostgresqldb->query( ) ../ezpostgresqldb.php:232 14 219.5975 pg_exec ( ) ../ezpostgresqldb.php:164