Search in product description error
Posted: Wed Feb 11, 2009 10:27 pm
When i make Serch in product description i receive the folowing error
Error: Unknown column 'pd.long_description' in 'where clause'
Error No: 1054
SELECT COUNT(*) AS total FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) WHERE pd.language_id = '1' AND (pd.name LIKE '%hp%' OR pd.long_description LIKE '%hp%') AND p.date_available < NOW() AND p.status = '1'
Can you tell me what is the problem?
Error: Unknown column 'pd.long_description' in 'where clause'
Error No: 1054
SELECT COUNT(*) AS total FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) WHERE pd.language_id = '1' AND (pd.name LIKE '%hp%' OR pd.long_description LIKE '%hp%') AND p.date_available < NOW() AND p.status = '1'
Can you tell me what is the problem?