VirtueMart Forum

VirtueMart 2 + 3 + 4 => Virtuemart Development and bug reports => Topic started by: nickson on December 22, 2012, 08:39:02 AM

Title: Problem when opening products in backend
Post by: nickson on December 22, 2012, 08:39:02 AM
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?
Title: Re: Problem when opening products in backend
Post by: Milbo on December 22, 2012, 11:32:22 AM
BE/models/product.php

line 379, change the "case 'ordering':" to "case '`pc`.ordering':"
Title: Re: Problem when opening products in backend
Post by: Milbo on January 01, 2013, 19:41:01 PM
Please use this thread http://forum.virtuemart.net/index.php?topic=111322.msg373894#msg373894
closed.