Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations

Created on 19 October 2023, 9 months ago

Im facing this error on my site during all the time cron runs which stops the cron.

Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '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" WHERE ("node_field_data"."title" LIKE :db_condition_placeholder_0 ESCAPE '\\') AND ("node_field_data"."type" = :db_condition_placeholder_1) GROUP BY "base_table"."vid", "base_table"."nid" LIMIT 1 OFFSET 0; Array ( [:db_condition_placeholder_0] => Mission Viejo: πŸ’¬ OCFA PIO: OCFA is on scene of an approximate 3 acre vegetation fire in Aliso Woods Canyon. We are in unified command with @LagunaB... [:db_condition_placeholder_1] => twitter_feeds ) in Drupal\Core\Entity\Query\Sql\Query->result() (line 271 of /var/www/html/cityofmission/core/lib/Drupal/Core/Entity/Query/Sql/Query.php).

Can anybody help ?

πŸ“Œ Task
Status

Active

Component

User interface

Created by

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Production build 0.69.0 2024