Search Error - MySQL Out of Memory

[Bali Hai]

I searched the forum and found 2 posts similar in 2003, but no reply. Can anyone help me resolve my Out of Memory error. I have 200MB allocated to MYSQL. I have used 0.73MB. My website is:

 

Siti's Jewelry Creations Catalog - Siti's Gallery

 

I get this error for most any search query:

Warning: mysql_query(): Unable to save result set in /hsphere/local/home/dwdobbs/sitisgallery.com/catalog/includes/functions/database.php on line 44

5 - Out of memory (Needed 4194276 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 '%pearl%' or p.products_model like '%pearl%' or m.manufacturers_name like '%pearl%') )

[♥Vger]

I get no error when searching your site.

 

Vger

[Bali Hai]

I get no error when searching your site.

 

Vger

Thank you Vger for your quick reply. I still get errors almost all the time.:angry:

 

If your not getting the error, then it must be on my machine, not the server (at least that's a good consolation). I just can't figure out what it could be and it's driving me nuts. :wacko:

 

Please let me know if there is anything I can check where this may be coming from.

 

Thanks again!!