Problem with Zip Circle/Hearth finder

Case number:100-59
Project:Website Issues
Opened by:Anonymous
Status:Closed
Assigned:admin
Priority:3
Type:Website Change
Opened on:Sunday, June 15, 2008 - 09:09
Last modified:Friday, November 7, 2008 - 21:23

Hello. When I type in my zip code, it gives the following:

user warning: Column 'nid' in field list is ambiguous query: SELECT COUNT(DISTINCT (nid)) AS count FROM node n INNER JOIN location l ON n.vid = l.eid INNER JOIN node_access na ON na.nid = n.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 1 AND na.realm = 'term_access'))) AND ( l.type ='node' AND l.latitude > 33.5125105388 AND l.latitude < 34.2361174612 AND l.longitude > -118.399471407 AND l.longitude < -117.527928593 AND (IFNULL(ACOS(0.830262241753*COS(RADIANS(latitude))*(-0.468912073165*COS(RADIANS(longitude)) + -0.883244851465*SIN(RADIANS(longitude))) + 0.557372954062*SIN(RADIANS(latitude))), 0.00000)*6371470.44015) < 40233.68) in /home/spiralscouts.org/public_html/includes/database.mysql.inc on line 172.