Database storage only works with ASCII public_id

Created on 10 October 2024, 9 months ago

Problem/Motivation

When uploading files that have non-ASCII characters in their filename the cloudinary database storage module cannot save them. The public_id column of the cloudinary_storage table is defined as a varchar_ascii type, which results in the following error when using non-ASCII characters:

Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (ascii_general_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '=': SELECT "cs".* FROM "cloudinary_storage" "cs" WHERE "public_id" = :db_condition_placeholder_0 LIMIT 1 OFFSET 0; Array ( [:db_condition_placeholder_0] => ) in Drupal\cloudinary_storage_db\CloudinaryStorageDb->load() (regel 69 van /code/web/modules/contrib/cloudinary/modules/cloudinary_storage/modules/cloudinary_storage_db/src/CloudinaryStorageDb.php).

Steps to reproduce

Enable the cloudinary_storage_db module
Upload a to Cloudinary using non-ASCII characters (e.g. é) in the filename
Select the file in a cloudinary media entity

Proposed resolution

Change the column type of cloudinary_storage.public_id to varchar.

🐛 Bug report

Status

Active

Version

3.0

Component

Code

Created by

🇧🇪Belgium klaasvw

Live updates comments and jobs are added and updated live.

Merge Requests

!32Database storage only works with ASCII public_id
Open
🇧🇪Belgium klaasvw
updated 9 months ago

Comments & Activities

Issue created by @klaasvw
Merge request !32Change the column type of cloudinary_storage.public_id to varchar → (Open) created by klaasvw
Comment 9 months ago →
🇧🇪Belgium klaasvw
The attached batches changes the column type to varchar.

contrib.social Blog FAQ Discussions

Production build 0.71.5 2024