I created a content type "map_location" which has a bunch of fields, including latitude and longitude text CCK fields. Then per the instructions here (http://drupal.org/node/244312) I created a view type "gProximity: Google Map Locations". Finally, when creating a gProximity via admin/build/gproximity/add, I receive the following error after submitting:

user warning: Unknown column 'results_node_link' in 'field list' query: INSERT INTO gproximity (gpid,results_enabled,search_enabled,results_position,search_position,search_title,search_field_size,search_description,search_show_button,results_title,results_pager,results_qty,results_distance_limit,results_width,results_height,results_node_link,marker_zoom_out,marker_zoom_in,marker_icon,marker_shadow,additional_fields,format,geo_lat,geo_lng,width,height,zoom_lvl,search_zoom_lvl,center_lat,center_lng,scale,maptype,zoom,setOverview,hide_show_overview,doubleclick,scrollzoom,map_dragging,continuousZoom) VALUES ('45','1','1','3','0','Search','35','Enter an address to search by.','1','Results','1','5','50','250','350','1','0','max','/sites/all/modules/gproximity/markers/orange.png','','','','node_title','node_title','350','250','5','8','30.268735','-97.745209','0','0','2','0','1','0','0','1','0') in /var/www/mysite.com/includes/database.mysql.inc on line 172.

Of course I selected the map_location type's lat/long CCK fields for "Latitude" and "Longitude". After this error occurs, the proximity is not listed under admin/build/gproximity/. In other words, I am not able to enter any proximity.

Version of my setup:
Drupal 5.7
token-5.x-1.11.tar
keys_api-5.x-1.0.tar
location-5.x-1.x-dev.tar (2007-Oct-31)
gproximity-5.x-1.x-dev.tar (2008-Jun-04)
gmap-5.x-1.x-dev.tar (2008-Jun-10)

Comments

mgenovese’s picture

Whoops, looks like I added the issue too soon. Think it's a dupe of:

http://drupal.org/node/267473

Has this been resolved? I just tried running update.php, but I still receive the error when adding a proximity.

mgenovese’s picture

Status: Active » Closed (duplicate)

Duping issue. When I ran update.php, I had to select "5000" for that module (from no updates necessary).

This does need to be put in the install script though, as noted in the other issue.