AnsweredAssumed Answered

In inquiry module product catalog  popup will be open but showing blank

Question asked by BhaveshBhanushali on Oct 20, 2015
Hello,

I am using SUGAR CRM CE 6.5.1

I import the inquiry module in my crm.

There is relation ship with product catalog. i click on select button it show me popup but its blank and in error log show

" Query Failed:  SELECT  product_templates.id , product_templates.name  , product_categories.name category_name , product_categories.created_by category_name_owner  , 'ProductCategories' category_name_mod, product_templates.cost_price , product_templates.list_price , product_templates.discount_price , product_templates.created_by  FROM product_templates   LEFT JOIN  product_categories product_categories ON product_templates.category_id=product_categories.id AND product_categories.deleted=0 AND product_categories.deleted=0 where product_templates.deleted=0 ORDER BY producttemplates.name  LIMIT 0,21: MySQL error 1054: Unknown column 'producttemplates.name' in 'order clause'"


"MySQL error 1054: Unknown column 'producttemplates.name' in 'order clause"

How i can resolved this issue.

Thanx

Outcomes