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.

    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

        Issue Links

          Activity

          Hide
          Chen Xiongjie added a comment -

          Fixed in ezlightbox(part of teamroom) trunk(0.8.0) and stable/0.7 in rev. 36

          Show
          Chen Xiongjie added a comment - Fixed in ezlightbox(part of teamroom) trunk(0.8.0) and stable/0.7 in rev. 36
          Hide
          ezrobot added a comment -

          This issue has been automatically closed due to the lack of activity over a long period of time. It is very likely that it is obsolete, but if you think it is still valid, do not hesitate to reopen it and mention why.

          Show
          ezrobot added a comment - This issue has been automatically closed due to the lack of activity over a long period of time. It is very likely that it is obsolete, but if you think it is still valid, do not hesitate to reopen it and mention why.

            People

            • Assignee:
              Chen Xiongjie
              Reporter:
              Ricardo Goulart
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: