Bug Character set 'utf8mb4_general_ci' cannot be used in conjunction with 'binary' in call to regex

[K a M a L]

The workaround for this issue

Duplicate - Character set 'binary' cannot be used in conjunction with 'utf8mb4_0900_ai_ci' in call to regexp_like ​

XF\Db\Exception: MySQL statement prepare error [3995]: Character set 'binary' cannot be used in conjunction with 'utf8mb4_0900_ai_ci' in call to regexp_like. src/XF/Db/AbstractStatement.php:228 Stack trace SELECT change_key, group_ids FROM xf_user_group_change...

xenforo.com

Fixed - MySQL 8.0.22+ - xf_phrase rlike compatibility ​

The xf_phrase.title table/column is varbinary. This affects XFRM/XFMG and some add-on migration code which uses RLIKE (or just LIKE) on this column. This works in previous versions of MySQL & MariaDB but appears to not work. Is there any reason for this column to not be varchar rather than...

xenforo.com
is no longer working with newer versions of MySQL

XF\Db\Exception: MySQL statement prepare error [3995]: Character set 'utf8mb4_general_ci' cannot be used in conjunction with 'binary' in call to...

Read more

Continue reading...