I have added the geolocation field to a Commerce product and it is working fine on the edit form.

On save I get this error. On inspection, I do not see a table named "field_data_field_geolocation" nor do I see any other table with a column named 'field_geolocation_glid';

PDOException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'field_geolocation_glid' cannot be null: INSERT INTO {field_data_field_geolocation} (entity_type, entity_id, revision_id, bundle, delta, language, field_geolocation_glid) 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] => commerce_product [:db_insert_placeholder_1] => 11 [:db_insert_placeholder_2] => 12 [:db_insert_placeholder_3] => product [:db_insert_placeholder_4] => 0 [:db_insert_placeholder_5] => und [:db_insert_placeholder_6] => ) in field_sql_storage_field_storage_write() (line 448 of [SITEROOT]\modules\field\modules\field_sql_storage\field_sql_storage.module).

Comments

jm.federico’s picture

Status: Active » Postponed (maintainer needs more info)

Hello, I'm sorry you are having problems with this module

Can you reproduce this on a blank Drupal + Commerce install?

This seems like a bug from some where else, we do not create the tables, they get cerated by core field module

Marking as need more info

derjochenmeyer’s picture

Title: missing table field_data_field_geolocation? » Missing table field_data_field_geolocation
Issue summary: View changes
Status: Postponed (maintainer needs more info) » Closed (cannot reproduce)