News:

Support the VirtueMart project and become a member

Main Menu

Error in product filter if i choose "filter on modified price"

Started by chabi01, December 15, 2014, 15:31:14 PM

Previous topic - Next topic

chabi01

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 :

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 :)

jenkinhill

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.
Kelvyn
Lowestoft, Suffolk, UK

Retired from forum life November 2023

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum