Drupal\Core\Entity\EntityStorageException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'referers_value' at row 1: INSERT INTO {broken_link__referers} [#3170856]

If the referer value length is greater than 255 characters, The following error occurs

Drupal\Core\Entity\EntityStorageException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'referers_value' at row 1: INSERT INTO {broken_link__referers} (entity_id, revision_id, bundle, delta, langcode, referers_value)

I checked the base field definition of the referer field and the length in constraint is not working.

Comment	File	Size	Author
#4	set-base-fields-max-length-3170856-4.patch	975 bytes	hmdnawaz
#2	data_too_long_for_column_referers_value-3170856-2.patch	571 bytes	hmdnawaz

Issue fork broken_link-3170856

Show commands

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

Add & fetch this issue fork’s repository

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

Add & fetch this issue fork’s repository

3170856- changes, plain diff MR !3
Check out this branch for the first time

Check out existing branch, if you already have it locally

About issue forks

Comments

Comment #1

14 September 2020 at 14:08

hmdnawaz created an issue. See original summary.

Comment #2

hmdnawaz commented 14 September 2020 at 14:11

Status	File	Size
new	data_too_long_for_column_referers_value-3170856-2.patch	571 bytes

Comment #3

hmdnawaz commented 14 September 2020 at 14:32

Status:

Active

» Needs review

Comment #4

hmdnawaz commented 20 May 2021 at 10:22

Status	File	Size
new	set-base-fields-max-length-3170856-4.patch	975 bytes

1 file was hidden/shown/deleted

Status	File	Size
hidden	data_too_long_for_column_referers_value-3170856-2.patch	571 bytes

The query_string base field also uses the wrong length. We need to set the max length of the field instead of adding a length constraints.

Here is the new patch.

Comment #5

jcandan commented 21 January 2022 at 18:38

Ran into this error for the query_string base field after a Drupal core upgrade from 9.2.10 to 9.3.3. However, after upgrading to 9.2.11 I was not able to reproduce this error.

This seems like an arbitrary maximum. We tried bumping it to 20,000 (almost the 21,844 character maximum) with no success. I feel like this needs further assessment to identify just what is being stored here and why. For me, this may be related to Media as it happens on node save with featured image field.