Error SQL SQLSTATE[22001] with large data

Created on 9 September 2021, over 3 years ago
Updated 10 March 2024, about 1 year 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.

  • 🇮🇹Italy finex

    Hi, I'm also experiencing this issue. Changed field type from blob to mediumblob temporary fixed it. A

  • Status changed to Closed: won't fix 3 months ago
  • 🇺🇸United States jastraat

    This is outside the scope of this module since the column is inheriting from Drupal core and the column size needs to be addressed there.

Production build 0.71.5 2024