[wp-hackers] Re: WP admin users.php for more than 40k users

[Malaiac]

2009/3/26 Malaiac <malaiac at gmail.com>:
> users.php did not work for a few days.
> The script stops on "get_users_of_blog()" (in wp-includes/user.php)
> called from wp-admin/users.php on line 255

just for info :
in wp-includes/user.php, line 235
line that breaks : $users = $wpdb->get_results( "SELECT user_id,
user_login, display_name, user_email, meta_value FROM $wpdb->users,
$wpdb->usermeta WHERE " . $wpdb->users . ".ID = " . $wpdb->usermeta .
".user_id AND meta_key = '" . $wpdb->prefix . "capabilities' ORDER BY
{$wpdb->usermeta}.user_id" );
with a limit, it works : $users = $wpdb->get_results( "SELECT user_id,
user_login, display_name, user_email, meta_value FROM $wpdb->users,
$wpdb->usermeta WHERE " . $wpdb->users . ".ID = " . $wpdb->usermeta .
".user_id AND meta_key = '" . $wpdb->prefix . "capabilities' ORDER BY
{$wpdb->usermeta}.user_id LIMIT 10000" );