PHP Warning: preg_match(): Compilation failed… in class-member-directory.php
-
I’m using Ultimate Member v2.1.6 on an up-to-date WordPress system. When users search the Member Directory for a name (e.g. “vanitha”), a PHP Warning is generated in the log:
[Jun 04, 11:29:43] PHP Warning: preg_match(): Compilation failed: number too big in {} quantifier at offset 30 in /wp-content/plugins/ultimate-member/includes/core/class-member-directory.php on line 1474
Here are the full details:
New PHP errors have been logged on https://www.villagehillcommunity.org
Here are the last 3 entries from /home/holycowom/public_html/www.VillageHillCommunity.org/wp-content/elm-error-logs/php-errors.log:) ORDER BY CAST(mt2.meta_value AS CHAR) ASC LIMIT 0, 12 made by do_action(‘wp_ajax_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->query
[Jun 04, 11:29:43] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘= ‘vanitha’
OR
mt3.meta_value LIKE ‘%vanitha%’
OR
‘ at line 11 for query SELECT DISTINCT SQL_CALC_FOUND_ROWS wp_users.ID FROM wp_users INNER JOIN wp_usermeta ON ( wp_users.ID = wp_usermeta.user_id ) INNER JOIN wp_usermeta AS mt1 ON ( wp_users.ID = mt1.user_id ) INNER JOIN wp_usermeta AS mt2 ON ( wp_users.ID = mt2.user_id ) INNER JOIN wp_usermeta AS mt3 ON ( wp_users.ID = mt3.user_id ) INNER JOIN wp_usermeta AS mt4 ON ( wp_users.ID = mt4.user_id ) WHERE 1=1 AND (
(
(
( wp_usermeta.meta_key = ‘um_member_directory_data’ AND wp_usermeta.meta_value LIKE ‘%s:14:\”account\\_status\”;s:8:\”approved\”;%’ )
AND
( mt1.meta_key = ‘um_member_directory_data’ AND mt1.meta_value LIKE ‘%s:15:\”hide\\_in\\_members\”;b:0;%’ )
AND
mt2.meta_key = ‘first_name’
AND
(
mt3user_login LIKE ‘%vanitha%’ OR user_url LIKE ‘%vanitha%’ OR display_name LIKE ‘%vanitha%’ OR user_email LIKE ‘%vanitha%’ OR user_nicename LIKE ‘%vanitha%’ OR .meta_value = ‘vanitha’
OR
mt3.meta_value LIKE ‘%vanitha%’
OR
mt3.meta_value LIKE ‘%s:7:\”vanitha\”;%’
)
)
AND
(
(
( mt4.meta_key = ‘wp_capabilities’ AND mt4.meta_value LIKE ‘%\”um\\_associate\”%’ )
OR
( mt4.meta_key = ‘wp_capabilities’ AND mt4.meta_value LIKE ‘%\”um\\_business\”%’ )
OR
( mt4.meta_key = ‘wp_capabilities’ AND mt4.meta_value LIKE ‘%\”um\\_resident\”%’ )
)
)
)
[Jun 04, 11:29:43] PHP Warning: preg_match(): Compilation failed: number too big in {} quantifier at offset 30 in /wp-content/plugins/ultimate-member/includes/core/class-member-directory.php on line 1474We’ve seen many of these recently and wanted to let you know. The search itself seems to work ok.
The page URL is restricted, so if you need access to the site, please let me know. Thanks!
The page I need help with: [log in to see the link]
- The topic ‘PHP Warning: preg_match(): Compilation failed… in class-member-directory.php’ is closed to new replies.