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.

CommentFileSizeAuthor
#6 image.png29.38 KBisa.bel
Command icon Show commands

Start within a Git clone of the project using the version control instructions.

Or, if you do not have SSH keys set up on git.drupalcode.org:

Comments

aangel created an issue. See original summary.

larowlan’s picture

Issue tags: +Novice
acbramley’s picture

Posting my analysis from slack:

The block name is a field block derivative of a block type provided by (possibly) standard profile. The experience_builder:component:reasons collection is definitely pointing to something XB is trying to save into key value

Steps to reproduce should be around installing the standard profile + block_content module (to generate the field block deriviative) then enabling experience_builder?

philalonso made their first commit to this issue’s fork.

isa.bel’s picture

StatusFileSize
new29.38 KB

Please add steps to replicate the issue, because with a vanilla Drupal 11.1 and trying to install this module, no errors were thrown. See attached screenshot.

brandonlira’s picture

wim leers’s picture

Status: Active » Postponed (maintainer needs more info)

Thanks, @brandonlira!

Specifically, we need to know which database (SQLite, MariaDB …) and which version.

wim leers’s picture

Status: Postponed (maintainer needs more info) » Closed (cannot reproduce)