Page 1 of 1
[SOLVED] Expand all pages caused out of memory
Posted: Fri Sep 25, 2009 5:09 am
by starbits
Hi,
I clicked "expand all pages" on a site with a very large number of pages and got an out of memory error. The rest of the admin functions correctly for that user name, but I can no longer view the content/pages. Is there some way in the database that I can reset my preference to "collapse all pages" so I can get that working again?
Thanks,
Steve
Re: Expand all pages caused out of memory
Posted: Fri Sep 25, 2009 6:30 am
by baresi
Adding this to your .htaccess file will probably help
php_value memory_limit 128M
Re: Expand all pages caused out of memory
Posted: Fri Sep 25, 2009 7:37 am
by Jeff
Go into you *_userprefs table and look for the preference "collapse". Clearing the blob field should collapse all the pages again.
Remember as with ALL database modifications, BACKUP FIRST!!!!
jeff
P.S. As suggested it would be wise to up your memory as well.
Re: [SOLVED] Expand all pages caused out of memory
Posted: Fri Sep 25, 2009 1:57 pm
by starbits
Thanks guys,
The .htaccess method gave me a 500 server error but the database mod worked fine. I will contact my host about raising the PHP memory limit.
I appreciate the help!
Re: [SOLVED] Expand all pages caused out of memory
Posted: Mon Sep 28, 2009 4:49 pm
by Pierre M.
Hello Steve,
next time please tell us more about "a very large number of pages" and your new working memory settings. Other people ask what the limit is and we say the limit is the current user interface rather than hard limit.
Pierre M.
Re: [SOLVED] Expand all pages caused out of memory
Posted: Mon Sep 28, 2009 5:04 pm
by starbits
Sorry Pierre,
I have not yet updated my memory, I have simply refrained from expanding all pages. At the time of failure I had approximately 800 pages, and the server has a 64M memory limit on PHP.
That is actually not a lot of pages; when the site goes live we will need to double that. Most of the pages are a catalog (using the Cataloger Module) so most pages are Content Type: Item rather than normal content (if that matters). But I think a 1600 item catalog should be able to be accommodated.
When we finish all the data entry, I may run some speed tests. If I do, I will let you know.
Regards,
STeve
Re: [SOLVED] Expand all pages caused out of memory
Posted: Mon Sep 28, 2009 5:07 pm
by Rolf
starbits wrote:
I will contact my host about raising the PHP memory limit.
Why don't you try the config.php file:
Code: Select all
# If you are experiencing propblems with php memory limit errors, then you may
# want to try enabling and/or adjusting this setting.
# Note: Your server may not allow the application to override memory limits.
$config['php_memory_limit'] = '128M';
Grtz. Rolf
Re: [SOLVED] Expand all pages caused out of memory
Posted: Mon Sep 28, 2009 5:53 pm
by starbits
Thanks Rolf,
I got my host to do it.
Steve