Just to let you know that I receive DB Query error when using the feature: Search Result NEAR ME in the boonex IPHONE APPS. Because I didn't install the Profiles Map module.
Woud it be possible to add something to prevent receiving that error everytime ?
Query:
SELECT * , (POW(45.5325-`loc`.`lat`, 2)+POW(-75.7238-`loc`.`lng`, 2)) AS `distance` FROM `Profiles` INNER JOIN `bx_map_profiles` AS `loc` ON (`loc`.`id` = `Profiles`.`ID` AND `loc`.`failed` = 0) WHERE 1 AND `DateLastNav` >= DATE_SUB(NOW(), INTERVAL 1 MINUTE) ORDER BY `distance` ASC LIMIT 0, 5
Mysql error: Table 'boonex_db.bx_map_profiles' doesn't exist
Found error in the file '/public_html/xmlrpc/BxDolXMLRPCSearch.php' at line 83.
Called 'db_res' function with erroneous argument #0.
[5] => Array
(
[file] => /public_html/xmlrpc/lib/xmlrpcs.inc
[line] => 1131
[function] => call_user_func_array
[args] => Array
(
[0] => Array
(
[0] => BxDolXMLRPCSearch
[1] => getSearchResultsNearMe
)
[1] => Array
(
[0] => kblu
[1] => 6ba84cdb67cc880244a7c9b65bdd9ff1
[2] => English
[3] => 45.5325
[4] => -75.7238
[5] => 1
[6] =>
[7] => 0
[8] => 5
)
)
)