I just ran into the same issue and edited includes\modules\pages\advanced_search_result\header_php.php as follows:
Change line 206 from:
Code:
" m.manufacturers_id, p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_price_sorter, p.products_qty_box_status ";
to
Code:
" cd.categories_description, m.manufacturers_id, p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_price_sorter, p.products_qty_box_status ";
then change line 219 from:
Code:
USING(manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c )
to
Code:
USING(manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c )
and line 249:
Code:
AND p2c.categories_id = c.categories_id ";
to
Code:
AND p2c.categories_id = c.categories_id
AND c.categories_id = cd.categories_id ";
and after what was line 297 (
Code:
OR p.products_model
) add the following lines:
Code:
LIKE '%:keywords%'
OR cd.categories_name
Works a treat!
Hope this helps...
Linda
Bookmarks