PDO error!
SELECT *,
((ACOS(SIN( * PI() / 180) * SIN(object_lat * PI() / 180) + COS( * PI() / 180) * COS(object_lat * PI() / 180) * COS(( - object_long) * PI() / 180)) * 180 / PI()) * 60 * 1.1515) AS `distance`
FROM `bv_sit_selection_objet`
LEFT JOIN bv_sit_object ON `bv_sit_selection_objet`.object_id = bv_sit_object.object_id
WHERE 1 AND bv_sit_object.object_id != 4911959
AND bv_sit_selection_objet.selection_id = 26556
ORDER BY distance ASC
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(object_lat * PI() / 180) + COS( * PI() / 180) * COS(object_l' at line 2
((ACOS(SIN( * PI() / 180) * SIN(object_lat * PI() / 180) + COS( * PI() / 180) * COS(object_lat * PI() / 180) * COS(( - object_long) * PI() / 180)) * 180 / PI()) * 60 * 1.1515) AS `distance`
FROM `bv_sit_selection_objet`
LEFT JOIN bv_sit_object ON `bv_sit_selection_objet`.object_id = bv_sit_object.object_id
WHERE 1 AND bv_sit_object.object_id != 4911959
AND bv_sit_selection_objet.selection_id = 26556
ORDER BY distance ASC
- Requested Url: http://tourisme-bievrevalloire.com/noesit/!/fiche/equit-atelier-4911959
- Error Message:
#0 /var/www/vhosts/bievre-valloire.fr/httpdocs/wp-content/noe/noephp/framework/DB.class.php(119): NOE\Error::throwException('PDO error! <br ...', 'sql', 'http://tourisme...')
#1 /var/www/vhosts/bievre-valloire.fr/httpdocs/wp-content/noe/noephp/abstract/ADbCollection.class.php(178): NOE\DB->query('SELECT *,? ...')
#2 /var/www/vhosts/bievre-valloire.fr/httpdocs/wp-content/noe/noephp/abstract/ADbCollection.class.php(59): NOE\ADbCollection->getDbRecords(NULL, NULL, Array, Array, Array, 'SELECT *,? ...')
#3 /var/www/vhosts/bievre-valloire.fr/httpdocs/wp-content/modules/noesit/noesitcore/classes/selection/models/Selection.class.php(386): NOE\ADbCollection->fetch(NULL, NULL, Array, Array, Array, 'SELECT *,? ...')
#4 /var/www/vhosts/bievre-valloire.fr/httpdocs/wp-content/modules/noesit/frontend/helpers/fiche_selections_liees.php(36): NOE\SIT\Selection->fetchSelectionObjectCol(1, 3, Array, Array, Array, 'SELECT *,? ...', true)
#5 /var/www/vhosts/bievre-valloire.fr/httpdocs/wp-content/modules/noesit/controllers/NoesitFrontendController.class.php(625): include('/var/www/vhosts...')
#6 /var/www/vhosts/bievre-valloire.fr/httpdocs/wp-content/modules/noesit/controllers/NoesitFrontendController.class.php(642): NOE\WP\NoesitFrontendController->loadSitObjectTemplate(Object(NOE\SIT\Sitobject), '', false, 'fiche_selection...', 3)
#7 /var/www/vhosts/bievre-valloire.fr/httpdocs/wp-content/modules/noesit/controllers/NoesitFrontendController.class.php(637): NOE\WP\NoesitFrontendController->loadSitObjectTemplate(Object(NOE\SIT\Sitobject), Array, false, 'col1', 2)
#8 /var/www/vhosts/bievre-valloire.fr/httpdocs/wp-content/modules/noesit/frontend/views/fiche/fiche_detail.php(28): NOE\WP\NoesitFrontendController->loadSitObjectTemplate(Object(NOE\SIT\Sitobject), Array)
#9 /var/www/vhosts/bievre-valloire.fr/httpdocs/wp-content/modules/noesit/controllers/NoesitFrontendController.class.php(416): include('/var/www/vhosts...')
#10 /var/www/vhosts/bievre-valloire.fr/httpdocs/wp-content/modules/noesit/controllers/NoesitFrontendController.class.php(43): NOE\WP\NoesitFrontendController->fiche()
#11 /var/www/vhosts/bievre-valloire.fr/httpdocs/wp-content/noe/noewpcore/classes/modules/NoewpModelInit.class.php(87): NOE\WP\NoesitFrontendController->dispatch()
#12 /var/www/vhosts/bievre-valloire.fr/httpdocs/wp-content/noe/noewpcore/classes/modules/NoewpModules.class.php(451): NOE\WP\NoewpModelInit->load(Array)
#13 /var/www/vhosts/bievre-valloire.fr/httpdocs/wp-content/themes/noeStarter/t_moduleFO.php(52): NoewpModules::loadModuleFO(Array, Array)
#14 /var/www/vhosts/bievre-valloire.fr/httpdocs/wp-includes/template-loader.php(89): include('/var/www/vhosts...')
#15 /var/www/vhosts/bievre-valloire.fr/httpdocs/wp-blog-header.php(16): require_once('/var/www/vhosts...')
#16 /var/www/vhosts/bievre-valloire.fr/httpdocs/index.php(17): require('/var/www/vhosts...')
#17 {main}