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

PostgreSQL - sql error after setup wizard.

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: 3.9.2
    • Fix Version/s: 3.10.0alpha1, 3.9.3
    • Component/s: Database related
    • Labels:
      None
    • Environment:

      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

            • Assignee:
              rl Ruslan Lisnyk
              Reporter:
              br Bjørn Reiten
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: