[SOLVED] Expand all pages caused out of memory

[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

[baresi]

Adding this to your .htaccess file will probably help

php_value memory_limit 128M

[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.

[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!

[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.

[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

[Rolf]

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 

[starbits]

Thanks Rolf,
I got my host to do it.
Steve