Skip to:
Content
Pages
Categories
Search
Top
Bottom

Member Directory Says Viewing 1-20 of 9K but shows 7 per pg & Only Have 3K Users


  • webfoundryhg
    Participant

    @webfoundryhg

    DETAILS
    The Member Directory on our site is only accessible by logged in members. It is set to show only paid site members (that’s the only code we’ve added to bp-custom.php) and I have tested and confirmed that the issue is the same even if we remove the code in bp-custom.php and have the directory show all site members.

    We had to import these members. I did confirm there are no duplicate users.
    =============================================================================

    WE SHOULD SEE:
    We have 3302 paid members that should be appearing in the Member Directory.
    The member directory should show 20 folks per page.

    WE ARE SEEING:
    Viewing 1 – 20 of 9,629 members
    That’s not quite 3x too many

    The member directory is showing only 7 per page rather than 20 even though it says Viewing 1 – 20

    If you search for someone by first and last name so you only get 1 result….a couple fake examples:

    search for: JANE JAMES
    the top of the screen will say Viewing 1 – 3 of 3 members but below it we see the ONLY Jane James on site.

    search for: HOLLY HALL
    the top of the screen will say Viewing 1 – 4 of 4 members but below it we see the ONLY Jane James on site.

    =============================================================================

    WP Version 4.5.2
    WP Installed in root
    New site build, not upgrade
    BP Version 2.5.2
    bbPress Version 2.5.9
    Amazon AWS Server

    Thanks!

Viewing 1 replies (of 1 total)

  • webfoundryhg
    Participant

    @webfoundryhg

    SOLVED:
    was info left in database from previous imports leading up to launch…

    select field_id, count(*) c from wp_bp_xprofile_data group by field_id having c > 1;

    | field_id | c |
    +———-+——-+
    | 1 | 7159 |
    | 2 | 68 |
    | 3 | 23 |
    | 4 | 7103 |
    | 5 | 7041 |
    | 6 | 33 |
    | 7 | 7089 |
    | 9 | 7119 |
    | 13 | 21502 |
    | 14 | 7099 |
    | 15 | 7108 |
    | 16 | 7080 |
    | 17 | 7118 |
    | 18 | 7118 |
    | 19 | 7117 |
    | 20 | 7123 |
    | 21 | 7123 |
    | 22 | 7123 |
    +———-+——-+
    notice field_id 13
    has 21k rows, roughly 7000 x 3
    And field_id 13 is for our custom field
    So, i’ll bet our custom field is in wp_bp_xprofile_data 3x causing counts to go up x3 roughly
    And the proof query …
    select value, count(*) c from wp_bp_xprofile_data where field_id=13 group by value having c > 1;
    each member is in wp_bp_xprofile_data 3x

Viewing 1 replies (of 1 total)
  • You must be logged in to reply to this topic.
Skip to toolbar