Issue with custom profile element search

  • hi
    the custom search for profile elements, the ones added rencontre > custom > search > “Add a profile element into search”, isn’t working. It doesn’t get any results when there are profiles that should be a match.
    Tried a clean installation too, same issue. Sometimes I get no error, sometimes I get this:




    [15-Aug-2024 23:09:29 UTC] WordPress database error Syntax error in regular expression on line 1, character 2. for query SELECT
    U.user_login,
    U.display_name,
    R.user_id,

    R.i_zsex,
    R.c_zsex,
    R.i_zage_min,
    R.i_zage_max,
    R.i_zrelation,
    R.c_zrelation,
    R.c_pays,
    R.c_ville,
    R.i_sex,
    R.d_naissance,
    R.i_photo,
    R.e_lat,
    R.e_lon,
    R.d_session,
    P.t_annonce,
    P.t_titre,

    P.t_action
    FROM w2_users U
    INNER JOIN w2_rencontre_users R
    ON R.user_id=U.ID
    INNER JOIN w2_rencontre_users_profil P
    ON P.user_id=U.ID
    WHERE
    R.i_status IN (0,2,8,10)
    and (P.t_action NOT REGEXP ‘,pause1,|,pause2,’ or P.t_action IS NULL)
    and U.ID!=2 and R.i_sex=0 and (R.c_zsex LIKE ‘%,0,%’ or R.i_zsex=0) and R.i_taille<=’200′ and R.i_poids<=’120′ and P.t_profil REGEXP ‘({“i”:24,)[^{]+[[,:]0[],}]’ ORDER BY R.d_session DESC, P.d_modif DESC LIMIT 0, 7 made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/neve/page-templates/template-pagebuilder-full-width.php’), get_template_part, locate_template, load_template, require(‘/themes/neve/template-parts/content-pagebuilder.php’), the_content, apply_filters(‘the_content’), WP_Hook->apply_filters, do_shortcode, preg_replace_callback, do_shortcode_tag, f_shortcode_rencontre, RencontreWidget->widget, RencontreWidget::f_cherchePlus, RencontreWidget::f_trouver

    • This topic was modified 3 months, 1 week ago by sethy89.
Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter sethy89

    (@sethy89)

    hi
    if update 3.12.3 (Fix profil search issue on some servers.) was supposed to fix the above it doesn’t seem to have worked. It’s fine on the server just doesn’t work locally on wamp same error after the update.

    I also found another issue trying to add custom profile options strings with apostrophes on them. Just using “test v’s” results in error

    [28-Aug-2024 19:46:12 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 ‘s’,
    t_valeur='[“0″,”50″,”1″,”Unit”]’,
    i_type=’5′,
    i_poid’ at line 3 for query UPDATE wp_w2_rencontre_profil
    SET
    c_label=’test v’s’,
    t_valeur='[“0″,”50″,”1″,”Unit”]’,
    i_type=’5′,
    i_poids=’5′,
    c_genre=’0′
    WHERE
    id=’46’ and
    c_lang=’en’
    made by do_action(‘wp_ajax_profilA’), WP_Hook->do_action, WP_Hook->apply_filters, f_rencProfil, profil_edit

    I can add the escaped version ”s without error, but it will break the drop-down on the custom profile search if added and throws a console error ” Uncaught SyntaxError: Unexpected identifier ‘s’ “

    • This reply was modified 2 months, 3 weeks ago by sethy89.
    Plugin Author Jacques Malgrange

    (@sojahu)

    Noted! I will fix that.

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