Out of memory MySQL error

[Guest]

I seem to be getting the following error as of today only. I believe that everything was fine yesterday. It happens when I try to load the catalog's front page.

 

It can be seen here: http://www.k-wbookworm.com/catalog

 

Any ideas what this could be caused by?

 

Warning: mysql_query() [function.mysql-query]: Unable to save result set in /home/waterloo/public_html/k-wbookworm.com/catalog/includes/functions/database.php on line 44

2008 - MySQL client ran out of memory

 

select manufacturers_id, manufacturers_name from manufacturers order by manufacturers_name

[Jack_mcs]

Check the entries in the admin->catalog->manufacturers and make sure the entries are all valid. If they are, try running a repair on the database using phpmyadmin.

[Guest]

Check the entries in the admin->catalog->manufacturers and make sure the entries are all valid. If they are, try running a repair on the database using phpmyadmin.

I can run that same query with MySQL Query Browser and in phpMyAdmin with no errors.  I would assume if there was an error with the table it would show up there as well, no?

[Guest]

I have 9,000 manufacturers (authors) at the moment. Could that be an issue? I copied the table over and deleted all but 100 manufacturers and the error went away. I was replaced by another out of memory error, but the original one was gone.

 

I replaced the table with the original and the error came right back. Is this a limitation of OSCommerce somehow?

[Jack_mcs]

I can run that same query with MySQL Query Browser and in phpMyAdmin with no errors. I would assume if there was an error with the table it would show up there as well, no?

I wasn't talking about an error for the first check. There is a hacking method going around where the hacker adds entries to the manufacturers table. Running a repair won't help if that is the case.

[Guest]

I'm not sure how to check if they are valid. There are 9,000 of them!

[Jack_mcs]

I have 9,000 manufacturers (authors) at the moment. Could that be an issue? I copied the table over and deleted all but 100 manufacturers and the error went away. I was replaced by another out of memory error, but the original one was gone.

 

I replaced the table with the original and the error came right back. Is this a limitation of OSCommerce somehow?

Did you really have 9,000 manufacturers? I've never seen a site with anywhere that amount. Even a 100 seems high, unless you have a large number of products (or 100 products with unique manufacturers, I suppose). The only limitation to the number of manufacturers is how much the database/server can handle. If your manufacturers are valid and it is still failing and your database doesn't have an error, then your serever is causing the problem. If you are using an old version of oscommerce, you may need to modify the database to speed it up.

[Guest]

We are a bookstore. There are tons of authors out there! 22,000 unique products at the moment and counting.

[satish]

select manufacturers_id, manufacturers_name from manufacturers order by manufacturers_name

 

what is the mysql properties set for both thees fileds.

You can some limit condition to it.

 

Satish

[Guest]

It is just not with that query, here is another out of memory error being generated:

 

PHP Fatal error: Out of memory (allocated 2621440) (tried to allocate 7680 bytes) in /catalog/includes/classes/message_stack.php on line 37

[♥kymation]

Ask your host if they have changed the memory allocation for your database.

 

Regards

Jim

[Guest]

Maybe this is a problem with php version 5.3.8 and MySQL version 5.1.56? Maybe a php memory leak?