[wp-trac] [WordPress Trac] #16270: Thousand users collapse author select box

WordPress Trac wp-trac at lists.automattic.com
Mon Jan 17 14:36:47 UTC 2011

#16270: Thousand users collapse author select box
 Reporter:  mairav          |      Owner:
     Type:  defect (bug)    |     Status:  new
 Priority:  normal          |  Milestone:  Awaiting Review
Component:  Administration  |    Version:  3.0.4
 Severity:  normal          |   Keywords:
 I have a site with 80.000 users, all of them are contributors.
 When I go to create or edit a post or page, the 80.000 users are listed in
 the author select box, and I get this error:

 Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to
 allocate 1048576 bytes) in /home/maximo/public_html/wp-includes/wp-db.php
 on line 1151

 I solved it for now editing the file wp-includes/user.php
 I searched for SELECT {$wpdb->users}.* FROM $wpdb->users
 And commented this lines:

 //      if ( $include )
 //              $query_where[] = "ID IN ($include)";

 And inmediately added the line:

         $query_where[] = "ID IN (1)";

 That made the error dissapear, but I can only select the admin user now.

 How can I solve this? Is there any way the Create or Edit pages don't try
 to load the 80.000 users? For example, using a search box?

 I was originally using the plugin Co-Authors Plus, but it seems to use the
 list generated by Wordpress, so I get the same error with or without that

 Sincerely thanks.

Ticket URL: <http://core.trac.wordpress.org/ticket/16270>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software

More information about the wp-trac mailing list