PDOException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'field_message_rendered_subject_value

Created on 25 January 2013, over 11 years ago
Updated 15 January 2024, 5 months ago

Users have not been able to post comments - receiving the generic "The Site has Encounters an Error. Please try again later" error.

The error recorded in the log is as follows:

PDOException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'field_message_rendered_subject_value' at row 1: INSERT INTO {field_data_field_message_rendered_subject} (entity_type, entity_id, revision_id, bundle, delta, language, field_message_rendered_subject_value, field_message_rendered_subject_format) 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, :db_insert_placeholder_6, :db_insert_placeholder_7); Array ( [:db_insert_placeholder_0] => message [:db_insert_placeholder_1] => 16 [:db_insert_placeholder_2] => 16 [:db_insert_placeholder_3] => comment_insert [:db_insert_placeholder_4] => 0 [:db_insert_placeholder_5] => und [:db_insert_placeholder_6] =>

Hello Someone,

First Name Last Name has commented on your post Node Title.

Cheers,
Message notify example robot

[:db_insert_placeholder_7] => ) in field_sql_storage_field_storage_write() (line 448 of /var/www/html/modules/field/modules/field_sql_storage/field_sql_storage.module).

Disabling the Message Notify Module cleared the error and allowed comments to be posted again.

The error looks to be attributed to the comment subject field length is not properly set.

πŸ› Bug report
Status

Closed: outdated

Version

2.3

Component

Code

Created by

πŸ‡ΊπŸ‡ΈUnited States copeasetic

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

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

Production build 0.69.0 2024