Postgres Error On Product->Adjustments

I created a product with an attribute, added 3 options and visited the adjustments page... I didn't receive a pgsql warning. Could someone else confirm whether this is still an issue?

I am running Drupal 6 and am receiving the same error when editing a product and clicking on the Adjustments tab.

* warning: pg_query() [function.pg-query]: Query failed: ERROR: column "pa.nid" must appear in the GROUP BY clause or be used in an aggregate function in /srv/sites/siv3/includes/database.pgsql.inc on line 139.
* user warning: query: SELECT pa.nid, pa.aid, pa.ordering, a.name, a.ordering, ao.aid, COUNT(po.oid) FROM uc_product_attributes AS pa LEFT JOIN uc_attributes AS a ON pa.aid = a.aid LEFT JOIN uc_attribute_options AS ao ON a.aid = ao.aid LEFT JOIN uc_product_options AS po ON ao.oid = po.oid AND po.nid = 42 WHERE pa.nid = 42 GROUP BY ao.aid, pa.aid, a.name, pa.ordering, a.ordering HAVING count(po.oid) > 0 ORDER BY pa.ordering, a.ordering in /srv/sites/siv3/sites/all/modules/ubercart/uc_attribute/uc_attribute.admin.inc on line 904.

Ah, I see. It appears the pa.nid field was removed from the query in 1.x, so I didn't see the error. Thanks for bumping this up though, cause it's present in 2.x. Patch follows =)

Now THAT's service!

Gracias. Committed.

Has this issue somehow resurfaces? I am running the latest version of ubercart but still getting this same error. I tried to patch but (as I suspected) it's for an other version, or so it seems.

Help?

I am running Drupal 6.15 and Ubercart 6.x-2.2 and still seeing this issue when clicking Adjustments:

    * warning: pg_query() [function.pg-query]: Query failed: ERROR: column "pa.display" must appear in the GROUP BY clause or be used in an aggregate function in /var/www/includes/database.pgsql.inc on line 139.
    * user warning: query: SELECT pa.nid, pa.aid, pa.ordering, pa.display, a.name, a.ordering, ao.aid, COUNT(po.oid) FROM uc_product_attributes AS pa LEFT JOIN uc_attributes AS a ON pa.aid = a.aid LEFT JOIN uc_attribute_options AS ao ON a.aid = ao.aid LEFT JOIN uc_product_options AS po ON ao.oid = po.oid AND po.nid = 7297 WHERE pa.nid = 7297 AND pa.display <> 3 GROUP BY ao.aid, pa.aid, a.name, pa.ordering, a.ordering, pa.nid HAVING count(po.oid) > 0 ORDER BY pa.ordering, a.ordering in /var/www/sites/all/modules/contrib/ubercart/uc_attribute/uc_attribute.admin.inc on line 1045.

Again, this is fixed in -dev.