Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Out of memory MySQL error


Guest

Recommended Posts

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

Link to comment
Share on other sites

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.

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

All of My Addons

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

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?
Link to comment
Share on other sites

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?

Link to comment
Share on other sites

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.

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

All of My Addons

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

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.

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

All of My Addons

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

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

Ask/Skype for Free osCommerce value addon/SEO suggestion tips for your site.

 

Check My About US For who am I and what My company does.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...