Upgraded from D6 to D7, getting error on node save: [#1961630]

PDOException: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'field_location_lid' at row 1: INSERT INTO {field_data_field_location} (entity_type, entity_id, revision_id, bundle, delta, language, field_location_lid) 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); Array ( [:db_insert_placeholder_0] => node [:db_insert_placeholder_1] => 1919 [:db_insert_placeholder_2] => 1920 [:db_insert_placeholder_3] => event [:db_insert_placeholder_4] => 0 [:db_insert_placeholder_5] => und [:db_insert_placeholder_6] => ) in field_sql_storage_field_storage_write() (line 448 of .../public_html/modules/field/modules/field_sql_storage/field_sql_storage.module).

This is when saving the node with NO location. I noticed when I add a STATE to the location, it saves without error. Not all locations have a state, though.

Comments

Comment #1

Leo Pitt CreditAttribution: Leo Pitt commented 14 May 2013 at 16:01

I am getting the same problem, also after upgrading site, and using 7.x-3.0-alpha9.

I have my location field set to "unlimited values" - when I change that to any finite number, the problem goes away.

Does using a finite number of location fields solve the problem for you? If so - this is still a bug, but it might be a short-term workaround.

(came here from http://drupal.org/node/1994620)

Comment #2

zkrebs CreditAttribution: zkrebs commented 14 May 2013 at 17:26

I only had 1 location enabled on D6, and the same is the case on D7. I am no longer having the problem.

I had a few other problematic upgrade fields, and I cleared them out. One was a content_taxonomy field upgraded incorrectly. I can now save my node just fine.

Not sure precisely how I solved this - made a lot of changes in quick succession. I think clearing up upgrade problems in general helped. Sorry, can't be of more help