Notice (8): Undefined index: Arrondissement [APP/Controller/ArrondissementsController.php, line 17]
Code Context
                

        $this->loadModel('Ville');

        $maville = current($this->Ville->find('first', array('conditions'=>'code_commune = "'.$d['arrondissement']['Arrondissement']['C_Chef-lieu'].'"')));
$slug = 'saint-jean-d'
$d = array(
	'arrondissement' => array()
)
$joins = array(
	(int) 0 => array(
		'table' => 'departements',
		'alias' => 'Departement',
		'type' => 'LEFT',
		'conditions' => array(
			(int) 0 => 'Departement.id = Ville.departement_id'
		)
	)
)
ArrondissementsController::index() - APP/Controller/ArrondissementsController.php, line 17
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 490
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 191
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 165
[main] - APP/webroot/index.php, line 112

Notice (8): Undefined index: Arrondissement [APP/Controller/ArrondissementsController.php, line 20]
Code Context
        

        $this->loadModel('Departement');

        $mondepart = current($this->Departement->find('first', array('conditions'=>'code = "'.$d['arrondissement']['Arrondissement']['C_Dpt'].'"')));
$slug = 'saint-jean-d'
$d = array(
	'arrondissement' => array()
)
$joins = array(
	(int) 0 => array(
		'table' => 'departements',
		'alias' => 'Departement',
		'type' => 'LEFT',
		'conditions' => array(
			(int) 0 => 'Departement.id = Ville.departement_id'
		)
	)
)
$maville = false
ArrondissementsController::index() - APP/Controller/ArrondissementsController.php, line 20
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 490
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 191
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 165
[main] - APP/webroot/index.php, line 112

Warning (2): Cannot modify header information - headers already sent by (output started at /var/www/clients/client2/web16/web/recrutement/lib/Cake/Utility/Debugger.php:801) [CORE/Cake/Network/CakeResponse.php, line 448]
Code Context
                $name, $c['value'], $c['expire'], $c['path'],
                $c['domain'], $c['secure'], $c['httpOnly']
            );
