Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
We're stuck at the moment as after upgrading the code we get:
geofield module
Update #7200
Failed: PDOException: SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'field_ward_location_lat' at row 1: ALTER TABLE {field_data_field_ward_location} CHANGE `field_ward_location_lat` `field_ward_location_lat` DECIMAL(18, 12) NULL DEFAULT NULL; Array ( ) in db_change_field() (line 2988 of /var/www/html/ottdev.openplus.ca/includes/database/database.inc).
I'm not sure why this is out of the date range:
foreach ($field_keys as $field_key) {
db_change_field($table_name, $field_name . '_' . $field_key, $field_name . '_' . $field_key, array(
'type' => 'numeric',
'precision' => 18,
'scale' => 12,
'not null' => FALSE,
));
db_change_field($revision_table_name, $field_name . '_' . $field_key, $field_name . '_' . $field_key, array(
'type' => 'numeric',
'precision' => 18,
'scale' => 12,
'not null' => FALSE,
));
}
Comments
Comment #1
Brandonian CreditAttribution: Brandonian commentedWeird, @mgifford. If this is still an issue, can you pass along the minimum/maximum values of the data currently being held in the database field in question? Also, what database are you running?
Comment #2
Brandonian CreditAttribution: Brandonian commentedNo response after 3 1/2 weeks, closing.