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.
Comments
Comment #2
larowlanComment #3
acbramley commentedPosting my analysis from slack:
Steps to reproduce should be around installing the standard profile + block_content module (to generate the field block deriviative) then enabling experience_builder?
Comment #6
isa.belPlease 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.
Comment #7
brandonlira commentedComment #8
wim leersThanks, @brandonlira!
Specifically, we need to know which database (SQLite, MariaDB …) and which version.
Comment #9
wim leers