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

EzTeamRoom: PostGres: Create new lightbox [Error] Transaction in progress failed due to DB error, transaction was rollbacked.

    XMLWordPrintable

Details

    Description

      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 &quot;ezlightbox.name&quot; 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
      LINE 2: ...      FROM   ezlightbox WHERE owner_id=14 ORDER BY name DESC
                                                                    ^
      
      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.
      
      Steps to reproduce

      Try to create a new lightbox, it will prompt for the name, and when you press submit experience the error

      Attachments

        Activity

          People

            chen chen
            1353896f-f5e1-49a7-beb5-3f430ddab097@accounts.ibexa.co Ricardo Goulart
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: