Thread

Just to give a history on how I discovered this error is that I am writing a conversion script from PHPBB to EE for this site.  All is running smoothly and works perfectly.

The problem is that they currently have over 100,000 users and when I log in to EE admin and goto view members I get the following error.

Allowed memory size of 33554432 bytes exhausted (tried to allocate 71 bytes) in /var/www/vhosts/codingdesigns.net/subdomains/pronet/httpdocs/pronet_ee_core/db/db.mysql.php on line 384

I noticed before that the View Members area listed ALL members instead of paginating this which looks like the cause of the error.

Without incresing the memory size (which is currently at 32M) how do you suggest going about recoding the members template to display members in the admin area?

TIA,
Jason

Jason, you could probably write an extension to change things. But it would be a lot simpler to increase the memory size to 48M or so.

I agree that it would be easier but I think it is best if we just use an extension instead.  It is just that one area in the CP that does it because it isn’t paginated.

I guess I can put in a request thread for that to change?

A feature request would definitely be in order.

I looked through the code and found

function view_all_members($message = ‘’)

but I’m not seeing a hook.

What I’d do instead is build a query that paginates. It could be built into a template page and displayed that way.

One other way would be to use Solspace’s User Module. But that’s a front end solution instead of back end solution.

Cool.  I will put in a request.  I just checked and if I remove about 30,000 users it works with no problems.  A little slow compared to the paginated frontends but overall it works.

Thanks for the help.  😊

Hi, Jason - as Derek mentioned in your feature request, that section does have pagination.

Can you let us know what version and build of ExpressionEngine you’re on, as well as any extensions or hacks you may have in place?

Thanks for the help but I finally got it working.  Looks like 32M is not enough memory for 50 members to be listed.  Since pagination is there I took Sue’s advice and upped the memory size to 48M and voila.  😊

I am running 1.6.2 now but it was 1.6.1.

Thanks again,
Jason

Ah, glad you got it working, Jason. =)