Problem when opening products in backend

[nickson]

When opening the products tab in backend I get the following message.

vmError: exeSortSearchListQuery Unknown column 'pc.ordering' in 'order clause' SQL=SELECT SQL_CALC_FOUND_ROWS l.`virtuemart_product_id` FROM `vg72o_virtuemart_products_nl_nl` as l JOIN `vg72o_virtuemart_products` AS p using (`virtuemart_product_id`) group by p.`virtuemart_product_id` ORDER BY `pc`.ordering DESC LIMIT 0, 20

what to do?

[Milbo]

BE/models/product.php

line 379, change the "case 'ordering':" to "case '`pc`.ordering':"

[Milbo]

Please use this thread http://forum.virtuemart.net/index.php?topic=111322.msg373894#msg373894
closed.