Error during installation : Illegal mix of collations...

Created on 23 July 2025, 3 months ago

Error during installation : Illegal mix of collations

When I try to install this module on my remote server (php8.3), I get a blank page with this error :

Drupal\Core\Database\DatabaseExceptionWrapper : SQLSTATE[HY000]: General error: 1270 Illegal mix of collations (ascii_general_ci,IMPLICIT), (utf8mb4_general_ci,COERCIBLE), (utf8mb4_general_ci,COERCIBLE) for operation 'in': SELECT "name", "data" FROM "config" WHERE "collection" = :collection AND "name" IN ( :names__0, :names__1 ); Array ( [:collection] => [:names__0] => webform.webform.club [:names__1] => webform.webform.comités ) dans Drupal\Core\Config\DatabaseStorage->readMultiple() (ligne 115 de...

In the error, I see the collection with webforms that don't exist on my site. I don't have any of these configs in my database ???? I simply have a webform.webform.contact. It seems to invent configurations with other data (node...).

The error comes from the fact that the term 'comités' contains an accented character, which causes the error.

This is really strange behavior.

Thanks for your help.

🐛 Bug report
Status

Active

Version

5.5

Component

Code

Created by

🇫🇷France kumkum29

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

Comments & Activities

Production build 0.71.5 2024