- Issue created by @tim bozeman
-
tim bozeman β
committed 43569da2 on 2.0.x
Issue #3488274 by tim bozeman: Can't upload MacOS screenshot
-
tim bozeman β
committed 43569da2 on 2.0.x
Automatically closed - issue fixed for 2 weeks with no activity.
- π¦πΉAustria eameyers
@tim_bozeman Tim Bozeman, we have a similar error but at an upload from a zip file.
These are the errorsDrupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (ascii_general_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '=': UPDATE "inline_block_usage" SET "layout_entity_type"=:db_update_placeholder_0, "layout_entity_id"=:db_update_placeholder_1 WHERE ("layout_entity_type" = :db_condition_placeholder_0) AND ("layout_entity_id" = :db_condition_placeholder_1); Array ( [:db_update_placeholder_0] => [:db_update_placeholder_1] => [:db_condition_placeholder_0] => file_resup [:db_condition_placeholder_1] => 1-375101266-1732120946280-test_v1.0.0_2024-11-19.zip ) in Drupal\layout_builder\InlineBlockUsage->removeByLayoutEntity() (line 64 of /var/www/html/core/modules/layout_builder/src/InlineBlockUsage.php).
Drupal\Core\Entity\EntityStorageException: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (ascii_general_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '=': UPDATE "inline_block_usage" SET "layout_entity_type"=:db_update_placeholder_0, "layout_entity_id"=:db_update_placeholder_1 WHERE ("layout_entity_type" = :db_condition_placeholder_0) AND ("layout_entity_id" = :db_condition_placeholder_1); Array ( [:db_update_placeholder_0] => [:db_update_placeholder_1] => [:db_condition_placeholder_0] => file_resup [:db_condition_placeholder_1] => 1-375101266-1732120946280-test_v1.0.0_2024-11-19.zip ) in Drupal\Core\Entity\Sql\SqlContentEntityStorage->delete() (line 763 of /var/www/html/core/lib/Drupal/Core/Entity/Sql/SqlContentEntityStorage.php).
We have the 2.0.2 version, do you have any tips?
- πΊπΈUnited States tim bozeman
Have you narrowed down what character is the issue? Maybe thereβs a way to detect invalid characters in a generic way. π€