VirtueMart Forum

VirtueMart 2 + 3 => Virtuemart Development and bug reports => Topic started by: bmw2182 on June 18, 2014, 17:35:19 pm

Title: Error When searching for product without price on product screen in backend.
Post by: bmw2182 on June 18, 2014, 17:35:19 pm
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?
Title: Re: Error When searching for product without price on product screen in backend.
Post by: Milbo on June 20, 2014, 14:19:07 pm
The reason is your orderby "created_on".  I take a look on it. .... and fixed it.
Title: Re: Error When searching for product without price on product screen in backend.
Post by: bmw2182 on June 20, 2014, 23:03:27 pm
So this will be fixed with the next update?
Title: Re: Error When searching for product without price on product screen in backend.
Post by: Milbo on June 21, 2014, 02:13:26 am
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.