Drupal - User Management - Out of Memory error

Question

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!

Answer 1

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.

Answer 2

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