natural
10-8-03, 05:43 PM
Hello,
I have OSCommerce installed successfully(finally) on my website at http://www.naturalhealthland.com/catalog
Everything was working fine, until yesterday I noticed that when I perform a product search I get this message
Warning: mysql_query(): Unable to save result set in /www/n/naturalhealth/htdocs/catalog/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 '%n%' or p.products_model like '%n%' or m.manufacturers_name like '%n%') )
[TEP STOP]
I am certain that my database is not out of memory. I f I perform a search for an exact product name (that is in the database) the result is "no products found".
I have no idea what is causing this, and I would really appreciate any help.
I recently installed phpnuke in my root directory, and I clicked Optimize DB, I don't know if this may have had something to do with it, or not.
I also restored the database from the backup (causing me to lose some info ), and it didn't help
Thank you for any replies, you guys have always helped me out, since I am new here, you are a great help
Michal
I have OSCommerce installed successfully(finally) on my website at http://www.naturalhealthland.com/catalog
Everything was working fine, until yesterday I noticed that when I perform a product search I get this message
Warning: mysql_query(): Unable to save result set in /www/n/naturalhealth/htdocs/catalog/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 '%n%' or p.products_model like '%n%' or m.manufacturers_name like '%n%') )
[TEP STOP]
I am certain that my database is not out of memory. I f I perform a search for an exact product name (that is in the database) the result is "no products found".
I have no idea what is causing this, and I would really appreciate any help.
I recently installed phpnuke in my root directory, and I clicked Optimize DB, I don't know if this may have had something to do with it, or not.
I also restored the database from the backup (causing me to lose some info ), and it didn't help
Thank you for any replies, you guys have always helped me out, since I am new here, you are a great help
Michal