- 🇧🇷Brazil dungahk Balneário Camboriú
Are there any plans for a new release including this patch?
With MySQL 8.0.22, per the changelog:
Regular expression functions such as REGEXP_LIKE() yielded inconsistent results with binary string arguments. These functions now reject binary strings with an error. (Bug #31031886, Bug #98951, Bug #31031888, Bug #98950)
As a result, using BINARY (vs. NOT REGEXP) as an option (per the default setting upon install and the module's config form for transliteration_file_lowercase === TRUE), no longer work.
Download the module and attempt to enable/install Transliteration while using MySQL 8.0.22+ as your site's database. In my case, it returns the following error (though the character set may vary for other users):
SQLSTATE[HY000]: General error: 3995 Character set 'utf8_bin' cannot be used in conjunction with 'binary' in call to regexp_like.
Update the SQL statement to cast the uri as BINARY for MySQL databases.
Review the attached patch and see if it works correctly on MySQL 8.0.22 and lower MySQL versions.
None.
None.
None.
Fixed
3.0
Code
Not all content is available!
It's likely this issue predates Contrib.social: some issue and comment data are missing.
Are there any plans for a new release including this patch?