Error while searching for an article that exists

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

When I do a search on a article that exist I get the following error.
I'm sure I have sufficient diskspace for MySQL tables (about 570 Mb)
 Thx for any answers
[b]
Products meeting the search criteria  


Warning: mysql_query(): Unable to save result set in /www/t/tweetie/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 '%microsoft%' or p.products_model like '%microsoft%' or m.manufacturers_name like '%microsoft%') )

[TEP STOP]
 [/b]