Return to Question

When I attempt to programmatically update an event node, I get the error:

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

for most date fields. If I insert the record(s) with the same information into MySQL directly via the cli, it updates/inserts correctly. Anyone have any idea what's going wrong here?

Full error from logs: Drupal\Core\Entity\EntityStorageException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'field_event_end_date_and_time_value' at row 1: INSERT INTO {node__field_event_end_date_and_time} (entity_id, revision_id, bundle, delta, langcode, field_event_end_date_and_time_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] => 7159 [:db_insert_placeholder_1] => 7750 [:db_insert_placeholder_2] => events [:db_insert_placeholder_3] => 0 [:db_insert_placeholder_4] => en [:db_insert_placeholder_5] => 2014-06-18CDT21:30:00 ) in Drupal\Core\Entity\Sql\SqlContentEntityStorage->save() (line 770 of /var/www/acg/html/core/lib/Drupal/Core/Entity/Sql/SqlContentEntityStorage.php).

work correctly through the cli.

I'm sure I'm missing something stupid, does anyone see it?

When I attempt to programmatically update an event node, I get the error: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'field_event_end_date_and_time_value'...

For most date fields. If I insert the record(s) with the same information into MySQL directly via the CLI, it updates/inserts correctly. Anyone have any idea what's going wrong here?

Full error from logs:

Drupal\Core\Entity\EntityStorageException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'field_event_end_date_and_time_value' at row 1: INSERT INTO {node__field_event_end_date_and_time} (entity_id, revision_id, bundle, delta, langcode, field_event_end_date_and_time_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] => 7159 [:db_insert_placeholder_1] => 7750 [:db_insert_placeholder_2] => events [:db_insert_placeholder_3] => 0 [:db_insert_placeholder_4] => en [:db_insert_placeholder_5] => 2014-06-18CDT21:30:00 ) in Drupal\Core\Entity\Sql\SqlContentEntityStorage->save() (line 770 of /var/www/acg/html/core/lib/Drupal/Core/Entity/Sql/SqlContentEntityStorage.php).

work correctly through the CLI.

Does anyone see it?