Contrib.social

Data too long for column 'name' error

Open on Drupal.org →
Created on 24 March 2025, 6 months ago

Overview

While installing alpha6 on 11.1, I received the error below:

% ddev drush en experience_builder

In ExceptionHandler.php line 56:

  SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'name' at row 1: INSERT INTO "key_value" ("name", "collection", "value")
   VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2); Array
  (
      [:db_insert_placeholder_0] => field_block:block_content:basic:revision_translation_affected:block.field_block.block_content.basic.revision_transl
  ation_affected
      [:db_insert_placeholder_1] => experience_builder:component:reasons
      [:db_insert_placeholder_2] => a:1:{i:0;s:47:"Block plugin settings must be fully validatable";}
  )

I was able to push through by increasing the size of the VARCHAR from 128 to 255.

Proposed resolution

larowlan suggested that \Drupal\experience_builder\ComponentIncompatibilityReasonRepository::generateKey will need to hash if it is longer than 128 chars.

🐛 Bug report
Status

Active

Version

0.0

Component

Miscellaneous

Created by

🇺🇸United States aangel

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

Merge Requests

Comments & Activities

contrib.social Blog FAQ Discussions
Production build 0.71.5 2024