The nodes associated with vocabulary have no location and map markers

Hello -- I realize it has been some time since the above question but I am having the same issue. Geobrowser is exactly what I am looking for - I just hope I can get it working...

The primary key for joining the 'location' table has to be 'lid' instead of 'eid' as in the geobrowser.module. Follow these steps:
- go to the modules/geobrowser directory
- open geobrowser.module using a text editor
- first locate all instances of 'eid' in the code
- replace 'eid' with 'lid' appropriately
- save the same and update on the web root

Hope this should solve this issue.

Hi sudhira - Thanks!! - it appears some warning msgs went away upon making this change, specifically when after attempting to add new markers to the map - these warning have disappeared. However, the map markers do not appear and upon clicking the "check geobrowser install", I am still getting strange warnings:

user warning: Unknown column 'type' in 'where clause' query: SELECT * FROM location WHERE type = 'node' AND lid IN (724,726,728,729) AND latitude is NOT NULL AND longitude is NOT NULL in /var/www/includes/database.mysql.inc on line 172.

I similarly get this warning even though I have setup a vocabulary as per the tutorial provided here (and on the geobrowser homepage):
- http://mapswest.com/geobrowser_tutorial

The nodes associated with vocabulary "markers" have no location data associated with them! How can geobrowser map nodes if it doesn't know where they are?

I appreciate any assistance you (and others) could provide (and have provided!).

Hi. I started playing around with Drupal a couple of weeks ago and now I've begun my first site. I was making good progress but I ran into the same issue other's here seem to be having with Geobrowser. I get the following message:

user warning: Unknown column 'type' in 'where clause' query: SELECT * FROM location WHERE type = 'node' AND lid IN (10,11) AND latitude is NOT NULL AND longitude is NOT NULL in /Applications/MAMP/htdocs/drupal-5.11/includes/database.mysql.inc on line 174.

Also just like above in Administer> Site configuration > Geobrowser

The nodes associated with vocabulary "Map site types" have no location data associated with them! How can geobrowser map nodes if it doesn't know where they are?

Thanks in advance for any assistance!

I'm a print designer by trade so basic HTML, CSS and very, very basic database knowledge is as far as I go so please bear with me.

This feature is crucial to my website. I'm doing a site for a travel agency so I have to get the geolocation type stuff working even if it kills me :-P

OK, so I went over the tutorial on how to create Drupal modules to see if I could find any clues there.
http://drupal.org/node/82920

Since the error seems to be thrown from the database query I figured I'd start there. In the module tutorial the table name is "node" so it's between curly brackets like so:

Even though type is not used for this tutorial (type = 'type_here') I believe it mentioned that it's used to define a type within the table (not as clear on this).

What I find confusing is how can {node} be a table name on the tutorial and also be a column (type = 'node' refers to a column right?) on the location table.

I looked at the location table with a GUI application and it doesn't have a "type" column. I took it a step further to see what would happen if I simply removed type = 'node' altogether from the database query in the geobrowser.module file. To my thinking geobrowser can't find this "type" because it doesn't exist. I figured if the module tutorial could work without defining type maybe Geobrowser could as well.

So now my errors are gone. That's as far as I got and I have to wait until I get home tonight to see if this is an actual solution or if I'm screwing something else up.

P.S. When I looked at the location table the columns had all zeros on the longitude and latitude columns so I'm assuming that's why the following message in being thrown:

The nodes associated with vocabulary "Map site types" have no location data associated with them! How can geobrowser map nodes if it doesn't know where they are?

But I'll worry about that later.

Again, any input would be greatly appreciated.