Frontend not working correctly after update VM 2.0.16 to VM 2.0.18a

[kratzi]

Hi,

I did an update from VM 2.0.16 to VM 2.0.18a and no products are shown any more.

Where is the problem?? I am using Joomla 2.5.6

I receive this

vmError: exeSortSearchListQuery Column 'ordering' in order clause is ambiguous SQL=SELECT SQL_CALC_FOUND_ROWS l.`virtuemart_product_id` FROM `e6vw2_virtuemart_products_da_dk` as l JOIN `e6vw2_virtuemart_products` AS p using (`virtuemart_product_id`) LEFT JOIN `e6vw2_virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id` LEFT JOIN `e6vw2_virtuemart_categories_da_dk` as c ON c.`virtuemart_category_id` = `pc`.`virtuemart_category_id` LEFT JOIN `e6vw2_virtuemart_product_shoppergroups` ON p.`virtuemart_product_id` = `e6vw2_virtuemart_product_shoppergroups`.`virtuemart_product_id` LEFT OUTER JOIN `e6vw2_virtuemart_shoppergroups` as s ON s.`virtuemart_shoppergroup_id` = `e6vw2_virtuemart_product_shoppergroups`.`virtuemart_shoppergroup_id` WHERE ( p.`published`="1" AND `pc`.`virtuemart_category_id` = 6 AND `pc`.`virtuemart_category_id` > 0 AND ( s.`virtuemart_shoppergroup_id`= "2" OR s.`virtuemart_shoppergroup_id` IS NULL ) ) group by p.`virtuemart_product_id` ORDER BY ordering ASC LIMIT 0, 18

[kratzi]

I found out that the problem is caused through the code in administrator/components/com_virtuemart/models/product.php

Would be great if someone could help out with that

thank you

kratzi