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

[WordPress Trac]

#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
 plugin.

 Sincerely thanks.

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