Error When searching for product without price on product screen in backend.

[bmw2182]

I'm running Joomla 2.5.14 and Virtuemart 2.6.6.  When in the product screen searching for product with out price we get and error.

vmError: exeSortSearchListQuery Column 'created_on' in order clause is ambiguous SQL=SELECT SQL_CALC_FOUND_ROWS p.`virtuemart_product_id` FROM `z36yx_virtuemart_products` as p INNER JOIN `z36yx_virtuemart_products_en_gb` as l using (`virtuemart_product_id`) LEFT JOIN `z36yx_virtuemart_product_prices` as pp ON p.`virtuemart_product_id` = pp.`virtuemart_product_id` WHERE ((`product_name` LIKE "%clarinet%" OR `product_sku` LIKE "%clarinet%" OR `product_gtin` LIKE "%clarinet%" OR `product_mpn` LIKE "%clarinet%" OR `l`.`slug` LIKE "%clarinet%" OR `product_s_desc` LIKE "%clarinet%" OR `l`.`metadesc` LIKE "%clarinet%") AND pp.`product_price` IS NULL) group by p.`virtuemart_product_id` ORDER BY created_on DESC LIMIT 0, 48

Any ideas what we need to do to correct this?

[Milbo]

The reason is your orderby "created_on".  I take a look on it. .... and fixed it.

[bmw2182]

So this will be fixed with the next update?

[Milbo]

Yes, but atm only in vm3, but you can have it faster http://extensions.virtuemart.net/support/virtuemart-supporter-membership-detail , then I report it. The changes are in the trunk, but if you need an installer, that is the right way to support us.