Search Is not displaying all results/Search with Dash (-)

Hello,
My company sells parts which are often searched/sold by part number. Such as part # Q2425-69017 or RM1-0013. When we search for these with complete number we get no results. If we search by the portion after the - such as 0013 or 69017 we do get some results. This will not work for us...at all. Is there any suggestions as to what i can do to make this work?

http://www.azcomputing.biz/

Thanks in advance for your help!

I am really at a loss here. Is there any search alternative?
Thanks

This should not be a problem if you have updated the:
/includes/modules/pages/advanced_search_results/header_php.php

correctly with the new field(s) you want included on the search ...

You should have added something on the where_str for the code:

        $where_str .= "(pd.products_name LIKE '%:keywords%'
                                         OR p.products_model
                                         LIKE '%:keywords%'
                                         OR m.manufacturers_name
                                         LIKE '%:keywords%'";

Ajeh:

This should not be a problem if you have updated the:
/includes/modules/pages/advanced_search_results/header_php.php

correctly with the new field(s) you want included on the search ...

You should have added something on the where_str for the code:

    $where_str .= "(pd.products_name LIKE '%:keywords%'
                                     OR p.products_model
                                     LIKE '%:keywords%'
                                     OR m.manufacturers_name
                                     LIKE '%:keywords%'";

I have to be honest I have no idea what you mean here...Should I put this in there?  I am poor with php programming so I dont know if this is something I add in or should change.  Further advise welcomed.  I just want to be able to search for part #'s with - in the middle (not all part #'s have a - in middle but many do)   like RM1-0013

You have added new fields to "some table" in your database or you have added new table(s) to your database ...

Where are these fields added?

How are they currently added to the search to be included in the search?

This is on an out of the box install (or was when the search problem was not working. Search works it just does not factor in the -

You said ...

Such as part # Q2425-69017 or RM1-0013

What field in the products table are you using for the Part # ... :unsure:

The part # is in the item title or item description. I havnt added any fields/tables for this.

So far I cannot reproduce the problem ...

I add the same things to my product descriptions and have no problem on the search ...

I did find your search doesn't appear to work for anything ...

What happens if you switch to the Classic Template?

The advanced search is not working right now as I am trying some things. The default template does the same thing. When I search for just 0013 I get results. When I search for rm1-0013 no results found.
Thanks!

The only thing I can think of is to do a compare of your files with something like Beyond Compare from scootersoftware.com with a clean Zen Cart vs your site to see if something has been changed in some manner ...

No matter what combination I use, I cannot repeat this error ...

Yea its somehow gotten worse. now when I search Q5421A no results but 5421 returns results...Arg :( Sad day here.

Actually after posting this I got an idea to check something. Its not the dash causing the problem.....its letters. 1-0013 returns results 2425-67901 returns results, its when I add letters in that the search gets messed up. Is this any more help?

so i can search by words/letters or numbers but I can not mix them...

It doesn't make sense at all what is happening ...

Zen Cart doesn't care what it is searching for ... so there is something changed in your code ...

The easiest solution is the comparison on clean code against the code on your site to find it ...

You can try replacing the contents of:
/includes/modules/pages/advanced_search/
/includes/modules/pages/advanced_search_results/
/includes/templates/template_default/templates/tpl_advanced_search_default.php
/includes/templates/template_default/templates/tpl_advanced_search_default.php

But there are numerous functions and classes also involved that could be the problem ...

I'd use Beyond Compare, myself ... it would be easier ...

I have restored all of those to default on the default template and default files and had the same poor success.

I am going to try on a fresh install.

On a completely fresh install with all default values I have the same problem. I am wondering if there is some setting on my server that is preventing searching with letters and numbers at the same time.

Any help would be appreciated I am trying to go love but without a proper search function Im dead in the water.

What version php and MySQL are you using?

Database: MySQL 5.0.77
PHP Version: 5.1.6 (Zend: 2.1.0)

I have tried another completely fresh install on a new server with the same results...I can not imagine this problem is unique to me? Three servers free installs downloaded fresh from this site and I get the same results on all...

Well, since you're getting consistent problems that are not commonly experienced by others, then it stands to reason that there's something unique to your server configuration. I'm guessing your default database collation settings are your problem.
Related discussion: http://www.zen-cart.com/forum/showthread.php?t=143258
I'm guessing you're not using the _ci version, and thus the searches aren't actually working because your database isn't allowing for case-insensitive searches.

I was able to fix the problem by changing the data type to utf8_general_ci

Thanks all for your help!