VirtueMart Forum

VirtueMart 2 + 3 + 4 => Virtuemart Development and bug reports => Topic started by: jjk on November 22, 2011, 10:59:31 AM

Title: exeSortSearchListQuery error
Post by: jjk 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