After creating a View to list all of my unexpired auctions, rather than behaving normally if there are no items to list in the view I get an error instead, saying that the following query is incorrect on line 32 of uc_auction_handler_field_bid_count.inc

SELECT nid, COUNT(*) as count FROM uc_auction_bids WHERE nid IN () GROUP BY nid in <...>/uc_auction_handler_field_bid_count.inc

I'm sure this is a relatively minor problem, but I figured I should mention it... I'd try to fix it myself if I were more familiar with PHP & SQL.

Comments

davidcgutman’s picture

davidcgutman commented

It looks like the error is specifically when you include the bid count field, if I don't include it in my view the error disappears.

Garrett Albright’s picture

Garrett Albright commented
Assigned: Unassigned » Garrett Albright

Acknowledged. Thanks.

Garrett Albright’s picture

Garrett Albright commented
Status: Active » Fixed

This appears to have been fixed on my local machine for some time now. I did another CVS commit; the fix ought to show up when the next dev release is packaged.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.