Using the find a circle/hearth search failed
| Case number: | 100-50 |
| Project: | Website Issues |
| Opened by: | Anonymous |
| Status: | Working |
| Assigned: | admin |
| Priority: | 1-High |
| Type: | General Task |
| Opened on: | Thursday, February 21, 2008 - 23:08 |
| Last modified: | Thursday, February 21, 2008 - 23:08 |
I tried doing a search to locate a circle or hearth near me in zipcode 95035 and got the following error (and a note saying that there were no matches to my query).
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 > 37.0745759408 AND l.latitude < 37.7983260592 AND l.longitude > -122.350127713 AND l.longitude < -121.438632287 AND (IFNULL(ACOS(0.794028053382*COS(RADIANS(latitude))*(-0.528355058667*COS(RADIANS(longitude)) + -0.849023516742*SIN(RADIANS(longitude))) + 0.607881115385*SIN(RADIANS(latitude))), 0.00000)*6370209.82627) < 40233.68) in /home/spiralscouts.org/public_html/includes/database.mysql.inc on line 172.

