I try to migrate a simple node type with data for OpenLayers, from D6 to D7.

  • I use only migration UI
  • In my D6 data structure with OpenLayers 2, I have 2 fields, created by myself: longitude & latitude.
  • In D7, OpenLayers 3 comes with its own types.
  • I have mapped data.

When I import data, I get errors.

PDOException : SQLSTATE[21S01]: Insert value list does not match column list: 1136 Column count doesn't match value count at row 1: INSERT INTO {field_data_field_localization} (entity_type, entity_id, revision_id, bundle, delta, language, field_localization_geom, field_localization_geo_type, field_localization_lat, field_localization_lon, field_localization_left, field_localization_top, field_localization_right, field_localization_bottom, field_localization_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_0, :db_insert_placeholder_6_1, :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, :db_insert_placeholder_14); Array ( [:db_insert_placeholder_0] => node [:db_insert_placeholder_1] => 1304 [:db_insert_placeholder_2] => 1304 [:db_insert_placeholder_3] => dojo [:db_insert_placeholder_4] => 0 [:db_insert_placeholder_5] => und [: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] => [:db_insert_placeholder_14] => [:db_insert_placeholder_6_0] => 48.871 [:db_insert_placeholder_6_1] => 2.3547 ) dans field_sql_storage_field_storage_write() (ligne 514 dans /srv/d7/modules/field/modules/field_sql_storage/field_sql_storage.module).

There is more VALUES fields than fields to be inserted.

I suppose there is something wrong with placeholder_6_0 and placeholder_6_1 which may be counted as one.

Comments

benoitF created an issue.