Warning (2): Undefined array key "Ville" [APP/Controller/CommentsController.php, line 34]
Code Context
            ));
            
            $lat = $d['ville']['Ville']['lat'];
CommentsController::index() - APP/Controller/CommentsController.php, line 34
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/CommentsController.php, line 34]
Code Context
            ));
            
            $lat = $d['ville']['Ville']['lat'];
CommentsController::index() - APP/Controller/CommentsController.php, line 34
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 "Ville" [APP/Controller/CommentsController.php, line 35]
Code Context
            
            $lat = $d['ville']['Ville']['lat'];
            $lng = $d['ville']['Ville']['lng'];
CommentsController::index() - APP/Controller/CommentsController.php, line 35
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/CommentsController.php, line 35]
Code Context
            
            $lat = $d['ville']['Ville']['lat'];
            $lng = $d['ville']['Ville']['lng'];
CommentsController::index() - APP/Controller/CommentsController.php, line 35
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]
Code Context
            setcookie(
                $name, $c['value'], $c['expire'], $c['path'],
                $c['domain'], $c['secure'], $c['httpOnly']
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: 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

• CORE/Cake/Model/Datasource/DboSource.php line 502 → PDOStatement->execute()

          try {
              $query = $this->_connection->prepare($sql, $prepareOptions);
              $query->setFetchMode(PDO::FETCH_LAZY);
              if (!$query->execute($params)) {
                  $this->_result = $query;

• CORE/Cake/Model/Datasource/DboSource.php line 468 → DboSource->_execute()

          $options += array('log' => $this->fullDebug);
  
          $t = microtime(true);
          $this->_result = $this->_execute($sql, $params);
  

• CORE/Cake/Model/Datasource/DboSource.php line 715 → DboSource->execute()

          if ($cache && ($cached = $this->getQueryCache($sql, $params)) !== false) {
              return $cached;
          }
          $result = $this->execute($sql, array(), $params);
          if ($result) {

• CORE/Cake/Model/Datasource/DboSource.php line 1226 → DboSource->fetchAll()

          // Build SQL statement with the primary model, plus hasOne and belongsTo associations
          $query = $this->buildAssociationQuery($Model, $queryData);
  
          $resultSet = $this->fetchAll($query, $Model->cacheQueries);
          unset($query);

• CORE/Cake/Model/Model.php line 3053 → DboSource->read()

   * @return array
   */
      protected function _readDataSource($type, $query) {
          $results = $this->getDataSource()->read($this, $query);
          $this->resetAssociations();

• CORE/Cake/Model/Model.php line 3025 → Model->_readDataSource()

              return null;
          }
  
          return $this->_readDataSource($type, $query);
      }

• CORE/Cake/Controller/Component/PaginatorComponent.php line 212 → Model->find()

              if ($recursive != $object->recursive) {
                  $parameters['recursive'] = $recursive;
              }
              $results = $object->find($type, array_merge($parameters, $extra));
          }

• CORE/Cake/Controller/Controller.php line 1112 → PaginatorComponent->paginate()

   * @link https://book.cakephp.org/2.0/en/controllers.html#Controller::paginate
   */
      public function paginate($object = null, $scope = array(), $whitelist = array()) {
          return $this->Components->load('Paginator', $this->paginate)->paginate($object, $scope, $whitelist);
      }

• APP/Controller/CommentsController.php line 52 → Controller->paginate()

              'order' => 'Info.id desc'
          ); 
          
              $d['data'] = $this->paginate('Info');
              

• [internal function] → CommentsController->index()

• CORE/Cake/Controller/Controller.php line 504 → ReflectionMethod->invokeArgs()

                  $this,
                  is_array($request->params['pass'])
                      ? array_values($request->params['pass'])
                      : []
              );

• CORE/Cake/Routing/Dispatcher.php line 193 → Controller->invokeAction()

  
          $response = $controller->response;
          $render = true;
          $result = $controller->invokeAction($request);
          if ($result instanceof CakeResponse) {

• CORE/Cake/Routing/Dispatcher.php line 167 → Dispatcher->_invoke()

              ));
          }
  
          $response = $this->_invoke($controller, $request);
          if (isset($request->params['return'])) {

• APP/webroot/index.php line 111 → Dispatcher->dispatch()

  $Dispatcher = new Dispatcher();
  $Dispatcher->dispatch(
      new CakeRequest(),
      new CakeResponse()
  );