Author Topic: Problem when opening products in backend  (Read 2067 times)

nickson

  • Beginner
  • *
  • Posts: 28
Problem when opening products in backend
« 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?

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 10111
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: Problem when opening products in backend
« Reply #1 on: December 22, 2012, 11:32:22 am »
BE/models/product.php

line 379, change the "case 'ordering':" to "case '`pc`.ordering':"
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 10111
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: Problem when opening products in backend
« Reply #2 on: January 01, 2013, 19:41:01 pm »
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/