$name = 'CakeCookie[autologin]'
$c = array(
	'name' => 'CakeCookie[autologin]',
	'value' => '',
	'expire' => (int) 1743739605,
	'path' => '/',
	'domain' => '',
	'secure' => false,
	'httpOnly' => false
)
setcookie - [internal], line ??
CakeResponse::_setCookies() - CORE/Cake/Network/CakeResponse.php, line 448
CakeResponse::send() - CORE/Cake/Network/CakeResponse.php, line 418
ExceptionRenderer::_outputMessage() - CORE/Cake/Error/ExceptionRenderer.php, line 280
ExceptionRenderer::pdoError() - CORE/Cake/Error/ExceptionRenderer.php, line 267
ExceptionRenderer::render() - CORE/Cake/Error/ExceptionRenderer.php, line 176
ErrorHandler::handleException() - CORE/Cake/Error/ErrorHandler.php, line 119
[main] - [internal], line ??

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 MariaDB 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`.`nom`, `Ville`.`slug`, (((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 `c2_media_db`.`villes` AS `Ville` WHERE `Ville`.`population` > 2000 AND `Ville`.`slug` != "" GROUP BY `Ville`.`id` HAVING distance < 50000 ORDER BY `distance` ASC LIMIT 4

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 458 → PDOStatement->execute(array)

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

  array()

• CORE/Cake/Model/Datasource/DboSource.php line 424 → DboSource->_execute(string, array)

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

  'SELECT `Ville`.`nom`, `Ville`.`slug`, (((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 `c2_media_db`.`villes` AS `Ville`   WHERE `Ville`.`population` > 2000 AND `Ville`.`slug` != ""  GROUP BY `Ville`.`id` HAVING distance < 50000  ORDER BY `distance` ASC  LIMIT 4'
  array()

• CORE/Cake/Model/Datasource/DboSource.php line 666 → DboSource->execute(string, array, array)

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

  'SELECT `Ville`.`nom`, `Ville`.`slug`, (((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 `c2_media_db`.`villes` AS `Ville`   WHERE `Ville`.`population` > 2000 AND `Ville`.`slug` != ""  GROUP BY `Ville`.`id` HAVING distance < 50000  ORDER BY `distance` ASC  LIMIT 4'
  array()
  array()

• CORE/Cake/Model/Datasource/DboSource.php line 1106 → DboSource->fetchAll(string, boolean)

          // 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);

  'SELECT `Ville`.`nom`, `Ville`.`slug`, (((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 `c2_media_db`.`villes` AS `Ville`   WHERE `Ville`.`population` > 2000 AND `Ville`.`slug` != ""  GROUP BY `Ville`.`id` HAVING distance < 50000  ORDER BY `distance` ASC  LIMIT 4'
  false

• CORE/Cake/Model/Model.php line 2947 → DboSource->read(Ville, array)

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

  object(Ville) {
  	uses => array(
  		[maximum depth reached]
  	)
  	belongsTo => array(
  		[maximum depth reached]
  	)
  	validate => array(
  		[maximum depth reached]
  	)
  	recursive => (int) -1
  	actsAs => array(
  		[maximum depth reached]
  	)
  	useDbConfig => 'default'
  	useTable => 'villes'
  	id => false
  	data => array([maximum depth reached])
  	schemaName => 'c2_media_db'
  	table => 'villes'
  	primaryKey => 'id'
  	validationErrors => array([maximum depth reached])
  	validationDomain => null
  	tablePrefix => ''
  	plugin => null
  	name => 'Ville'
  	alias => 'Ville'
  	tableToModel => array(
  		[maximum depth reached]
  	)
  	cacheQueries => false
  	hasOne => array([maximum depth reached])
  	hasMany => array([maximum depth reached])
  	hasAndBelongsToMany => array([maximum depth reached])
  	Behaviors => object(BehaviorCollection) {}
  	whitelist => array([maximum depth reached])
  	cacheSources => true
  	findQueryType => 'all'
  	order => null
  	virtualFields => array([maximum depth reached])
  	__backAssociation => array([maximum depth reached])
  	__backInnerAssociation => array([maximum depth reached])
  	__backOriginalAssociation => array([maximum depth reached])
  	__backContainableAssociation => array([maximum depth reached])
  	__safeUpdateMode => false
  	findMethods => array(
  		[maximum depth reached]
  	)
  	[protected] _schema => array(
  		[maximum depth reached]
  	)
  	[protected] _associationKeys => array(
  		[maximum depth reached]
  	)
  	[protected] _associations => array(
  		[maximum depth reached]
  	)
  	[protected] _insertID => null
  	[protected] _sourceConfigured => true
  	[protected] _eventManager => object(CakeEventManager) {}
  	[protected] _validator => null
  }
  array(
  	'conditions' => 'Ville.population > 2000 AND Ville.slug != ""',
  	'fields' => 'Ville.nom,Ville.slug,(((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',
  	'joins' => array(),
  	'limit' => (int) 4,
  	'offset' => null,
  	'order' => array(
  		(int) 0 => 'distance'
  	),
  	'page' => (int) 1,
  	'group' => 'Ville.id HAVING distance < 50000',
  	'callbacks' => true
  )

• CORE/Cake/Model/Model.php line 2919 → Model->_readDataSource(string, array)

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

  'all'
  array(
  	'conditions' => 'Ville.population > 2000 AND Ville.slug != ""',
  	'fields' => 'Ville.nom,Ville.slug,(((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',
  	'joins' => array(),
  	'limit' => (int) 4,
  	'offset' => null,
  	'order' => array(
  		(int) 0 => 'distance'
  	),
  	'page' => (int) 1,
  	'group' => 'Ville.id HAVING distance < 50000',
  	'callbacks' => true
  )

• APP/Controller/ArrondissementsController.php line 33 → Model->find(string, array)

          'group'      => 'Ville.id HAVING distance < 50000',
  
          'order'      => 'distance',
  
          'limit'      => 4
  
          ));
  
          
  

  'all'
  array(
  	'fields' => 'Ville.nom,Ville.slug,(((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',
  	'conditions' => 'Ville.population > 2000 AND Ville.slug != ""',
  	'group' => 'Ville.id HAVING distance < 50000',
  	'order' => 'distance',
  	'limit' => (int) 4
  )

• [internal function] → ArrondissementsController->index(string)

  'saint-jean-d'

• CORE/Cake/Controller/Controller.php line 490 → ReflectionMethod->invokeArgs(ArrondissementsController, array)

                      'action' => $request->params['action']
                  ));
              }
              return $method->invokeArgs($this, $request->params['pass']);
  

  object(ArrondissementsController) {
  	helpers => array(
  		[maximum depth reached]
  	)
  	components => array(
  		[maximum depth reached]
  	)
  	name => 'Arrondissements'
  	uses => array(
  		[maximum depth reached]
  	)
  	request => object(CakeRequest) {}
  	response => object(CakeResponse) {}
  	viewPath => 'Arrondissements'
  	layoutPath => null
  	viewVars => array([maximum depth reached])
  	view => 'index'
  	layout => 'default'
  	autoRender => true
  	autoLayout => true
  	Components => object(ComponentCollection) {}
  	viewClass => 'View'
  	View => null
  	ext => '.ctp'
  	plugin => null
  	cacheAction => false
  	passedArgs => array(
  		[maximum depth reached]
  	)
  	scaffold => false
  	methods => array(
  		[maximum depth reached]
  	)
  	modelClass => 'Arrondissement'
  	modelKey => 'arrondissement'
  	validationErrors => null
  	AutoLogin => object(AutoLoginComponent) {}
  	Auth => object(AuthComponent) {}
  	RequestHandler => object(RequestHandlerComponent) {}
  	Session => object(SessionComponent) {}
  	Img => object(ImgComponent) {}
  	Paginator => object(PaginatorComponent) {}
  	Arrondissement => object(Arrondissement) {}
  	Ville => object(Ville) {}
  	Departement => object(Departement) {}
  	[protected] _responseClass => 'CakeResponse'
  	[protected] _mergeParent => 'AppController'
  	[protected] _eventManager => object(CakeEventManager) {}
  }
  array(
  	(int) 0 => 'saint-jean-d'
  )

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

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

  object(CakeRequest) {
  	params => array(
  		[maximum depth reached]
  	)
  	data => array([maximum depth reached])
  	query => array([maximum depth reached])
  	url => 'secteur/saint-jean-d'
  	base => '/recrutement'
  	webroot => '/recrutement/'
  	here => '/recrutement/secteur/saint-jean-d'
  	[protected] _detectors => array(
  		[maximum depth reached]
  	)
  	[protected] _input => ''
  }

• CORE/Cake/Routing/Dispatcher.php line 165 → Dispatcher->_invoke(ArrondissementsController, CakeRequest)

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

  object(ArrondissementsController) {
  	helpers => array(
  		[maximum depth reached]
  	)
  	components => array(
  		[maximum depth reached]
  	)
  	name => 'Arrondissements'
  	uses => array(
  		[maximum depth reached]
  	)
  	request => object(CakeRequest) {}
  	response => object(CakeResponse) {}
  	viewPath => 'Arrondissements'
  	layoutPath => null
  	viewVars => array([maximum depth reached])
  	view => 'index'
  	layout => 'default'
  	autoRender => true
  	autoLayout => true
  	Components => object(ComponentCollection) {}
  	viewClass => 'View'
  	View => null
  	ext => '.ctp'
  	plugin => null
  	cacheAction => false
  	passedArgs => array(
  		[maximum depth reached]
  	)
  	scaffold => false
  	methods => array(
  		[maximum depth reached]
  	)
  	modelClass => 'Arrondissement'
  	modelKey => 'arrondissement'
  	validationErrors => null
  	AutoLogin => object(AutoLoginComponent) {}
  	Auth => object(AuthComponent) {}
  	RequestHandler => object(RequestHandlerComponent) {}
  	Session => object(SessionComponent) {}
  	Img => object(ImgComponent) {}
  	Paginator => object(PaginatorComponent) {}
  	Arrondissement => object(Arrondissement) {}
  	Ville => object(Ville) {}
  	Departement => object(Departement) {}
  	[protected] _responseClass => 'CakeResponse'
  	[protected] _mergeParent => 'AppController'
  	[protected] _eventManager => object(CakeEventManager) {}
  }
  object(CakeRequest) {
  	params => array(
  		[maximum depth reached]
  	)
  	data => array([maximum depth reached])
  	query => array([maximum depth reached])
  	url => 'secteur/saint-jean-d'
  	base => '/recrutement'
  	webroot => '/recrutement/'
  	here => '/recrutement/secteur/saint-jean-d'
  	[protected] _detectors => array(
  		[maximum depth reached]
  	)
  	[protected] _input => ''
  }

• APP/webroot/index.php line 112 → Dispatcher->dispatch(CakeRequest, CakeResponse)

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

  object(CakeRequest) {
  	params => array(
  		[maximum depth reached]
  	)
  	data => array([maximum depth reached])
  	query => array([maximum depth reached])
  	url => 'secteur/saint-jean-d'
  	base => '/recrutement'
  	webroot => '/recrutement/'
  	here => '/recrutement/secteur/saint-jean-d'
  	[protected] _detectors => array(
  		[maximum depth reached]
  	)
  	[protected] _input => ''
  }
  object(CakeResponse) {
  	[protected] _statusCodes => array(
  		[maximum depth reached]
  	)
  	[protected] _mimeTypes => array(
  		[maximum depth reached]
  	)
  	[protected] _protocol => 'HTTP/1.1'
  	[protected] _status => (int) 200
  	[protected] _contentType => 'text/html'
  	[protected] _headers => array([maximum depth reached])
  	[protected] _body => null
  	[protected] _file => null
  	[protected] _fileRange => null
  	[protected] _charset => 'UTF-8'
  	[protected] _cacheDirectives => array([maximum depth reached])
  	[protected] _cookies => array(
  		[maximum depth reached]
  	)
  }