BUG: Distance Query on PostGreSQL

Jump to: navigation, search

Trying to do a distance query in Semantic Maps running on PostGreSQL (I know we PG people are a thorn in the developers' sides :-) ). When the query executes, it throws a syntax error. The problem appears to be that you are tying the bounding box criteria together with "&&" and PostGreSQL wants "AND". I went into SM_AreaValueDescription.php line 149 and changed && and || to AND and OR, and it works fine. Not sure if that is a global fix, but it worked for me.

Bplewe17:29, July 6, 2011

Thanks for reporting this, I fixed it in SM 0.7.8 and SM 1.0 :)

Jeroen De Dauw13:33, July 12, 2011
 
Personal tools
Namespaces
Variants
Views
Actions
Navigation
Manuals
Useful lists
More awesomeness
Toolbox