GMap, CCK, Location, View-- No map displayed

Of the 600+ nodes that have a cck location field, about 100 of them have lat/longs and show a marker on the edit page that exposes the gmap location picker. The others have a lat/long of 0(zero). I had somebody else doing data entry and they didn't notice that the entreis were not being assigned a lat/long. I enabled gmap and registered for an API key and now all new entries are generating a lat/long. the other 500+ have to be manually added. The module says if the lat/long field is left balmk it will generate one but that doesn't work either.

Scott

Well after a bit of sluething in the sql database I have found that the query run to populate the map, will never return the right lat/longs!

SELECT node.nid AS nid, node.title AS node_title, location.latitude AS gmap_lat, location.longitude AS gmap_lon FROM node node LEFT JOIN location_instance location_instance ON node.vid = location_instance.vid LEFT JOIN location location ON location_instance.lid = location.lid WHERE (node.status <> 0) AND (node.type in ('school_listing'))

returns a list of entries with all lat/longs set to 0/0!!!

using one entry these are the entries for each table

node table : nid=56 vid=805 type=school_listing title= Moorpark College status=1

location table : lid=510 latitude=34.283551 longitude=-118.873940

location_instance table : nid=0 vid=0 genid=cck:field_location:805 lid 510 (in this table all the nid & vid entries are 0(zero)? )

if node.vid = location_instance.vid, it will never find the correct location table. Interesting that the location_instance.genid has the correct id at the end of cck:field_location:805 correct id

And why are all the location_instance nid's and vid's 0(zero)?

I upgraded the Location module to the 6.x.3.x..dev release fromthe rc release

in the view
added a relationship to the cck location field in the content type node
added two fields from the relationship of type location:latitude location:longitude
changed the style gmap's data source from location.module to Choose Lat Long and chose location:latitude and location:longitude

WooHoo!!!!!

The baloon's are empty when you click on a marker, but i'm so much closer to a working map!

Scott
edit · reply