Print Page - Error in product filter if i choose "filter on modified price"

Title: Error in product filter if i choose "filter on modified price"
Post by: chabi01 on December 15, 2014, 15:31:14 PM

Hi,
I try to show only prices with modified price.
When i just select the option in the filter and click ok, i get this :

Code Select

vmError: exeSortSearchListQuery Column 'created_on' in order clause is ambiguous SQL=SELECT SQL_CALC_FOUND_ROWS p.`virtuemart_product_id` FROM `j2hvs_virtuemart_products` as p INNER JOIN `j2hvs_virtuemart_products_fr_fr` as l using (`virtuemart_product_id`) LEFT JOIN `j2hvs_virtuemart_product_prices` as pp ON p.`virtuemart_product_id` = pp.`virtuemart_product_id` WHERE (pp.`modified_on` < "15:27 15.12.2014") group by p.`virtuemart_product_id` ORDER BY created_on DESC LIMIT 0, 20
[/code]
I use VM 2.6.4.
I have allready tried to correct the table with the VM Tools...without success.

If there is any solution..
Thanks :)

Title: Re: Error in product filter if i choose "filter on modified price"
Post by: jenkinhill on December 15, 2014, 17:19:21 PM

VM2.6.4 is quite old and known to be insecure so updating to current VM2.6.14 is recommended. I have 2.6.14 and do not see the error.

VirtueMart Forum

VirtueMart 2 + 3 + 4 => General Questions => Topic started by: chabi01 on December 15, 2014, 15:31:14 PM