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.

