View Full Version : Search no longer working (Details inside)

11-14-2005, 03:26 AM

I have been working on our OSCMAX site for a while now, only inputting the products for the moment.
Today I added more products and used the search feature to check I had set them up right. I preformed a search on the site which brough back results, but when i click a product it says "page cannot be displayed".
It worked fine up until today. Any ideas???

Logs are clean both on apache and oscmax. No errors, nothing.

Windows XP PRO SP1, Apache 2, MySQL 4.1, PHP 5 (i think).

You can view our site at http://ink4u.no-ip.org
This is a temp address for development only.

Thank you

11-24-2005, 11:08 AM
Works for me.....

11-27-2005, 01:42 AM
My admin search (catalog) is experiencing an out of memory error, but my storefront search is working fine. This was working better when I was using a stock osCommerce.

Here's the message:

Warning: mysql_query(): Unable to save result set in [my path omitted]/admin/includes/functions/database.php on line 45
2008 - MySQL client ran out of memory

select p.products_ship_price, p.products_id, p.products_model, pd.products_name, p.products_quantity, p.products_image, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p2c.categories_id from products p, products_description pd, products_to_categories p2c where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and pd.products_name like '%chrome%' or p.products_model like '%chrome%' order by pd.products_name

I'm wide open to suggestions.

11-27-2005, 01:49 AM
Running this same sql in phpmyadmin takes bloody forever but it succeeds.