Forum Replies Created

Viewing 4 replies - 1 through 4 (of 4 total)
  • Eesh… I’ll take a look.

    I may contact the developer and see if he’ll let me take over ownership of the plugin.

    You’re right, @bennygill.

    Looks like this is the fix —

    on line 6 of /admin/bp-pending-activations-admin.php change this…

    return $wpdb->get_results( $wpdb->prepare( "SELECT u.*, m1.meta_value as activation_key FROM $wpdb->usermeta m1, $wpdb->users u WHERE u.ID = m1.user_id AND u.user_status = 2 AND m1.meta_key = 'activation_key' ORDER BY u.user_registered ASC" ) );

    to this…

    return $wpdb->get_results( $wpdb->prepare( "SELECT u.*, m1.meta_value as activation_key FROM $wpdb->usermeta m1, $wpdb->users u WHERE u.ID = m1.user_id AND u.user_status = %d AND m1.meta_key = %s ORDER BY u.user_registered ASC", 2, 'activation_key' ) );

    I’m thinking the developer may not be supporting this plugin anymore. It hasn’t been updated in over a year.

    Here’s the fix. On line 18 of bp-pending-activations.php change this…

    $count = $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(u.ID) FROM $wpdb->usermeta m1, $wpdb->users u WHERE u.ID = m1.user_id AND u.user_status = 2 AND m1.meta_key = 'activation_key' ORDER BY u.user_registered ASC" ) );

    to this …

    $count = $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(u.ID) FROM $wpdb->usermeta m1, $wpdb->users u WHERE u.ID = m1.user_id AND u.user_status = %d AND m1.meta_key = %s ORDER BY u.user_registered ASC", 2, 'activation_key' ) );

    Have you all tried refreshing your permalinks? Do this by going to Settings > Permalinks in your admin area.

    Solved it for me. Thanks Justin.

Viewing 4 replies - 1 through 4 (of 4 total)