Ready to get started?Download WordPress


massive user table causes fatal errors in php with wp_list_authors (3 posts)

  1. Andy Bailey
    Posted 3 years ago #

    my error log is showing lots of errors to do with memory exceeded.
    I believe it is to do with the fact that I have over 43,000 registered user accounts with over 535,000 rows in wp_usermeta

    any time that I go to edit a post by a contributor the select author drop down box would take an age to render so I wrote a plugin to remove the authordiv meta box and replace it with one that only shows contributors.

    the problem still persists though due to other core files using wp_list_authors which I think is the function that is consuming so much memory

    here is a few lines from my error log

    [25-Jun-2011 11:20:38] WordPress database error MySQL server has gone away for query SELECT COUNT(ID) FROM wp_users made by require, require_once, include, genesis, do_action, call_user_func_array, genesis_get_sidebar, get_sidebar, locate_template, load_template, require_once, do_action, call_user_func_array, genesis_do_sidebar, dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, WP_Widget_Text->widget, apply_filters, call_user_func_array, do_shortcode, preg_replace_callback, do_shortcode_tag, call_user_func, cl_login_box
    [25-Jun-2011 11:20:55] PHP Fatal error:  Allowed memory size of 268435456 bytes exhausted (tried to allocate 64 bytes) in /home/comluv/public_html/wp-includes/meta.php on line 341
    [25-Jun-2011 11:21:43] PHP Fatal error:  Allowed memory size of 268435456 bytes exhausted (tried to allocate 82 bytes) in /home/comluv/public_html/wp-includes/wp-db.php on line 1400
    [25-Jun-2011 11:23:43] PHP Fatal error:  Allowed memory size of 268435456 bytes exhausted (tried to allocate 71 bytes) in /home/comluv/public_html/wp-includes/meta.php on line 344

    what can I do about this, I have upped my php memory limit from 64 to 128 to 256M but still the error persists. Just how much memory do I need for that kind of user table?

  2. whdcoinc
    Posted 3 years ago #

    I'm running into this same problem myself. I've increased memory to over a gig and still no luck. I keep getting the error too.

    In my case, I am getting this error when trying to use the broadcast email function.

  3. tikibah
    Posted 2 years ago #

    I had the same issue and fixed it by going into the domains cpanel in my host gator account and enabling EZconfig, then changed the memory_limit from 64m to 256m

    Everything works ok now, phew!!!!

Topic Closed

This topic has been closed to new replies.

About this Topic