I have a Recipe content type that uses a multi-value field for ingredients lists. I was testing doing a search and replace on "avocado." This is the field content before:
and the field content after:
and the error that I received upon performing the search/replace:
Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'field_ingredients_value' at row 1: INSERT INTO "node__field_ingredients" ("entity_id", "revision_id", "bundle", "delta", "langcode", "field_ingredients_value") 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); Array ( [:db_insert_placeholder_0] => 250016 [:db_insert_placeholder_1] => 2070781 [:db_insert_placeholder_2] => recipe [:db_insert_placeholder_3] => 0 [:db_insert_placeholder_4] => en [:db_insert_placeholder_5] => 6 medium sweet potatoes, 2 scallions, sliced thin, 1 cup shredded part-skim mozzarella or dairy-free mozzarella style shreds, 1 cup canned black beans, drained, rinsed, 2 tbsp. Parmesan, grated, or dairy-free Parmesan or nutritional yeast, 1/2 avocadoo, peeled, pitted, and diced, 1/2 cup salsa verde, Extra virgin olive oil ) in Drupal\Core\Entity\Sql\SqlContentEntityStorage->saveToDedicatedTables() (line 1403 of /var/www/html/docroot/core/lib/Drupal/Core/Entity/Sql/SqlContentEntityStorage.php).
Active
Code