• courageous999

    (@courageous999)


    [13-Apr-2021 14:02:38 UTC] PHP Warning: preg_match(): Compilation failed: number too big in {} quantifier at offset 31 in /home/user/public_html/wp-content/plugins/ultimate-member/includes/core/class-member-directory.php on line 1481

    [13-Apr-2021 14:02:38 UTC] 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 '= 'travis' 
            OR 
            mt3.meta_value LIKE '%travis%' 
            OR 
        ' at line 13 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 = 'pp_rank' )  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 = 'um_member_directory_data' AND wp_usermeta.meta_value LIKE '%s:14:\"account\\_status\";s:8:\"approved\";%' ) 
          AND 
          ( 
            mt1.meta_key = 'pp_rank' 
            OR 
            mt2.user_id IS NULL
          ) 
          AND 
          ( 
            mt3user_login LIKE '%travis%' OR user_url LIKE '%travis%' OR display_name LIKE '%travis%' OR user_email LIKE '%travis%' OR user_nicename LIKE '%travis%' OR .meta_value = 'travis' 
            OR 
            mt3.meta_value LIKE '%travis%' 
            OR 
            mt3.meta_value LIKE '%s:6:\"travis\";%'
          )
        ) 
        AND 
        ( 
          ( 
            ( mt4.meta_key = 'wp_capabilities' AND mt4.meta_value LIKE '%\"um\\_client-npg\"%' ) 
            OR 
            ( mt4.meta_key = 'wp_capabilities' AND mt4.meta_value LIKE '%\"um\\_free-npg\"%' )
          )
        )
      )
    ) ORDER BY CAST(mt1.meta_value AS SIGNED) ASC, user_login 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->query

    Your plugin has been throwing those 2 errors for about a couple months intermittently now. I don’t know how to replicate it or when it’s happening. I just keep seeing it in the error_log.

    Just off eye inspection alone, you can see that after the 2nd AND in the query there’s a “mt3user_login” which seems like an error since “mt3” shouldn’t be there. Furthermore, in that same line you have a “OR .meta_value = ‘travis'” where it seems like the “mt3” should be just before that dot (which is what the 2nd error is complaining about). I’m not sure how this query has passed your testing or how it’s been running all this time without causing massive issues.

Viewing 4 replies - 1 through 4 (of 4 total)
Viewing 4 replies - 1 through 4 (of 4 total)
  • You must be logged in to reply to this topic.