Notice (8): Undefined index: Etablissement [APP/Controller/EtablissementsController.php, line 98]
Notice (8): Trying to access array offset on value of type null [APP/Controller/EtablissementsController.php, line 98]
Notice (8): Undefined index: Ville [APP/Controller/EtablissementsController.php, line 101]
Notice (8): Trying to access array offset on value of type null [APP/Controller/EtablissementsController.php, line 101]
Notice (8): Undefined index: Ville [APP/Controller/EtablissementsController.php, line 102]
Notice (8): Trying to access array offset on value of type null [APP/Controller/EtablissementsController.php, line 102]
Notice (8): Undefined index: Etablissement [APP/Controller/EtablissementsController.php, line 108]
Notice (8): Trying to access array offset on value of type null [APP/Controller/EtablissementsController.php, line 108]
Warning (2): Cannot modify header information - headers already sent by (output started at /home/lepetitbz/animauxadmis/lib/Cake/Utility/Debugger.php:797) [CORE/Cake/Network/CakeResponse.php, line 458]
Errors

Database Error

Error: SQLSTATE[42000]: Syntax error or access violation: 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((Ville.lat*pi()/180))+cos((*pi()/180)) * cos((Ville.lat*pi()/1' at line 1

SQL Query: SELECT Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((*pi()/180)) * sin((Ville.lat*pi()/180))+cos((*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance, `Ville`.`id` FROM `lepetitbz331`.`etablissements` AS `Etablissement` LEFT JOIN `lepetitbz331`.`villes` AS `Ville` ON (`Etablissement`.`ville_id` = `Ville`.`id`) WHERE `Etablissement`.`id` != 121257 AND `Etablissement`.`agregat_id`= GROUP BY `Ville`.`id` HAVING distance <40000 ORDER BY `distance` ASC LIMIT 7

Notice: If you want to customize this error message, create app/View/Errors/pdo_error.ctp

Stack Trace