Out of Memory error when I perform a search

[TKPope]

My website is https://herbsofmexico.com/store/
When a search is performed using the zencart search in the upper right (not the google search in the left column), I receive the following error message:

5 Out of memory (Needed 8388580 bytes)
in:
[select count(distinct p.products_id) as total FROM (zen_products p LEFT JOIN zen_manufacturers m USING(manufacturers_id), zen_products_description pd, zen_categories c, zen_products_to_categories p2c ) LEFT JOIN zen_meta_tags_products_description mtpd ON mtpd.products_id= p2c.products_id AND mtpd.language_id = 1 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 '%gingko%' OR p.products_model LIKE '%gingko%' OR m.manufacturers_name LIKE '%gingko%' OR (mtpd.metatags_keywords LIKE '%gingko%' AND mtpd.metatags_keywords !='') OR (mtpd.metatags_description LIKE '%gingko%' AND mtpd.metatags_description !='') OR pd.products_description LIKE '%gingko%') ))]

Is this a zencart problem or a sql problem?

What can be done to correct the problem?

Thanks!

Sean
+<|:-)

[kobra]

Need more information about the server you are on
http://www.zen-cart.com/forum/faq.php

[TKPope]

Server Information
Server Host: doblo.websitewelcome.com (174.120.189.226) Database Host: localhost (127.0.0.1)
Server OS: Linux 2.6.34.6 Database: MySQL 5.1.50
Server Date: 10/11/2010 12:31:00 Database Date: 10/11/2010 12:31:00
Server Up Time: 12:31:00 up 23 days, 13:58, 1 user, load average: 2.03, 1.82, 2.20 HTTP Server: Apache mod_fcgid/2.3.5 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635
PHP Version: 5.2.14 (Zend: 2.2.0) PHP Memory Limit: 64M PHP Safe Mode: Off
PHP File Uploads: On Max Size: 64M POST Max Size: 64M
Database Data Size: 220,270 kB Database Index Size: 3,858 kB

[kobra]

I believe your host allows a local php.ini file

PHP Memory Limit: 64M

Try 96M

[TKPope]

I use HostGator. Do I upload a php.ini file? If so, where?

Thanks!

[kobra]

I use HostGator.

websitewelcome.com told me that

Do I upload a php.ini file? If so, where?

At the root of your shop

[TKPope]

I created a php.ini file with the code mentioned above.
Does the file need to contain any other info?

I added that file to the store directory.

Now the entire site is down:
https://herbsofmexico.com/store/

Any help would be greatly appreciated!

Thanks,

Sean

[kobra]

What did you enter in the file
Using what editor

[TKPope]

Good news - The site is back up.
Bad news - The search is still not working...

I use ConTEXT as my editor.
The file simply has the one line code:
PHP Memory Limit: 64M

[kobra]

Server Information
PHP Memory Limit: 64M

The file simply has the one line code:
PHP Memory Limit: 64M

Bad news - The search is still not working...

You did not change anything it was 64M before and you entered 64M

BTW the correct syntax is

memory_limit = 96M