Search function not working properly

[THISclose]

I'm not a programmer by trade or by choice, but if I want my site live this week, I've got to work out these kinks myself. I've read the FAQ's in their entirety and searched the forum-both current and archived- in every way I could think of, and nothing seemed to match or address the problem I'm having.

The Search function is misfiring in the following ways:

1. It seems to be searching product descriptions only. I need it to search category names and product names also.

2. It searches for a string and not a whole word. So when I put in 'red' as a search term, the results return items with the word 'colored' in the description.

My categories are set up like so:
Type:
>Anklet
>Bracelet
etc....

Color:
>Blue
>Red
etc....
I haven't mixed sub-categories and products in any category. None of my products are in the top. From what I've read here, it should autogenerate the keywords from the fields that I want, but it's not happening. Is this something that anyone can help with? Or is this beyond the scope of the forum?

Thanks much in advance :)

http://www.dragonsdreams.net/ (for reference)

edited to add:
I'm guessing I need to add the category ID and product name ID tables somewhere, but I'm at a loss as to where 'somewhere' is.

[DrByte]

The logic driving the search results is in includes/modules/pages/advanced_search_result/header_php.php

product names are searched
category names are not searched
partial word matches are done by default

[Fogie]

So what specific changes should be made to includes/modules/pages/advanced_search_result/header_php.php so that category names and/or descriptions are included in the search?

Fogie

[lvanderb]

I just ran into the same issue and edited includes\modules\pages\advanced_search_result\header_php.php as follows:

Change line 206 from:

              " 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

              " 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:

             USING(manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c )

to

             USING(manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c )

and line 249:

               AND p2c.categories_id = c.categories_id ";

to

               AND p2c.categories_id = c.categories_id
               AND c.categories_id = cd.categories_id ";

and after what was line 297 (

                                         OR p.products_model

) add the following lines:

                                         LIKE '%:keywords%'
                                         OR cd.categories_name

Works a treat!

Hope this helps...

Linda

[Jedward]

I have done all those changes and still my search can NOt search the product info text, for example if I have a "red pen" in product info and search for "red" in the search, search result shows nothing!!
WHat else should I do?

[Ajeh]

Have you an URL that we can look at where this is happening?

Is this a clean v1.3.7 or an upgrade?

If an upgrade from what version and how did you do the upgrade?

[Jedward]

It is clean version 1.3.6
www.iantiquerugs.com

[Ajeh]

What happens if you switch to Classic template and try the search?

[Jedward]

Good idea, I did it and search works just fine.... so it is something wrong in my template, can I copy the classic search files to my template manualy or would you please tell me where and what should I look for?
J.

[Ajeh]

The search box files for the header are controlled by:
/includes/modules/sideboxes/search_header.php
/includes/templates/template_default/sideboxes/tpl_search_header.php

Look like either they are out of date or you are using override files that are out of date:
/includes/modules/sideboxes/your_template_dir/search_header.php
/includes/templates/your_template_dir/sideboxes/tpl_search_header.php

Check a clean Zen Cart for the version you are running and compare the files ...