Results 1 to 2 of 2

Thread: BUG - v1.1.4 - in geo.php

March 27th, 2013 #1

joes

Thread Starter

Join Date

Nov 2012

Location

Australia

Posts

877

Thanks

12

Thanked 358 Times in 261 Posts

BUG - v1.1.4 - in geo.php
Hi Support,

Can this bug be fixed in the next Vantage release and DEV build. See this post for details and explanation.

The "distance" calculation performed by MySQL to retrieve listings within a radius is returning "distance=NULL" results which equate to when the supplied location co-ordinates match exactly to the geocodes recorded for a listing.

The code that needs fixing is in geo.php file and is:

PHP Code:

$clauses['where'] .= $wpdb->prepare( " AND distance < %f", (float) $rad );

To:

PHP Code:

$clauses['where'] .= $wpdb->prepare( " AND (distance IS NULL OR distance < %f)", (float) $rad );

Reply With Quote
The Following User Says Thank You to joes For This Useful Post:

hopfoto (March 28th, 2013)
March 28th, 2013 #2

dimitris

Join Date

Oct 2011

Location

Earth

Posts

20,617

Thanks

222

Thanked 1,873 Times in 1,770 Posts

You must be an AppThemes customer and logged in to view this response. Join today!

Reply With Quote

There are currently 1 users browsing this thread. (0 members and 1 guests)

BUG - v1.1.4 - in geo.php