Hi,
I am trying to use the taxonomy markers, but when I try to set the marker handling (within view editing) to "by term" I get following warning:

user warning: Unknown column 'gmap_taxonomy_node.marker' in 'field list' query: SELECT location.lid AS lid, node.title AS node_title, node.nid AS node_nid, node_revisions.body AS node_revisions_body, node_revisions.format AS node_revisions_format, location.latitude AS gmap_lat, location.longitude AS gmap_lon, gmap_taxonomy_node.marker AS gmap_node_marker FROM location location LEFT JOIN location_instance location_instance ON location.lid = location_instance.lid LEFT JOIN node node ON location_instance.vid = node.vid LEFT JOIN node_revisions node_revisions ON location_instance.vid = node_revisions.vid WHERE (node.status <> 0 OR (node.uid = 1 AND 1 <> 0) OR 1 = 1) AND (node.type in ('spot')) LIMIT 0, 10 in /mnt/data/accounts/k/kubistaj/data/www/drupal6/sites/default/modules/views/plugins/views_plugin_query_default.inc on line 1091.

any help?

Comments

bartclarkson’s picture

bartclarkson commented

same issue. query missing FROM gmap_taxonomy_node, seems to me.

kubajs’s picture

kubajs commented

its my feeling as well, but I am not that sql-educated...
any suggestion for repair?
Anyway - thats great to hear that I am not the only one :)

bricef’s picture

bricef commented

or LEFT JOIN. Maybe we need a view expert.

n1kk1w’s picture

n1kk1w commented

I was getting the error when I had the view type set to Location. I rebuilt the view using the type Node, and the error went away. I'm using GMap v 6.x-1.0. Hope this helps someone.

rooby’s picture

rooby commented

Here is one I got with a taxonomy view:

user warning: Unknown column 'node.type' in 'field list' query: SELECT term_data.tid AS tid, term_data.name AS term_data_name, term_data.vid AS term_data_vid, node_term_node.title AS node_term_node_title, node_term_node.nid AS node_term_node_nid, node_term_node.language AS node_term_node_language, location.latitude AS location_latitude, location.longitude AS location_longitude, node_term_node__location.latitude AS node_term_node__location_latitude, node_term_node__location.longitude AS node_term_node__location_longitude, node.type AS gmap_node_type FROM term_data term_data LEFT JOIN term_node term_node ON term_data.tid = term_node.tid LEFT JOIN node node_term_node ON term_node.vid = node_term_node.vid LEFT JOIN location_instance location_instance ON CONCAT('taxonomy:', term_data.tid) = location_instance.genid LEFT JOIN location location ON location_instance.lid = location.lid LEFT JOIN location_instance node_term_node__location_instance ON node_term_node.vid = node_term_node__location_instance.vid LEFT JOIN location_instance node_term_node_node_term_node__location_instance ON node_term_node.vid = node_term_node_node_term_node__location_instance.vid LEFT JOIN location node_term_node__location ON node_term_node__location_instance.lid = node_term_node__location.lid WHERE term_data.tid = 533 LIMIT 0, 10 in views/includes/view.inc on line 780.

As mentioned in the option itself the option is aimed very specifically at node views and break otherwise.

Will investigate possible solutions.

johnv’s picture

johnv
Primary language Dutch
commented
Status: Active » Closed (won't fix)

Closing this very old issue. Please reopen if it is still valid.