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 MariaDB server version for the right syntax to use near 'AND `Etablissement`.`ville_id` = LIMIT 7' at line 1

SQL Query: SELECT Etablissement.id, Etablissement.nom,Etablissement.slug,Etablissement.adresse,Etablissement.cpville, `Ville`.`id` FROM `c2_ecolesprivees_db`.`etablissements` AS `Etablissement` LEFT JOIN `c2_ecolesprivees_db`.`villes` AS `Ville` ON (`Etablissement`.`ville_id` = `Ville`.`id`) WHERE `Etablissement`.`agregat_id` = AND `Etablissement`.`ville_id` = 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 458 → PDOStatement->execute(array)

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

array()

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

        $options += array('log' => $this->fullDebug);

        $t = microtime(true);
        $this->_result = $this->_execute($sql, $params);

'SELECT Etablissement.id, Etablissement.nom,Etablissement.slug,Etablissement.adresse,Etablissement.cpville, `Ville`.`id` FROM `c2_ecolesprivees_db`.`etablissements` AS `Etablissement` LEFT JOIN `c2_ecolesprivees_db`.`villes` AS `Ville` ON (`Etablissement`.`ville_id` = `Ville`.`id`)  WHERE  `Etablissement`.`agregat_id` =  AND `Etablissement`.`ville_id` =     LIMIT 7'
array()

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

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

'SELECT Etablissement.id, Etablissement.nom,Etablissement.slug,Etablissement.adresse,Etablissement.cpville, `Ville`.`id` FROM `c2_ecolesprivees_db`.`etablissements` AS `Etablissement` LEFT JOIN `c2_ecolesprivees_db`.`villes` AS `Ville` ON (`Etablissement`.`ville_id` = `Ville`.`id`)  WHERE  `Etablissement`.`agregat_id` =  AND `Etablissement`.`ville_id` =     LIMIT 7'
array()
array()

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

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

        $resultSet = $this->fetchAll($query, $Model->cacheQueries);
        unset($query);

'SELECT Etablissement.id, Etablissement.nom,Etablissement.slug,Etablissement.adresse,Etablissement.cpville, `Ville`.`id` FROM `c2_ecolesprivees_db`.`etablissements` AS `Etablissement` LEFT JOIN `c2_ecolesprivees_db`.`villes` AS `Ville` ON (`Etablissement`.`ville_id` = `Ville`.`id`)  WHERE  `Etablissement`.`agregat_id` =  AND `Etablissement`.`ville_id` =     LIMIT 7'
false

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

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

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 => 'c2_ecolesprivees_db'
	table => 'etablissements'
	primaryKey => 'id'
	validate => array([maximum depth reached])
	validationErrors => array([maximum depth reached])
	validationDomain => null
	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 => 'all'
	order => null
	virtualFields => array([maximum depth reached])
	__backAssociation => array(
		[maximum depth reached]
	)
	__backInnerAssociation => array([maximum depth reached])
	__backOriginalAssociation => array([maximum depth reached])
	__backContainableAssociation => array([maximum depth reached])
	__safeUpdateMode => false
	findMethods => array(
		[maximum depth reached]
	)
	Ville => object(Ville) {}
	Agregat => object(Agregat) {}
	tablePrefix => ''
	[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
}
array(
	'conditions' => ' Etablissement.agregat_id =  AND Etablissement.ville_id = ',
	'fields' => array(
		(int) 0 => 'Etablissement.id, Etablissement.nom,Etablissement.slug,Etablissement.adresse,Etablissement.cpville',
		(int) 1 => 'Ville.id'
	),
	'joins' => array(),
	'limit' => (int) 7,
	'offset' => null,
	'order' => array(
		(int) 0 => null
	),
	'page' => (int) 1,
	'group' => null,
	'callbacks' => true,
	'contain' => array(
		(int) 0 => 'Ville'
	),
	'recursive' => (int) 1
)

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

            return null;
        }

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

'all'
array(
	'conditions' => ' Etablissement.agregat_id =  AND Etablissement.ville_id = ',
	'fields' => array(
		(int) 0 => 'Etablissement.id, Etablissement.nom,Etablissement.slug,Etablissement.adresse,Etablissement.cpville',
		(int) 1 => 'Ville.id'
	),
	'joins' => array(),
	'limit' => (int) 7,
	'offset' => null,
	'order' => array(
		(int) 0 => null
	),
	'page' => (int) 1,
	'group' => null,
	'callbacks' => true,
	'contain' => array(
		(int) 0 => 'Ville'
	),
	'recursive' => (int) 1
)

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

            'conditions'=>' Etablissement.agregat_id = '.$d['data']['Etablissement']['agregat_id'].' AND Etablissement.ville_id = '.$d['data']['Etablissement']['ville_id'],
            'contain'=>array('Ville'),
            'limit'      => 7
            ));

'all'
array(
	'fields' => 'Etablissement.id, Etablissement.nom,Etablissement.slug,Etablissement.adresse,Etablissement.cpville',
	'conditions' => ' Etablissement.agregat_id =  AND Etablissement.ville_id = ',
	'contain' => array(
		(int) 0 => 'Ville'
	),
	'limit' => (int) 7
)

[internal function] → EtablissementsController->view(string, string)

'8845'
'ecole-elementaire-privee-du-sacre-coeur'

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

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

