VillesController::listing() - APP/Controller/VillesController.php, line 313
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 504
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 111
Warning (2): Trying to access array offset on value of type null [APP/Controller/VillesController.php, line 313]
VillesController::listing() - APP/Controller/VillesController.php, line 313
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 504
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 111
Warning (2): Trying to access array offset on value of type null [APP/Controller/VillesController.php, line 313]
VillesController::listing() - APP/Controller/VillesController.php, line 313
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 504
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 111
Warning (2): Undefined array key 0 [APP/Controller/VillesController.php, line 314]
VillesController::listing() - APP/Controller/VillesController.php, line 314
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 504
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 111
Warning (2): Trying to access array offset on value of type null [APP/Controller/VillesController.php, line 314]
VillesController::listing() - APP/Controller/VillesController.php, line 314
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 504
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 111
Warning (2): Trying to access array offset on value of type null [APP/Controller/VillesController.php, line 314]
VillesController::listing() - APP/Controller/VillesController.php, line 314
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 504
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 111
Warning (2): Undefined array key 0 [APP/Controller/VillesController.php, line 320]
VillesController::listing() - APP/Controller/VillesController.php, line 320
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 504
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 111
Warning (2): Trying to access array offset on value of type null [APP/Controller/VillesController.php, line 320]
VillesController::listing() - APP/Controller/VillesController.php, line 320
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 504
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 111
Warning (2): Trying to access array offset on value of type null [APP/Controller/VillesController.php, line 320]
VillesController::listing() - APP/Controller/VillesController.php, line 320
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 504
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 111
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]
setcookie - [internal], line ??
CakeResponse::_setCookies() - CORE/Cake/Network/CakeResponse.php, line 458
CakeResponse::send() - CORE/Cake/Network/CakeResponse.php, line 429
ExceptionRenderer::_outputMessage() - CORE/Cake/Error/ExceptionRenderer.php, line 294
ExceptionRenderer::pdoError() - CORE/Cake/Error/ExceptionRenderer.php, line 281
ExceptionRenderer::render() - CORE/Cake/Error/ExceptionRenderer.php, line 190
ErrorHandler::handleException() - CORE/Cake/Error/ErrorHandler.php, line 127
[main] - [internal], line ??
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 `Ville`.`id`, `Ville`.`slug`, `Ville`.`dep`, `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 FROM `db285787289`.`villes` AS `Ville` WHERE `Ville`.`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