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

Brandonian’s picture

Status: Active » Postponed (maintainer needs more info)

Weird, @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?

Brandonian’s picture

Status: Postponed (maintainer needs more info) » Closed (cannot reproduce)

No response after 3 1/2 weeks, closing.