Quick Find Doesn't seem to work

This message was sent from: General Support
http://forums.oscommerce.com/viewtopic.php?p=228116#228116
----------------------------------------------------------------

The "Quick Find" search box in OS Commerce MS2 doesn't seem to work for me. I customized some things, but it didn't work even with the data in the sample store before I touched anything. I even installed the default setup on a second account I have for testing purposes, and it also doesn't work there. Is there something that needs to be done to configure this thing to work. The only thing I have done differently is install everything in the htdocs directory insteady of in a "catalog" subdirectory. I wouldn't think that would matter, though.

When I do a search it either tells me:

" There is no product that matches your search"


Or, more often than this it gives the following error:

Warning: mysql_query(): Unable to save result set in /www/c/charmcreation/htdocs/includes/functions/database.php on line 44
5 - Out of memory (Needed 8388580 bytes)

select count(distinct p.products_id) as total from products p left join manufacturers m using(manufacturers_id), products_description pd left join specials s on p.products_id = s.products_id, categories c, products_to_categories p2c where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and ((pd.products_name like '%bob%' or p.products_model like '%bob%' or m.manufacturers_name like '%bob%') )

Any suggestions?

Kirk