Warning (2): Undefined array key "Ville" [APP/Controller/CommentsController.php, line 34]
Warning (2): Trying to access array offset on value of type null [APP/Controller/CommentsController.php, line 34]
Warning (2): Undefined array key "Ville" [APP/Controller/CommentsController.php, line 35]
Warning (2): Trying to access array offset on value of type null [APP/Controller/CommentsController.php, line 35]
Warning (2): Cannot modify header information - headers already sent by (output started at /homepages/3/d279718623/htdocs/dmprenov/lib/Cake/Utility/Debugger.php:797) [CORE/Cake/Network/CakeResponse.php, line 458]

Deprecated: strpos(): Passing null to parameter #1 ($haystack) of type string is deprecated in /homepages/3/d279718623/htdocs/dmprenov/lib/Cake/Network/CakeResponse.php on line 1105
Errors


Deprecated: Automatic conversion of false to array is deprecated in /homepages/3/d279718623/htdocs/dmprenov/lib/Cake/I18n/I18n.php on line 448
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 `Info`.*, `Sujet`.*, COUNT(`Sujet`.`id`) as nbComs, `Ville`.*, (((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 FROM `db285787289`.`infos` AS `Info` LEFT JOIN `db285787289`.`villes` AS `Ville` ON (`Info`.`ville_id` = `Ville`.`id`) LEFT JOIN `db285787289`.`sujets` AS `Sujet` ON (`Sujet`.`info_id` = `Info`.`id`) WHERE 1=1 GROUP BY `Sujet`.`id` HAVING distance < 50000 ORDER BY `Info`.`id` desc LIMIT 20

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

Stack Trace