Thread

I am getting memory errors in the control panel of an EE 1x site that now has over 300,000 entries.

Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 72 bytes) in /path/to/system/db/db.mysql.php on line 383

* There is one channel specifically that has most of the entries and it throws a memory error when I try to filter for that channel.
* And now (within the last week) it throws a memory error when I try to edit any entry in any channel.
* I tried to disable all Extensions but the memory errors persisted.
* The site is running EE 1.6.9 and is hosted on an EngineHosting shared plan.

I wondered if the site has outgrown the shared hosting plan but I thought I would check with EE support to see if there are other issues to investigate as well.

Hi, Mark.

First things first.. can we get you to upgrade to 1.7.1? This way we can both be on the same page as far as versions go.

Is this site slated to be upgraded to EE2.x at any time?

Sue, the site will be upgraded to 2x late summer or in the fall.

As far as upgrading… this has been an issue for a while. I can upgrade to 1.7.1 but it may be a few days before I can get to that. Is there anything that comes to mind that I could investigate or tweak related to the memory errors before the upgrade?

EngineHosting normally runs with 64M of PHP Memory, and you’re topping out at 132M, so it looks like something’s already being done.

You mentioned you have 300,000 entries. How many custom fields are you using? You mentioned you attempted to disable extensions, did you do that globally via the big green button?

If you create an Edit This link on the main site, can you get into the back end enough to edit a single entry that way?

There are about 220 custom fields. And yes, it was a global Extension disable using the green button.

For the Edit link, are you asking if I can paste in a url like this to jump right to an entry?
http://example.com/system/index.php?S=0&C=edit&M=edit_entry&weblog_id=11&entry_id=160786

When I tried that, I still get this memory error:
Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 80 bytes) in /path/to/system/db/db.mysql.php on line 383

Okay, I think I am closer to figuring out the cause of this issue…

The memory error only shows up on channels where the “Authors” menu is enabled on the Publish Page Customization. I just did a test where I turned off the Authors tab and the screens load just find.

This site does have 70,000+ members and the members are being logged as the authors on some of the channels.

Thoughts?

NOTE: I still get the memory errors when trying to filter by the one channel that has 200,000+ entries.

Hi Mark,

The upcoming 2.2 release has optimizations in this area, so that might be a consideration for upgrading sooner. If you want to get by on 1.x, try upgrading to 1.7.1 and if you still hit that error we can take a look.