Give the gift of Drupal. All merchandise is 50% off through 2016.
I have a Location CCK field attached to Users. I want to do a User proximity search in a view. But it fails, because the locations attached to my users look like this:
Certainly those first three columns should be inverted; the nids and vids should all be zero, and the uids should be 10, 11, and 12. Manually making this change to the database makes the search work beautifully.
Clearly the ideal thing would be to redesign the module so that Location filters are specified by field like everything else, rather than just by node or user the old way. But in the meantime, some logic to fill out these database entries correctly would be welcome. I don't have time to dig into it right now, but maybe next week sometime I'll take a crack at it, if no one else does first.