Working on a project where we have a Drupal 5 set-up. There are currently 25'000 users in the database, and all 25'000 have a role with an expiry. Now every single time the admin tries to edit the user data (eg. Update User Role), the User Management page throws "Fatal Error: Out of Memory" on submission. Refreshing the user listing shows that the update has been made.
What can this be? How can I fix it?
Thanks!
PHP can be configured to use a limited amount of memory per HTTP request by means of the memory_limit configuration option.
Drupal 6 works around this and other resource limitations by distributing the work across several requests (via HTTP redirect or AJAX) using the Batch API.
With Drupal 5, I suggest increasing the memory limit. If this still does not work, investigate where the memory goes. Try deactivating modules until your memory problem goes away. This might not give you a solution, but might at least point you to the module that causes the memory problem.
Its better to make the memory limit to 128m in php.ini file and in settings.php file in drupal
http://drupal.org/node/207036
....then try to restart the apache if its possible
good luck