LordEd Posted February 7, 2008 Share Posted February 7, 2008 1. Went to my profile: http://www.geocaching.com/profile/?guid=46...d8-9c44e82cc785 2. Clicked "Geocaches" 3. Tried to click "Traditional Caches (on either side)" 4. Wound up at http://www.geocaching.com/seek/nearest.asp...7&ul=LordEd with error message "ORDER BY items must appear in the select list if SELECT DISTINCT is specified." Anybody else have this? Looks like a bug in the sql statement to me. Found it while attempting to read somebody's profile Tested in firefox and IE just to be sure. Link to comment
+the hermit crabs Posted February 7, 2008 Share Posted February 7, 2008 I see it too, when looking at my own profile. Win XP pro, Firefox 2.0.0.11 Link to comment
+Steve L Posted February 7, 2008 Share Posted February 7, 2008 It's broken in Safari (Mac OS X 10.4.11) too. Link to comment
OpinioNate Posted February 7, 2008 Share Posted February 7, 2008 Thanks, this might be related to our recent update. I will look into this and make sure it's fixed. Link to comment
+Kiwi Nomad Posted February 7, 2008 Share Posted February 7, 2008 Yes same message, got it when checking someones profile. Where LordEd says 'on either side' I believe that he is meaning that it happens for both the hidden by and found by. I am using Internet Explorer. Also something else that may be related is I got the error page pop up when I tried to search for newest caches by state. On the other hand clicking on closest caches to home (ignore found caches) worked fine. Link to comment
OpinioNate Posted February 7, 2008 Share Posted February 7, 2008 Everything should be back to normal now. Sorry for the trouble, everyone. Link to comment
+Kiwi Nomad Posted February 7, 2008 Share Posted February 7, 2008 Thanks for the fast repair. Link to comment
Recommended Posts