Allowed memory size exhausted
yosmc - March 8, 2008 - 00:03
| Project: | Site User List |
| Version: | 5.x-1.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Jump to:
Description
When trying to use this module I get the following error message:
Allowed memory size of 33554432 bytes exhausted (tried to allocate 24 bytes)
Granted, I have a fairly large user base, but a script like this (any script that isn't a special purpose maintainance script) should be able to run on 32 megs of memory. And on the other hand, I really can't go and raise the memory limits for the entire site to some huge value (simply too dangerous).
A fix would be highly appreciated!
#1
I'm not sure I have any way to fix this. There are a million things that could cause memory problems, and your error doesn't help me figure out what is going on at all.
For a start, can you go to the preferences and change it to use a "table" vs. a "view" or a "subselect query". Then go into the database and tell me how many rows are in the site_user_list_table?
Next, how many columns are you trying to display? And with what options? Do you use any custom templates or PHP templates?
Ricky
#2
Thanks for the reply. Actually it's quite simple - I have 50,000 members, and would have to set the memory that's available to a single php request beyond 100MB to even be allowed to get past clicking on the first menu link. The reason, as I've found out now by temporarily setting memory to 200MB is that the module immediately displays a list of ALL users on the first page. Unfortunately, I have found no way to turn that off - if I uncheck the "show the results" page it appears (judging from the time it takes to load the page) that all 50,000 users are still loaded from the database - they are just not displayed. Plus, that also breaks the results of any subsequent searches, which aren't displayed either.
I was assuming that the module would break the results down into pages, but it doesn't appear like that's possible - or did I overlook something? Thanks again!
#3
Hi! There's a patch in a different issue that will put a pager in place. When I have the time to make the next version (if Views 2 doesn't supercede SUL), I will probably add a pager.
But the reason I created this module in the first place was because all of the other user listers _did_ have a pager, and I needed one without a pager.
50,000 users is a lot of users, btw...
Ricky
#4
Well I picked Site User List because of the *search* functionality! ;) As you can imagine, a list with just pagination isn't really that useful when the member base reaches a certain size, but completely omitting it can lead to other problems...
Which patch are you referring to? I found only two patches in http://drupal.org/project/issues/site_user_list?states=8,13,14 and neither seems to do what you describe.