Errors

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 `lepetitbz331`.`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

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 `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 `lepetitbz331`.`villes` AS `Ville`   WHERE `Ville`.`id` !=   GROUP BY `Ville`.`id` HAVING distance < 40000  ORDER BY `distance` ASC  LIMIT 7'
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 `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 `lepetitbz331`.`villes` AS `Ville`   WHERE `Ville`.`id` !=   GROUP BY `Ville`.`id` HAVING distance < 40000  ORDER BY `distance` ASC  LIMIT 7'
array(
	'log' => true
)
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 `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 `lepetitbz331`.`villes` AS `Ville`   WHERE `Ville`.`id` !=   GROUP BY `Ville`.`id` HAVING distance < 40000  ORDER BY `distance` ASC  LIMIT 7'
array()

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

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

object(Ville) {
	belongsTo => array(
		'Departement' => array(
			'className' => 'Departement',
			'foreignKey' => 'departement_id',
			'conditions' => '',
			'fields' => '',
			'order' => '',
			'counterCache' => ''
		)
	)
	hasMany => array(
		'Info' => array(
			'className' => 'Info',
			'foreignKey' => 'ville_id',
			'conditions' => '',
			'fields' => '',
			'order' => '',
			'limit' => '',
			'offset' => '',
			'dependent' => '',
			'exclusive' => '',
			'finderQuery' => '',
			'counterQuery' => ''
		)
	)
	recursive => (int) -1
	actsAs => array(
		(int) 0 => 'Containable'
	)
	useDbConfig => 'default'
	useTable => 'villes'
	id => false
	data => array()
	schemaName => 'lepetitbz331'
	table => 'villes'
	primaryKey => 'id'
	validate => array()
	validationErrors => array()
	validationDomain => null
	tablePrefix => ''
	plugin => null
	name => 'Ville'
	alias => 'Ville'
	tableToModel => array(
		'villes' => 'Ville'
	)
	cacheQueries => false
	hasOne => array()
	hasAndBelongsToMany => array()
	Behaviors => object(BehaviorCollection) {
		modelName => 'Ville'
		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.id != ',
	'fields' => array(
		(int) 0 => '`Ville`.`id`',
		(int) 1 => '`Ville`.`slug`',
		(int) 2 => '`Ville`.`dep`',
		(int) 3 => '`Ville`.`nom`',
		(int) 4 => '`Ville`.`lat`',
		(int) 5 => '`Ville`.`lng`',
		(int) 6 => '(((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) 7,
	'offset' => null,
	'order' => array(
		(int) 0 => 'distance'
	),
	'page' => (int) 1,
	'group' => 'Ville.id HAVING distance < 40000',
	'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.id != ',
	'fields' => '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',
	'joins' => array(),
	'limit' => (int) 7,
	'offset' => null,
	'order' => array(
		(int) 0 => 'distance'
	),
	'page' => (int) 1,
	'group' => 'Ville.id HAVING distance < 40000',
	'callbacks' => true
)

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

            'conditions' => 'Ville.id != '.$d['data'][0]['Ville']['id'],
            'group'      => 'Ville.id HAVING distance < 40000',
            'order'      => 'distance',
            'limit'      => 7
        ));

'all'
array(
	'conditions' => 'Ville.id != ',
	'fields' => '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',
	'joins' => array(),
	'limit' => (int) 7,
	'offset' => null,
	'order' => array(
		(int) 0 => 'distance'
	),
	'page' => (int) 1,
	'group' => 'Ville.id HAVING distance < 40000',
	'callbacks' => true
)

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

