Hi! I wish you have a great year
I’m adapting the search code of activities for meta_key.
The error is in the line of $sql that i cant found the right way to resolve.
I see the post https://buddydev.com/support/forums/topic/search-activity-meta/ but in this not use the sql.
I’ve been looking in forums and nothing helps me, can you please guide me?

`function sql( $search_term, $only_totalrow_count=false ){
global $wpdb, $bp;
$query_placeholder = array();

$activity_table = $wpdb->prefix.”bp_activity”;
$activity_meta_table = $wpdb->prefix.”bp_activity_meta”;
$sql = “SELECT COUNT(*) FROM $activity_table a INNER JOIN $activity_meta_table am ON a.id = am.activity_id WHERE a.item_id = %s AND meta_key = ‘titulo’ OR meta_key = ‘descr”;

$query_placeholder[] = ‘%’.$wpdb->esc_like( $search_term ).’%’;
$sql = $wpdb->prepare( $sql, $query_placeholder );

return apply_filters(
‘BBoss_Global_Search_Activities_sql’,
$sql,
array(
‘search_term’ => $search_term,
‘only_totalrow_count’ => $only_totalrow_count,
)
);
}`

The original code is

`function sql( $search_term, $only_totalrow_count=false ){
global $wpdb, $bp;
$query_placeholder = array();
$sql = ” SELECT “;
if( $only_totalrow_count ){
$sql .= ” COUNT( DISTINCT id ) “;
} else {
$sql .= ” DISTINCT a.id , ‘activity’ as type, a.content LIKE %s AS relevance, a.date_recorded as entry_date “;
$query_placeholder[] = ‘%’.$wpdb->esc_like( $search_term ).’%’;
}

//searching only activity updates, others don’t make sense
$sql .= ” FROM
{$bp->activity->table_name} a
WHERE
1=1
AND is_spam = 0
AND a.content LIKE %s
AND a.hide_sitewide = 0
AND a.type = ‘activity_update’
“;
$query_placeholder[] = ‘%’.$wpdb->esc_like( $search_term ).’%’;
$sql = $wpdb->prepare( $sql, $query_placeholder );

return apply_filters(
‘BBoss_Global_Search_Activities_sql’,
$sql,
array(
‘search_term’ => $search_term,
‘only_totalrow_count’ => $only_totalrow_count,
)
);
} `