When removing fields via a configuration sync, a number of red error messages appeared containing the following text (one for each field and field storage removed - this example is for field_description's storage)
Unexpected error during import with operation delete for field.storage.node.field_description: SQLSTATE[22007]: Invalid datetime format: 1292 Truncated incorrect DOUBLE value: 'node.field_description': DELETE FROM "views_natural_sort"
WHERE ("eid" = :db_condition_placeholder_0) AND ("entity_type" = :db_condition_placeholder_1); Array
(
[:db_condition_placeholder_0] => node.field_description
[:db_condition_placeholder_1] => field_storage_config
) On two sites which are syncronizing config, delete a field on one, then push the changed config to the other.
Needs review
Code
Same issue if you try to uninstall themes (upgrading some websites to Drupal 10).
This patch fix the issue.
I some how missed getting this one in. let me see if it still applies