'villemomble'
'tabac'

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 => 'Departement',
		(int) 2 => 'Etablissement'
	)
	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/villemomble/tabac'
		base => ''
		webroot => '/'
		here => '/ville/villemomble/tabac'
		[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(
		'username' => null
	)
	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 => 'villemomble',
		(int) 1 => 'tabac'
	)
	scaffold => false
	methods => array(
		(int) 0 => 'index',
		(int) 1 => 'toiture',
		(int) 2 => 'shampouineuse',
		(int) 3 => 'prix',
		(int) 4 => 'poster',
		(int) 5 => 'listing',
		(int) 6 => 'details',
		(int) 7 => 'search',
		(int) 8 => 'admin_index',
		(int) 9 => 'admin_add',
		(int) 10 => 'admin_delete',
		(int) 11 => '_usersUsername',
		(int) 13 => '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])
	}
	Departement => object(Departement) {
		belongTo => array(
			[maximum depth reached]
		)
		hasMany => array(
			[maximum depth reached]
		)
		recursive => (int) -1
		actsAs => array(
			[maximum depth reached]
		)
		useDbConfig => 'default'
		useTable => 'departements'
		id => false
		data => array([maximum depth reached])
		schemaName => 'lepetitbz331'
		table => 'departements'
		primaryKey => 'id'
		validate => array([maximum depth reached])
		validationErrors => array([maximum depth reached])
		validationDomain => null
		tablePrefix => ''
		plugin => null
		name => 'Departement'
		alias => 'Departement'
		tableToModel => array(
			[maximum depth reached]
		)
		cacheQueries => false
		belongsTo => array([maximum depth reached])
		hasOne => array([maximum depth reached])
		hasAndBelongsToMany => array([maximum depth reached])
		Behaviors => object(BehaviorCollection) {}
		whitelist => array([maximum depth reached])
		cacheSources => true
		findQueryType => null
		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
	}
	Etablissement => object(Etablissement) {
		actsAs => array(
			[maximum depth reached]
		)
		belongsTo => array(
			[maximum depth reached]
		)
		hasMany => array(
			[maximum depth reached]
		)
		recursive => (int) -1
		useDbConfig => 'default'
		useTable => 'etablissements'
		id => false
		data => array([maximum depth reached])
		schemaName => 'lepetitbz331'
		table => 'etablissements'
		primaryKey => 'id'
		validate => array([maximum depth reached])
		validationErrors => array([maximum depth reached])
		validationDomain => null
		tablePrefix => ''
		plugin => null
		name => 'Etablissement'
		alias => 'Etablissement'
		tableToModel => array(
			[maximum depth reached]
		)
		cacheQueries => false
		hasOne => array([maximum depth reached])
		hasAndBelongsToMany => array([maximum depth reached])
		Behaviors => object(BehaviorCollection) {}
		whitelist => array([maximum depth reached])
		cacheSources => true
		findQueryType => null
		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]
		)
		Ville => object(Ville) {}
		Agregat => object(Agregat) {}
		[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
	}
	Ville => object(Ville) {
		belongsTo => array(
			[maximum depth reached]
		)
		hasMany => array(
			[maximum depth reached]
		)
		recursive => (int) -1
		actsAs => array(
			[maximum depth reached]
		)
		useDbConfig => 'default'
		useTable => 'villes'
		id => false
		data => array([maximum depth reached])
		schemaName => 'lepetitbz331'
		table => 'villes'
		primaryKey => 'id'
		validate => array([maximum depth reached])
		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])
		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 => 'villemomble',
	(int) 1 => 'tabac'
)

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 => 'villemomble',
			(int) 1 => 'tabac'
		),
		'ville' => 'villemomble',
		'cat' => 'tabac',
		'isAjax' => false,
		'models' => array(
			'Departement' => array(
				[maximum depth reached]
			),
			'Etablissement' => array(
				[maximum depth reached]
			),
			'Ville' => array(
				[maximum depth reached]
			),
			'Agregat' => array(
				[maximum depth reached]
			)
		)
	)
	data => array()
	query => array()
	url => 'ville/villemomble/tabac'
	base => ''
	webroot => '/'
	here => '/ville/villemomble/tabac'
	[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 => 'Departement',
		(int) 2 => 'Etablissement'
	)
	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/villemomble/tabac'
		base => ''
		webroot => '/'
		here => '/ville/villemomble/tabac'
		[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(
		'username' => null
	)
	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 => 'villemomble',
		(int) 1 => 'tabac'
	)
	scaffold => false
	methods => array(
		(int) 0 => 'index',
		(int) 1 => 'toiture',
		(int) 2 => 'shampouineuse',
		(int) 3 => 'prix',
		(int) 4 => 'poster',
		(int) 5 => 'listing',
		(int) 6 => 'details',
		(int) 7 => 'search',
		(int) 8 => 'admin_index',
		(int) 9 => 'admin_add',
		(int) 10 => 'admin_delete',
		(int) 11 => '_usersUsername',
		(int) 13 => '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])
	}
	Departement => object(Departement) {
		belongTo => array(
			[maximum depth reached]
		)
		hasMany => array(
			[maximum depth reached]
		)
		recursive => (int) -1
		actsAs => array(
			[maximum depth reached]
		)
		useDbConfig => 'default'
		useTable => 'departements'
		id => false
		data => array([maximum depth reached])
		schemaName => 'lepetitbz331'
		table => 'departements'
		primaryKey => 'id'
		validate => array([maximum depth reached])
		validationErrors => array([maximum depth reached])
		validationDomain => null
		tablePrefix => ''
		plugin => null
		name => 'Departement'
		alias => 'Departement'
		tableToModel => array(
			[maximum depth reached]
		)
		cacheQueries => false
		belongsTo => array([maximum depth reached])
		hasOne => array([maximum depth reached])
		hasAndBelongsToMany => array([maximum depth reached])
		Behaviors => object(BehaviorCollection) {}
		whitelist => array([maximum depth reached])
		cacheSources => true
		findQueryType => null
		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
	}
	Etablissement => object(Etablissement) {
		actsAs => array(
			[maximum depth reached]
		)
		belongsTo => array(
			[maximum depth reached]
		)
		hasMany => array(
			[maximum depth reached]
		)
		recursive => (int) -1
		useDbConfig => 'default'
		useTable => 'etablissements'
		id => false
		data => array([maximum depth reached])
		schemaName => 'lepetitbz331'
		table => 'etablissements'
		primaryKey => 'id'
		validate => array([maximum depth reached])
		validationErrors => array([maximum depth reached])
		validationDomain => null
		tablePrefix => ''
		plugin => null
		name => 'Etablissement'
		alias => 'Etablissement'
		tableToModel => array(
			[maximum depth reached]
		)
		cacheQueries => false
		hasOne => array([maximum depth reached])
		hasAndBelongsToMany => array([maximum depth reached])
		Behaviors => object(BehaviorCollection) {}
		whitelist => array([maximum depth reached])
		cacheSources => true
		findQueryType => null
		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]
		)
		Ville => object(Ville) {}
		Agregat => object(Agregat) {}
		[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
	}
	Ville => object(Ville) {
		belongsTo => array(
			[maximum depth reached]
		)
		hasMany => array(
			[maximum depth reached]
		)
		recursive => (int) -1
		actsAs => array(
			[maximum depth reached]
		)
		useDbConfig => 'default'
		useTable => 'villes'
		id => false
		data => array([maximum depth reached])
		schemaName => 'lepetitbz331'
		table => 'villes'
		primaryKey => 'id'
		validate => array([maximum depth reached])
		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])
		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 => 'villemomble',
			(int) 1 => 'tabac'
		),
		'ville' => 'villemomble',
		'cat' => 'tabac',
		'isAjax' => false,
		'models' => array(
			'Departement' => array(
				[maximum depth reached]
			),
			'Etablissement' => array(
				[maximum depth reached]
			),
			'Ville' => array(
				[maximum depth reached]
			),
			'Agregat' => array(
				[maximum depth reached]
			)
		)
	)
	data => array()
	query => array()
	url => 'ville/villemomble/tabac'
	base => ''
	webroot => '/'
	here => '/ville/villemomble/tabac'
	[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 111 → 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 => 'villemomble',
			(int) 1 => 'tabac'
		),
		'ville' => 'villemomble',
		'cat' => 'tabac',
		'isAjax' => false,
		'models' => array(
			'Departement' => array(
				[maximum depth reached]
			),
			'Etablissement' => array(
				[maximum depth reached]
			),
			'Ville' => array(
				[maximum depth reached]
			),
			'Agregat' => array(
				[maximum depth reached]
			)
		)
	)
	data => array()
	query => array()
	url => 'ville/villemomble/tabac'
	base => ''
	webroot => '/'
	here => '/ville/villemomble/tabac'
	[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) 1761296682,
			'path' => '/',
			'domain' => '',
			'secure' => false,
			'httpOnly' => false
		)
	)
}

Database Error

Stack Trace