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?
Who is online
Users browsing this forum: No registered users and 49 guests