user profiles don’t show after search
-
when i search for my profile, or of another member’s profile i get no results even though i know i created them.
i talked to wp support nd they said this error is appearing:
[08-Jan-2020 04:12:19 UTC] PHP Notice: Undefined variable: meta_join_for_search in /srv/htdocs/wp-content/plugins/ultimate-member/includes/core/class-member-directory.php on line 1329
[08-Jan-2020 04:12:19 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘= ‘jack’
OR
mt4.meta_value LIKE ‘%jack%’
OR
mt4.meta’ at line 18 for query SELECT DISTINCT SQL_CALC_FOUND_ROWS wp_users.ID FROM wp_users LEFT JOIN wp_usermeta ON ( wp_users.ID = wp_usermeta.user_id ) LEFT JOIN wp_usermeta AS mt1 ON ( wp_users.ID = mt1.user_id ) LEFT JOIN wp_usermeta AS mt2 ON (wp_users.ID = mt2.user_id AND mt2.meta_key = ‘hide_in_members’ ) LEFT JOIN wp_usermeta AS mt3 ON ( wp_users.ID = mt3.user_id ) LEFT JOIN wp_usermeta AS mt4 ON ( wp_users.ID = mt4.user_id ) WHERE 1=1 AND (
wp_usermeta.meta_key = ‘First and Last name’
AND
(
( mt1.meta_key = ‘account_status’ AND mt1.meta_value = ‘approved’ )
AND
(
mt2.user_id IS NULL
OR
(
( mt3.meta_key = ‘hide_in_members’ AND mt3.meta_value NOT LIKE ‘%Yes%’ )
AND
( mt3.meta_key = ‘hide_in_members’ AND mt3.meta_value NOT LIKE ‘%Yes%’ )
)
)
AND
(
mt4user_login LIKE ‘%jack%’ OR user_url LIKE ‘%jack%’ OR display_name LIKE ‘%jack%’ OR user_email LIKE ‘%jack%’ OR user_nicename LIKE ‘%jack%’ OR .meta_value = ‘jack’
OR
mt4.meta_value LIKE ‘%jack%’
OR
mt4.meta_value LIKE ‘%s:4:\”jack\”;%’
)
)
) ORDER BY wp_usermeta.meta_value ASC, display_name ASC LIMIT 0, 12 made by do_action(‘wp_ajax_nopriv_um_get_members’), WP_Hook->do_action, WP_Hook->apply_filters, um\core\Member_Directory->ajax_get_members, WP_User_Query->__construct, WP_User_Query->querynot sure what this is although how can i fix the search issues
- The topic ‘user profiles don’t show after search’ is closed to new replies.