mysqli error: [1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*pi()/180)) * sin((lat*pi()/180)) + cos((*pi()/180)) * cos((lat*pi()/180)) * cos' at line 2] in EXECUTE("INSERT INTO NearbyPlaces (place_id, distance) SELECT DISTINCT place_id, (((acos(sin((*pi()/180)) * sin((lat*pi()/180)) + cos((*pi()/180)) * cos((lat*pi()/180)) * cos((( - lon)*pi()/180))))*180/pi())*60*1.1515)*(1.609344) AS distance FROM Places LEFT JOIN PlaceCategoryLink USING(place_id) WHERE lat <= 0.00900900900901 AND lat >= -0.00900900900901 AND lon <= 4.49151552717 AND lon >= -4.49151552717 AND (cat_id<>'18' AND cat_id<>'29' AND cat_id<>'30' OR cat_id IS NULL) ")
/var/www/sg.shownearby.com/protected/Common/adodb/adodb-exceptions.inc.php (78)
0067: * @param $p1 $fn specific parameter - see below
0068: * @param $P2 $fn specific parameter - see below
0069: */
0070:
0071: function adodb_throw($dbms, $fn, $errno, $errmsg, $p1, $p2, $thisConnection)
0072: {
0073: global $ADODB_EXCEPTION;
0074:
0075: if (error_reporting() == 0) return; // obey @ protocol
0076: if (is_string($ADODB_EXCEPTION)) $errfn = $ADODB_EXCEPTION;
0077: else $errfn = 'ADODB_EXCEPTION';
0078: throw new $errfn($dbms, $fn, $errno, $errmsg, $p1, $p2, $thisConnection);
0079: }
0080:
0081:
0082: ?>
#0 /var/www/sg.shownearby.com/protected/Common/adodb/adodb.inc.php(918): adodb_throw('mysqli', 'EXECUTE', 1064, 'You have an err...', 'INSERT INTO Nea...', false, Object(ADODB_mysqli))
#1 /var/www/sg.shownearby.com/protected/Common/adodb/adodb.inc.php(874): ADOConnection->_Execute('INSERT INTO Nea...')
#2 /var/www/sg.shownearby.com/protected/Common/SnbNearby.php(245): ADOConnection->Execute('INSERT INTO Nea...', Array)
#3 /var/www/sg.shownearby.com/protected/Portlets/Places/PlaceSideBar.php(31): SnbNearby->prepareSearch(NULL, NULL, 500, false, false, 'places')
#4 /var/www/sg.shownearby.com/framework/Web/UI/TControl.php(1286): PlaceSideBar->OnLoad(NULL)
#5 /var/www/sg.shownearby.com/framework/Web/UI/TControl.php(1293): TControl->loadRecursive()
#6 /var/www/sg.shownearby.com/framework/Web/UI/TControl.php(1293): TControl->loadRecursive()
#7 /var/www/sg.shownearby.com/framework/Web/UI/TControl.php(1293): TControl->loadRecursive()
#8 /var/www/sg.shownearby.com/framework/Web/UI/TControl.php(1293): TControl->loadRecursive()
#9 /var/www/sg.shownearby.com/framework/Web/UI/TPage.php(210): TControl->loadRecursive()
#10 /var/www/sg.shownearby.com/framework/Web/UI/TPage.php(193): TPage->processNormalRequest(Object(THtmlWriter))
#11 /var/www/sg.shownearby.com/framework/Web/Services/TPageService.php(474): TPage->run(Object(THtmlWriter))
#12 /var/www/sg.shownearby.com/framework/Web/Services/TPageService.php(420): TPageService->runPage(Object(PlaceOverview), Array)
#13 /var/www/sg.shownearby.com/framework/TApplication.php(1066): TPageService->run()
#14 /var/www/sg.shownearby.com/framework/TApplication.php(376): TApplication->runService()
#15 /var/www/sg.shownearby.com/index.php(36): TApplication->run()
#16 {main}