I really like to create a view with auction won by the user.

like : user/uid/auctions/won

how can i do that.
I try to create an arument for the high bidder but that gives an error (see below)
Any help in this is greatly appreciated.

thanks

---error--

:
user warning: Unknown column 'uc_auction.high_bidder' in 'where clause' query: SELECT node.nid AS nid, node.type AS node_type, node.title AS node_title, node.language AS node_language, node_data_field_prod_img.field_prod_img_fid AS node_data_field_prod_img_field_prod_img_fid, node_data_field_prod_img.field_prod_img_list AS node_data_field_prod_img_field_prod_img_list, node_data_field_prod_img.field_prod_img_data AS node_data_field_prod_img_field_prod_img_data, node.vid AS node_vid, uc_auction.start_price AS uc_auction_start_price, uc_auction_bids.amount AS uc_auction_bids_amount, node_uc_order_products__uc_orders.uid AS node_uc_order_products__uc_orders_uid, users.uid AS uc_auction_high_bidder, users.name AS uc_auction_high_bidder_name, users.uid AS users_uid FROM node node LEFT JOIN uc_order_products uc_order_products ON node.nid = uc_order_products.nid LEFT JOIN node node_uc_order_products ON uc_order_products.nid = node_uc_order_products.nid LEFT JOIN uc_orders uc_orders ON uc_order_products.order_id = uc_orders.order_id LEFT JOIN users users_uc_orders ON uc_orders.uid = users_uc_orders.uid INNER JOIN uc_auction uc_auction ON node.nid = uc_auction.nid LEFT JOIN content_type_product node_data_field_prod_img ON node.vid = node_data_field_prod_img.vid LEFT JOIN uc_auction_bids uc_auction_bids ON uc_auction.high_bid = uc_auction_bids.bid LEFT JOIN uc_order_products node_uc_order_products__uc_order_products ON node_uc_order_products.nid = node_uc_order_products__uc_order_products.nid LEFT JOIN uc_order_products node_uc_order_products_node_uc_order_products__uc_order_products ON node_uc_order_products.nid = node_uc_order_products_node_uc_order_products__uc_order_products.nid LEFT JOIN uc_orders node_uc_order_products__uc_orders ON node_uc_order_products__uc_order_products.order_id = node_uc_order_products__uc_orders.order_id LEFT JOIN uc_auction_bids uc_auction_bids2 ON uc_auction.high_bid = uc_auction_bids2.bid LEFT JOIN users users ON uc_auction_bids.uid = users.uid WHERE (node.type IN ('product')) AND (uc_auction.high_bidder = '1') LIMIT 0, 10 in /sites/all/modules/views/includes/view.inc on line 810.

Comments

pindaman’s picture

pindaman commented
Title: Views help auciton listings » Views help auction listings

I am willing pay for this fix to make auction integrate with views

pindaman’s picture

pindaman commented

The module itself has functions which create following lists:
1: current active auctions path site.com/user/id/auctions
2: auctions won by user path site.com/user/id/auctions/won
3: auctions lost by user path site.com/user/id/auctions/lost

I need these following lists to be created with views.
In short i need the following in views:

1: current active auctions were the user has made a bid
2: auctions won by user - but now yet paid for
2: auctions won by user - paid for by current user
3: auctions lost by user

if some can help to make this work please contact me.