Uploaded image for project: 'eZ Publish / Platform'
  1. eZ Publish / Platform
  2. EZP-10788

PostgreSQL - sql error after setup wizard.

    XMLWordPrintable

Details

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Medium Medium
    • 3.10.0alpha1, 3.9.3
    • 3.9.2
    • Database related
    • 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
      

      Attachments

        Activity

          People

            rl rl
            br br
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: