PostgreSQL errors with Packages and Userpoints Integration [#220586]

I am using PostgreSQL with Drupal 5.5.

Receiving this error when viewing individual orders.

    * warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "uc_updiscounts" does not exist in /usr/local/apache2/htdocs/drupal/includes/database.pgsql.inc on line 125.
    * user warning: query: SELECT * FROM uc_updiscounts WHERE oid = 3 in /usr/local/apache2/htdocs/drupal/includes/database.pgsql.inc on line 144.
    * warning: Division by zero in /usr/local/apache2/htdocs/drupal/modules/userpoints_ubercart/uc_points_payment.inc on line 13.

Receiving this error when selecting the Packages tab within an individual order.

    * warning: pg_query() [function.pg-query]: Query failed: ERROR: column "packaged" does not exist LINE 1: ....order_id = 3 GROUP BY op.order_product_id HAVING packaged I... ^ in /usr/local/apache2/htdocs/drupal/includes/database.pgsql.inc on line 125.
    * user warning: query: SELECT op.order_product_id, SUM(op.qty) AS total, SUM(pp.qty) AS packaged FROM uc_order_products AS op LEFT JOIN uc_packaged_products AS pp ON op.order_product_id = pp.order_product_id WHERE op.order_id = 3 GROUP BY op.order_product_id HAVING packaged IS NULL OR total > packaged in /usr/local/apache2/htdocs/drupal/includes/database.pgsql.inc on line 144.

I'm also seeing a single order shown multiple times in the View Order screen. All with the same Pending status.

Comments

Comment #1

rszrama CreditAttribution: rszrama commented 19 February 2008 at 16:14

Title:	Errors with View Orders	» PostgreSQL errors with Packages and Userpoints Integration
Status:	Active	» Postponed (maintainer needs more info)

The first error comes from the userpoints integration module. You'll need to verify this one w/ the module developer through the issue tracker at u.o.

For the second, did you perform a clean beta 5 installation or update from a previous version. If updated, did you run update.php after updating? We can investigate further based on which one it is. : )