Database Error
Error:
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'GROUP BY `Ville`.`id` HAVING distance <40000 ORDER BY `distance` ASC LIMIT 7' at line 1
SQL Query:
SELECT Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((47.9*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.9*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.26667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance, `Ville`.`id` FROM `c2_1001ecolesprivees_db`.`etablissements` AS `Etablissement` LEFT JOIN `c2_1001ecolesprivees_db`.`villes` AS `Ville` ON (`Etablissement`.`ville_id` = `Ville`.`id`) WHERE `Etablissement`.`id` != 9134 AND `Etablissement`.`agregat_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 458 → PDOStatement->execute(array)
try {
$query = $this->_connection->prepare($sql, $prepareOptions);
$query->setFetchMode(PDO::FETCH_LAZY);
if (!$query->execute($params)) {
$this->_results = $query;
- 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.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((47.9*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.9*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.26667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance, `Ville`.`id` FROM `c2_1001ecolesprivees_db`.`etablissements` AS `Etablissement` LEFT JOIN `c2_1001ecolesprivees_db`.`villes` AS `Ville` ON (`Etablissement`.`ville_id` = `Ville`.`id`) WHERE `Etablissement`.`id` != 9134 AND `Etablissement`.`agregat_id`= GROUP BY `Ville`.`id` HAVING distance <40000 ORDER BY `distance` ASC 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.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((47.9*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.9*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.26667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance, `Ville`.`id` FROM `c2_1001ecolesprivees_db`.`etablissements` AS `Etablissement` LEFT JOIN `c2_1001ecolesprivees_db`.`villes` AS `Ville` ON (`Etablissement`.`ville_id` = `Ville`.`id`) WHERE `Etablissement`.`id` != 9134 AND `Etablissement`.`agregat_id`= GROUP BY `Ville`.`id` HAVING distance <40000 ORDER BY `distance` ASC 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.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((47.9*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.9*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.26667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance, `Ville`.`id` FROM `c2_1001ecolesprivees_db`.`etablissements` AS `Etablissement` LEFT JOIN `c2_1001ecolesprivees_db`.`villes` AS `Ville` ON (`Etablissement`.`ville_id` = `Ville`.`id`) WHERE `Etablissement`.`id` != 9134 AND `Etablissement`.`agregat_id`= GROUP BY `Ville`.`id` HAVING distance <40000 ORDER BY `distance` ASC 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_1001ecolesprivees_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) {}
Plaquette => object(Plaquette) {}
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.id != 9134 AND Etablissement.agregat_id=',
'fields' => array(
(int) 0 => 'Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((47.9*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.9*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.26667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance',
(int) 1 => 'Ville.id'
),
'joins' => array(),
'limit' => (int) 7,
'offset' => null,
'order' => array(
(int) 0 => 'distance'
),
'page' => (int) 1,
'group' => 'Ville.id HAVING distance <40000',
'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.id != 9134 AND Etablissement.agregat_id=',
'fields' => array(
(int) 0 => 'Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((47.9*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.9*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.26667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance',
(int) 1 => 'Ville.id'
),
'joins' => array(),
'limit' => (int) 7,
'offset' => null,
'order' => array(
(int) 0 => 'distance'
),
'page' => (int) 1,
'group' => 'Ville.id HAVING distance <40000',
'callbacks' => true,
'contain' => array(
(int) 0 => 'Ville'
),
'recursive' => (int) 1
)
- APP/Controller/EtablissementsController.php line 113 → Model->find(string, array)
'group' => 'Ville.id HAVING distance <40000',
'order' => 'distance',
'limit' => 7
));
'all'
array(
'fields' => 'Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((47.9*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.9*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.26667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance',
'conditions' => 'Etablissement.id != 9134 AND Etablissement.agregat_id=',
'contain' => array(
(int) 0 => 'Ville'
),
'group' => 'Ville.id HAVING distance <40000',
'order' => 'distance',
'limit' => (int) 7
)
- [internal function] → EtablissementsController->view(string, string)
'9134'
'lycee-prive-institution-champagnat'
- 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) {}
Emploi => object(Emploi) {}
Virtuelle => object(AppModel) {}
Etablissement => object(Etablissement) {}
[protected] _responseClass => 'CakeResponse'
[protected] _mergeParent => 'AppController'
[protected] _eventManager => object(CakeEventManager) {}
}
array(
(int) 0 => '9134',
(int) 1 => 'lycee-prive-institution-champagnat'
)
- 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 => 'etablissement/9134-lycee-prive-institution-champagnat'
base => ''
webroot => '/'
here => '/etablissement/9134-lycee-prive-institution-champagnat'
[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) {}
Emploi => object(Emploi) {}
Virtuelle => object(AppModel) {}
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 => 'etablissement/9134-lycee-prive-institution-champagnat'
base => ''
webroot => '/'
here => '/etablissement/9134-lycee-prive-institution-champagnat'
[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 => 'etablissement/9134-lycee-prive-institution-champagnat'
base => ''
webroot => '/'
here => '/etablissement/9134-lycee-prive-institution-champagnat'
[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]
)
}