- Issue created by @Mohan6695
- Status changed to Closed: duplicate
almost 2 years ago 3:35pm 14 April 2023 - 🇺🇸United States DamienMcKenna NH, USA
Let's fix this in 📌 Fix MySQL 7.4 vs 8 compatibility bugs Fixed .
Search keyword functionality is not working with MySQL version 8.0.30, it results in the below SQL query error.
SQLSTATE[HY000]: General error: 3995 Character set 'utf8mb4_0900_ai_ci' cannot be used in conjunction with 'binary' in call to regexp_like.: SELECT "base_table"."vid" AS "vid", "base_table"."nid" AS "nid"
FROM
"node" "base_table"
INNER JOIN "node_field_data" "node_field_data" ON "node_field_data"."nid" = "base_table"."nid"
INNER JOIN "node__body" "node__body" ON "node__body"."entity_id" = "base_table"."nid"
WHERE ("node_field_data"."type" = :db_condition_placeholder_0) AND ("node__body"."body_value" REGEXP BINARY :db_condition_placeholder_1); Array
(
[:db_condition_placeholder_0] => product
[:db_condition_placeholder_1] => \bpolicy\b
)
Note: The module is working with MySQL version less than 8
1. Install the module (scanner 8.x-1.x-dev/8.x-1.0-rc6) & enable entity types.
2. Search the any keyword
Thanks, in advance.
Closed: duplicate
1.0
Code
Let's fix this in 📌 Fix MySQL 7.4 vs 8 compatibility bugs Fixed .