Notice (8): Undefined index: Etablissement [APP/Controller/EtablissementsController.php, line 98]Code Context
setlocale (LC_TIME, 'fr_FR.utf8','fra');
$d['dateMAJ'] = strftime('%d %b %Y', strtotime($d['data']['Etablissement']['modified'])) ;
$id = '6106' $joins = array( (int) 0 => array( 'table' => 'academies', 'alias' => 'Academie', 'type' => 'LEFT', 'conditions' => array( (int) 0 => 'Academie.id = Etablissement.codeAcad' ) ) ) $d = array( 'data' => array(), 'emploisCat' => array( (int) 1 => 'Secrétaire', (int) 2 => 'ATSEM', (int) 3 => 'AESH', (int) 5 => 'Professeur des écoles', (int) 4 => 'CPE', (int) 6 => 'Documentaliste', (int) 7 => 'Professeur de Mathématiques', (int) 8 => 'Professeur d'EPS', (int) 9 => 'Professeur d'Anglais', (int) 10 => 'Professeur d'Allemand', (int) 11 => 'Professeur d'Espagnol', (int) 12 => 'Professeur d'Italien', (int) 13 => 'Professeur de Musique', (int) 14 => 'Professeur de Français', (int) 15 => 'Professeur d'Histoire-Géographie', (int) 16 => 'Professeur d'Arts Plastiques', (int) 17 => 'Professeur de SVT', (int) 18 => 'Professeur de Physique-Chimie', (int) 19 => 'Professeur d'Informatique - Technologie', (int) 20 => 'Autre Professeur (préciser)', (int) 21 => 'AVS', (int) 22 => 'Assistante d'éducation', (int) 23 => 'Directeur', (int) 24 => 'Comptable', (int) 25 => 'Autre métier (préciser)' ) )EtablissementsController::view() - APP/Controller/EtablissementsController.php, line 98 ReflectionMethod::invokeArgs() - [internal], line ?? Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 490 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 191 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 165 [main] - APP/webroot/index.php, line 112
Notice (8): Undefined index: Ville [APP/Controller/EtablissementsController.php, line 101]Code Context
$lat = $d['data']['Ville']['lat'];
$id = '6106' $joins = array( (int) 0 => array( 'table' => 'academies', 'alias' => 'Academie', 'type' => 'LEFT', 'conditions' => array( (int) 0 => 'Academie.id = Etablissement.codeAcad' ) ) ) $d = array( 'data' => array(), 'emploisCat' => array( (int) 1 => 'Secrétaire', (int) 2 => 'ATSEM', (int) 3 => 'AESH', (int) 5 => 'Professeur des écoles', (int) 4 => 'CPE', (int) 6 => 'Documentaliste', (int) 7 => 'Professeur de Mathématiques', (int) 8 => 'Professeur d'EPS', (int) 9 => 'Professeur d'Anglais', (int) 10 => 'Professeur d'Allemand', (int) 11 => 'Professeur d'Espagnol', (int) 12 => 'Professeur d'Italien', (int) 13 => 'Professeur de Musique', (int) 14 => 'Professeur de Français', (int) 15 => 'Professeur d'Histoire-Géographie', (int) 16 => 'Professeur d'Arts Plastiques', (int) 17 => 'Professeur de SVT', (int) 18 => 'Professeur de Physique-Chimie', (int) 19 => 'Professeur d'Informatique - Technologie', (int) 20 => 'Autre Professeur (préciser)', (int) 21 => 'AVS', (int) 22 => 'Assistante d'éducation', (int) 23 => 'Directeur', (int) 24 => 'Comptable', (int) 25 => 'Autre métier (préciser)' ), 'dateMAJ' => '01 janv. 1970' )EtablissementsController::view() - APP/Controller/EtablissementsController.php, line 101 ReflectionMethod::invokeArgs() - [internal], line ?? Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 490 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 191 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 165 [main] - APP/webroot/index.php, line 112
Notice (8): Undefined index: Ville [APP/Controller/EtablissementsController.php, line 102]Code Context
$lat = $d['data']['Ville']['lat'];
$lng = $d['data']['Ville']['lng'];
$id = '6106' $joins = array( (int) 0 => array( 'table' => 'academies', 'alias' => 'Academie', 'type' => 'LEFT', 'conditions' => array( (int) 0 => 'Academie.id = Etablissement.codeAcad' ) ) ) $d = array( 'data' => array(), 'emploisCat' => array( (int) 1 => 'Secrétaire', (int) 2 => 'ATSEM', (int) 3 => 'AESH', (int) 5 => 'Professeur des écoles', (int) 4 => 'CPE', (int) 6 => 'Documentaliste', (int) 7 => 'Professeur de Mathématiques', (int) 8 => 'Professeur d'EPS', (int) 9 => 'Professeur d'Anglais', (int) 10 => 'Professeur d'Allemand', (int) 11 => 'Professeur d'Espagnol', (int) 12 => 'Professeur d'Italien', (int) 13 => 'Professeur de Musique', (int) 14 => 'Professeur de Français', (int) 15 => 'Professeur d'Histoire-Géographie', (int) 16 => 'Professeur d'Arts Plastiques', (int) 17 => 'Professeur de SVT', (int) 18 => 'Professeur de Physique-Chimie', (int) 19 => 'Professeur d'Informatique - Technologie', (int) 20 => 'Autre Professeur (préciser)', (int) 21 => 'AVS', (int) 22 => 'Assistante d'éducation', (int) 23 => 'Directeur', (int) 24 => 'Comptable', (int) 25 => 'Autre métier (préciser)' ), 'dateMAJ' => '01 janv. 1970' ) $lat = nullEtablissementsController::view() - APP/Controller/EtablissementsController.php, line 102 ReflectionMethod::invokeArgs() - [internal], line ?? Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 490 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 191 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 165 [main] - APP/webroot/index.php, line 112
Notice (8): Undefined index: Etablissement [APP/Controller/EtablissementsController.php, line 108]Code Context$d['idem'] = $this->Etablissement->find('all', array(
'fields' => 'Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img,Ville.id,Ville.nom,Ville.lat,Ville.lng,'.$sql_distance,
'conditions' => 'Etablissement.id != '.$id.' AND '. 'Etablissement.agregat_id='.$d['data']['Etablissement']['agregat_id'],
$id = '6106' $joins = array( (int) 0 => array( 'table' => 'academies', 'alias' => 'Academie', 'type' => 'LEFT', 'conditions' => array( (int) 0 => 'Academie.id = Etablissement.codeAcad' ) ) ) $d = array( 'data' => array(), 'emploisCat' => array( (int) 1 => 'Secrétaire', (int) 2 => 'ATSEM', (int) 3 => 'AESH', (int) 5 => 'Professeur des écoles', (int) 4 => 'CPE', (int) 6 => 'Documentaliste', (int) 7 => 'Professeur de Mathématiques', (int) 8 => 'Professeur d'EPS', (int) 9 => 'Professeur d'Anglais', (int) 10 => 'Professeur d'Allemand', (int) 11 => 'Professeur d'Espagnol', (int) 12 => 'Professeur d'Italien', (int) 13 => 'Professeur de Musique', (int) 14 => 'Professeur de Français', (int) 15 => 'Professeur d'Histoire-Géographie', (int) 16 => 'Professeur d'Arts Plastiques', (int) 17 => 'Professeur de SVT', (int) 18 => 'Professeur de Physique-Chimie', (int) 19 => 'Professeur d'Informatique - Technologie', (int) 20 => 'Autre Professeur (préciser)', (int) 21 => 'AVS', (int) 22 => 'Assistante d'éducation', (int) 23 => 'Directeur', (int) 24 => 'Comptable', (int) 25 => 'Autre métier (préciser)' ), 'dateMAJ' => '01 janv. 1970' ) $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'EtablissementsController::view() - APP/Controller/EtablissementsController.php, line 108 ReflectionMethod::invokeArgs() - [internal], line ?? Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 490 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 191 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 165 [main] - APP/webroot/index.php, line 112
Warning (2): Cannot modify header information - headers already sent by (output started at /var/www/clients/client2/web21/web/lib/Cake/Utility/Debugger.php:801) [CORE/Cake/Network/CakeResponse.php, line 448]Code Context$name, $c['value'], $c['expire'], $c['path'],
$c['domain'], $c['secure'], $c['httpOnly']
);
$name = 'CakeCookie[autologin]' $c = array( 'name' => 'CakeCookie[autologin]', 'value' => '', 'expire' => (int) 1711683853, 'path' => '/', 'domain' => '', 'secure' => false, 'httpOnly' => false )setcookie - [internal], line ?? CakeResponse::_setCookies() - CORE/Cake/Network/CakeResponse.php, line 448 CakeResponse::send() - CORE/Cake/Network/CakeResponse.php, line 418 ExceptionRenderer::_outputMessage() - CORE/Cake/Error/ExceptionRenderer.php, line 280 ExceptionRenderer::pdoError() - CORE/Cake/Error/ExceptionRenderer.php, line 267 ExceptionRenderer::render() - CORE/Cake/Error/ExceptionRenderer.php, line 176 ErrorHandler::handleException() - CORE/Cake/Error/ErrorHandler.php, line 119 [main] - [internal], line ??
Error: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '*pi()/180)) * sin((Ville.lat*pi()/180))+cos((*pi()/180)) * cos((Ville.lat*pi()/1' at line 1
SQL Query: SELECT Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img,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, `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` != 6106 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
try {
$query = $this->_connection->prepare($sql, $prepareOptions);
$query->setFetchMode(PDO::FETCH_LAZY);
if (!$query->execute($params)) {
$this->_results = $query;
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((*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, `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` != 6106 AND `Etablissement`.`agregat_id`= GROUP BY `Ville`.`id` HAVING distance <40000 ORDER BY `distance` ASC LIMIT 7' 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((*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, `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` != 6106 AND `Etablissement`.`agregat_id`= GROUP BY `Ville`.`id` HAVING distance <40000 ORDER BY `distance` ASC LIMIT 7' array() 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 Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img,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, `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` != 6106 AND `Etablissement`.`agregat_id`= GROUP BY `Ville`.`id` HAVING distance <40000 ORDER BY `distance` ASC LIMIT 7' false
* @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 != 6106 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((*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', (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 )
return null;
}
return $this->_readDataSource($type, $query);
}
'all' array( 'conditions' => 'Etablissement.id != 6106 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((*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', (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 )
'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((*pi()/180)) * sin((Ville.lat*pi()/180))+cos((*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance', 'conditions' => 'Etablissement.id != 6106 AND Etablissement.agregat_id=', 'contain' => array( (int) 0 => 'Ville' ), 'group' => 'Ville.id HAVING distance <40000', 'order' => 'distance', 'limit' => (int) 7 )
'6106' 'lycee-professionnel-horticole-camille-godard'
'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 => '6106', (int) 1 => 'lycee-professionnel-horticole-camille-godard' )
$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/6106-lycee-professionnel-horticole-camille-godard' base => '' webroot => '/' here => '/etablissement/6106-lycee-professionnel-horticole-camille-godard' [protected] _detectors => array( [maximum depth reached] ) [protected] _input => '' }
));
}
$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/6106-lycee-professionnel-horticole-camille-godard' base => '' webroot => '/' here => '/etablissement/6106-lycee-professionnel-horticole-camille-godard' [protected] _detectors => array( [maximum depth reached] ) [protected] _input => '' }
$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/6106-lycee-professionnel-horticole-camille-godard' base => '' webroot => '/' here => '/etablissement/6106-lycee-professionnel-horticole-camille-godard' [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] ) }