Notice (8): Undefined offset: 0 [APP/Controller/VillesController.php, line 402]
Code Context
        $d['nbEtab'] = count($d['data']);
        
        $lat = $d['data'][0]['Ville']['lat'];
$ville = 'thun-l-eveque'
$cat = 'img'
$d = array(
	'data' => array(),
	'nbEtab' => (int) 0
)
$joinsSco = array(
	(int) 0 => array(
		'table' => 'listes',
		'alias' => 'Liste',
		'type' => 'LEFT',
		'conditions' => array(
			(int) 0 => 'Structure.liste_id = Liste.id'
		)
	),
	(int) 1 => array(
		'table' => 'villes',
		'alias' => 'Ville',
		'type' => 'LEFT',
		'conditions' => array(
			(int) 0 => 'Structure.codeInsee = Ville.code_commune'
		)
	),
	(int) 2 => array(
		'table' => 'departements',
		'alias' => 'Departement',
		'type' => 'LEFT',
		'conditions' => array(
			(int) 0 => 'Departement.id = Ville.departement_id'
		)
	)
)
VillesController::listing() - APP/Controller/VillesController.php, line 402
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 117

Notice (8): Trying to access array offset on value of type null [APP/Controller/VillesController.php, line 402]
Code Context
        $d['nbEtab'] = count($d['data']);
        
        $lat = $d['data'][0]['Ville']['lat'];
$ville = 'thun-l-eveque'
$cat = 'img'
$d = array(
	'data' => array(),
	'nbEtab' => (int) 0
)
$joinsSco = array(
	(int) 0 => array(
		'table' => 'listes',
		'alias' => 'Liste',
		'type' => 'LEFT',
		'conditions' => array(
			(int) 0 => 'Structure.liste_id = Liste.id'
		)
	),
	(int) 1 => array(
		'table' => 'villes',
		'alias' => 'Ville',
		'type' => 'LEFT',
		'conditions' => array(
			(int) 0 => 'Structure.codeInsee = Ville.code_commune'
		)
	),
	(int) 2 => array(
		'table' => 'departements',
		'alias' => 'Departement',
		'type' => 'LEFT',
		'conditions' => array(
			(int) 0 => 'Departement.id = Ville.departement_id'
		)
	)
)
VillesController::listing() - APP/Controller/VillesController.php, line 402
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 117

Notice (8): Trying to access array offset on value of type null [APP/Controller/VillesController.php, line 402]
Code Context
        $d['nbEtab'] = count($d['data']);
        
        $lat = $d['data'][0]['Ville']['lat'];
$ville = 'thun-l-eveque'
$cat = 'img'
$d = array(
	'data' => array(),
	'nbEtab' => (int) 0
)
$joinsSco = array(
	(int) 0 => array(
		'table' => 'listes',
		'alias' => 'Liste',
		'type' => 'LEFT',
		'conditions' => array(
			(int) 0 => 'Structure.liste_id = Liste.id'
		)
	),
	(int) 1 => array(
		'table' => 'villes',
		'alias' => 'Ville',
		'type' => 'LEFT',
		'conditions' => array(
			(int) 0 => 'Structure.codeInsee = Ville.code_commune'
		)
	),
	(int) 2 => array(
		'table' => 'departements',
		'alias' => 'Departement',
		'type' => 'LEFT',
		'conditions' => array(
			(int) 0 => 'Departement.id = Ville.departement_id'
		)
	)
)
VillesController::listing() - APP/Controller/VillesController.php, line 402
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 117

Notice (8): Undefined offset: 0 [APP/Controller/VillesController.php, line 403]
Code Context
        
        $lat = $d['data'][0]['Ville']['lat'];
        $lng = $d['data'][0]['Ville']['lng'];
$ville = 'thun-l-eveque'
$cat = 'img'
$d = array(
	'data' => array(),
	'nbEtab' => (int) 0
)
$joinsSco = array(
	(int) 0 => array(
		'table' => 'listes',
		'alias' => 'Liste',
		'type' => 'LEFT',
		'conditions' => array(
			(int) 0 => 'Structure.liste_id = Liste.id'
		)
	),
	(int) 1 => array(
		'table' => 'villes',
		'alias' => 'Ville',
		'type' => 'LEFT',
		'conditions' => array(
			(int) 0 => 'Structure.codeInsee = Ville.code_commune'
		)
	),
	(int) 2 => array(
		'table' => 'departements',
		'alias' => 'Departement',
		'type' => 'LEFT',
		'conditions' => array(
			(int) 0 => 'Departement.id = Ville.departement_id'
		)
	)
)
$lat = null
VillesController::listing() - APP/Controller/VillesController.php, line 403
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 117

Notice (8): Trying to access array offset on value of type null [APP/Controller/VillesController.php, line 403]
Code Context
        
        $lat = $d['data'][0]['Ville']['lat'];
        $lng = $d['data'][0]['Ville']['lng'];
$ville = 'thun-l-eveque'
$cat = 'img'
$d = array(
	'data' => array(),
	'nbEtab' => (int) 0
)
$joinsSco = array(
	(int) 0 => array(
		'table' => 'listes',
		'alias' => 'Liste',
		'type' => 'LEFT',
		'conditions' => array(
			(int) 0 => 'Structure.liste_id = Liste.id'
		)
	),
	(int) 1 => array(
		'table' => 'villes',
		'alias' => 'Ville',
		'type' => 'LEFT',
		'conditions' => array(
			(int) 0 => 'Structure.codeInsee = Ville.code_commune'
		)
	),
	(int) 2 => array(
		'table' => 'departements',
		'alias' => 'Departement',
		'type' => 'LEFT',
		'conditions' => array(
			(int) 0 => 'Departement.id = Ville.departement_id'
		)
	)
)
$lat = null
VillesController::listing() - APP/Controller/VillesController.php, line 403
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 117

Notice (8): Trying to access array offset on value of type null [APP/Controller/VillesController.php, line 403]
Code Context
        
        $lat = $d['data'][0]['Ville']['lat'];
        $lng = $d['data'][0]['Ville']['lng'];
$ville = 'thun-l-eveque'
$cat = 'img'
$d = array(
	'data' => array(),
	'nbEtab' => (int) 0
)
$joinsSco = array(
	(int) 0 => array(
		'table' => 'listes',
		'alias' => 'Liste',
		'type' => 'LEFT',
		'conditions' => array(
			(int) 0 => 'Structure.liste_id = Liste.id'
		)
	),
	(int) 1 => array(
		'table' => 'villes',
		'alias' => 'Ville',
		'type' => 'LEFT',
		'conditions' => array(
			(int) 0 => 'Structure.codeInsee = Ville.code_commune'
		)
	),
	(int) 2 => array(
		'table' => 'departements',
		'alias' => 'Departement',
		'type' => 'LEFT',
		'conditions' => array(
			(int) 0 => 'Departement.id = Ville.departement_id'
		)
	)
)
$lat = null
VillesController::listing() - APP/Controller/VillesController.php, line 403
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 117

