I'm reproducing an existing Drupal 7 site in Drupal 10 and I just ran into the following when pasting location data from the old site into the new. This is a MultiPolygon and, yes, it's a lot of data, but other MultiPolygon regions on the new site work just fine, as does the region on Drupal 7.
I'm pasting the full error message below; the desired entry goes on for days, but again, it works fine on Drupal 7.
Any ideas? Assistance greatly appreciated... thanks in advance!
---error message----
Drupal\Core\Entity\EntityStorageException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'field_map_location_value' at row 1: INSERT INTO "node__field_map_location" ("entity_id", "revision_id", "bundle", "delta", "langcode", "field_map_location_value", "field_map_location_geo_type", "field_map_location_lat", "field_map_location_lon", "field_map_location_left", "field_map_location_top", "field_map_location_right", "field_map_location_bottom", "field_map_location_geohash") 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, :db_insert_placeholder_8, :db_insert_placeholder_9, :db_insert_placeholder_10, :db_insert_placeholder_11, :db_insert_placeholder_12, :db_insert_placeholder_13); Array ( [:db_insert_placeholder_0] => 45 [:db_insert_placeholder_1] => 81 [:db_insert_placeholder_2] => region [:db_insert_placeholder_3] => 0 [:db_insert_placeholder_4] => en [:db_insert_placeholder_5] => 01060000000b000000010300000001000000c20000005f0a0f9a5d0a52c00b96ea025e9844400d18247d5a0a52c03c4ed1915c98444074452921580a52c09f5a7d75559844400b45ba9f530a52c04c1762f547984440bd8dcd8e540a52c0ecbdf8a23d9844400420eeea550a52c06b2a8bc22e9844408a05bea25b0a52c08fe3874a239844404be9995e620a52c0fe9dedd11b984440ea5e27f5650a52c08318e8da179844405ad5928e720a52c0adf6b0170a984440cd1e6805860a52c0d1afad9ffe974440b91798158a0a52c0b532e197fa974440b35da10f960a52c0d32ea699ee974440168a743fa70a52c0d6ad9e93de9744401b13622ea90a52c0d124b1a4dc974440001b1021ae0a52c0eb1c03b2d79744
---end error message---
Closed: works as designed
4.5
Miscellaneous