Author Topic: Error When searching for product without price on product screen in backend.  (Read 1184 times)

bmw2182

  • Jr. Member
  • **
  • Posts: 93
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

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 9972
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
The reason is your orderby "created_on".  I take a look on it. .... and fixed it.
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

bmw2182

  • Jr. Member
  • **
  • Posts: 93
So this will be fixed with the next update?

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 9972
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
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.
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/