Ajouter au carnet

la plagne

38270 Beaurepaire
Localiser

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 != 2806086
                    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

  • Requested Url: http://tourisme-bievrevalloire.com/noesit/!/fiche/sortie-ski-la-plagne-2806086
  • 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}