Recently, I started getting "out of memory" messages on my website. It appears to be related specifically to the PHP database, not Zen Cart. These happen at random, not all of the time.
Has anyone else experieneced this? Is so, how did you resolve the problem?
Thread: Database Memory errors?
Results 1 to 5 of 5
-
9 Nov 2008, 10:29 AM #1
New Zenner
- Join Date
- Aug 2008
- Posts
- 51
- Plugin Contributions
- 0
Database Memory errors?
European designed, safe, eco-friendly children's toys:
Landbridge Toys
-
Re: Database Memory errors?
Do you have more details of the actual error message?
What is the "PHP Memory Limit" setting showing in Admin->Tools->Server Info?.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
-
9 Nov 2008, 11:10 PM #3
New Zenner
- Join Date
- Aug 2008
- Posts
- 51
- Plugin Contributions
- 0
Re: Database Memory errors?
Originally Posted by DrByte
Example of error message:
5 Out of memory (Needed 2091136 bytes)
in:
[select distinct p.products_id, p.products_image, pd.products_name from (landbridge1_products p left join landbridge1_featured f on p.products_id = f.products_id left join landbridge1_products_description pd on p.products_id = pd.products_id ) where p.products_id = f.products_id and p.products_id = pd.products_id and p.products_status = 1 and f.status = 1 and pd.language_id = '1']
In Server Info section
memory_limit = 99MEuropean designed, safe, eco-friendly children's toys:
Landbridge Toys
-
11 Nov 2008, 07:28 AM #4
Sensei
- Join Date
- Jan 2004
- Posts
- 66,373
- Blog Entries
- 7
- Plugin Contributions
- 274
Re: Database Memory errors?
99M is already a pretty good setting. However, bumping that up to 120M might be good, if you have control over that.
What version of Zen Cart are you using?
What addons do you have installed?
What version of PHP?.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
-
11 Nov 2008, 03:58 PM #5
New Zenner
- Join Date
- Aug 2008
- Posts
- 51
- Plugin Contributions
- 0
Re: Database Memory errors?
Zen Cart: 1.3.7
Addons: Image Handler
PHP Version: 4.4.8
I'll look into if I have the ability to increase the memory level.
If you have any other suggestions, please let me know.
ThanksEuropean designed, safe, eco-friendly children's toys:
Landbridge Toys
Similar Threads
-
v139h PHP Out of memory errors
By jgold723 in forum General QuestionsReplies: 14Last Post: 9 Jul 2014, 06:14 PM -
Optimizing database to avoid hitting memory limits?
By laurelsstitchery in forum General QuestionsReplies: 5Last Post: 29 Dec 2012, 06:40 PM -
PHPBB database errors
By hookah in forum General QuestionsReplies: 5Last Post: 4 Mar 2009, 07:39 PM -
Errors importing database
By ckosloff in forum General QuestionsReplies: 12Last Post: 18 Jun 2007, 01:34 PM -
Getting database errors
By stacy in forum General QuestionsReplies: 7Last Post: 23 Apr 2007, 10:13 PM
Bookmarks