Author Topic: exeSortSearchListQuery error  (Read 1347 times)

jjk

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 3523
  • using Matomo instead of Google Analytics
exeSortSearchListQuery error
« on: November 22, 2011, 10:59:31 am »
J1.7.3/VM2 SVN revision 4787

Hi,

I'm just trying to get my product data to work with the latest SVN revision. Currently I don't see any products in the BE Product List. VMDebug says:
vmdebug exeSortSearchListQuery error in class VirtueMartModelProduct sql: Var1:

Unknown column 'p.product_name' in 'order clause' SQL=SELECT SQL_CALC_FOUND_ROWS  * FROM `jos_virtuemart_products_de_de` as l JOIN `jos_virtuemart_products` AS p using (`virtuemart_product_id`) ORDER BY p.product_name

So I currently can't check, if the following FE notice on the category browse page goes away if I add missing prices (On a page where there are 6 products with missing prices I see 6 of these notices):
Notice: Undefined property: TableProducts::$virtuemart_product_price_id in ...\administrator\components\com_virtuemart\models\product.php on line 451
Non-English Shops: Are your language files up to date?
http://virtuemart.net/community/translations