[resolved] Complete User List on 1 Page (4 posts)

  1. mrclean
    Posted 8 years ago #

    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?

  2. Trent Adams
    Posted 8 years ago #

    Will this help?


  3. mrclean
    Posted 8 years ago #

    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)!

  4. mrclean
    Posted 8 years ago #

    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!

Topic Closed

This topic has been closed to new replies.

About this Topic