Notice (8): Undefined offset: 0 [APP/Controller/VillesController.php, line 409]
Code Context
        $d['idem'] = $this->Structure->find('all', array(
            'fields'     => 'Structure.*,Ville.id,Ville.nom,Ville.lat,Ville.lng,'.$sql_distance,
            'conditions' => 'Ville.slug != "'.$ville.'" AND Structure.liste_id = '.$d['data'][0]['Structure']['liste_id'],
$ville = 'thun-l-eveque'
$cat = 'img'
$d = array(
	'data' => array(),
	'nbEtab' => (int) 0
)
$joinsSco = array(
	(int) 0 => array(
		'table' => 'listes',
		'alias' => 'Liste',
		'type' => 'LEFT',
		'conditions' => array(
			(int) 0 => 'Structure.liste_id = Liste.id'
		)
	),
	(int) 1 => array(
		'table' => 'villes',
		'alias' => 'Ville',
		'type' => 'LEFT',
		'conditions' => array(
			(int) 0 => 'Structure.codeInsee = Ville.code_commune'
		)
	),
	(int) 2 => array(
		'table' => 'departements',
		'alias' => 'Departement',
		'type' => 'LEFT',
		'conditions' => array(
			(int) 0 => 'Departement.id = Ville.departement_id'
		)
	)
)
$lat = null
$lng = null
$sql_distance = '(((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'
VillesController::listing() - APP/Controller/VillesController.php, line 409
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 117

Notice (8): Trying to access array offset on value of type null [APP/Controller/VillesController.php, line 409]
Code Context
        $d['idem'] = $this->Structure->find('all', array(
            'fields'     => 'Structure.*,Ville.id,Ville.nom,Ville.lat,Ville.lng,'.$sql_distance,
            'conditions' => 'Ville.slug != "'.$ville.'" AND Structure.liste_id = '.$d['data'][0]['Structure']['liste_id'],
$ville = 'thun-l-eveque'
$cat = 'img'
$d = array(
	'data' => array(),
	'nbEtab' => (int) 0
)
$joinsSco = array(
	(int) 0 => array(
		'table' => 'listes',
		'alias' => 'Liste',
		'type' => 'LEFT',
		'conditions' => array(
			(int) 0 => 'Structure.liste_id = Liste.id'
		)
	),
	(int) 1 => array(
		'table' => 'villes',
		'alias' => 'Ville',
		'type' => 'LEFT',
		'conditions' => array(
			(int) 0 => 'Structure.codeInsee = Ville.code_commune'
		)
	),
	(int) 2 => array(
		'table' => 'departements',
		'alias' => 'Departement',
		'type' => 'LEFT',
		'conditions' => array(
			(int) 0 => 'Departement.id = Ville.departement_id'
		)
	)
)
$lat = null
$lng = null
$sql_distance = '(((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'
VillesController::listing() - APP/Controller/VillesController.php, line 409
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 117

Notice (8): Trying to access array offset on value of type null [APP/Controller/VillesController.php, line 409]
Code Context
        $d['idem'] = $this->Structure->find('all', array(
            'fields'     => 'Structure.*,Ville.id,Ville.nom,Ville.lat,Ville.lng,'.$sql_distance,
            'conditions' => 'Ville.slug != "'.$ville.'" AND Structure.liste_id = '.$d['data'][0]['Structure']['liste_id'],
$ville = 'thun-l-eveque'
$cat = 'img'
$d = array(
	'data' => array(),
	'nbEtab' => (int) 0
)
$joinsSco = array(
	(int) 0 => array(
		'table' => 'listes',
		'alias' => 'Liste',
		'type' => 'LEFT',
		'conditions' => array(
			(int) 0 => 'Structure.liste_id = Liste.id'
		)
	),
	(int) 1 => array(
		'table' => 'villes',
		'alias' => 'Ville',
		'type' => 'LEFT',
		'conditions' => array(
			(int) 0 => 'Structure.codeInsee = Ville.code_commune'
		)
	),
	(int) 2 => array(
		'table' => 'departements',
		'alias' => 'Departement',
		'type' => 'LEFT',
		'conditions' => array(
			(int) 0 => 'Departement.id = Ville.departement_id'
		)
	)
)
$lat = null
$lng = null
$sql_distance = '(((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'
VillesController::listing() - APP/Controller/VillesController.php, line 409
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 117

Warning (2): Cannot modify header information - headers already sent by (output started at /home/lepetitbz/portailfamille.org/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']
$c = array(
	'name' => 'CakeCookie[autologin]',
	'value' => '',
	'expire' => (int) 1715983664,
	'path' => '/',
	'domain' => '',
	'secure' => false,
	'httpOnly' => false
)
$name = 'CakeCookie[autologin]'
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 ??

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 `Structure`.*, `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 FROM `lepetitbz331`.`structures` AS `Structure` LEFT JOIN `lepetitbz331`.`listes` AS `Liste` ON (`Structure`.`liste_id` = `Liste`.`id`) LEFT JOIN `lepetitbz331`.`villes` AS `Ville` ON (`Structure`.`codeInsee` = `Ville`.`code_commune`) LEFT JOIN `lepetitbz331`.`departements` AS `Departement` ON (`Departement`.`id` = `Ville`.`departement_id`) WHERE `Ville`.`slug` != "thun-l-eveque" AND `Structure`.`liste_id` = GROUP BY `Ville`.`id` HAVING distance < 50000 ORDER BY `distance` ASC LIMIT 5

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(array)

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

  array()

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

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

  'SELECT `Structure`.*, `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 FROM `lepetitbz331`.`structures` AS `Structure` LEFT JOIN `lepetitbz331`.`listes` AS `Liste` ON (`Structure`.`liste_id` = `Liste`.`id`) LEFT JOIN `lepetitbz331`.`villes` AS `Ville` ON (`Structure`.`codeInsee` = `Ville`.`code_commune`) LEFT JOIN `lepetitbz331`.`departements` AS `Departement` ON (`Departement`.`id` = `Ville`.`departement_id`)  WHERE `Ville`.`slug` != "thun-l-eveque" AND `Structure`.`liste_id` =   GROUP BY `Ville`.`id` HAVING distance < 50000  ORDER BY `distance` ASC  LIMIT 5'
  array()

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

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

  'SELECT `Structure`.*, `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 FROM `lepetitbz331`.`structures` AS `Structure` LEFT JOIN `lepetitbz331`.`listes` AS `Liste` ON (`Structure`.`liste_id` = `Liste`.`id`) LEFT JOIN `lepetitbz331`.`villes` AS `Ville` ON (`Structure`.`codeInsee` = `Ville`.`code_commune`) LEFT JOIN `lepetitbz331`.`departements` AS `Departement` ON (`Departement`.`id` = `Ville`.`departement_id`)  WHERE `Ville`.`slug` != "thun-l-eveque" AND `Structure`.`liste_id` =   GROUP BY `Ville`.`id` HAVING distance < 50000  ORDER BY `distance` ASC  LIMIT 5'
  array(
  	'log' => false
  )
  array()

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

          // 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 `Structure`.*, `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 FROM `lepetitbz331`.`structures` AS `Structure` LEFT JOIN `lepetitbz331`.`listes` AS `Liste` ON (`Structure`.`liste_id` = `Liste`.`id`) LEFT JOIN `lepetitbz331`.`villes` AS `Ville` ON (`Structure`.`codeInsee` = `Ville`.`code_commune`) LEFT JOIN `lepetitbz331`.`departements` AS `Departement` ON (`Departement`.`id` = `Ville`.`departement_id`)  WHERE `Ville`.`slug` != "thun-l-eveque" AND `Structure`.`liste_id` =   GROUP BY `Ville`.`id` HAVING distance < 50000  ORDER BY `distance` ASC  LIMIT 5'
  array()

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

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

  object(Structure) {
  	name => 'Structure'
  	belongsTo => array(
  		'Ville' => array(
  			'className' => 'Ville',
  			'foreignKey' => 'ville_id',
  			'conditions' => '',
  			'fields' => '',
  			'order' => '',
  			'counterCache' => ''
  		)
  	)
  	validate => array(
  		'pseudo' => array(
  			'Only alphabets and numbers allowed' => array(
  				[maximum depth reached]
  			)
  		)
  	)
  	recursive => (int) -1
  	actsAs => array(
  		(int) 0 => 'Containable'
  	)
  	useDbConfig => 'default'
  	useTable => 'structures'
  	id => false
  	data => array()
  	schemaName => 'lepetitbz331'
  	table => 'structures'
  	primaryKey => 'id'
  	validationErrors => array()
  	validationDomain => null
  	tablePrefix => ''
  	plugin => null
  	alias => 'Structure'
  	tableToModel => array(
  		'structures' => 'Structure'
  	)
  	cacheQueries => false
  	hasOne => array()
  	hasMany => array()
  	hasAndBelongsToMany => array()
  	Behaviors => object(BehaviorCollection) {
  		modelName => 'Structure'
  		defaultPriority => (int) 10
  		[protected] _methods => array(
  			[maximum depth reached]
  		)
  		[protected] _mappedMethods => array([maximum depth reached])
  		[protected] _enabled => array(
  			[maximum depth reached]
  		)
  		[protected] _loaded => array(
  			[maximum depth reached]
  		)
  	}
  	whitelist => array()
  	cacheSources => true
  	findQueryType => 'all'
  	order => null
  	virtualFields => array()
  	__backAssociation => array()
  	__backInnerAssociation => array()
  	__backOriginalAssociation => array()
  	__backContainableAssociation => array()
  	__safeUpdateMode => false
  	useConsistentAfterFind => true
  	findMethods => array(
  		'all' => true,
  		'first' => true,
  		'count' => true,
  		'neighbors' => true,
  		'list' => true,
  		'threaded' => true
  	)
  	[protected] _schema => null
  	[protected] _associationKeys => array(
  		'belongsTo' => array(
  			(int) 0 => 'className',
  			(int) 1 => 'foreignKey',
  			(int) 2 => 'conditions',
  			(int) 3 => 'fields',
  			(int) 4 => 'order',
  			(int) 5 => 'counterCache'
  		),
  		'hasOne' => array(
  			(int) 0 => 'className',
  			(int) 1 => 'foreignKey',
  			(int) 2 => 'conditions',
  			(int) 3 => 'fields',
  			(int) 4 => 'order',
  			(int) 5 => 'dependent'
  		),
  		'hasMany' => array(
  			(int) 0 => 'className',
  			(int) 1 => 'foreignKey',
  			(int) 2 => 'conditions',
  			(int) 3 => 'fields',
  			(int) 4 => 'order',
  			(int) 5 => 'limit',
  			(int) 6 => 'offset',
  			(int) 7 => 'dependent',
  			(int) 8 => 'exclusive',
  			(int) 9 => 'finderQuery',
  			(int) 10 => 'counterQuery'
  		),
  		'hasAndBelongsToMany' => array(
  			(int) 0 => 'className',
  			(int) 1 => 'joinTable',
  			(int) 2 => 'with',
  			(int) 3 => 'foreignKey',
  			(int) 4 => 'associationForeignKey',
  			(int) 5 => 'conditions',
  			(int) 6 => 'fields',
  			(int) 7 => 'order',
  			(int) 8 => 'limit',
  			(int) 9 => 'offset',
  			(int) 10 => 'unique',
  			(int) 11 => 'finderQuery'
  		)
  	)
  	[protected] _associations => array(
  		(int) 0 => 'belongsTo',
  		(int) 1 => 'hasOne',
  		(int) 2 => 'hasMany',
  		(int) 3 => 'hasAndBelongsToMany'
  	)
  	[protected] _insertID => null
  	[protected] _sourceConfigured => true
  	[protected] _eventManager => object(CakeEventManager) {
  		[protected] _generalManager => object(CakeEventManager) {}
  		[protected] _listeners => array(
  			[maximum depth reached]
  		)
  		[protected] _isGlobal => false
  	}
  	[protected] _validator => null
  }
  array(
  	'conditions' => 'Ville.slug != "thun-l-eveque" AND Structure.liste_id = ',
  	'fields' => array(
  		(int) 0 => '`Structure`.*',
  		(int) 1 => '`Ville`.`id`',
  		(int) 2 => '`Ville`.`nom`',
  		(int) 3 => '`Ville`.`lat`',
  		(int) 4 => '`Ville`.`lng`',
  		(int) 5 => '(((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(
  		(int) 0 => array(
  			'table' => 'listes',
  			'alias' => 'Liste',
  			'type' => 'LEFT',
  			'conditions' => array(
  				(int) 0 => 'Structure.liste_id = Liste.id'
  			)
  		),
  		(int) 1 => array(
  			'table' => 'villes',
  			'alias' => 'Ville',
  			'type' => 'LEFT',
  			'conditions' => array(
  				(int) 0 => 'Structure.codeInsee = Ville.code_commune'
  			)
  		),
  		(int) 2 => array(
  			'table' => 'departements',
  			'alias' => 'Departement',
  			'type' => 'LEFT',
  			'conditions' => array(
  				(int) 0 => 'Departement.id = Ville.departement_id'
  			)
  		)
  	),
  	'limit' => (int) 5,
  	'offset' => null,
  	'order' => array(
  		(int) 0 => 'distance'
  	),
  	'page' => (int) 1,
  	'group' => 'Ville.id HAVING distance < 50000',
  	'callbacks' => true,
  	'having' => null,
  	'lock' => null
  )

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

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

  'all'
  array(
  	'conditions' => 'Ville.slug != "thun-l-eveque" AND Structure.liste_id = ',
  	'fields' => 'Structure.*,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',
  	'joins' => array(
  		(int) 0 => array(
  			'table' => 'listes',
  			'alias' => 'Liste',
  			'type' => 'LEFT',
  			'conditions' => array(
  				(int) 0 => 'Structure.liste_id = Liste.id'
  			)
  		),
  		(int) 1 => array(
  			'table' => 'villes',
  			'alias' => 'Ville',
  			'type' => 'LEFT',
  			'conditions' => array(
  				(int) 0 => 'Structure.codeInsee = Ville.code_commune'
  			)
  		),
  		(int) 2 => array(
  			'table' => 'departements',
  			'alias' => 'Departement',
  			'type' => 'LEFT',
  			'conditions' => array(
  				(int) 0 => 'Departement.id = Ville.departement_id'
  			)
  		)
  	),
  	'limit' => (int) 5,
  	'offset' => null,
  	'order' => array(
  		(int) 0 => 'distance'
  	),
  	'page' => (int) 1,
  	'group' => 'Ville.id HAVING distance < 50000',
  	'callbacks' => true
  )

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

              'joins' => $joinsSco,
              'group'      => 'Ville.id HAVING distance < 50000',
              'order'      => 'distance',
              'limit'      => 5
          ));

  'all'
  array(
  	'conditions' => 'Ville.slug != "thun-l-eveque" AND Structure.liste_id = ',
  	'fields' => 'Structure.*,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',
  	'joins' => array(
  		(int) 0 => array(
  			'table' => 'listes',
  			'alias' => 'Liste',
  			'type' => 'LEFT',
  			'conditions' => array(
  				(int) 0 => 'Structure.liste_id = Liste.id'
  			)
  		),
  		(int) 1 => array(
  			'table' => 'villes',
  			'alias' => 'Ville',
  			'type' => 'LEFT',
  			'conditions' => array(
  				(int) 0 => 'Structure.codeInsee = Ville.code_commune'
  			)
  		),
  		(int) 2 => array(
  			'table' => 'departements',
  			'alias' => 'Departement',
  			'type' => 'LEFT',
  			'conditions' => array(
  				(int) 0 => 'Departement.id = Ville.departement_id'
  			)
  		)
  	),
  	'limit' => (int) 5,
  	'offset' => null,
  	'order' => array(
  		(int) 0 => 'distance'
  	),
  	'page' => (int) 1,
  	'group' => 'Ville.id HAVING distance < 50000',
  	'callbacks' => true
  )

• [internal function] → VillesController->listing(string, string, string)

  'thun-l-eveque'
  'img'
  'v-item-01.jpg'

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

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

  object(VillesController) {
  	name => 'villes'
  	uses => array(
  		(int) 0 => 'Ville',
  		(int) 1 => 'Structure'
  	)
  	helpers => array(
  		(int) 0 => 'Text',
  		(int) 1 => 'Js',
  		'Form' => array(
  			'className' => 'FormExt'
  		),
  		(int) 2 => 'Html',
  		(int) 3 => 'Date',
  		(int) 4 => 'Session'
  	)
  	components => array(
  		(int) 0 => 'AutoLogin',
  		'Auth' => array(
  			'loginAction' => array(
  				[maximum depth reached]
  			),
  			'loginRedirect' => array(
  				[maximum depth reached]
  			),
  			'logoutRedirect' => array(
  				[maximum depth reached]
  			),
  			'authorize' => array(
  				[maximum depth reached]
  			),
  			'authError' => 'You are not authorized to view this page.'
  		),
  		(int) 1 => 'RequestHandler',
  		(int) 2 => 'Session',
  		(int) 3 => 'Img',
  		(int) 4 => 'Paginator'
  	)
  	request => object(CakeRequest) {
  		params => array(
  			[maximum depth reached]
  		)
  		data => array([maximum depth reached])
  		query => array([maximum depth reached])
  		url => 'ville/thun-l-eveque/img/v-item-01.jpg'
  		base => ''
  		webroot => '/'
  		here => '/ville/thun-l-eveque/img/v-item-01.jpg'
  		[protected] _detectors => array(
  			[maximum depth reached]
  		)
  		[protected] _input => ''
  	}
  	response => 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]
  		)
  	}
  	viewPath => 'villes'
  	layoutPath => null
  	viewVars => array()
  	view => 'listing'
  	layout => 'default'
  	autoRender => true
  	autoLayout => true
  	Components => object(ComponentCollection) {
  		defaultPriority => (int) 10
  		[protected] _Controller => object(VillesController) {}
  		[protected] _enabled => array(
  			[maximum depth reached]
  		)
  		[protected] _loaded => array(
  			[maximum depth reached]
  		)
  	}
  	viewClass => 'View'
  	View => null
  	ext => '.ctp'
  	plugin => null
  	cacheAction => false
  	passedArgs => array(
  		(int) 0 => 'thun-l-eveque',
  		(int) 1 => 'img',
  		(int) 2 => 'v-item-01.jpg'
  	)
  	scaffold => false
  	methods => array(
  		(int) 0 => 'index',
  		(int) 1 => 'vinted',
  		(int) 2 => 'listing',
  		(int) 3 => 'avis',
  		(int) 4 => 'forum',
  		(int) 5 => 'details',
  		(int) 6 => 'indexation',
  		(int) 7 => 'admin_envoi',
  		(int) 8 => 'search',
  		(int) 9 => 'admin_index',
  		(int) 10 => 'actu',
  		(int) 11 => 'admin_add',
  		(int) 12 => 'admin_delete',
  		(int) 13 => 'publier',
  		(int) 15 => 'isAuthorized'
  	)
  	modelClass => 'Ville'
  	modelKey => 'ville'
  	validationErrors => null
  	AutoLogin => object(AutoLoginComponent) {
  		components => array(
  			[maximum depth reached]
  		)
  		model => 'User'
  		username => 'username'
  		password => 'password'
  		plugin => ''
  		controller => 'users'
  		loginAction => 'login'
  		logoutAction => 'logout'
  		cookieName => 'autologin'
  		expires => '+2 weeks'
  		cookieLocalDomain => false
  		redirect => true
  		requirePrompt => true
  		active => true
  		settings => array([maximum depth reached])
  		Cookie => object(CookieComponent) {}
  		Auth => object(AuthComponent) {}
  		[protected] _debug => false
  		[protected] _Collection => object(ComponentCollection) {}
  		[protected] _componentMap => array(
  			[maximum depth reached]
  		)
  	}
  	Auth => object(AuthComponent) {
  		components => array(
  			[maximum depth reached]
  		)
  		authenticate => array(
  			[maximum depth reached]
  		)
  		authorize => array(
  			[maximum depth reached]
  		)
  		ajaxLogin => null
  		flash => array(
  			[maximum depth reached]
  		)
  		loginAction => array(
  			[maximum depth reached]
  		)
  		loginRedirect => array(
  			[maximum depth reached]
  		)
  		logoutRedirect => array(
  			[maximum depth reached]
  		)
  		authError => 'You are not authorized to view this page.'
  		unauthorizedRedirect => true
  		allowedActions => array(
  			[maximum depth reached]
  		)
  		request => object(CakeRequest) {}
  		response => object(CakeResponse) {}
  		settings => array(
  			[maximum depth reached]
  		)
  		[protected] _authenticateObjects => array(
  			[maximum depth reached]
  		)
  		[protected] _authorizeObjects => array([maximum depth reached])
  		[protected] _user => array([maximum depth reached])
  		[protected] _methods => array(
  			[maximum depth reached]
  		)
  		[protected] _Collection => object(ComponentCollection) {}
  		[protected] _componentMap => array(
  			[maximum depth reached]
  		)
  	}
  	RequestHandler => object(RequestHandlerComponent) {
  		ajaxLayout => 'ajax'
  		enabled => true
  		request => object(CakeRequest) {}
  		response => object(CakeResponse) {}
  		ext => null
  		params => array(
  			[maximum depth reached]
  		)
  		settings => array(
  			[maximum depth reached]
  		)
  		components => array([maximum depth reached])
  		[protected] _renderType => null
  		[protected] _inputTypeMap => array(
  			[maximum depth reached]
  		)
  		[protected] _viewClassMap => array(
  			[maximum depth reached]
  		)
  		[protected] _Collection => object(ComponentCollection) {}
  		[protected] _componentMap => array([maximum depth reached])
  	}
  	Session => object(SessionComponent) {
  		settings => array([maximum depth reached])
  		components => array([maximum depth reached])
  		[protected] _Collection => object(ComponentCollection) {}
  		[protected] _componentMap => array([maximum depth reached])
  	}
  	Img => object(ImgComponent) {
  		settings => array([maximum depth reached])
  		components => array([maximum depth reached])
  		[protected] _Collection => object(ComponentCollection) {}
  		[protected] _componentMap => array([maximum depth reached])
  	}
  	Paginator => object(PaginatorComponent) {
  		settings => array(
  			[maximum depth reached]
  		)
  		whitelist => array(
  			[maximum depth reached]
  		)
  		components => array([maximum depth reached])
  		Controller => object(VillesController) {}
  		[protected] _Collection => object(ComponentCollection) {}
  		[protected] _componentMap => array([maximum depth reached])
  	}
  	Structure => object(Structure) {
  		name => 'Structure'
  		belongsTo => array(
  			[maximum depth reached]
  		)
  		validate => array(
  			[maximum depth reached]
  		)
  		recursive => (int) -1
  		actsAs => array(
  			[maximum depth reached]
  		)
  		useDbConfig => 'default'
  		useTable => 'structures'
  		id => false
  		data => array([maximum depth reached])
  		schemaName => 'lepetitbz331'
  		table => 'structures'
  		primaryKey => 'id'
  		validationErrors => array([maximum depth reached])
  		validationDomain => null
  		tablePrefix => ''
  		plugin => null
  		alias => 'Structure'
  		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
  		useConsistentAfterFind => true
  		findMethods => array(
  			[maximum depth reached]
  		)
  		[protected] _schema => null
  		[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
  	}
  	[protected] _responseClass => 'CakeResponse'
  	[protected] _mergeParent => 'AppController'
  	[protected] _eventManager => object(CakeEventManager) {
  		[protected] _generalManager => object(CakeEventManager) {}
  		[protected] _listeners => array(
  			[maximum depth reached]
  		)
  		[protected] _isGlobal => false
  	}
  }
  array(
  	(int) 0 => 'thun-l-eveque',
  	(int) 1 => 'img',
  	(int) 2 => 'v-item-01.jpg'
  )

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

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

  object(CakeRequest) {
  	params => array(
  		'plugin' => null,
  		'controller' => 'villes',
  		'action' => 'listing',
  		'named' => array(),
  		'pass' => array(
  			(int) 0 => 'thun-l-eveque',
  			(int) 1 => 'img',
  			(int) 2 => 'v-item-01.jpg'
  		),
  		'ville' => 'thun-l-eveque',
  		'cat' => 'img',
  		'isAjax' => false,
  		'models' => array(
  			'Structure' => array(
  				[maximum depth reached]
  			)
  		)
  	)
  	data => array()
  	query => array()
  	url => 'ville/thun-l-eveque/img/v-item-01.jpg'
  	base => ''
  	webroot => '/'
  	here => '/ville/thun-l-eveque/img/v-item-01.jpg'
  	[protected] _detectors => array(
  		'get' => array(
  			'env' => 'REQUEST_METHOD',
  			'value' => 'GET'
  		),
  		'patch' => array(
  			'env' => 'REQUEST_METHOD',
  			'value' => 'PATCH'
  		),
  		'post' => array(
  			'env' => 'REQUEST_METHOD',
  			'value' => 'POST'
  		),
  		'put' => array(
  			'env' => 'REQUEST_METHOD',
  			'value' => 'PUT'
  		),
  		'delete' => array(
  			'env' => 'REQUEST_METHOD',
  			'value' => 'DELETE'
  		),
  		'head' => array(
  			'env' => 'REQUEST_METHOD',
  			'value' => 'HEAD'
  		),
  		'options' => array(
  			'env' => 'REQUEST_METHOD',
  			'value' => 'OPTIONS'
  		),
  		'ssl' => array(
  			'env' => 'HTTPS',
  			'value' => (int) 1
  		),
  		'ajax' => array(
  			'env' => 'HTTP_X_REQUESTED_WITH',
  			'value' => 'XMLHttpRequest'
  		),
  		'flash' => array(
  			'env' => 'HTTP_USER_AGENT',
  			'pattern' => '/^(Shockwave|Adobe) Flash/'
  		),
  		'mobile' => array(
  			'env' => 'HTTP_USER_AGENT',
  			'options' => array(
  				[maximum depth reached]
  			)
  		),
  		'requested' => array(
  			'param' => 'requested',
  			'value' => (int) 1
  		),
  		'json' => array(
  			'accept' => array(
  				[maximum depth reached]
  			),
  			'param' => 'ext',
  			'value' => 'json'
  		),
  		'xml' => array(
  			'accept' => array(
  				[maximum depth reached]
  			),
  			'param' => 'ext',
  			'value' => 'xml'
  		)
  	)
  	[protected] _input => ''
  }

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

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

  object(VillesController) {
  	name => 'villes'
  	uses => array(
  		(int) 0 => 'Ville',
  		(int) 1 => 'Structure'
  	)
  	helpers => array(
  		(int) 0 => 'Text',
  		(int) 1 => 'Js',
  		'Form' => array(
  			'className' => 'FormExt'
  		),
  		(int) 2 => 'Html',
  		(int) 3 => 'Date',
  		(int) 4 => 'Session'
  	)
  	components => array(
  		(int) 0 => 'AutoLogin',
  		'Auth' => array(
  			'loginAction' => array(
  				[maximum depth reached]
  			),
  			'loginRedirect' => array(
  				[maximum depth reached]
  			),
  			'logoutRedirect' => array(
  				[maximum depth reached]
  			),
  			'authorize' => array(
  				[maximum depth reached]
  			),
  			'authError' => 'You are not authorized to view this page.'
  		),
  		(int) 1 => 'RequestHandler',
  		(int) 2 => 'Session',
  		(int) 3 => 'Img',
  		(int) 4 => 'Paginator'
  	)
  	request => object(CakeRequest) {
  		params => array(
  			[maximum depth reached]
  		)
  		data => array([maximum depth reached])
  		query => array([maximum depth reached])
  		url => 'ville/thun-l-eveque/img/v-item-01.jpg'
  		base => ''
  		webroot => '/'
  		here => '/ville/thun-l-eveque/img/v-item-01.jpg'
  		[protected] _detectors => array(
  			[maximum depth reached]
  		)
  		[protected] _input => ''
  	}
  	response => 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]
  		)
  	}
  	viewPath => 'villes'
  	layoutPath => null
  	viewVars => array()
  	view => 'listing'
  	layout => 'default'
  	autoRender => true
  	autoLayout => true
  	Components => object(ComponentCollection) {
  		defaultPriority => (int) 10
  		[protected] _Controller => object(VillesController) {}
  		[protected] _enabled => array(
  			[maximum depth reached]
  		)
  		[protected] _loaded => array(
  			[maximum depth reached]
  		)
  	}
  	viewClass => 'View'
  	View => null
  	ext => '.ctp'
  	plugin => null
  	cacheAction => false
  	passedArgs => array(
  		(int) 0 => 'thun-l-eveque',
  		(int) 1 => 'img',
  		(int) 2 => 'v-item-01.jpg'
  	)
  	scaffold => false
  	methods => array(
  		(int) 0 => 'index',
  		(int) 1 => 'vinted',
  		(int) 2 => 'listing',
  		(int) 3 => 'avis',
  		(int) 4 => 'forum',
  		(int) 5 => 'details',
  		(int) 6 => 'indexation',
  		(int) 7 => 'admin_envoi',
  		(int) 8 => 'search',
  		(int) 9 => 'admin_index',
  		(int) 10 => 'actu',
  		(int) 11 => 'admin_add',
  		(int) 12 => 'admin_delete',
  		(int) 13 => 'publier',
  		(int) 15 => 'isAuthorized'
  	)
  	modelClass => 'Ville'
  	modelKey => 'ville'
  	validationErrors => null
  	AutoLogin => object(AutoLoginComponent) {
  		components => array(
  			[maximum depth reached]
  		)
  		model => 'User'
  		username => 'username'
  		password => 'password'
  		plugin => ''
  		controller => 'users'
  		loginAction => 'login'
  		logoutAction => 'logout'
  		cookieName => 'autologin'
  		expires => '+2 weeks'
  		cookieLocalDomain => false
  		redirect => true
  		requirePrompt => true
  		active => true
  		settings => array([maximum depth reached])
  		Cookie => object(CookieComponent) {}
  		Auth => object(AuthComponent) {}
  		[protected] _debug => false
  		[protected] _Collection => object(ComponentCollection) {}
  		[protected] _componentMap => array(
  			[maximum depth reached]
  		)
  	}
  	Auth => object(AuthComponent) {
  		components => array(
  			[maximum depth reached]
  		)
  		authenticate => array(
  			[maximum depth reached]
  		)
  		authorize => array(
  			[maximum depth reached]
  		)
  		ajaxLogin => null
  		flash => array(
  			[maximum depth reached]
  		)
  		loginAction => array(
  			[maximum depth reached]
  		)
  		loginRedirect => array(
  			[maximum depth reached]
  		)
  		logoutRedirect => array(
  			[maximum depth reached]
  		)
  		authError => 'You are not authorized to view this page.'
  		unauthorizedRedirect => true
  		allowedActions => array(
  			[maximum depth reached]
  		)
  		request => object(CakeRequest) {}
  		response => object(CakeResponse) {}
  		settings => array(
  			[maximum depth reached]
  		)
  		[protected] _authenticateObjects => array(
  			[maximum depth reached]
  		)
  		[protected] _authorizeObjects => array([maximum depth reached])
  		[protected] _user => array([maximum depth reached])
  		[protected] _methods => array(
  			[maximum depth reached]
  		)
  		[protected] _Collection => object(ComponentCollection) {}
  		[protected] _componentMap => array(
  			[maximum depth reached]
  		)
  	}
  	RequestHandler => object(RequestHandlerComponent) {
  		ajaxLayout => 'ajax'
  		enabled => true
  		request => object(CakeRequest) {}
  		response => object(CakeResponse) {}
  		ext => null
  		params => array(
  			[maximum depth reached]
  		)
  		settings => array(
  			[maximum depth reached]
  		)
  		components => array([maximum depth reached])
  		[protected] _renderType => null
  		[protected] _inputTypeMap => array(
  			[maximum depth reached]
  		)
  		[protected] _viewClassMap => array(
  			[maximum depth reached]
  		)
  		[protected] _Collection => object(ComponentCollection) {}
  		[protected] _componentMap => array([maximum depth reached])
  	}
  	Session => object(SessionComponent) {
  		settings => array([maximum depth reached])
  		components => array([maximum depth reached])
  		[protected] _Collection => object(ComponentCollection) {}
  		[protected] _componentMap => array([maximum depth reached])
  	}
  	Img => object(ImgComponent) {
  		settings => array([maximum depth reached])
  		components => array([maximum depth reached])
  		[protected] _Collection => object(ComponentCollection) {}
  		[protected] _componentMap => array([maximum depth reached])
  	}
  	Paginator => object(PaginatorComponent) {
  		settings => array(
  			[maximum depth reached]
  		)
  		whitelist => array(
  			[maximum depth reached]
  		)
  		components => array([maximum depth reached])
  		Controller => object(VillesController) {}
  		[protected] _Collection => object(ComponentCollection) {}
  		[protected] _componentMap => array([maximum depth reached])
  	}
  	Structure => object(Structure) {
  		name => 'Structure'
  		belongsTo => array(
  			[maximum depth reached]
  		)
  		validate => array(
  			[maximum depth reached]
  		)
  		recursive => (int) -1
  		actsAs => array(
  			[maximum depth reached]
  		)
  		useDbConfig => 'default'
  		useTable => 'structures'
  		id => false
  		data => array([maximum depth reached])
  		schemaName => 'lepetitbz331'
  		table => 'structures'
  		primaryKey => 'id'
  		validationErrors => array([maximum depth reached])
  		validationDomain => null
  		tablePrefix => ''
  		plugin => null
  		alias => 'Structure'
  		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
  		useConsistentAfterFind => true
  		findMethods => array(
  			[maximum depth reached]
  		)
  		[protected] _schema => null
  		[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
  	}
  	[protected] _responseClass => 'CakeResponse'
  	[protected] _mergeParent => 'AppController'
  	[protected] _eventManager => object(CakeEventManager) {
  		[protected] _generalManager => object(CakeEventManager) {}
  		[protected] _listeners => array(
  			[maximum depth reached]
  		)
  		[protected] _isGlobal => false
  	}
  }
  object(CakeRequest) {
  	params => array(
  		'plugin' => null,
  		'controller' => 'villes',
  		'action' => 'listing',
  		'named' => array(),
  		'pass' => array(
  			(int) 0 => 'thun-l-eveque',
  			(int) 1 => 'img',
  			(int) 2 => 'v-item-01.jpg'
  		),
  		'ville' => 'thun-l-eveque',
  		'cat' => 'img',
  		'isAjax' => false,
  		'models' => array(
  			'Structure' => array(
  				[maximum depth reached]
  			)
  		)
  	)
  	data => array()
  	query => array()
  	url => 'ville/thun-l-eveque/img/v-item-01.jpg'
  	base => ''
  	webroot => '/'
  	here => '/ville/thun-l-eveque/img/v-item-01.jpg'
  	[protected] _detectors => array(
  		'get' => array(
  			'env' => 'REQUEST_METHOD',
  			'value' => 'GET'
  		),
  		'patch' => array(
  			'env' => 'REQUEST_METHOD',
  			'value' => 'PATCH'
  		),
  		'post' => array(
  			'env' => 'REQUEST_METHOD',
  			'value' => 'POST'
  		),
  		'put' => array(
  			'env' => 'REQUEST_METHOD',
  			'value' => 'PUT'
  		),
  		'delete' => array(
  			'env' => 'REQUEST_METHOD',
  			'value' => 'DELETE'
  		),
  		'head' => array(
  			'env' => 'REQUEST_METHOD',
  			'value' => 'HEAD'
  		),
  		'options' => array(
  			'env' => 'REQUEST_METHOD',
  			'value' => 'OPTIONS'
  		),
  		'ssl' => array(
  			'env' => 'HTTPS',
  			'value' => (int) 1
  		),
  		'ajax' => array(
  			'env' => 'HTTP_X_REQUESTED_WITH',
  			'value' => 'XMLHttpRequest'
  		),
  		'flash' => array(
  			'env' => 'HTTP_USER_AGENT',
  			'pattern' => '/^(Shockwave|Adobe) Flash/'
  		),
  		'mobile' => array(
  			'env' => 'HTTP_USER_AGENT',
  			'options' => array(
  				[maximum depth reached]
  			)
  		),
  		'requested' => array(
  			'param' => 'requested',
  			'value' => (int) 1
  		),
  		'json' => array(
  			'accept' => array(
  				[maximum depth reached]
  			),
  			'param' => 'ext',
  			'value' => 'json'
  		),
  		'xml' => array(
  			'accept' => array(
  				[maximum depth reached]
  			),
  			'param' => 'ext',
  			'value' => 'xml'
  		)
  	)
  	[protected] _input => ''
  }

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

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

  object(CakeRequest) {
  	params => array(
  		'plugin' => null,
  		'controller' => 'villes',
  		'action' => 'listing',
  		'named' => array(),
  		'pass' => array(
  			(int) 0 => 'thun-l-eveque',
  			(int) 1 => 'img',
  			(int) 2 => 'v-item-01.jpg'
  		),
  		'ville' => 'thun-l-eveque',
  		'cat' => 'img',
  		'isAjax' => false,
  		'models' => array(
  			'Structure' => array(
  				[maximum depth reached]
  			)
  		)
  	)
  	data => array()
  	query => array()
  	url => 'ville/thun-l-eveque/img/v-item-01.jpg'
  	base => ''
  	webroot => '/'
  	here => '/ville/thun-l-eveque/img/v-item-01.jpg'
  	[protected] _detectors => array(
  		'get' => array(
  			'env' => 'REQUEST_METHOD',
  			'value' => 'GET'
  		),
  		'patch' => array(
  			'env' => 'REQUEST_METHOD',
  			'value' => 'PATCH'
  		),
  		'post' => array(
  			'env' => 'REQUEST_METHOD',
  			'value' => 'POST'
  		),
  		'put' => array(
  			'env' => 'REQUEST_METHOD',
  			'value' => 'PUT'
  		),
  		'delete' => array(
  			'env' => 'REQUEST_METHOD',
  			'value' => 'DELETE'
  		),
  		'head' => array(
  			'env' => 'REQUEST_METHOD',
  			'value' => 'HEAD'
  		),
  		'options' => array(
  			'env' => 'REQUEST_METHOD',
  			'value' => 'OPTIONS'
  		),
  		'ssl' => array(
  			'env' => 'HTTPS',
  			'value' => (int) 1
  		),
  		'ajax' => array(
  			'env' => 'HTTP_X_REQUESTED_WITH',
  			'value' => 'XMLHttpRequest'
  		),
  		'flash' => array(
  			'env' => 'HTTP_USER_AGENT',
  			'pattern' => '/^(Shockwave|Adobe) Flash/'
  		),
  		'mobile' => array(
  			'env' => 'HTTP_USER_AGENT',
  			'options' => array(
  				[maximum depth reached]
  			)
  		),
  		'requested' => array(
  			'param' => 'requested',
  			'value' => (int) 1
  		),
  		'json' => array(
  			'accept' => array(
  				[maximum depth reached]
  			),
  			'param' => 'ext',
  			'value' => 'json'
  		),
  		'xml' => array(
  			'accept' => array(
  				[maximum depth reached]
  			),
  			'param' => 'ext',
  			'value' => 'xml'
  		)
  	)
  	[protected] _input => ''
  }
  object(CakeResponse) {
  	[protected] _statusCodes => array(
  		(int) 100 => 'Continue',
  		(int) 101 => 'Switching Protocols',
  		(int) 200 => 'OK',
  		(int) 201 => 'Created',
  		(int) 202 => 'Accepted',
  		(int) 203 => 'Non-Authoritative Information',
  		(int) 204 => 'No Content',
  		(int) 205 => 'Reset Content',
  		(int) 206 => 'Partial Content',
  		(int) 300 => 'Multiple Choices',
  		(int) 301 => 'Moved Permanently',
  		(int) 302 => 'Found',
  		(int) 303 => 'See Other',
  		(int) 304 => 'Not Modified',
  		(int) 305 => 'Use Proxy',
  		(int) 307 => 'Temporary Redirect',
  		(int) 400 => 'Bad Request',
  		(int) 401 => 'Unauthorized',
  		(int) 402 => 'Payment Required',
  		(int) 403 => 'Forbidden',
  		(int) 404 => 'Not Found',
  		(int) 405 => 'Method Not Allowed',
  		(int) 406 => 'Not Acceptable',
  		(int) 407 => 'Proxy Authentication Required',
  		(int) 408 => 'Request Time-out',
  		(int) 409 => 'Conflict',
  		(int) 410 => 'Gone',
  		(int) 411 => 'Length Required',
  		(int) 412 => 'Precondition Failed',
  		(int) 413 => 'Request Entity Too Large',
  		(int) 414 => 'Request-URI Too Large',
  		(int) 415 => 'Unsupported Media Type',
  		(int) 416 => 'Requested range not satisfiable',
  		(int) 417 => 'Expectation Failed',
  		(int) 429 => 'Too Many Requests',
  		(int) 500 => 'Internal Server Error',
  		(int) 501 => 'Not Implemented',
  		(int) 502 => 'Bad Gateway',
  		(int) 503 => 'Service Unavailable',
  		(int) 504 => 'Gateway Time-out',
  		(int) 505 => 'Unsupported Version'
  	)
  	[protected] _mimeTypes => array(
  		'html' => array(
  			(int) 0 => 'text/html',
  			(int) 1 => '*/*'
  		),
  		'json' => 'application/json',
  		'xml' => array(
  			(int) 0 => 'application/xml',
  			(int) 1 => 'text/xml'
  		),
  		'rss' => 'application/rss+xml',
  		'ai' => 'application/postscript',
  		'bcpio' => 'application/x-bcpio',
  		'bin' => 'application/octet-stream',
  		'ccad' => 'application/clariscad',
  		'cdf' => 'application/x-netcdf',
  		'class' => 'application/octet-stream',
  		'cpio' => 'application/x-cpio',
  		'cpt' => 'application/mac-compactpro',
  		'csh' => 'application/x-csh',
  		'csv' => array(
  			(int) 0 => 'text/csv',
  			(int) 1 => 'application/vnd.ms-excel'
  		),
  		'dcr' => 'application/x-director',
  		'dir' => 'application/x-director',
  		'dms' => 'application/octet-stream',
  		'doc' => 'application/msword',
  		'docx' => 'application/vnd.openxmlformats-officedocument.wordprocessingml.document',
  		'drw' => 'application/drafting',
  		'dvi' => 'application/x-dvi',
  		'dwg' => 'application/acad',
  		'dxf' => 'application/dxf',
  		'dxr' => 'application/x-director',
  		'eot' => 'application/vnd.ms-fontobject',
  		'eps' => 'application/postscript',
  		'exe' => 'application/octet-stream',
  		'ez' => 'application/andrew-inset',
  		'flv' => 'video/x-flv',
  		'gtar' => 'application/x-gtar',
  		'gz' => 'application/x-gzip',
  		'bz2' => 'application/x-bzip',
  		'7z' => 'application/x-7z-compressed',
  		'hdf' => 'application/x-hdf',
  		'hqx' => 'application/mac-binhex40',
  		'ico' => 'image/x-icon',
  		'ips' => 'application/x-ipscript',
  		'ipx' => 'application/x-ipix',
  		'js' => 'application/javascript',
  		'jsonapi' => 'application/vnd.api+json',
  		'latex' => 'application/x-latex',
  		'lha' => 'application/octet-stream',
  		'lsp' => 'application/x-lisp',
  		'lzh' => 'application/octet-stream',
  		'man' => 'application/x-troff-man',
  		'me' => 'application/x-troff-me',
  		'mif' => 'application/vnd.mif',
  		'ms' => 'application/x-troff-ms',
  		'nc' => 'application/x-netcdf',
  		'oda' => 'application/oda',
  		'otf' => 'font/otf',
  		'pdf' => 'application/pdf',
  		'pgn' => 'application/x-chess-pgn',
  		'pot' => 'application/vnd.ms-powerpoint',
  		'pps' => 'application/vnd.ms-powerpoint',
  		'ppt' => 'application/vnd.ms-powerpoint',
  		'pptx' => 'application/vnd.openxmlformats-officedocument.presentationml.presentation',
  		'ppz' => 'application/vnd.ms-powerpoint',
  		'pre' => 'application/x-freelance',
  		'prt' => 'application/pro_eng',
  		'ps' => 'application/postscript',
  		'roff' => 'application/x-troff',
  		'scm' => 'application/x-lotusscreencam',
  		'set' => 'application/set',
  		'sh' => 'application/x-sh',
  		'shar' => 'application/x-shar',
  		'sit' => 'application/x-stuffit',
  		'skd' => 'application/x-koan',
  		'skm' => 'application/x-koan',
  		'skp' => 'application/x-koan',
  		'skt' => 'application/x-koan',
  		'smi' => 'application/smil',
  		'smil' => 'application/smil',
  		'sol' => 'application/solids',
  		'spl' => 'application/x-futuresplash',
  		'src' => 'application/x-wais-source',
  		'step' => 'application/STEP',
  		'stl' => 'application/SLA',
  		'stp' => 'application/STEP',
  		'sv4cpio' => 'application/x-sv4cpio',
  		'sv4crc' => 'application/x-sv4crc',
  		'svg' => 'image/svg+xml',
  		'svgz' => 'image/svg+xml',
  		'swf' => 'application/x-shockwave-flash',
  		't' => 'application/x-troff',
  		'tar' => 'application/x-tar',
  		'tcl' => 'application/x-tcl',
  		'tex' => 'application/x-tex',
  		'texi' => 'application/x-texinfo',
  		'texinfo' => 'application/x-texinfo',
  		'tr' => 'application/x-troff',
  		'tsp' => 'application/dsptype',
  		'ttc' => 'font/ttf',
  		'ttf' => 'font/ttf',
  		'unv' => 'application/i-deas',
  		'ustar' => 'application/x-ustar',
  		'vcd' => 'application/x-cdlink',
  		'vda' => 'application/vda',
  		'xlc' => 'application/vnd.ms-excel',
  		'xll' => 'application/vnd.ms-excel',
  		'xlm' => 'application/vnd.ms-excel',
  		'xls' => 'application/vnd.ms-excel',
  		'xlsx' => 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet',
  		'xlw' => 'application/vnd.ms-excel',
  		'zip' => 'application/zip',
  		'aif' => 'audio/x-aiff',
  		'aifc' => 'audio/x-aiff',
  		'aiff' => 'audio/x-aiff',
  		'au' => 'audio/basic',
  		'kar' => 'audio/midi',
  		'mid' => 'audio/midi',
  		'midi' => 'audio/midi',
  		'mp2' => 'audio/mpeg',
  		'mp3' => 'audio/mpeg',
  		'mpga' => 'audio/mpeg',
  		'ogg' => 'audio/ogg',
  		'oga' => 'audio/ogg',
  		'spx' => 'audio/ogg',
  		'ra' => 'audio/x-realaudio',
  		'ram' => 'audio/x-pn-realaudio',
  		'rm' => 'audio/x-pn-realaudio',
  		'rpm' => 'audio/x-pn-realaudio-plugin',
  		'snd' => 'audio/basic',
  		'tsi' => 'audio/TSP-audio',
  		'wav' => 'audio/x-wav',
  		'aac' => 'audio/aac',
  		'asc' => 'text/plain',
  		'c' => 'text/plain',
  		'cc' => 'text/plain',
  		'css' => 'text/css',
  		'etx' => 'text/x-setext',
  		'f' => 'text/plain',
  		'f90' => 'text/plain',
  		'h' => 'text/plain',
  		'hh' => 'text/plain',
  		'htm' => array(
  			(int) 0 => 'text/html',
  			(int) 1 => '*/*'
  		),
  		'ics' => 'text/calendar',
  		'm' => 'text/plain',
  		'rtf' => 'text/rtf',
  		'rtx' => 'text/richtext',
  		'sgm' => 'text/sgml',
  		'sgml' => 'text/sgml',
  		'tsv' => 'text/tab-separated-values',
  		'tpl' => 'text/template',
  		'txt' => 'text/plain',
  		'text' => 'text/plain',
  		'avi' => 'video/x-msvideo',
  		'fli' => 'video/x-fli',
  		'mov' => 'video/quicktime',
  		'movie' => 'video/x-sgi-movie',
  		'mpe' => 'video/mpeg',
  		'mpeg' => 'video/mpeg',
  		'mpg' => 'video/mpeg',
  		'qt' => 'video/quicktime',
  		'viv' => 'video/vnd.vivo',
  		'vivo' => 'video/vnd.vivo',
  		'ogv' => 'video/ogg',
  		'webm' => 'video/webm',
  		'mp4' => 'video/mp4',
  		'm4v' => 'video/mp4',
  		'f4v' => 'video/mp4',
  		'f4p' => 'video/mp4',
  		'm4a' => 'audio/mp4',
  		'f4a' => 'audio/mp4',
  		'f4b' => 'audio/mp4',
  		'gif' => 'image/gif',
  		'ief' => 'image/ief',
  		'jpg' => 'image/jpeg',
  		'jpeg' => 'image/jpeg',
  		'jpe' => 'image/jpeg',
  		'pbm' => 'image/x-portable-bitmap',
  		'pgm' => 'image/x-portable-graymap',
  		'png' => 'image/png',
  		'pnm' => 'image/x-portable-anymap',
  		'ppm' => 'image/x-portable-pixmap',
  		'ras' => 'image/cmu-raster',
  		'rgb' => 'image/x-rgb',
  		'tif' => 'image/tiff',
  		'tiff' => 'image/tiff',
  		'xbm' => 'image/x-xbitmap',
  		'xpm' => 'image/x-xpixmap',
  		'xwd' => 'image/x-xwindowdump',
  		'psd' => array(
  			(int) 0 => 'application/photoshop',
  			(int) 1 => 'application/psd',
  			(int) 2 => 'image/psd',
  			(int) 3 => 'image/x-photoshop',
  			(int) 4 => 'image/photoshop',
  			(int) 5 => 'zz-application/zz-winassoc-psd'
  		),
  		'ice' => 'x-conference/x-cooltalk',
  		'iges' => 'model/iges',
  		'igs' => 'model/iges',
  		'mesh' => 'model/mesh',
  		'msh' => 'model/mesh',
  		'silo' => 'model/mesh',
  		'vrml' => 'model/vrml',
  		'wrl' => 'model/vrml',
  		'mime' => 'www/mime',
  		'pdb' => 'chemical/x-pdb',
  		'xyz' => 'chemical/x-pdb',
  		'javascript' => 'application/javascript',
  		'form' => 'application/x-www-form-urlencoded',
  		'file' => 'multipart/form-data',
  		'xhtml' => array(
  			(int) 0 => 'application/xhtml+xml',
  			(int) 1 => 'application/xhtml',
  			(int) 2 => 'text/xhtml'
  		),
  		'xhtml-mobile' => 'application/vnd.wap.xhtml+xml',
  		'atom' => 'application/atom+xml',
  		'amf' => 'application/x-amf',
  		'wap' => array(
  			(int) 0 => 'text/vnd.wap.wml',
  			(int) 1 => 'text/vnd.wap.wmlscript',
  			(int) 2 => 'image/vnd.wap.wbmp'
  		),
  		'wml' => 'text/vnd.wap.wml',
  		'wmlscript' => 'text/vnd.wap.wmlscript',
  		'wbmp' => 'image/vnd.wap.wbmp',
  		'woff' => 'application/x-font-woff',
  		'webp' => 'image/webp',
  		'appcache' => 'text/cache-manifest',
  		'manifest' => 'text/cache-manifest',
  		'htc' => 'text/x-component',
  		'rdf' => 'application/xml',
  		'crx' => 'application/x-chrome-extension',
  		'oex' => 'application/x-opera-extension',
  		'xpi' => 'application/x-xpinstall',
  		'safariextz' => 'application/octet-stream',
  		'webapp' => 'application/x-web-app-manifest+json',
  		'vcf' => 'text/x-vcard',
  		'vtt' => 'text/vtt',
  		'mkv' => 'video/x-matroska',
  		'pkpass' => 'application/vnd.apple.pkpass',
  		'ajax' => 'text/html'
  	)
  	[protected] _protocol => 'HTTP/1.1'
  	[protected] _status => (int) 200
  	[protected] _contentType => 'text/html'
  	[protected] _headers => array()
  	[protected] _body => null
  	[protected] _file => null
  	[protected] _fileRange => null
  	[protected] _charset => 'UTF-8'
  	[protected] _cacheDirectives => array()
  	[protected] _cookies => array(
  		'CakeCookie[autologin]' => array(
  			'name' => 'CakeCookie[autologin]',
  			'value' => '',
  			'expire' => (int) 1715983664,
  			'path' => '/',
  			'domain' => '',
  			'secure' => false,
  			'httpOnly' => false
  		)
  	)
  }