While attempting to run a D7 to D8 migration, I am receiving the following errors:

[error] SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'field_name_lon' when attempting to insert a value with the following longitude -111.8945042

When attempting to insert the value manually, it was working, but rounding the value to -99.99999..

After following the advice from this link I have resolved the issue by adjusting the field storage values.

https://stackoverflow.com/questions/12504208/what-mysql-data-type-should...

The attached patch seems to resolve the issue.

CommentFileSizeAuthor
#2 lon-oor-3057111-2.patch1.54 KBmikedance
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

mikedance created an issue. See original summary.

mikedance’s picture

mikedance CreditAttribution: mikedance as a volunteer commented
FileSize
lon-oor-3057111-2.patch1.54 KB

  • itamair committed 10e4795 on 8.x-1.x authored by mikedance 
    Issue #3057111 by mikedance: Numeric value out of range: 1264 Out of...
itamair’s picture

itamair CreditAttribution: itamair as a volunteer commented

Thanks @mikedance ... perfectly right.
Your patch was committed into the last dev, just rising precision to 12

itamair’s picture

itamair CreditAttribution: itamair as a volunteer commented
Status: Active » Fixed

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.