BuddyPress.org

HI,

When i search for a member in a group (/groups/grupo/members/), occurs this error:
[Unknown column ‘u.user_id’ in ‘IN/ALL/ANY subquery’]
SELECT u.ID as id FROM adwp_users u WHERE 1=1 AND u.ID IN (27412,304,509,6625) AND u.user_id IN ( SELECT ID FROM adwp_users WHERE ( display_name LIKE ‘%ar%’ OR user_login LIKE ‘%ar%’ ) ) ORDER BY FIELD(u.id,27412,304,509,6625) LIMIT 0, 20
[Unknown column ‘u.user_id’ in ‘IN/ALL/ANY subquery’]
SELECT COUNT(u.ID) FROM adwp_users u WHERE 1=1 AND u.ID IN (27412,304,509,6625) AND u.user_id IN ( SELECT ID FROM adwp_users WHERE ( display_name LIKE ‘%ar%’ OR user_login LIKE ‘%ar%’ ) )
In log we have “do_action(‘wp_ajax_bp_get_suggestions’), WP_Hook->do_action, WP_Hook->apply_filters, bp_ajax_get_suggestions, bp_core_get_suggestions, BP_Groups_Member_Suggestions->get_suggestions, BP_User_Query->__construct, BP_User_Query->do_user_ids_query”

I check the SQL and changing the field name “… AND u.user_id IN ( SELECT ID FROM adwp_users …” by “… AND u.ID IN ( SELECT ID FROM adwp_users …” fix it.

So, in /plug-ins/buddypress/bp-core/classes/class-bp-user-query.php file, on line 346, changing:
$sql[‘where’][] = “u.{$this->uid_name} IN ( SELECT ID FROM {$wpdb->users} WHERE ” . bp_core_get_status_sql( ” ) . ” )”;
to:
$sql[‘where’][] = “u.ID IN ( SELECT ID FROM {$wpdb->users} WHERE ” . bp_core_get_status_sql( ” ) . ” )”;

The message error is solved.
Could someone confirm and fixit in a new version?
I am using WP 4.9.7 and Buddypress 4.2.0.

Tks
Douglas

BuddyPress 4.2.0 is now available: https://buddypress.org/2019/02/buddypress-4-2-0-maintenance-and-security-release/

ENGLISH:
Hello, I have a problem with my buddypress for sending message between two members. When I click on “Write a message” I switch to the parge to write a message but in the location “Send @UserName” the name of the recipient does not start automatically. It must be written manually. This poses me a problem.

I wish that the recipient of the message is automatically put, that we do not have to write it each time.

Thanks for your help.

FRENCH:
Bonjour, j’ai un probleme avec mon buddypress pour l’envoi de message entre deux membres. Lorsque je clique sur “Rédiger un message” je bascule sur la parge afin d’ecrire un message mais dans l’emplacement “Envoyer @NomUtilisateur” le nom du destinataire ne se met pas automatiquement. Il faut l’ecrire manuellement. Cela me pose un probleme.

Je souhaiterai que le destinataire du message se mette automatiquement, que l’on ne soit pas obligé de l’écrire à chaque fois.

Merci pour votre aide.

Hi!

I am using BuddyPress with “SuitePlugins – Advanced XProfile Fields for BuddyPress”, and I created some custom fields. On the registration page I want to check if ex. “idofcertificate” custom field data exist in the database. If exist then throw an error, to only one account to be created with this “idofcertificate”. There is any resolution to do this?

Thank you very much!

A general question, not related to a live site at this point, just something I’m playing with.

With a fresh WordPress + BuddyPress install, under Users > Profile Fields, I’ve created a new field called Last Name.

New registrations are capturing the data correctly and it is stored in wp_bp_xprofile_data.

Is there any easy way of also getting that value into wp_usermeta.last_name as well?

Thanks in advance.

Hi. I noticed that the three options which BuddyPress offers in regards to field visibility is “Only Me”, “Friends Only”, and “Everyone”. If someone sets their preference of a field to “Only Me” or “Friends Only”, is it still possible for the admin to see it? If not, is there a method that I can implement to see it as an admin but to hide it to other members? Also, can I put this field into an additional column on the Users Admin Panel? Thanks for any assistance which you can provide me.