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

Started by bmw2182, June 18, 2014, 17:35:19 PM

Previous topic - Next topic

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.
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

bmw2182


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.
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/