sql error after update to version 2.0.20b

[tomj]

Hi,

After updating virtuemart to version 2.0.20b i get the following sql error when i want to see all articles of a category:

vmError: exeSortSearchListQuery Column 'ordering' in order clause is ambiguous SQL=SELECT SQL_CALC_FOUND_ROWS l.`virtuemart_product_id` FROM `gdyt4_virtuemart_products_nl_nl` as l JOIN `gdyt4_virtuemart_products` AS p using (`virtuemart_product_id`) LEFT JOIN `gdyt4_virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id` LEFT JOIN `gdyt4_virtuemart_categories_nl_nl` as c ON c.`virtuemart_category_id` = `pc`.`virtuemart_category_id` LEFT JOIN `gdyt4_virtuemart_product_shoppergroups` ON p.`virtuemart_product_id` = `gdyt4_virtuemart_product_shoppergroups`.`virtuemart_product_id` LEFT OUTER JOIN `gdyt4_virtuemart_shoppergroups` as s ON s.`virtuemart_shoppergroup_id` = `gdyt4_virtuemart_product_shoppergroups`.`virtuemart_shoppergroup_id` WHERE ( p.`published`="1" AND `pc`.`virtuemart_category_id` = 1 AND `pc`.`virtuemart_category_id` > 0 AND ( s.`virtuemart_shoppergroup_id`= "1" OR s.`virtuemart_shoppergroup_id` IS NULL ) ) group by p.`virtuemart_product_id` ORDER BY ordering ASC LIMIT 0, 9

Tom

[jenkinhill]

From a forum search: http://forum.virtuemart.net/index.php?topic=114873.0