Iupgraded to latest dev and now get this red notice anytime I access a user - Notice: Undefined property: stdClass::$field_geo_address_wkt in field_sql_storage_field_storage_load() (line 360 of /home4/growtogi/public_html/modules/field/modules/field_sql_storage/field_sql_storage.module).
I reverted back to older version but it seems like a new database column or something has been added because I just got a php error when running a rule which involved a user (i'm using addressfield, geocoder, and geofield for users)
PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'field_geo_address_wkt' in 'field list': INSERT INTO {field_data_field_geo_address} (entity_type, entity_id, revision_id, bundle, delta, language, field_geo_address_wkt, field_geo_address_geo_type, field_geo_address_lat, field_geo_address_lon, field_geo_address_left, field_geo_address_top, field_geo_address_right, field_geo_address_bottom, field_geo_address_srid, field_geo_address_accuracy, field_geo_address_source) 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, :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_15, :db_insert_placeholder_16); Array ( [:db_insert_placeholder_0] => user [:db_insert_placeholder_1] => 783 [:db_insert_placeholder_2] => 783 [:db_insert_placeholder_3] => user [:db_insert_placeholder_4] => 0 [:db_insert_placeholder_5] => und [:db_insert_placeholder_6] => [: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_15] => [:db_insert_placeholder_16] => ) in field_sql_storage_field_storage_write() (line 448 of /home4/growtogi/public_html/modules/field/modules/field_sql_storage/field_sql_storage.module).
Comments
Comment #1
IWasBornToWin commentedI was able to solve this by deleting the geofield, then deleting the module (it wouldn't allow me to uncheck it). then I reinstalled module, unchecked it, uninstalled it, reinstalled it, reinstalled the geofield field and everything worked fine. It also solved this issue http://drupal.org/node/1692954 and no longer has all the dropdown options in comment #3 of that issue.
Comment #2
bcobin commentedThanks for the tip; unfortunately, I'm using OL Locator and have a lot of location info, which would be trashed if I uninstalled the module. Any other ideas? Thanks in advance...
Comment #3
Brandonian commentedMarking as duplicate of #1708624: Migration issues from Geofield db storage updates