#010788: PostgreSQL - sql error after setup wizard.

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

Environment:

Operating System:
PHP Version: 4.4.7
Database and version: PostgreSQL 8.1.6
Browser (and version): Konqueror


- Attachments

No attachments for this issue.


- Comments

fixed in
stable/3.8 (3.8.9) rev. 19123
stable/3.9 (3.9.3) rev. 19121
trunk (3.10.0alpha1) rev. 19122

#252943 by Dmitry Lakhtyuk on June 26th, 2007 [Permanent Link]

There was also additional fix that fixes similar problems of queries on Postgresql in:
trunk (3.10.0alpha1) rev. 19130,
stable/3.9 (3.9.3) rev. 19131,
stable/3.8 (3.8.9) rev. 19132.

#252961 by Ruslan Lisnyk on June 27th, 2007 [Permanent Link]

Tested and works fine on PostgreSQL now.

#253142 by Bjørn Reiten on July 27th, 2007 [Permanent Link]

- History
Properties
Type Bug
Priority Medium
Component Database related
Affects 3.9.2
Fix Versions 3.9.3
3.10.0alpha1
Reporter Bjørn Reiten
Responsible Ruslan Lisnyk
Status 0 Closed
Resolution Fixed
Created May 14th, 2007
Updated July 27th, 2007
Resolved June 26th, 2007
 
Navigation [Permanent Link]
Previous Issue
Back to Issues List
Next Issue: #016400
  Content of an ezmedia attribute is deleted from published version when a new draft is deleted...