Howdy,

after installing KML module i get the following warning:

user warning: Unknown column 'l.eid' in 'field list' query: kml_interface SELECT n.nid, n.created FROM node n WHERE n.status = 1 AND n.vid IN (SELECT l.eid FROM location l WHERE l.source != 0 AND l.type = 'node' AND l.eid = n.vid) AND n.nid = 603 in /home/public_html/test/includes/database.mysql.inc on line 120.

and my .kml file does not contain any latitude or longitude (i've attached a sample node.kml file).

Can anyone please give a hand on this? Only clue i have is that maybe i need to upgrade to a more recent version of Drupal or Location? cheers

Drupal 4.7.2, location.module v 1.62 2006/04/19, latest 4.7 version of KML.

CommentFileSizeAuthor
#1 nodes.txt526 bytesmarcoBauli

Comments

marcoBauli’s picture

marcoBauli commented
StatusFileSize
new nodes.txt526 bytes

uops, here's the file..renamed to .txt to be able to upload

geodaniel’s picture

geodaniel commented

There was a change in location module that meant one of the columns was renamed to eid. You should update to the latest version of Location Module to get KML Module working again. Don't forget to run update.php when you do that as well.

marcoBauli’s picture

marcoBauli commented
Status: Active » Fixed

just upgraded and works a treat! thank you :)

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)