When adding Ubercart order ID to views, I see nice notiffication:
user warning: Unknown column 'node.order_id' in 'on clause' query: SELECT uc_orders.order_id AS order_id, node.title AS node_title, node.nid AS node_nid FROM iodb_uc_orders uc_orders LEFT JOIN iodb_uc_order_products uc_order_products ON uc_orders.order_id = uc_order_products.order_id LEFT JOIN iodb_node node ON uc_order_products.order_id = node.order_id LIMIT 0, 10 in /usr/home/iodb/public_html/modules/views/includes/view.inc on line 755.

Comments

madsph’s picture

madsph commented

It seems that there is an error in the way the join is made between order products and nodes. I think this is an old bug that for some reason hasn't had the fix committed to the official 2.0 branch.

The right thing to do is that I fix the bug in that branch and make a new release, but in stead I will ask if you have a test environment where you can try out the dev branch of the 3.0 version.

The reason I ask this is that a lot of changes are going on in the Ubercart project right now, which breaks several features of uc_views. I am trying to keep up with them in the dev branch, so if you are upgrading Ubercart to the newer versions, then you will also need the dev branch of this project to keep it all together.

Ubercart is planning to make a final 2.0 release in a week or so, and then I will make the 3.0 version of uc_views an official release, when I have verified that everything seems to work.

madsph’s picture

madsph commented
Status: Active » Closed (fixed)