Contrib.social

Drupal\Core\Entity\EntityStorageException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column deleted_value

Open on Drupal.org →
Created on 17 August 2023, 11 months ago
Updated 7 September 2023, 10 months ago

If the entity label value length is 255 characters the following error occurs

Drupal\Core\Entity\EntityStorageException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'deleted_value' at row 1: INSERT INTO "build_hooks_deployment__deleted" ("entity_id", "revision_id", "bundle", "delta", "langcode", "deleted_value") VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5); Array ( [:db_insert_placeholder_0] => 117 [:db_insert_placeholder_1] => 117 [:db_insert_placeholder_2] => pantheon_dev [:db_insert_placeholder_3] => 0 [:db_insert_placeholder_4] => en [:db_insert_placeholder_5] => Sed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium, totam rem aperiam, eaque ipsa quae ab illo inventore veritatis et quasi architecto beatae vitae dicta sunt explicabo. Nemo enim ipsam voluptatem quia vol (Content) ) in Drupal\Core\Entity\Sql\SqlContentEntityStorage->delete() (line 763 of /var/www/html/docroot/core/lib/Drupal/Core/Entity/Sql/SqlContentEntityStorage.php).

🐛 Bug report
Status

Fixed

Version

3.0

Component

Code

Created by

🇺🇦Ukraine loon Lutsk

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

Comments & Activities

contrib.social Blog FAQ Discussions
Production build 0.69.0 2024