Regex failed with mysql 8

  • Resolved msadowski

    (@msadowski)


    1 year, 11 months ago

    Hi There.

    Just found an issue with regex search with mysql 8 (PHP Warning: mysqli_query(): (HY000/3688): Syntax error in regular expression on line 1, character 3.)

    file: acf-better-search/src/Search/Where.php
    line: 127
    ‘REGEXP \'[[:<:]]’ . $this->wpdb->_real_escape( $phrase ) . ‘[[:>:]]\”;

    stackoverflow explanation https://stackoverflow.com/questions/59230737/mysql-regexp-changes-in-8-x

    configuration settings should consider if option “Options::OPTION_WHOLE_WORDS” is available in settings, when wp db is using mysql 8. This checkbox should be disabled and additional information should be provided

    • This topic was modified 1 year, 11 months ago by msadowski.
Viewing 1 replies (of 1 total)
  • Plugin Author Mateusz Gbiorczyk

    (@mateuszgbiorczyk)

    Hi @msadowski,

    Thank you for your message.

    Please check the “Use implementation of regular expression by Henry Spencer to search for whole words” option in the plugin settings. This should solve the problem.

    Best,
    Mateusz

Viewing 1 replies (of 1 total)
  • The topic ‘Regex failed with mysql 8’ is closed to new replies.

Tags