“Hi,

To search in product description and in subcategories by default, you need to edit catalog/view/theme/shoppica/js/shoppica.js. Find this piece of code:

url = ‘index.php?route=product/search&filter_name=’ + encodeURIComponent(filter_name);

and replace it with:

url = ‘index.php?route=product/search&filter_name=’ + encodeURIComponent(filter_name) + ‘&filter_sub_category=true&filter_description=true’;

Best,
ThemeBurn team

TB Support
November 24, 2011 at 10:34 am #3830 ”

Hello
I changed as indicated in the file, but this is error.
What is the solution?

Notice: Error: Can’t find FULLTEXT index matching the column list
Error No: 1191
SELECT p.product_id,(SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = ’1′ AND ((ps.date_start = ’0000-00-00′ OR ps.date_start NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, p.price AS price FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN product_special ps ON (p.product_id = ps.product_id) WHERE pd.language_id = ’2′ AND p.status = ’1′ AND p.date_available <= NOW() AND p2s.store_id = '0' AND (LCASE(pd.name) LIKE '%agr%' OR MATCH(pd.description) AGAINST('agr')) OR LCASE(p.model) = 'agr' OR LCASE(p.sku) = 'agr' OR LCASE(p.upc) = 'agr' OR LCASE(p.ean) = 'agr' OR LCASE(p.jan) = 'agr' OR LCASE(p.isbn) = 'agr' OR LCASE(p.mpn) = 'agr' GROUP BY p.product_id in /var/www/res/kreativ/opeleseknek.hu/opelshop/system/database/mysql.php on line 50