• Resolved mrclean

    (@mrclean)


    Is there any setting on WP2.1 where I can change how the list of Authors/Users is displayed? I need to have all of them on one page (like it used to be) instead of on multiple pages. Ideas? Suggestions? Hacks?

Viewing 3 replies - 1 through 3 (of 3 total)
  • Will this help?

    Trent

    Thread Starter mrclean

    (@mrclean)

    I apologize. I should be more specific. This is just for the Administration portion. For some reason, my user list has duplicated itself and I need to remove the duplicates. This would be much easier if all the Users and Authors were listed on a single page instead of on multiple pages. (I have 2000+ members)!

    Thread Starter mrclean

    (@mrclean)

    I found another method to fix this problem. Using phpMyAdmin I entered this SQL query:

    select bad_rows.*
    from wp_users as bad_rows
    inner join (
    select user_login, MIN(id) as min_id
    from wp_users
    group by user_login
    having count(*) > 1
    ) as good_rows on good_rows.user_login = bad_rows.user_login
    and good_rows.min_id <> bad_rows.id;

    This gave me a list of duplicates in which I could delete all of the records shown to remove the dupes. Thanks again for your help Trent!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Complete User List on 1 Page’ is closed to new replies.