Error SQL SQLSTATE[22001] with large data

Created on 9 September 2021, over 3 years ago
Updated 10 March 2024, 10 months ago

Error SQL with large data

Insert more than 10 blocks

Than we will have :

Drupal\Core\Entity\EntityStorageException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'layout_section_section' at row 1: INSERT INTO {section_library_template__layout_section} ("entity_id", "revision_id", "bundle", "delta", "langcode", "layout_section_section") 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);

My resolution

In the table Table: section_library_template__layout_section change layout_section_section column from to LongBlob

🐛 Bug report
Status

Active

Version

1.0

Component

Code

Created by

🇫🇷France ckhalilo

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

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

Production build 0.71.5 2024