PowWeb Forums - The Perfect Community for the Perfect Host  

Register now to interact with over 11,000 members! Registered users have Posting Privileges, free access to Private Messaging, Email Notifications and more.

Go Back   PowWeb Community Forums > Web Site Design > Content Management Systems > E-commerce and Shopping Carts
User Name
Password
Register FAQ Members List Search Today's Posts Mark Forums Read

Closed Thread
 
Thread Tools Search this Thread
Old 9-11-03, 07:12 PM   #1
kvanoote
 
Posts: n/a
Quick Find Doesn't Work

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 Powweb 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
 
Closed Thread


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT -4. The time now is 11:45 AM.


Contents ©PowWeb, Inc. ~ vBulletin, Copyright © 2000-2007 Jelsoft Enterprises Limited.