News:

Support the VirtueMart project and become a member

Main Menu

Problem when opening products in backend

Started by nickson, December 22, 2012, 08:39:02 AM

Previous topic - Next topic

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':"
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

Milbo

Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/