• Resolved Larry Daniele

    (@larrydaniele)


    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 1474

    We’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!

    • This topic was modified 4 years, 9 months ago by Larry Daniele. Reason: Added information about URL with problem

    The page I need help with: [log in to see the link]

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Mykyta Synelnikov

    (@nsinelnikov)

    Hi @larrydaniele

    You could activate this option to change WP native queries to the custom database table https://www.screencast.com/t/T1quPy6SzI

    Let me know how it works with an active option,
    Thanks!

    Thread Starter Larry Daniele

    (@larrydaniele)

    @nsinelnikov Thanks for the suggestion. I went to Ultimate Member > Settings > Misc and checked the “Enable custom table for usermeta” option. I pressed “Run” and the upgrade process completed successfully.

    I’ll report back next week if this solves the problem.

    Larry

    Plugin Contributor Champ Camba

    (@champsupertramp)

    Hi @larrydaniele,

    This thread has been inactive for a while so we’re going to go ahead and mark it Resolved..Please feel free to re-open this thread if any other questions come up and we’d be happy to help. ??

    Regards,

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘PHP Warning: preg_match(): Compilation failed… in class-member-directory.php’ is closed to new replies.