I updated my website to the latest version of drupal 7 and then updated my modules. I updated Geofield to 7.x-2.3. I ran update.php after i installed each module. But Geofield is caught in a loop. Every time I go to update php, it tells me that I have 4 updates pending for geo field .

7100 - Changing srid from int to text
7200 - Change geofield lat, lon, left, top, right and bottom from floats to numeric fields with precision of 18 and scale of 12.
7201 - Converts the wkt field into a geom field. Converts already existing data from wkt storage to wkb. Much inspiration for this implementation comes from taxonomy_update_7005.
7202 - Drops unused table fields srid, accuracy and source, adds geohash field, populates it.

I run update.php and then I get this error:

Failed: PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'verilancom.field_data_field_location' doesn't exist: SELECT f.field_location_srid AS field_location_srid, f.entity_type AS entity_type, f.bundle AS bundle, f.entity_id AS entity_id FROM {field_data_field_location} f; Array ( ) in geofield_update_7100() (line 122 of /var/www/verilan.com/html/sites/all/modules/geofield/geofield.install).

How can I fix this? I especially need to fix the 4 updates that won't update. Any help would be amazing and really appreciated.

Rebecca

Comments

robertwb’s picture

@beckyjohnson - assuming that this is not a dead issue - it seems that this could be that there WAS a geofield named 'field_data_field_location', that no longer exists, but Drupal thinks it does... if your still tuned in drop a line here, a clear caches might get Drupal to forget about the missing field. Otherwise, it sounds like a deeper issue which will need more details.

robertwb’s picture

Status: Active » Closed (cannot reproduce)