Thread

Anyone know what is causing this error: it just started happening whenever I try to switch to another CP menu item or save a record. If I refresh the browser on the error occurance it appears OK and any changes completed. Strange to say the least!!!

Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 85 bytes) in /home/wincityh/public_html/arp/earp/codeigniter/system/database/drivers/mysql/mysql_result.php on line 147

Hello MichaelSimone,

This is a pretty common error, especially on a shared hosting solution.

Can you check a few settings for me? These are in php.ini.

memory_limit
This sets the maximum amount of memory in bytes that a script is allowed to allocate.
Default size 5.3 in is “8M”

post_max_size (must be greater than upload_max_filesize)
Sets max size of post data allowed. This setting also affects file upload.
Default size in 5.3 is “128M”

upload_max_filesize
The maximum size of an uploaded file.

max_execution_time
This sets the maximum time in seconds a script is allowed to run before it is terminated by the parser.
Default setting in 5.3 is “30”

What do you have on your end?

If your settings look a little low, then you may want to increase some values.

Cheers,

Here is what I found when I pulled up the PHP Info
            Local|Master  
max_execution_time 300 | 30
max_file_uploads 20 | 20
max_input_nesting_level 64 | 64
max_input_time 60 | 60
memory_limit 32M | 32M
post_max_size 8M | 8M

do you see what the problem might be. This happens even when I simply log on to the CP

Thanks
Mike

Hello MichaelSimone,

These look okay to me, but since you are running out of mem, I would set memory_limit a bit higher. 64M is pretty decent, but I like to run with 128M.

Can you give that a try?

Cheers,

Where would I do it or do I have to contact the hosting company???

Hi,

Oh yeah, sorry about that.

The value gets changed in the php.ini file and then you bump Apache to pick the changes up.

On shared hosting you will have to get them to do it. Some will charge you more to run with more memory, which I have all kinds of issues with, but it’s something to be aware of.

Cheers,

I am trying to work through the same error and our shared hosting will not increase the memory beyond 64Mb.

I’m still experiencing the problem on an intermittent basis. I just refresh the browser and the changes or request goes through. I believe its an EE problem not a hosting problem. Everything else I have using EE or others works just fine.

I will call the hosting company and see if they will increase memory hoping this will solve the problem. Will let everyone know the results at that time

Good luck

Hey MichaelSimone,

Please do keep us posted!

Thanks!

I have a memory limit of 96M and getting

Fatal error: Allowed memory size of 100663296 bytes exhausted (tried to allocate 2048 bytes) in ..../control/codeigniter/system/database/drivers/mysql/mysql_result.php on line 147

Setting the memory limit higher in htaccess causes a 500 error. Virtual Dedicated server hosted by EngineHosting

Any ideas

Hi Ralph123,

Let’s get some more info here.

What version of ExpressionEngine are you using? What are you doing when the error shows? Is this in the Control Panel or the front end? What 3rd Party add-ons are you using? Did you make any recent changes before the errors began?

Cheers,

Structure Entries caused the issue. Pity I couldnt increase the memory limit though using htaccess. I seem to be locked in to 96M

Hey Ralph123,

Indeed, that is probably controlled at the server level.

Structure Entries caused the issue.

Did you contact the developer? They may not be aware of how memory intensive it is. They might be able to do something. 96M is a rather generous amount.

Cheers,

Structure Entries creates huge amounts of queries which renders it useless for a busy site. Reckon the developer knows. Flagged b4. Thanks

Hey Ralph123,

I am glad that Dan could help.

Is there anything else we can help you with?

Cheers,