Location not returning any search results

This is related to another bug that is fixed in cvs and 4.7 versions. This bug should have been fixed before it was okayed into a stable module environment, without this the module does not work.

Actually I seem to be having the same problem under Drupal 4.7.2 and HEAD location module.

Bumping version to cvs since it applies to both.

The only way I was able to confirm these bugs was when search.module was turned off. If your search function is still not working after you've made sure that search.module is enabled at the same time, please post back here with an exact sequence of steps I could use to replicate this error on a fresh install for drupal 4.6 or for drupal 4.7

Also consider deleting from your cache.

the same problem is happening with me. I am running drupal 4.7. I also issued a re-index of my database to make sure that wasn't the problem. I don't have cache enabled either, but have tried it with cache enabled as well. Any help would greatly be appreciated since this is a module I very much need for my site.

I have installed the most recent version of location and am having this problem. In my case, It's becasue the country dropdown is empty. When I add "us" to the URL string manually, it works. I have canada and US enabled in the settings. So the real question is, where are my counties in the dropdown. Related?
http://drupal.org/node/72658

This is definitely a bug. The problem is with the $sql, $count_sql, and $count_display_sql queries in location_search_get_results. The queries are joining the location table to the node table by node.nid rather than node.vid, which is what is stored in the location.oid field in the location table.

I tried the suggestion in #9 not really thinking it would help since I have no countries in my country selection. Sure enough, it doesn't help. I am working with location HEAD. Does everyone else have countries listed. The locationsearch.module has countries listed in it's drowdown.

Has anyone gotten this to work on 4.6? I'm having the same issues as well.

I'm suprised this hasn't been fixed yet considering the bug was posted back in Febuary.

I had found that I had not followed the install instructions to dump the zip codes into my database, but after I had did it still resulted in no success. Any help would greatly be appreciated.

I am using 4.7 and couldn't get the location module to return any search results.

Here's how I fixed it (I'm a Drupal newbie, so I haven't gotten to checking changes into CVS yet):
-Open location/location.module
-Replace all instances of 'a.oid = n.nid' with 'a.oid = n.vid'
(I think there were three of them)

I tried what's mentioned about with no luck. I made sure that my user had info in it and re-indexed the site. I also tried enabling, then disabling the module. But didn't make a difference.

The fix described in http://drupal.org/node/46280#comment-116716 and http://drupal.org/node/46280#comment-131268 works for me fine for CVS and 4.7 versions. Attached is the patch against the CVS version.

What is weird is I was using views to show the users and it's like the zipcode is not being stored in the profile. It's weird cause if I edit the profile it's there but when I generate the list with views it is not showing anything in that field for any of my users. That's why I'm guessing it's finding anything.

I'm having the same problem with my prox. search not returning any results. However, I have probably caused it by skipping step 1 in the install.txt because I didn't know how to do that. Did you complete step 1 of the install.txt? Any idea on how to do that?

Thanks,
B

committed to HEAD and DRUPAL-4-7

How is this fixed? I've updated the module and am still having the same problem.