object(EtablissementsController) {
	helpers => array(
		[maximum depth reached]
	)
	components => array(
		[maximum depth reached]
	)
	name => 'Etablissements'
	uses => array(
		[maximum depth reached]
	)
	request => object(CakeRequest) {}
	response => object(CakeResponse) {}
	viewPath => 'Etablissements'
	layoutPath => null
	viewVars => array([maximum depth reached])
	view => 'view'
	layout => 'default'
	autoRender => true
	autoLayout => true
	Components => object(ComponentCollection) {}
	viewClass => 'View'
	View => null
	ext => '.ctp'
	plugin => null
	cacheAction => false
	passedArgs => array(
		[maximum depth reached]
	)
	scaffold => false
	methods => array(
		[maximum depth reached]
	)
	modelClass => 'Etablissement'
	modelKey => 'etablissement'
	validationErrors => null
	AutoLogin => object(AutoLoginComponent) {}
	Auth => object(AuthComponent) {}
	RequestHandler => object(RequestHandlerComponent) {}
	Session => object(SessionComponent) {}
	Img => object(ImgComponent) {}
	Paginator => object(PaginatorComponent) {}
	Pub => object(Pub) {}
	Ville => object(Ville) {}
	Departement => object(Departement) {}
	Comment => object(Comment) {}
	Agregat => object(Agregat) {}
	Lien => object(Lien) {}
	Brevet => object(Brevet) {}
	Etablissement => object(Etablissement) {}
	[protected] _responseClass => 'CakeResponse'
	[protected] _mergeParent => 'AppController'
	[protected] _eventManager => object(CakeEventManager) {}
}
array(
	(int) 0 => '8845',
	(int) 1 => 'ecole-elementaire-privee-du-sacre-coeur'
)

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


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

object(CakeRequest) {
	params => array(
		[maximum depth reached]
	)
	data => array([maximum depth reached])
	query => array([maximum depth reached])
	url => 'fiche/8845-ecole-elementaire-privee-du-sacre-coeur'
	base => ''
	webroot => '/'
	here => '/fiche/8845-ecole-elementaire-privee-du-sacre-coeur'
	[protected] _detectors => array(
		[maximum depth reached]
	)
	[protected] _input => ''
}

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

            ));
        }

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

object(EtablissementsController) {
	helpers => array(
		[maximum depth reached]
	)
	components => array(
		[maximum depth reached]
	)
	name => 'Etablissements'
	uses => array(
		[maximum depth reached]
	)
	request => object(CakeRequest) {}
	response => object(CakeResponse) {}
	viewPath => 'Etablissements'
	layoutPath => null
	viewVars => array([maximum depth reached])
	view => 'view'
	layout => 'default'
	autoRender => true
	autoLayout => true
	Components => object(ComponentCollection) {}
	viewClass => 'View'
	View => null
	ext => '.ctp'
	plugin => null
	cacheAction => false
	passedArgs => array(
		[maximum depth reached]
	)
	scaffold => false
	methods => array(
		[maximum depth reached]
	)
	modelClass => 'Etablissement'
	modelKey => 'etablissement'
	validationErrors => null
	AutoLogin => object(AutoLoginComponent) {}
	Auth => object(AuthComponent) {}
	RequestHandler => object(RequestHandlerComponent) {}
	Session => object(SessionComponent) {}
	Img => object(ImgComponent) {}
	Paginator => object(PaginatorComponent) {}
	Pub => object(Pub) {}
	Ville => object(Ville) {}
	Departement => object(Departement) {}
	Comment => object(Comment) {}
	Agregat => object(Agregat) {}
	Lien => object(Lien) {}
	Brevet => object(Brevet) {}
	Etablissement => object(Etablissement) {}
	[protected] _responseClass => 'CakeResponse'
	[protected] _mergeParent => 'AppController'
	[protected] _eventManager => object(CakeEventManager) {}
}
object(CakeRequest) {
	params => array(
		[maximum depth reached]
	)
	data => array([maximum depth reached])
	query => array([maximum depth reached])
	url => 'fiche/8845-ecole-elementaire-privee-du-sacre-coeur'
	base => ''
	webroot => '/'
	here => '/fiche/8845-ecole-elementaire-privee-du-sacre-coeur'
	[protected] _detectors => array(
		[maximum depth reached]
	)
	[protected] _input => ''
}

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

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

object(CakeRequest) {
	params => array(
		[maximum depth reached]
	)
	data => array([maximum depth reached])
	query => array([maximum depth reached])
	url => 'fiche/8845-ecole-elementaire-privee-du-sacre-coeur'
	base => ''
	webroot => '/'
	here => '/fiche/8845-ecole-elementaire-privee-du-sacre-coeur'
	[protected] _detectors => array(
		[maximum depth reached]
	)
	[protected] _input => ''
}
object(CakeResponse) {
	[protected] _statusCodes => array(
		[maximum depth reached]
	)
	[protected] _mimeTypes => array(
		[maximum depth reached]
	)
	[protected] _protocol => 'HTTP/1.1'
	[protected] _status => (int) 200
	[protected] _contentType => 'text/html'
	[protected] _headers => array([maximum depth reached])
	[protected] _body => null
	[protected] _file => null
	[protected] _fileRange => null
	[protected] _charset => 'UTF-8'
	[protected] _cacheDirectives => array([maximum depth reached])
	[protected] _cookies => array(
		[maximum depth reached]
	)
}

Database Error

Stack Trace