Unknown column 'l.eid' and no coordinates in .kml files
marcoBauli - March 30, 2007 - 09:07
| Project: | KML module |
| Version: | 4.7.x-1.x-dev |
| Component: | Code |
| Category: | support request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed |
Description
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.
#1
uops, here's the file..renamed to .txt to be able to upload
#2
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.
#3
just upgraded and works a treat! thank you :)
#4