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.


Leo Pitt’s picture

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)

slavojzizek’s picture

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

podarok’s picture

Version: 7.x-5.x-dev » 7.x-3.x-dev

The main version tag
7.x-5.x unsupported

podarok’s picture

Priority: Critical » Major
Issue summary: View changes

It is not critical

djdevin’s picture

Assigned: Unassigned » djdevin

I've got this issue too, we are doing a massive D6->D7 upgrade with many CCK locations and multiple fields.

We have to get it fixed so I'll report back when we do.

qasimzee’s picture

Any updates ? I think this is critical.

ttamniwdoog’s picture

@djdevin & @qasimzee, Check out my patch on this thread which may fix your issue as well. https://www.drupal.org/node/1511638#comment-10277377