Notice (8): Undefined index: Etablissement [APP/Controller/EtablissementsController.php, line 372]Code Context
if ($d['data']['Etablissement']['agregat_id'] == 9):
$id = '82687'
$d = array(
'data' => array(),
'visite' => array(),
'comments' => array(),
'noteMoyenne' => array(
(int) 0 => array(
(int) 0 => array(
[maximum depth reached]
)
)
),
'emploisCat' => array(
(int) 1 => 'Aide-Soignant(e)',
(int) 2 => 'Aide médico-psychologique',
(int) 3 => 'Agent des services hospitaliers',
(int) 4 => 'Infirmier - Infirmière',
(int) 5 => 'Médecin coordonnateur',
(int) 6 => 'Infirmier/ère coordinateur/trice (IDEC)',
(int) 7 => 'Ergothérapeute',
(int) 8 => 'Animateur - Animatrice',
(int) 9 => 'Kinésithérapeute',
(int) 10 => 'Psychologue',
(int) 11 => 'Diététicien(ne)',
(int) 12 => 'Assistant(e) de Soins en Gérontologie',
(int) 13 => 'Cuisinier - Cuisinière',
(int) 14 => 'Secrétaire',
(int) 15 => 'Médecin',
(int) 16 => 'Pharmacien(ne)',
(int) 17 => 'Auxiliaire de vie',
(int) 18 => 'Chef de service',
(int) 19 => 'Psychiatre',
(int) 20 => 'Surveillant(e) de nuit',
(int) 21 => 'Éducateur - Éducatrice spécialisé(e)',
(int) 22 => 'Apprenti aide-soignant(e)'
)
)
EtablissementsController::view() - APP/Controller/EtablissementsController.php, line 372
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 382]Code Context
setlocale (LC_TIME, 'fr_FR.utf8','fra');
$d['dateMAJ'] = strftime('%d %b %Y', strtotime($d['data']['Etablissement']['modified'])) ;
$id = '82687'
$d = array(
'data' => array(),
'visite' => array(),
'comments' => array(),
'noteMoyenne' => array(
(int) 0 => array(
(int) 0 => array(
[maximum depth reached]
)
)
),
'emploisCat' => array(
(int) 1 => 'Aide-Soignant(e)',
(int) 2 => 'Aide médico-psychologique',
(int) 3 => 'Agent des services hospitaliers',
(int) 4 => 'Infirmier - Infirmière',
(int) 5 => 'Médecin coordonnateur',
(int) 6 => 'Infirmier/ère coordinateur/trice (IDEC)',
(int) 7 => 'Ergothérapeute',
(int) 8 => 'Animateur - Animatrice',
(int) 9 => 'Kinésithérapeute',
(int) 10 => 'Psychologue',
(int) 11 => 'Diététicien(ne)',
(int) 12 => 'Assistant(e) de Soins en Gérontologie',
(int) 13 => 'Cuisinier - Cuisinière',
(int) 14 => 'Secrétaire',
(int) 15 => 'Médecin',
(int) 16 => 'Pharmacien(ne)',
(int) 17 => 'Auxiliaire de vie',
(int) 18 => 'Chef de service',
(int) 19 => 'Psychiatre',
(int) 20 => 'Surveillant(e) de nuit',
(int) 21 => 'Éducateur - Éducatrice spécialisé(e)',
(int) 22 => 'Apprenti aide-soignant(e)'
)
)
EtablissementsController::view() - APP/Controller/EtablissementsController.php, line 382
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 385]Code Context
$lat = $d['data']['Ville']['lat'];
$id = '82687'
$d = array(
'data' => array(),
'visite' => array(),
'comments' => array(),
'noteMoyenne' => array(
(int) 0 => array(
(int) 0 => array(
[maximum depth reached]
)
)
),
'emploisCat' => array(
(int) 1 => 'Aide-Soignant(e)',
(int) 2 => 'Aide médico-psychologique',
(int) 3 => 'Agent des services hospitaliers',
(int) 4 => 'Infirmier - Infirmière',
(int) 5 => 'Médecin coordonnateur',
(int) 6 => 'Infirmier/ère coordinateur/trice (IDEC)',
(int) 7 => 'Ergothérapeute',
(int) 8 => 'Animateur - Animatrice',
(int) 9 => 'Kinésithérapeute',
(int) 10 => 'Psychologue',
(int) 11 => 'Diététicien(ne)',
(int) 12 => 'Assistant(e) de Soins en Gérontologie',
(int) 13 => 'Cuisinier - Cuisinière',
(int) 14 => 'Secrétaire',
(int) 15 => 'Médecin',
(int) 16 => 'Pharmacien(ne)',
(int) 17 => 'Auxiliaire de vie',
(int) 18 => 'Chef de service',
(int) 19 => 'Psychiatre',
(int) 20 => 'Surveillant(e) de nuit',
(int) 21 => 'Éducateur - Éducatrice spécialisé(e)',
(int) 22 => 'Apprenti aide-soignant(e)'
),
'dateMAJ' => '01 janv. 1970'
)
EtablissementsController::view() - APP/Controller/EtablissementsController.php, line 385
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 386]Code Context
$lat = $d['data']['Ville']['lat'];
$lng = $d['data']['Ville']['lng'];
$id = '82687'
$d = array(
'data' => array(),
'visite' => array(),
'comments' => array(),
'noteMoyenne' => array(
(int) 0 => array(
(int) 0 => array(
[maximum depth reached]
)
)
),
'emploisCat' => array(
(int) 1 => 'Aide-Soignant(e)',
(int) 2 => 'Aide médico-psychologique',
(int) 3 => 'Agent des services hospitaliers',
(int) 4 => 'Infirmier - Infirmière',
(int) 5 => 'Médecin coordonnateur',
(int) 6 => 'Infirmier/ère coordinateur/trice (IDEC)',
(int) 7 => 'Ergothérapeute',
(int) 8 => 'Animateur - Animatrice',
(int) 9 => 'Kinésithérapeute',
(int) 10 => 'Psychologue',
(int) 11 => 'Diététicien(ne)',
(int) 12 => 'Assistant(e) de Soins en Gérontologie',
(int) 13 => 'Cuisinier - Cuisinière',
(int) 14 => 'Secrétaire',
(int) 15 => 'Médecin',
(int) 16 => 'Pharmacien(ne)',
(int) 17 => 'Auxiliaire de vie',
(int) 18 => 'Chef de service',
(int) 19 => 'Psychiatre',
(int) 20 => 'Surveillant(e) de nuit',
(int) 21 => 'Éducateur - Éducatrice spécialisé(e)',
(int) 22 => 'Apprenti aide-soignant(e)'
),
'dateMAJ' => '01 janv. 1970'
)
$lat = null
EtablissementsController::view() - APP/Controller/EtablissementsController.php, line 386
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 392]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 = '82687'
$d = array(
'data' => array(),
'visite' => array(),
'comments' => array(),
'noteMoyenne' => array(
(int) 0 => array(
(int) 0 => array(
[maximum depth reached]
)
)
),
'emploisCat' => array(
(int) 1 => 'Aide-Soignant(e)',
(int) 2 => 'Aide médico-psychologique',
(int) 3 => 'Agent des services hospitaliers',
(int) 4 => 'Infirmier - Infirmière',
(int) 5 => 'Médecin coordonnateur',
(int) 6 => 'Infirmier/ère coordinateur/trice (IDEC)',
(int) 7 => 'Ergothérapeute',
(int) 8 => 'Animateur - Animatrice',
(int) 9 => 'Kinésithérapeute',
(int) 10 => 'Psychologue',
(int) 11 => 'Diététicien(ne)',
(int) 12 => 'Assistant(e) de Soins en Gérontologie',
(int) 13 => 'Cuisinier - Cuisinière',
(int) 14 => 'Secrétaire',
(int) 15 => 'Médecin',
(int) 16 => 'Pharmacien(ne)',
(int) 17 => 'Auxiliaire de vie',
(int) 18 => 'Chef de service',
(int) 19 => 'Psychiatre',
(int) 20 => 'Surveillant(e) de nuit',
(int) 21 => 'Éducateur - Éducatrice spécialisé(e)',
(int) 22 => 'Apprenti aide-soignant(e)'
),
'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 392
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/web13/web/lib/Cake/Utility/Debugger.php:801) [APP/View/Layouts/default.ctp, line 9]Code Context if ("https://www.santeenfrance.fr".$urlActuelle != $this->fetch('urlcanonique')) {
header("Status: 301 Moved Permanently", false, 301);
$viewFile = '/var/www/clients/client2/web13/web/app/View/Layouts/default.ctp'
$dataForView = array(
'code' => (int) 500,
'name' => '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',
'message' => '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',
'url' => '/etablissement/82687-maison-retraite-hopital-local-lamarche',
'error' => object(PDOException) {
errorInfo => array(
[maximum depth reached]
)
queryString => '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_sef_db`.`etablissements` AS `Etablissement` LEFT JOIN `c2_sef_db`.`villes` AS `Ville` ON (`Etablissement`.`ville_id` = `Ville`.`id`) WHERE `Etablissement`.`id` != 82687 AND `Etablissement`.`agregat_id`= ORDER BY `distance` ASC LIMIT 5'
[protected] message => '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'
[protected] code => '42000'
[protected] file => '/var/www/clients/client2/web13/web/lib/Cake/Model/Datasource/DboSource.php'
[protected] line => (int) 458
},
'_serialize' => array(
(int) 0 => 'code',
(int) 1 => 'name',
(int) 2 => 'message',
(int) 3 => 'url',
(int) 4 => 'error'
),
'content_for_layout' => '<h2>Database Error</h2>
<p class="error">
<strong>Error: </strong>
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</p>
<p class="notice">
<strong>SQL Query: </strong>
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_sef_db`.`etablissements` AS `Etablissement` LEFT JOIN `c2_sef_db`.`villes` AS `Ville` ON (`Etablissement`.`ville_id` = `Ville`.`id`) WHERE `Etablissement`.`id` != 82687 AND `Etablissement`.`agregat_id`= ORDER BY `distance` ASC LIMIT 5 </p>
<p class="notice">
<strong>Notice: </strong>
If you want to customize this error message, create app/View/Errors/pdo_error.ctp</p>
<h3>Stack Trace</h3>
<ul class="cake-stack-trace">
<li><a href="#" onclick="traceToggle(event, 'file-excerpt-0')">CORE/Cake/Model/Datasource/DboSource.php line 458</a> → <a href="#" onclick="traceToggle(event, 'trace-args-0')">PDOStatement->execute(array)</a> <div id="file-excerpt-0" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">try {</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> $query </span><span style="color: #007700">= </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">_connection</span><span style="color: #007700">-></span><span style="color: #0000BB">prepare</span><span style="color: #007700">(</span><span style="color: #0000BB">$sql</span><span style="color: #007700">, </span><span style="color: #0000BB">$prepareOptions</span><span style="color: #007700">);</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> $query</span><span style="color: #007700">-></span><span style="color: #0000BB">setFetchMode</span><span style="color: #007700">(</span><span style="color: #0000BB">PDO</span><span style="color: #007700">::</span><span style="color: #0000BB">FETCH_LAZY</span><span style="color: #007700">);</span></span></code>
<span class="code-highlight"><code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">if (!</span><span style="color: #0000BB">$query</span><span style="color: #007700">-></span><span style="color: #0000BB">execute</span><span style="color: #007700">(</span><span style="color: #0000BB">$params</span><span style="color: #007700">)) {</span></span></code></span>
<code><span style="color: #000000"><span style="color: #0000BB"> $this</span><span style="color: #007700">-></span><span style="color: #0000BB">_results </span><span style="color: #007700">= </span><span style="color: #0000BB">$query</span><span style="color: #007700">;</span></span></code></pre></div> <div id="trace-args-0" class="cake-code-dump" style="display: none;"><pre>array()</pre></div></li>
<li><a href="#" onclick="traceToggle(event, 'file-excerpt-1')">CORE/Cake/Model/Datasource/DboSource.php line 424</a> → <a href="#" onclick="traceToggle(event, 'trace-args-1')">DboSource->_execute(string, array)</a> <div id="file-excerpt-1" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB"> $options </span><span style="color: #007700">+= array(</span><span style="color: #DD0000">'log' </span><span style="color: #007700">=> </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">fullDebug</span><span style="color: #007700">);</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"></span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> $t </span><span style="color: #007700">= </span><span style="color: #0000BB">microtime</span><span style="color: #007700">(</span><span style="color: #0000BB">true</span><span style="color: #007700">);</span></span></code>
<span class="code-highlight"><code><span style="color: #000000"><span style="color: #0000BB"> $this</span><span style="color: #007700">-></span><span style="color: #0000BB">_result </span><span style="color: #007700">= </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">_execute</span><span style="color: #007700">(</span><span style="color: #0000BB">$sql</span><span style="color: #007700">, </span><span style="color: #0000BB">$params</span><span style="color: #007700">);</span></span></code></span>
<code><span style="color: #000000"><span style="color: #0000BB"></span></span></code></pre></div> <div id="trace-args-1" class="cake-code-dump" style="display: none;"><pre>'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_sef_db`.`etablissements` AS `Etablissement` LEFT JOIN `c2_sef_db`.`villes` AS `Ville` ON (`Etablissement`.`ville_id` = `Ville`.`id`) WHERE `Etablissement`.`id` != 82687 AND `Etablissement`.`agregat_id`= ORDER BY `distance` ASC LIMIT 5'
array()</pre></div></li>
<li><a href="#" onclick="traceToggle(event, 'file-excerpt-2')">CORE/Cake/Model/Datasource/DboSource.php line 666</a> → <a href="#" onclick="traceToggle(event, 'trace-args-2')">DboSource->execute(string, array, array)</a> <div id="file-excerpt-2" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">if (</span><span style="color: #0000BB">$cache </span><span style="color: #007700">&& (</span><span style="color: #0000BB">$cached </span><span style="color: #007700">= </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">getQueryCache</span><span style="color: #007700">(</span><span style="color: #0000BB">$sql</span><span style="color: #007700">, </span><span style="color: #0000BB">$params</span><span style="color: #007700">)) !== </span><span style="color: #0000BB">false</span><span style="color: #007700">) {</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">return </span><span style="color: #0000BB">$cached</span><span style="color: #007700">;</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">}</span></span></code>
<span class="code-highlight"><code><span style="color: #000000"><span style="color: #0000BB"> $result </span><span style="color: #007700">= </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">execute</span><span style="color: #007700">(</span><span style="color: #0000BB">$sql</span><span style="color: #007700">, array(), </span><span style="color: #0000BB">$params</span><span style="color: #007700">);</span></span></code></span>
<code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">if (</span><span style="color: #0000BB">$result</span><span style="color: #007700">) {</span></span></code></pre></div> <div id="trace-args-2" class="cake-code-dump" style="display: none;"><pre>'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_sef_db`.`etablissements` AS `Etablissement` LEFT JOIN `c2_sef_db`.`villes` AS `Ville` ON (`Etablissement`.`ville_id` = `Ville`.`id`) WHERE `Etablissement`.`id` != 82687 AND `Etablissement`.`agregat_id`= ORDER BY `distance` ASC LIMIT 5'
array()
array()</pre></div></li>
<li><a href="#" onclick="traceToggle(event, 'file-excerpt-3')">CORE/Cake/Model/Datasource/DboSource.php line 1106</a> → <a href="#" onclick="traceToggle(event, 'trace-args-3')">DboSource->fetchAll(string, boolean)</a> <div id="file-excerpt-3" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #FF8000">// Build SQL statement with the primary model, plus hasOne and belongsTo associations</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> $query </span><span style="color: #007700">= </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">buildAssociationQuery</span><span style="color: #007700">(</span><span style="color: #0000BB">$Model</span><span style="color: #007700">, </span><span style="color: #0000BB">$queryData</span><span style="color: #007700">);</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"></span></span></code>
<span class="code-highlight"><code><span style="color: #000000"><span style="color: #0000BB"> $resultSet </span><span style="color: #007700">= </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">fetchAll</span><span style="color: #007700">(</span><span style="color: #0000BB">$query</span><span style="color: #007700">, </span><span style="color: #0000BB">$Model</span><span style="color: #007700">-></span><span style="color: #0000BB">cacheQueries</span><span style="color: #007700">);</span></span></code></span>
<code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">unset(</span><span style="color: #0000BB">$query</span><span style="color: #007700">);</span></span></code></pre></div> <div id="trace-args-3" class="cake-code-dump" style="display: none;"><pre>'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_sef_db`.`etablissements` AS `Etablissement` LEFT JOIN `c2_sef_db`.`villes` AS `Ville` ON (`Etablissement`.`ville_id` = `Ville`.`id`) WHERE `Etablissement`.`id` != 82687 AND `Etablissement`.`agregat_id`= ORDER BY `distance` ASC LIMIT 5'
false</pre></div></li>
<li><a href="#" onclick="traceToggle(event, 'file-excerpt-4')">CORE/Cake/Model/Model.php line 2947</a> → <a href="#" onclick="traceToggle(event, 'trace-args-4')">DboSource->read(Etablissement, array)</a> <div id="file-excerpt-4" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">* @return array</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">*/</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">protected function </span><span style="color: #0000BB">_readDataSource</span><span style="color: #007700">(</span><span style="color: #0000BB">$type</span><span style="color: #007700">, </span><span style="color: #0000BB">$query</span><span style="color: #007700">) {</span></span></code>
<span class="code-highlight"><code><span style="color: #000000"><span style="color: #0000BB"> $results </span><span style="color: #007700">= </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">getDataSource</span><span style="color: #007700">()-></span><span style="color: #0000BB">read</span><span style="color: #007700">(</span><span style="color: #0000BB">$this</span><span style="color: #007700">, </span><span style="color: #0000BB">$query</span><span style="color: #007700">);</span></span></code></span>
<code><span style="color: #000000"><span style="color: #0000BB"> $this</span><span style="color: #007700">-></span><span style="color: #0000BB">resetAssociations</span><span style="color: #007700">();</span></span></code></pre></div> <div id="trace-args-4" class="cake-code-dump" style="display: none;"><pre>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_sef_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 != 82687 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) 5,
'offset' => null,
'order' => array(
(int) 0 => 'distance'
),
'page' => (int) 1,
'group' => null,
'callbacks' => true,
'contain' => array(
(int) 0 => 'Ville'
),
'recursive' => (int) 1
)</pre></div></li>
<li><a href="#" onclick="traceToggle(event, 'file-excerpt-5')">CORE/Cake/Model/Model.php line 2919</a> → <a href="#" onclick="traceToggle(event, 'trace-args-5')">Model->_readDataSource(string, array)</a> <div id="file-excerpt-5" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">return </span><span style="color: #0000BB">null</span><span style="color: #007700">;</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">}</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"></span></span></code>
<span class="code-highlight"><code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">return </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">_readDataSource</span><span style="color: #007700">(</span><span style="color: #0000BB">$type</span><span style="color: #007700">, </span><span style="color: #0000BB">$query</span><span style="color: #007700">);</span></span></code></span>
<code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">}</span></span></code></pre></div> <div id="trace-args-5" class="cake-code-dump" style="display: none;"><pre>'all'
array(
'conditions' => 'Etablissement.id != 82687 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) 5,
'offset' => null,
'order' => array(
(int) 0 => 'distance'
),
'page' => (int) 1,
'group' => null,
'callbacks' => true,
'contain' => array(
(int) 0 => 'Ville'
),
'recursive' => (int) 1
)</pre></div></li>
<li><a href="#" onclick="traceToggle(event, 'file-excerpt-6')">APP/Controller/EtablissementsController.php line 397</a> → <a href="#" onclick="traceToggle(event, 'trace-args-6')">Model->find(string, array)</a> <div id="file-excerpt-6" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #FF8000">// 'group' => 'Ville.id HAVING distance < 40000',</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #DD0000">'order' </span><span style="color: #007700">=> </span><span style="color: #DD0000">'distance'</span><span style="color: #007700">,</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #DD0000">'limit' </span><span style="color: #007700">=> </span><span style="color: #0000BB">5</span></span></code>
<span class="code-highlight"><code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">));</span></span></code></span>
<code><span style="color: #000000"><span style="color: #0000BB"> </span></span></code></pre></div> <div id="trace-args-6" class="cake-code-dump" style="display: none;"><pre>'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 != 82687 AND Etablissement.agregat_id=',
'contain' => array(
(int) 0 => 'Ville'
),
'order' => 'distance',
'limit' => (int) 5
)</pre></div></li>
<li><a href="#">[internal function]</a> → <a href="#" onclick="traceToggle(event, 'trace-args-7')">EtablissementsController->view(string, string)</a> <div id="trace-args-7" class="cake-code-dump" style="display: none;"><pre>'82687'
'maison-retraite-hopital-local-lamarche'</pre></div></li>
<li><a href="#" onclick="traceToggle(event, 'file-excerpt-8')">CORE/Cake/Controller/Controller.php line 490</a> → <a href="#" onclick="traceToggle(event, 'trace-args-8')">ReflectionMethod->invokeArgs(EtablissementsController, array)</a> <div id="file-excerpt-8" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #DD0000">'action' </span><span style="color: #007700">=> </span><span style="color: #0000BB">$request</span><span style="color: #007700">-></span><span style="color: #0000BB">params</span><span style="color: #007700">[</span><span style="color: #DD0000">'action'</span><span style="color: #007700">]</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">));</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">}</span></span></code>
<span class="code-highlight"><code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">return </span><span style="color: #0000BB">$method</span><span style="color: #007700">-></span><span style="color: #0000BB">invokeArgs</span><span style="color: #007700">(</span><span style="color: #0000BB">$this</span><span style="color: #007700">, </span><span style="color: #0000BB">$request</span><span style="color: #007700">-></span><span style="color: #0000BB">params</span><span style="color: #007700">[</span><span style="color: #DD0000">'pass'</span><span style="color: #007700">]);</span></span></code></span>
<code><span style="color: #000000"><span style="color: #0000BB"></span></span></code></pre></div> <div id="trace-args-8" class="cake-code-dump" style="display: none;"><pre>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) {}
Etablissement => object(Etablissement) {}
Virtuelle => object(AppModel) {}
[protected] _responseClass => 'CakeResponse'
[protected] _mergeParent => 'AppController'
[protected] _eventManager => object(CakeEventManager) {}
}
array(
(int) 0 => '82687',
(int) 1 => 'maison-retraite-hopital-local-lamarche'
)</pre></div></li>
<li><a href="#" onclick="traceToggle(event, 'file-excerpt-9')">CORE/Cake/Routing/Dispatcher.php line 191</a> → <a href="#" onclick="traceToggle(event, 'trace-args-9')">Controller->invokeAction(CakeRequest)</a> <div id="file-excerpt-9" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB"></span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> $response </span><span style="color: #007700">= </span><span style="color: #0000BB">$controller</span><span style="color: #007700">-></span><span style="color: #0000BB">response</span><span style="color: #007700">;</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> $render </span><span style="color: #007700">= </span><span style="color: #0000BB">true</span><span style="color: #007700">;</span></span></code>
<span class="code-highlight"><code><span style="color: #000000"><span style="color: #0000BB"> $result </span><span style="color: #007700">= </span><span style="color: #0000BB">$controller</span><span style="color: #007700">-></span><span style="color: #0000BB">invokeAction</span><span style="color: #007700">(</span><span style="color: #0000BB">$request</span><span style="color: #007700">);</span></span></code></span>
<code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">if (</span><span style="color: #0000BB">$result </span><span style="color: #007700">instanceof </span><span style="color: #0000BB">CakeResponse</span><span style="color: #007700">) {</span></span></code></pre></div> <div id="trace-args-9" class="cake-code-dump" style="display: none;"><pre>object(CakeRequest) {
params => array(
[maximum depth reached]
)
data => array([maximum depth reached])
query => array([maximum depth reached])
url => 'etablissement/82687-maison-retraite-hopital-local-lamarche'
base => ''
webroot => '/'
here => '/etablissement/82687-maison-retraite-hopital-local-lamarche'
[protected] _detectors => array(
[maximum depth reached]
)
[protected] _input => ''
}</pre></div></li>
<li><a href="#" onclick="traceToggle(event, 'file-excerpt-10')">CORE/Cake/Routing/Dispatcher.php line 165</a> → <a href="#" onclick="traceToggle(event, 'trace-args-10')">Dispatcher->_invoke(EtablissementsController, CakeRequest)</a> <div id="file-excerpt-10" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">));</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">}</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"></span></span></code>
<span class="code-highlight"><code><span style="color: #000000"><span style="color: #0000BB"> $response </span><span style="color: #007700">= </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">_invoke</span><span style="color: #007700">(</span><span style="color: #0000BB">$controller</span><span style="color: #007700">, </span><span style="color: #0000BB">$request</span><span style="color: #007700">);</span></span></code></span>
<code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">if (isset(</span><span style="color: #0000BB">$request</span><span style="color: #007700">-></span><span style="color: #0000BB">params</span><span style="color: #007700">[</span><span style="color: #DD0000">'return'</span><span style="color: #007700">])) {</span></span></code></pre></div> <div id="trace-args-10" class="cake-code-dump" style="display: none;"><pre>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) {}
Etablissement => object(Etablissement) {}
Virtuelle => object(AppModel) {}
[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/82687-maison-retraite-hopital-local-lamarche'
base => ''
webroot => '/'
here => '/etablissement/82687-maison-retraite-hopital-local-lamarche'
[protected] _detectors => array(
[maximum depth reached]
)
[protected] _input => ''
}</pre></div></li>
<li><a href="#" onclick="traceToggle(event, 'file-excerpt-11')">APP/webroot/index.php line 112</a> → <a href="#" onclick="traceToggle(event, 'trace-args-11')">Dispatcher->dispatch(CakeRequest, CakeResponse)</a> <div id="file-excerpt-11" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB">$Dispatcher</span><span style="color: #007700">-></span><span style="color: #0000BB">dispatch</span><span style="color: #007700">(</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">new </span><span style="color: #0000BB">CakeRequest</span><span style="color: #007700">(),</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">new </span><span style="color: #0000BB">CakeResponse</span><span style="color: #007700">()</span></span></code>
<span class="code-highlight"><code><span style="color: #000000"><span style="color: #0000BB"></span><span style="color: #007700">);</span></span></code></span>
<code><span style="color: #000000"><span style="color: #0000BB"></span></span></code></pre></div> <div id="trace-args-11" class="cake-code-dump" style="display: none;"><pre>object(CakeRequest) {
params => array(
[maximum depth reached]
)
data => array([maximum depth reached])
query => array([maximum depth reached])
url => 'etablissement/82687-maison-retraite-hopital-local-lamarche'
base => ''
webroot => '/'
here => '/etablissement/82687-maison-retraite-hopital-local-lamarche'
[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]
)
}</pre></div></li>
</ul>
<script type="text/javascript">
function traceToggle(event, id) {
var el = document.getElementById(id);
el.style.display = (el.style.display === 'block') ? 'none' : 'block';
event.preventDefault();
return false;
}
</script>
',
'scripts_for_layout' => '',
'title_for_layout' => 'Errors'
)
$code = (int) 500
$name = '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'
$message = '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'
$url = '/etablissement/82687-maison-retraite-hopital-local-lamarche'
$error = object(PDOException) {
errorInfo => array(
(int) 0 => '42000',
(int) 1 => (int) 1064,
(int) 2 => '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'
)
queryString => '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_sef_db`.`etablissements` AS `Etablissement` LEFT JOIN `c2_sef_db`.`villes` AS `Ville` ON (`Etablissement`.`ville_id` = `Ville`.`id`) WHERE `Etablissement`.`id` != 82687 AND `Etablissement`.`agregat_id`= ORDER BY `distance` ASC LIMIT 5'
[protected] message => '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'
[protected] code => '42000'
[protected] file => '/var/www/clients/client2/web13/web/lib/Cake/Model/Datasource/DboSource.php'
[protected] line => (int) 458
}
$_serialize = array(
(int) 0 => 'code',
(int) 1 => 'name',
(int) 2 => 'message',
(int) 3 => 'url',
(int) 4 => 'error'
)
$content_for_layout = '<h2>Database Error</h2>
<p class="error">
<strong>Error: </strong>
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</p>
<p class="notice">
<strong>SQL Query: </strong>
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_sef_db`.`etablissements` AS `Etablissement` LEFT JOIN `c2_sef_db`.`villes` AS `Ville` ON (`Etablissement`.`ville_id` = `Ville`.`id`) WHERE `Etablissement`.`id` != 82687 AND `Etablissement`.`agregat_id`= ORDER BY `distance` ASC LIMIT 5 </p>
<p class="notice">
<strong>Notice: </strong>
If you want to customize this error message, create app/View/Errors/pdo_error.ctp</p>
<h3>Stack Trace</h3>
<ul class="cake-stack-trace">
<li><a href="#" onclick="traceToggle(event, 'file-excerpt-0')">CORE/Cake/Model/Datasource/DboSource.php line 458</a> → <a href="#" onclick="traceToggle(event, 'trace-args-0')">PDOStatement->execute(array)</a> <div id="file-excerpt-0" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">try {</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> $query </span><span style="color: #007700">= </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">_connection</span><span style="color: #007700">-></span><span style="color: #0000BB">prepare</span><span style="color: #007700">(</span><span style="color: #0000BB">$sql</span><span style="color: #007700">, </span><span style="color: #0000BB">$prepareOptions</span><span style="color: #007700">);</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> $query</span><span style="color: #007700">-></span><span style="color: #0000BB">setFetchMode</span><span style="color: #007700">(</span><span style="color: #0000BB">PDO</span><span style="color: #007700">::</span><span style="color: #0000BB">FETCH_LAZY</span><span style="color: #007700">);</span></span></code>
<span class="code-highlight"><code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">if (!</span><span style="color: #0000BB">$query</span><span style="color: #007700">-></span><span style="color: #0000BB">execute</span><span style="color: #007700">(</span><span style="color: #0000BB">$params</span><span style="color: #007700">)) {</span></span></code></span>
<code><span style="color: #000000"><span style="color: #0000BB"> $this</span><span style="color: #007700">-></span><span style="color: #0000BB">_results </span><span style="color: #007700">= </span><span style="color: #0000BB">$query</span><span style="color: #007700">;</span></span></code></pre></div> <div id="trace-args-0" class="cake-code-dump" style="display: none;"><pre>array()</pre></div></li>
<li><a href="#" onclick="traceToggle(event, 'file-excerpt-1')">CORE/Cake/Model/Datasource/DboSource.php line 424</a> → <a href="#" onclick="traceToggle(event, 'trace-args-1')">DboSource->_execute(string, array)</a> <div id="file-excerpt-1" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB"> $options </span><span style="color: #007700">+= array(</span><span style="color: #DD0000">'log' </span><span style="color: #007700">=> </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">fullDebug</span><span style="color: #007700">);</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"></span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> $t </span><span style="color: #007700">= </span><span style="color: #0000BB">microtime</span><span style="color: #007700">(</span><span style="color: #0000BB">true</span><span style="color: #007700">);</span></span></code>
<span class="code-highlight"><code><span style="color: #000000"><span style="color: #0000BB"> $this</span><span style="color: #007700">-></span><span style="color: #0000BB">_result </span><span style="color: #007700">= </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">_execute</span><span style="color: #007700">(</span><span style="color: #0000BB">$sql</span><span style="color: #007700">, </span><span style="color: #0000BB">$params</span><span style="color: #007700">);</span></span></code></span>
<code><span style="color: #000000"><span style="color: #0000BB"></span></span></code></pre></div> <div id="trace-args-1" class="cake-code-dump" style="display: none;"><pre>'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_sef_db`.`etablissements` AS `Etablissement` LEFT JOIN `c2_sef_db`.`villes` AS `Ville` ON (`Etablissement`.`ville_id` = `Ville`.`id`) WHERE `Etablissement`.`id` != 82687 AND `Etablissement`.`agregat_id`= ORDER BY `distance` ASC LIMIT 5'
array()</pre></div></li>
<li><a href="#" onclick="traceToggle(event, 'file-excerpt-2')">CORE/Cake/Model/Datasource/DboSource.php line 666</a> → <a href="#" onclick="traceToggle(event, 'trace-args-2')">DboSource->execute(string, array, array)</a> <div id="file-excerpt-2" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">if (</span><span style="color: #0000BB">$cache </span><span style="color: #007700">&& (</span><span style="color: #0000BB">$cached </span><span style="color: #007700">= </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">getQueryCache</span><span style="color: #007700">(</span><span style="color: #0000BB">$sql</span><span style="color: #007700">, </span><span style="color: #0000BB">$params</span><span style="color: #007700">)) !== </span><span style="color: #0000BB">false</span><span style="color: #007700">) {</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">return </span><span style="color: #0000BB">$cached</span><span style="color: #007700">;</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">}</span></span></code>
<span class="code-highlight"><code><span style="color: #000000"><span style="color: #0000BB"> $result </span><span style="color: #007700">= </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">execute</span><span style="color: #007700">(</span><span style="color: #0000BB">$sql</span><span style="color: #007700">, array(), </span><span style="color: #0000BB">$params</span><span style="color: #007700">);</span></span></code></span>
<code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">if (</span><span style="color: #0000BB">$result</span><span style="color: #007700">) {</span></span></code></pre></div> <div id="trace-args-2" class="cake-code-dump" style="display: none;"><pre>'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_sef_db`.`etablissements` AS `Etablissement` LEFT JOIN `c2_sef_db`.`villes` AS `Ville` ON (`Etablissement`.`ville_id` = `Ville`.`id`) WHERE `Etablissement`.`id` != 82687 AND `Etablissement`.`agregat_id`= ORDER BY `distance` ASC LIMIT 5'
array()
array()</pre></div></li>
<li><a href="#" onclick="traceToggle(event, 'file-excerpt-3')">CORE/Cake/Model/Datasource/DboSource.php line 1106</a> → <a href="#" onclick="traceToggle(event, 'trace-args-3')">DboSource->fetchAll(string, boolean)</a> <div id="file-excerpt-3" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #FF8000">// Build SQL statement with the primary model, plus hasOne and belongsTo associations</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> $query </span><span style="color: #007700">= </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">buildAssociationQuery</span><span style="color: #007700">(</span><span style="color: #0000BB">$Model</span><span style="color: #007700">, </span><span style="color: #0000BB">$queryData</span><span style="color: #007700">);</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"></span></span></code>
<span class="code-highlight"><code><span style="color: #000000"><span style="color: #0000BB"> $resultSet </span><span style="color: #007700">= </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">fetchAll</span><span style="color: #007700">(</span><span style="color: #0000BB">$query</span><span style="color: #007700">, </span><span style="color: #0000BB">$Model</span><span style="color: #007700">-></span><span style="color: #0000BB">cacheQueries</span><span style="color: #007700">);</span></span></code></span>
<code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">unset(</span><span style="color: #0000BB">$query</span><span style="color: #007700">);</span></span></code></pre></div> <div id="trace-args-3" class="cake-code-dump" style="display: none;"><pre>'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_sef_db`.`etablissements` AS `Etablissement` LEFT JOIN `c2_sef_db`.`villes` AS `Ville` ON (`Etablissement`.`ville_id` = `Ville`.`id`) WHERE `Etablissement`.`id` != 82687 AND `Etablissement`.`agregat_id`= ORDER BY `distance` ASC LIMIT 5'
false</pre></div></li>
<li><a href="#" onclick="traceToggle(event, 'file-excerpt-4')">CORE/Cake/Model/Model.php line 2947</a> → <a href="#" onclick="traceToggle(event, 'trace-args-4')">DboSource->read(Etablissement, array)</a> <div id="file-excerpt-4" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">* @return array</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">*/</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">protected function </span><span style="color: #0000BB">_readDataSource</span><span style="color: #007700">(</span><span style="color: #0000BB">$type</span><span style="color: #007700">, </span><span style="color: #0000BB">$query</span><span style="color: #007700">) {</span></span></code>
<span class="code-highlight"><code><span style="color: #000000"><span style="color: #0000BB"> $results </span><span style="color: #007700">= </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">getDataSource</span><span style="color: #007700">()-></span><span style="color: #0000BB">read</span><span style="color: #007700">(</span><span style="color: #0000BB">$this</span><span style="color: #007700">, </span><span style="color: #0000BB">$query</span><span style="color: #007700">);</span></span></code></span>
<code><span style="color: #000000"><span style="color: #0000BB"> $this</span><span style="color: #007700">-></span><span style="color: #0000BB">resetAssociations</span><span style="color: #007700">();</span></span></code></pre></div> <div id="trace-args-4" class="cake-code-dump" style="display: none;"><pre>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_sef_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 != 82687 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) 5,
'offset' => null,
'order' => array(
(int) 0 => 'distance'
),
'page' => (int) 1,
'group' => null,
'callbacks' => true,
'contain' => array(
(int) 0 => 'Ville'
),
'recursive' => (int) 1
)</pre></div></li>
<li><a href="#" onclick="traceToggle(event, 'file-excerpt-5')">CORE/Cake/Model/Model.php line 2919</a> → <a href="#" onclick="traceToggle(event, 'trace-args-5')">Model->_readDataSource(string, array)</a> <div id="file-excerpt-5" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">return </span><span style="color: #0000BB">null</span><span style="color: #007700">;</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">}</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"></span></span></code>
<span class="code-highlight"><code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">return </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">_readDataSource</span><span style="color: #007700">(</span><span style="color: #0000BB">$type</span><span style="color: #007700">, </span><span style="color: #0000BB">$query</span><span style="color: #007700">);</span></span></code></span>
<code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">}</span></span></code></pre></div> <div id="trace-args-5" class="cake-code-dump" style="display: none;"><pre>'all'
array(
'conditions' => 'Etablissement.id != 82687 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) 5,
'offset' => null,
'order' => array(
(int) 0 => 'distance'
),
'page' => (int) 1,
'group' => null,
'callbacks' => true,
'contain' => array(
(int) 0 => 'Ville'
),
'recursive' => (int) 1
)</pre></div></li>
<li><a href="#" onclick="traceToggle(event, 'file-excerpt-6')">APP/Controller/EtablissementsController.php line 397</a> → <a href="#" onclick="traceToggle(event, 'trace-args-6')">Model->find(string, array)</a> <div id="file-excerpt-6" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #FF8000">// 'group' => 'Ville.id HAVING distance < 40000',</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #DD0000">'order' </span><span style="color: #007700">=> </span><span style="color: #DD0000">'distance'</span><span style="color: #007700">,</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #DD0000">'limit' </span><span style="color: #007700">=> </span><span style="color: #0000BB">5</span></span></code>
<span class="code-highlight"><code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">));</span></span></code></span>
<code><span style="color: #000000"><span style="color: #0000BB"> </span></span></code></pre></div> <div id="trace-args-6" class="cake-code-dump" style="display: none;"><pre>'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 != 82687 AND Etablissement.agregat_id=',
'contain' => array(
(int) 0 => 'Ville'
),
'order' => 'distance',
'limit' => (int) 5
)</pre></div></li>
<li><a href="#">[internal function]</a> → <a href="#" onclick="traceToggle(event, 'trace-args-7')">EtablissementsController->view(string, string)</a> <div id="trace-args-7" class="cake-code-dump" style="display: none;"><pre>'82687'
'maison-retraite-hopital-local-lamarche'</pre></div></li>
<li><a href="#" onclick="traceToggle(event, 'file-excerpt-8')">CORE/Cake/Controller/Controller.php line 490</a> → <a href="#" onclick="traceToggle(event, 'trace-args-8')">ReflectionMethod->invokeArgs(EtablissementsController, array)</a> <div id="file-excerpt-8" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #DD0000">'action' </span><span style="color: #007700">=> </span><span style="color: #0000BB">$request</span><span style="color: #007700">-></span><span style="color: #0000BB">params</span><span style="color: #007700">[</span><span style="color: #DD0000">'action'</span><span style="color: #007700">]</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">));</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">}</span></span></code>
<span class="code-highlight"><code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">return </span><span style="color: #0000BB">$method</span><span style="color: #007700">-></span><span style="color: #0000BB">invokeArgs</span><span style="color: #007700">(</span><span style="color: #0000BB">$this</span><span style="color: #007700">, </span><span style="color: #0000BB">$request</span><span style="color: #007700">-></span><span style="color: #0000BB">params</span><span style="color: #007700">[</span><span style="color: #DD0000">'pass'</span><span style="color: #007700">]);</span></span></code></span>
<code><span style="color: #000000"><span style="color: #0000BB"></span></span></code></pre></div> <div id="trace-args-8" class="cake-code-dump" style="display: none;"><pre>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) {}
Etablissement => object(Etablissement) {}
Virtuelle => object(AppModel) {}
[protected] _responseClass => 'CakeResponse'
[protected] _mergeParent => 'AppController'
[protected] _eventManager => object(CakeEventManager) {}
}
array(
(int) 0 => '82687',
(int) 1 => 'maison-retraite-hopital-local-lamarche'
)</pre></div></li>
<li><a href="#" onclick="traceToggle(event, 'file-excerpt-9')">CORE/Cake/Routing/Dispatcher.php line 191</a> → <a href="#" onclick="traceToggle(event, 'trace-args-9')">Controller->invokeAction(CakeRequest)</a> <div id="file-excerpt-9" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB"></span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> $response </span><span style="color: #007700">= </span><span style="color: #0000BB">$controller</span><span style="color: #007700">-></span><span style="color: #0000BB">response</span><span style="color: #007700">;</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> $render </span><span style="color: #007700">= </span><span style="color: #0000BB">true</span><span style="color: #007700">;</span></span></code>
<span class="code-highlight"><code><span style="color: #000000"><span style="color: #0000BB"> $result </span><span style="color: #007700">= </span><span style="color: #0000BB">$controller</span><span style="color: #007700">-></span><span style="color: #0000BB">invokeAction</span><span style="color: #007700">(</span><span style="color: #0000BB">$request</span><span style="color: #007700">);</span></span></code></span>
<code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">if (</span><span style="color: #0000BB">$result </span><span style="color: #007700">instanceof </span><span style="color: #0000BB">CakeResponse</span><span style="color: #007700">) {</span></span></code></pre></div> <div id="trace-args-9" class="cake-code-dump" style="display: none;"><pre>object(CakeRequest) {
params => array(
[maximum depth reached]
)
data => array([maximum depth reached])
query => array([maximum depth reached])
url => 'etablissement/82687-maison-retraite-hopital-local-lamarche'
base => ''
webroot => '/'
here => '/etablissement/82687-maison-retraite-hopital-local-lamarche'
[protected] _detectors => array(
[maximum depth reached]
)
[protected] _input => ''
}</pre></div></li>
<li><a href="#" onclick="traceToggle(event, 'file-excerpt-10')">CORE/Cake/Routing/Dispatcher.php line 165</a> → <a href="#" onclick="traceToggle(event, 'trace-args-10')">Dispatcher->_invoke(EtablissementsController, CakeRequest)</a> <div id="file-excerpt-10" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">));</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">}</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"></span></span></code>
<span class="code-highlight"><code><span style="color: #000000"><span style="color: #0000BB"> $response </span><span style="color: #007700">= </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">_invoke</span><span style="color: #007700">(</span><span style="color: #0000BB">$controller</span><span style="color: #007700">, </span><span style="color: #0000BB">$request</span><span style="color: #007700">);</span></span></code></span>
<code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">if (isset(</span><span style="color: #0000BB">$request</span><span style="color: #007700">-></span><span style="color: #0000BB">params</span><span style="color: #007700">[</span><span style="color: #DD0000">'return'</span><span style="color: #007700">])) {</span></span></code></pre></div> <div id="trace-args-10" class="cake-code-dump" style="display: none;"><pre>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) {}
Etablissement => object(Etablissement) {}
Virtuelle => object(AppModel) {}
[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/82687-maison-retraite-hopital-local-lamarche'
base => ''
webroot => '/'
here => '/etablissement/82687-maison-retraite-hopital-local-lamarche'
[protected] _detectors => array(
[maximum depth reached]
)
[protected] _input => ''
}</pre></div></li>
<li><a href="#" onclick="traceToggle(event, 'file-excerpt-11')">APP/webroot/index.php line 112</a> → <a href="#" onclick="traceToggle(event, 'trace-args-11')">Dispatcher->dispatch(CakeRequest, CakeResponse)</a> <div id="file-excerpt-11" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB">$Dispatcher</span><span style="color: #007700">-></span><span style="color: #0000BB">dispatch</span><span style="color: #007700">(</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">new </span><span style="color: #0000BB">CakeRequest</span><span style="color: #007700">(),</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">new </span><span style="color: #0000BB">CakeResponse</span><span style="color: #007700">()</span></span></code>
<span class="code-highlight"><code><span style="color: #000000"><span style="color: #0000BB"></span><span style="color: #007700">);</span></span></code></span>
<code><span style="color: #000000"><span style="color: #0000BB"></span></span></code></pre></div> <div id="trace-args-11" class="cake-code-dump" style="display: none;"><pre>object(CakeRequest) {
params => array(
[maximum depth reached]
)
data => array([maximum depth reached])
query => array([maximum depth reached])
url => 'etablissement/82687-maison-retraite-hopital-local-lamarche'
base => ''
webroot => '/'
here => '/etablissement/82687-maison-retraite-hopital-local-lamarche'
[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]
)
}</pre></div></li>
</ul>
<script type="text/javascript">
function traceToggle(event, id) {
var el = document.getElementById(id);
el.style.display = (el.style.display === 'block') ? 'none' : 'block';
event.preventDefault();
return false;
}
</script>
'
$scripts_for_layout = ''
$title_for_layout = 'Errors'
$urlActuelle = '/etablissement/82687-maison-retraite-hopital-local-lamarche'
$redirection = 'https://www.santeenfrance.fr/pages/plandusite'header - [internal], line ??
include - APP/View/Layouts/default.ctp, line 9
View::_evaluate() - CORE/Cake/View/View.php, line 948
View::_render() - CORE/Cake/View/View.php, line 910
View::renderLayout() - CORE/Cake/View/View.php, line 542
View::render() - CORE/Cake/View/View.php, line 479
Controller::render() - CORE/Cake/Controller/Controller.php, line 954
ExceptionRenderer::_outputMessage() - CORE/Cake/Error/ExceptionRenderer.php, line 278
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 ??
Warning (2): Cannot modify header information - headers already sent by (output started at /var/www/clients/client2/web13/web/lib/Cake/Utility/Debugger.php:801) [APP/View/Layouts/default.ctp, line 10]Code Context if ("https://www.santeenfrance.fr".$urlActuelle != $this->fetch('urlcanonique')) {
header("Status: 301 Moved Permanently", false, 301);
header("Location: ".$redirection."");
$viewFile = '/var/www/clients/client2/web13/web/app/View/Layouts/default.ctp'
$dataForView = array(
'code' => (int) 500,
'name' => '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',
'message' => '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',
'url' => '/etablissement/82687-maison-retraite-hopital-local-lamarche',
'error' => object(PDOException) {
errorInfo => array(
[maximum depth reached]
)
queryString => '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_sef_db`.`etablissements` AS `Etablissement` LEFT JOIN `c2_sef_db`.`villes` AS `Ville` ON (`Etablissement`.`ville_id` = `Ville`.`id`) WHERE `Etablissement`.`id` != 82687 AND `Etablissement`.`agregat_id`= ORDER BY `distance` ASC LIMIT 5'
[protected] message => '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'
[protected] code => '42000'
[protected] file => '/var/www/clients/client2/web13/web/lib/Cake/Model/Datasource/DboSource.php'
[protected] line => (int) 458
},
'_serialize' => array(
(int) 0 => 'code',
(int) 1 => 'name',
(int) 2 => 'message',
(int) 3 => 'url',
(int) 4 => 'error'
),
'content_for_layout' => '<h2>Database Error</h2>
<p class="error">
<strong>Error: </strong>
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</p>
<p class="notice">
<strong>SQL Query: </strong>
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_sef_db`.`etablissements` AS `Etablissement` LEFT JOIN `c2_sef_db`.`villes` AS `Ville` ON (`Etablissement`.`ville_id` = `Ville`.`id`) WHERE `Etablissement`.`id` != 82687 AND `Etablissement`.`agregat_id`= ORDER BY `distance` ASC LIMIT 5 </p>
<p class="notice">
<strong>Notice: </strong>
If you want to customize this error message, create app/View/Errors/pdo_error.ctp</p>
<h3>Stack Trace</h3>
<ul class="cake-stack-trace">
<li><a href="#" onclick="traceToggle(event, 'file-excerpt-0')">CORE/Cake/Model/Datasource/DboSource.php line 458</a> → <a href="#" onclick="traceToggle(event, 'trace-args-0')">PDOStatement->execute(array)</a> <div id="file-excerpt-0" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">try {</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> $query </span><span style="color: #007700">= </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">_connection</span><span style="color: #007700">-></span><span style="color: #0000BB">prepare</span><span style="color: #007700">(</span><span style="color: #0000BB">$sql</span><span style="color: #007700">, </span><span style="color: #0000BB">$prepareOptions</span><span style="color: #007700">);</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> $query</span><span style="color: #007700">-></span><span style="color: #0000BB">setFetchMode</span><span style="color: #007700">(</span><span style="color: #0000BB">PDO</span><span style="color: #007700">::</span><span style="color: #0000BB">FETCH_LAZY</span><span style="color: #007700">);</span></span></code>
<span class="code-highlight"><code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">if (!</span><span style="color: #0000BB">$query</span><span style="color: #007700">-></span><span style="color: #0000BB">execute</span><span style="color: #007700">(</span><span style="color: #0000BB">$params</span><span style="color: #007700">)) {</span></span></code></span>
<code><span style="color: #000000"><span style="color: #0000BB"> $this</span><span style="color: #007700">-></span><span style="color: #0000BB">_results </span><span style="color: #007700">= </span><span style="color: #0000BB">$query</span><span style="color: #007700">;</span></span></code></pre></div> <div id="trace-args-0" class="cake-code-dump" style="display: none;"><pre>array()</pre></div></li>
<li><a href="#" onclick="traceToggle(event, 'file-excerpt-1')">CORE/Cake/Model/Datasource/DboSource.php line 424</a> → <a href="#" onclick="traceToggle(event, 'trace-args-1')">DboSource->_execute(string, array)</a> <div id="file-excerpt-1" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB"> $options </span><span style="color: #007700">+= array(</span><span style="color: #DD0000">'log' </span><span style="color: #007700">=> </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">fullDebug</span><span style="color: #007700">);</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"></span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> $t </span><span style="color: #007700">= </span><span style="color: #0000BB">microtime</span><span style="color: #007700">(</span><span style="color: #0000BB">true</span><span style="color: #007700">);</span></span></code>
<span class="code-highlight"><code><span style="color: #000000"><span style="color: #0000BB"> $this</span><span style="color: #007700">-></span><span style="color: #0000BB">_result </span><span style="color: #007700">= </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">_execute</span><span style="color: #007700">(</span><span style="color: #0000BB">$sql</span><span style="color: #007700">, </span><span style="color: #0000BB">$params</span><span style="color: #007700">);</span></span></code></span>
<code><span style="color: #000000"><span style="color: #0000BB"></span></span></code></pre></div> <div id="trace-args-1" class="cake-code-dump" style="display: none;"><pre>'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_sef_db`.`etablissements` AS `Etablissement` LEFT JOIN `c2_sef_db`.`villes` AS `Ville` ON (`Etablissement`.`ville_id` = `Ville`.`id`) WHERE `Etablissement`.`id` != 82687 AND `Etablissement`.`agregat_id`= ORDER BY `distance` ASC LIMIT 5'
array()</pre></div></li>
<li><a href="#" onclick="traceToggle(event, 'file-excerpt-2')">CORE/Cake/Model/Datasource/DboSource.php line 666</a> → <a href="#" onclick="traceToggle(event, 'trace-args-2')">DboSource->execute(string, array, array)</a> <div id="file-excerpt-2" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">if (</span><span style="color: #0000BB">$cache </span><span style="color: #007700">&& (</span><span style="color: #0000BB">$cached </span><span style="color: #007700">= </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">getQueryCache</span><span style="color: #007700">(</span><span style="color: #0000BB">$sql</span><span style="color: #007700">, </span><span style="color: #0000BB">$params</span><span style="color: #007700">)) !== </span><span style="color: #0000BB">false</span><span style="color: #007700">) {</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">return </span><span style="color: #0000BB">$cached</span><span style="color: #007700">;</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">}</span></span></code>
<span class="code-highlight"><code><span style="color: #000000"><span style="color: #0000BB"> $result </span><span style="color: #007700">= </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">execute</span><span style="color: #007700">(</span><span style="color: #0000BB">$sql</span><span style="color: #007700">, array(), </span><span style="color: #0000BB">$params</span><span style="color: #007700">);</span></span></code></span>
<code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">if (</span><span style="color: #0000BB">$result</span><span style="color: #007700">) {</span></span></code></pre></div> <div id="trace-args-2" class="cake-code-dump" style="display: none;"><pre>'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_sef_db`.`etablissements` AS `Etablissement` LEFT JOIN `c2_sef_db`.`villes` AS `Ville` ON (`Etablissement`.`ville_id` = `Ville`.`id`) WHERE `Etablissement`.`id` != 82687 AND `Etablissement`.`agregat_id`= ORDER BY `distance` ASC LIMIT 5'
array()
array()</pre></div></li>
<li><a href="#" onclick="traceToggle(event, 'file-excerpt-3')">CORE/Cake/Model/Datasource/DboSource.php line 1106</a> → <a href="#" onclick="traceToggle(event, 'trace-args-3')">DboSource->fetchAll(string, boolean)</a> <div id="file-excerpt-3" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #FF8000">// Build SQL statement with the primary model, plus hasOne and belongsTo associations</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> $query </span><span style="color: #007700">= </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">buildAssociationQuery</span><span style="color: #007700">(</span><span style="color: #0000BB">$Model</span><span style="color: #007700">, </span><span style="color: #0000BB">$queryData</span><span style="color: #007700">);</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"></span></span></code>
<span class="code-highlight"><code><span style="color: #000000"><span style="color: #0000BB"> $resultSet </span><span style="color: #007700">= </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">fetchAll</span><span style="color: #007700">(</span><span style="color: #0000BB">$query</span><span style="color: #007700">, </span><span style="color: #0000BB">$Model</span><span style="color: #007700">-></span><span style="color: #0000BB">cacheQueries</span><span style="color: #007700">);</span></span></code></span>
<code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">unset(</span><span style="color: #0000BB">$query</span><span style="color: #007700">);</span></span></code></pre></div> <div id="trace-args-3" class="cake-code-dump" style="display: none;"><pre>'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_sef_db`.`etablissements` AS `Etablissement` LEFT JOIN `c2_sef_db`.`villes` AS `Ville` ON (`Etablissement`.`ville_id` = `Ville`.`id`) WHERE `Etablissement`.`id` != 82687 AND `Etablissement`.`agregat_id`= ORDER BY `distance` ASC LIMIT 5'
false</pre></div></li>
<li><a href="#" onclick="traceToggle(event, 'file-excerpt-4')">CORE/Cake/Model/Model.php line 2947</a> → <a href="#" onclick="traceToggle(event, 'trace-args-4')">DboSource->read(Etablissement, array)</a> <div id="file-excerpt-4" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">* @return array</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">*/</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">protected function </span><span style="color: #0000BB">_readDataSource</span><span style="color: #007700">(</span><span style="color: #0000BB">$type</span><span style="color: #007700">, </span><span style="color: #0000BB">$query</span><span style="color: #007700">) {</span></span></code>
<span class="code-highlight"><code><span style="color: #000000"><span style="color: #0000BB"> $results </span><span style="color: #007700">= </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">getDataSource</span><span style="color: #007700">()-></span><span style="color: #0000BB">read</span><span style="color: #007700">(</span><span style="color: #0000BB">$this</span><span style="color: #007700">, </span><span style="color: #0000BB">$query</span><span style="color: #007700">);</span></span></code></span>
<code><span style="color: #000000"><span style="color: #0000BB"> $this</span><span style="color: #007700">-></span><span style="color: #0000BB">resetAssociations</span><span style="color: #007700">();</span></span></code></pre></div> <div id="trace-args-4" class="cake-code-dump" style="display: none;"><pre>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_sef_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 != 82687 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) 5,
'offset' => null,
'order' => array(
(int) 0 => 'distance'
),
'page' => (int) 1,
'group' => null,
'callbacks' => true,
'contain' => array(
(int) 0 => 'Ville'
),
'recursive' => (int) 1
)</pre></div></li>
<li><a href="#" onclick="traceToggle(event, 'file-excerpt-5')">CORE/Cake/Model/Model.php line 2919</a> → <a href="#" onclick="traceToggle(event, 'trace-args-5')">Model->_readDataSource(string, array)</a> <div id="file-excerpt-5" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">return </span><span style="color: #0000BB">null</span><span style="color: #007700">;</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">}</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"></span></span></code>
<span class="code-highlight"><code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">return </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">_readDataSource</span><span style="color: #007700">(</span><span style="color: #0000BB">$type</span><span style="color: #007700">, </span><span style="color: #0000BB">$query</span><span style="color: #007700">);</span></span></code></span>
<code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">}</span></span></code></pre></div> <div id="trace-args-5" class="cake-code-dump" style="display: none;"><pre>'all'
array(
'conditions' => 'Etablissement.id != 82687 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) 5,
'offset' => null,
'order' => array(
(int) 0 => 'distance'
),
'page' => (int) 1,
'group' => null,
'callbacks' => true,
'contain' => array(
(int) 0 => 'Ville'
),
'recursive' => (int) 1
)</pre></div></li>
<li><a href="#" onclick="traceToggle(event, 'file-excerpt-6')">APP/Controller/EtablissementsController.php line 397</a> → <a href="#" onclick="traceToggle(event, 'trace-args-6')">Model->find(string, array)</a> <div id="file-excerpt-6" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #FF8000">// 'group' => 'Ville.id HAVING distance < 40000',</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #DD0000">'order' </span><span style="color: #007700">=> </span><span style="color: #DD0000">'distance'</span><span style="color: #007700">,</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #DD0000">'limit' </span><span style="color: #007700">=> </span><span style="color: #0000BB">5</span></span></code>
<span class="code-highlight"><code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">));</span></span></code></span>
<code><span style="color: #000000"><span style="color: #0000BB"> </span></span></code></pre></div> <div id="trace-args-6" class="cake-code-dump" style="display: none;"><pre>'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 != 82687 AND Etablissement.agregat_id=',
'contain' => array(
(int) 0 => 'Ville'
),
'order' => 'distance',
'limit' => (int) 5
)</pre></div></li>
<li><a href="#">[internal function]</a> → <a href="#" onclick="traceToggle(event, 'trace-args-7')">EtablissementsController->view(string, string)</a> <div id="trace-args-7" class="cake-code-dump" style="display: none;"><pre>'82687'
'maison-retraite-hopital-local-lamarche'</pre></div></li>
<li><a href="#" onclick="traceToggle(event, 'file-excerpt-8')">CORE/Cake/Controller/Controller.php line 490</a> → <a href="#" onclick="traceToggle(event, 'trace-args-8')">ReflectionMethod->invokeArgs(EtablissementsController, array)</a> <div id="file-excerpt-8" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #DD0000">'action' </span><span style="color: #007700">=> </span><span style="color: #0000BB">$request</span><span style="color: #007700">-></span><span style="color: #0000BB">params</span><span style="color: #007700">[</span><span style="color: #DD0000">'action'</span><span style="color: #007700">]</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">));</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">}</span></span></code>
<span class="code-highlight"><code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">return </span><span style="color: #0000BB">$method</span><span style="color: #007700">-></span><span style="color: #0000BB">invokeArgs</span><span style="color: #007700">(</span><span style="color: #0000BB">$this</span><span style="color: #007700">, </span><span style="color: #0000BB">$request</span><span style="color: #007700">-></span><span style="color: #0000BB">params</span><span style="color: #007700">[</span><span style="color: #DD0000">'pass'</span><span style="color: #007700">]);</span></span></code></span>
<code><span style="color: #000000"><span style="color: #0000BB"></span></span></code></pre></div> <div id="trace-args-8" class="cake-code-dump" style="display: none;"><pre>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) {}
Etablissement => object(Etablissement) {}
Virtuelle => object(AppModel) {}
[protected] _responseClass => 'CakeResponse'
[protected] _mergeParent => 'AppController'
[protected] _eventManager => object(CakeEventManager) {}
}
array(
(int) 0 => '82687',
(int) 1 => 'maison-retraite-hopital-local-lamarche'
)</pre></div></li>
<li><a href="#" onclick="traceToggle(event, 'file-excerpt-9')">CORE/Cake/Routing/Dispatcher.php line 191</a> → <a href="#" onclick="traceToggle(event, 'trace-args-9')">Controller->invokeAction(CakeRequest)</a> <div id="file-excerpt-9" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB"></span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> $response </span><span style="color: #007700">= </span><span style="color: #0000BB">$controller</span><span style="color: #007700">-></span><span style="color: #0000BB">response</span><span style="color: #007700">;</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> $render </span><span style="color: #007700">= </span><span style="color: #0000BB">true</span><span style="color: #007700">;</span></span></code>
<span class="code-highlight"><code><span style="color: #000000"><span style="color: #0000BB"> $result </span><span style="color: #007700">= </span><span style="color: #0000BB">$controller</span><span style="color: #007700">-></span><span style="color: #0000BB">invokeAction</span><span style="color: #007700">(</span><span style="color: #0000BB">$request</span><span style="color: #007700">);</span></span></code></span>
<code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">if (</span><span style="color: #0000BB">$result </span><span style="color: #007700">instanceof </span><span style="color: #0000BB">CakeResponse</span><span style="color: #007700">) {</span></span></code></pre></div> <div id="trace-args-9" class="cake-code-dump" style="display: none;"><pre>object(CakeRequest) {
params => array(
[maximum depth reached]
)
data => array([maximum depth reached])
query => array([maximum depth reached])
url => 'etablissement/82687-maison-retraite-hopital-local-lamarche'
base => ''
webroot => '/'
here => '/etablissement/82687-maison-retraite-hopital-local-lamarche'
[protected] _detectors => array(
[maximum depth reached]
)
[protected] _input => ''
}</pre></div></li>
<li><a href="#" onclick="traceToggle(event, 'file-excerpt-10')">CORE/Cake/Routing/Dispatcher.php line 165</a> → <a href="#" onclick="traceToggle(event, 'trace-args-10')">Dispatcher->_invoke(EtablissementsController, CakeRequest)</a> <div id="file-excerpt-10" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">));</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">}</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"></span></span></code>
<span class="code-highlight"><code><span style="color: #000000"><span style="color: #0000BB"> $response </span><span style="color: #007700">= </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">_invoke</span><span style="color: #007700">(</span><span style="color: #0000BB">$controller</span><span style="color: #007700">, </span><span style="color: #0000BB">$request</span><span style="color: #007700">);</span></span></code></span>
<code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">if (isset(</span><span style="color: #0000BB">$request</span><span style="color: #007700">-></span><span style="color: #0000BB">params</span><span style="color: #007700">[</span><span style="color: #DD0000">'return'</span><span style="color: #007700">])) {</span></span></code></pre></div> <div id="trace-args-10" class="cake-code-dump" style="display: none;"><pre>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) {}
Etablissement => object(Etablissement) {}
Virtuelle => object(AppModel) {}
[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/82687-maison-retraite-hopital-local-lamarche'
base => ''
webroot => '/'
here => '/etablissement/82687-maison-retraite-hopital-local-lamarche'
[protected] _detectors => array(
[maximum depth reached]
)
[protected] _input => ''
}</pre></div></li>
<li><a href="#" onclick="traceToggle(event, 'file-excerpt-11')">APP/webroot/index.php line 112</a> → <a href="#" onclick="traceToggle(event, 'trace-args-11')">Dispatcher->dispatch(CakeRequest, CakeResponse)</a> <div id="file-excerpt-11" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB">$Dispatcher</span><span style="color: #007700">-></span><span style="color: #0000BB">dispatch</span><span style="color: #007700">(</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">new </span><span style="color: #0000BB">CakeRequest</span><span style="color: #007700">(),</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">new </span><span style="color: #0000BB">CakeResponse</span><span style="color: #007700">()</span></span></code>
<span class="code-highlight"><code><span style="color: #000000"><span style="color: #0000BB"></span><span style="color: #007700">);</span></span></code></span>
<code><span style="color: #000000"><span style="color: #0000BB"></span></span></code></pre></div> <div id="trace-args-11" class="cake-code-dump" style="display: none;"><pre>object(CakeRequest) {
params => array(
[maximum depth reached]
)
data => array([maximum depth reached])
query => array([maximum depth reached])
url => 'etablissement/82687-maison-retraite-hopital-local-lamarche'
base => ''
webroot => '/'
here => '/etablissement/82687-maison-retraite-hopital-local-lamarche'
[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]
)
}</pre></div></li>
</ul>
<script type="text/javascript">
function traceToggle(event, id) {
var el = document.getElementById(id);
el.style.display = (el.style.display === 'block') ? 'none' : 'block';
event.preventDefault();
return false;
}
</script>
',
'scripts_for_layout' => '',
'title_for_layout' => 'Errors'
)
$code = (int) 500
$name = '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'
$message = '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'
$url = '/etablissement/82687-maison-retraite-hopital-local-lamarche'
$error = object(PDOException) {
errorInfo => array(
(int) 0 => '42000',
(int) 1 => (int) 1064,
(int) 2 => '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'
)
queryString => '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_sef_db`.`etablissements` AS `Etablissement` LEFT JOIN `c2_sef_db`.`villes` AS `Ville` ON (`Etablissement`.`ville_id` = `Ville`.`id`) WHERE `Etablissement`.`id` != 82687 AND `Etablissement`.`agregat_id`= ORDER BY `distance` ASC LIMIT 5'
[protected] message => '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'
[protected] code => '42000'
[protected] file => '/var/www/clients/client2/web13/web/lib/Cake/Model/Datasource/DboSource.php'
[protected] line => (int) 458
}
$_serialize = array(
(int) 0 => 'code',
(int) 1 => 'name',
(int) 2 => 'message',
(int) 3 => 'url',
(int) 4 => 'error'
)
$content_for_layout = '<h2>Database Error</h2>
<p class="error">
<strong>Error: </strong>
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</p>
<p class="notice">
<strong>SQL Query: </strong>
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_sef_db`.`etablissements` AS `Etablissement` LEFT JOIN `c2_sef_db`.`villes` AS `Ville` ON (`Etablissement`.`ville_id` = `Ville`.`id`) WHERE `Etablissement`.`id` != 82687 AND `Etablissement`.`agregat_id`= ORDER BY `distance` ASC LIMIT 5 </p>
<p class="notice">
<strong>Notice: </strong>
If you want to customize this error message, create app/View/Errors/pdo_error.ctp</p>
<h3>Stack Trace</h3>
<ul class="cake-stack-trace">
<li><a href="#" onclick="traceToggle(event, 'file-excerpt-0')">CORE/Cake/Model/Datasource/DboSource.php line 458</a> → <a href="#" onclick="traceToggle(event, 'trace-args-0')">PDOStatement->execute(array)</a> <div id="file-excerpt-0" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">try {</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> $query </span><span style="color: #007700">= </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">_connection</span><span style="color: #007700">-></span><span style="color: #0000BB">prepare</span><span style="color: #007700">(</span><span style="color: #0000BB">$sql</span><span style="color: #007700">, </span><span style="color: #0000BB">$prepareOptions</span><span style="color: #007700">);</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> $query</span><span style="color: #007700">-></span><span style="color: #0000BB">setFetchMode</span><span style="color: #007700">(</span><span style="color: #0000BB">PDO</span><span style="color: #007700">::</span><span style="color: #0000BB">FETCH_LAZY</span><span style="color: #007700">);</span></span></code>
<span class="code-highlight"><code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">if (!</span><span style="color: #0000BB">$query</span><span style="color: #007700">-></span><span style="color: #0000BB">execute</span><span style="color: #007700">(</span><span style="color: #0000BB">$params</span><span style="color: #007700">)) {</span></span></code></span>
<code><span style="color: #000000"><span style="color: #0000BB"> $this</span><span style="color: #007700">-></span><span style="color: #0000BB">_results </span><span style="color: #007700">= </span><span style="color: #0000BB">$query</span><span style="color: #007700">;</span></span></code></pre></div> <div id="trace-args-0" class="cake-code-dump" style="display: none;"><pre>array()</pre></div></li>
<li><a href="#" onclick="traceToggle(event, 'file-excerpt-1')">CORE/Cake/Model/Datasource/DboSource.php line 424</a> → <a href="#" onclick="traceToggle(event, 'trace-args-1')">DboSource->_execute(string, array)</a> <div id="file-excerpt-1" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB"> $options </span><span style="color: #007700">+= array(</span><span style="color: #DD0000">'log' </span><span style="color: #007700">=> </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">fullDebug</span><span style="color: #007700">);</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"></span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> $t </span><span style="color: #007700">= </span><span style="color: #0000BB">microtime</span><span style="color: #007700">(</span><span style="color: #0000BB">true</span><span style="color: #007700">);</span></span></code>
<span class="code-highlight"><code><span style="color: #000000"><span style="color: #0000BB"> $this</span><span style="color: #007700">-></span><span style="color: #0000BB">_result </span><span style="color: #007700">= </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">_execute</span><span style="color: #007700">(</span><span style="color: #0000BB">$sql</span><span style="color: #007700">, </span><span style="color: #0000BB">$params</span><span style="color: #007700">);</span></span></code></span>
<code><span style="color: #000000"><span style="color: #0000BB"></span></span></code></pre></div> <div id="trace-args-1" class="cake-code-dump" style="display: none;"><pre>'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_sef_db`.`etablissements` AS `Etablissement` LEFT JOIN `c2_sef_db`.`villes` AS `Ville` ON (`Etablissement`.`ville_id` = `Ville`.`id`) WHERE `Etablissement`.`id` != 82687 AND `Etablissement`.`agregat_id`= ORDER BY `distance` ASC LIMIT 5'
array()</pre></div></li>
<li><a href="#" onclick="traceToggle(event, 'file-excerpt-2')">CORE/Cake/Model/Datasource/DboSource.php line 666</a> → <a href="#" onclick="traceToggle(event, 'trace-args-2')">DboSource->execute(string, array, array)</a> <div id="file-excerpt-2" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">if (</span><span style="color: #0000BB">$cache </span><span style="color: #007700">&& (</span><span style="color: #0000BB">$cached </span><span style="color: #007700">= </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">getQueryCache</span><span style="color: #007700">(</span><span style="color: #0000BB">$sql</span><span style="color: #007700">, </span><span style="color: #0000BB">$params</span><span style="color: #007700">)) !== </span><span style="color: #0000BB">false</span><span style="color: #007700">) {</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">return </span><span style="color: #0000BB">$cached</span><span style="color: #007700">;</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">}</span></span></code>
<span class="code-highlight"><code><span style="color: #000000"><span style="color: #0000BB"> $result </span><span style="color: #007700">= </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">execute</span><span style="color: #007700">(</span><span style="color: #0000BB">$sql</span><span style="color: #007700">, array(), </span><span style="color: #0000BB">$params</span><span style="color: #007700">);</span></span></code></span>
<code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">if (</span><span style="color: #0000BB">$result</span><span style="color: #007700">) {</span></span></code></pre></div> <div id="trace-args-2" class="cake-code-dump" style="display: none;"><pre>'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_sef_db`.`etablissements` AS `Etablissement` LEFT JOIN `c2_sef_db`.`villes` AS `Ville` ON (`Etablissement`.`ville_id` = `Ville`.`id`) WHERE `Etablissement`.`id` != 82687 AND `Etablissement`.`agregat_id`= ORDER BY `distance` ASC LIMIT 5'
array()
array()</pre></div></li>
<li><a href="#" onclick="traceToggle(event, 'file-excerpt-3')">CORE/Cake/Model/Datasource/DboSource.php line 1106</a> → <a href="#" onclick="traceToggle(event, 'trace-args-3')">DboSource->fetchAll(string, boolean)</a> <div id="file-excerpt-3" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #FF8000">// Build SQL statement with the primary model, plus hasOne and belongsTo associations</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> $query </span><span style="color: #007700">= </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">buildAssociationQuery</span><span style="color: #007700">(</span><span style="color: #0000BB">$Model</span><span style="color: #007700">, </span><span style="color: #0000BB">$queryData</span><span style="color: #007700">);</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"></span></span></code>
<span class="code-highlight"><code><span style="color: #000000"><span style="color: #0000BB"> $resultSet </span><span style="color: #007700">= </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">fetchAll</span><span style="color: #007700">(</span><span style="color: #0000BB">$query</span><span style="color: #007700">, </span><span style="color: #0000BB">$Model</span><span style="color: #007700">-></span><span style="color: #0000BB">cacheQueries</span><span style="color: #007700">);</span></span></code></span>
<code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">unset(</span><span style="color: #0000BB">$query</span><span style="color: #007700">);</span></span></code></pre></div> <div id="trace-args-3" class="cake-code-dump" style="display: none;"><pre>'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_sef_db`.`etablissements` AS `Etablissement` LEFT JOIN `c2_sef_db`.`villes` AS `Ville` ON (`Etablissement`.`ville_id` = `Ville`.`id`) WHERE `Etablissement`.`id` != 82687 AND `Etablissement`.`agregat_id`= ORDER BY `distance` ASC LIMIT 5'
false</pre></div></li>
<li><a href="#" onclick="traceToggle(event, 'file-excerpt-4')">CORE/Cake/Model/Model.php line 2947</a> → <a href="#" onclick="traceToggle(event, 'trace-args-4')">DboSource->read(Etablissement, array)</a> <div id="file-excerpt-4" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">* @return array</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">*/</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">protected function </span><span style="color: #0000BB">_readDataSource</span><span style="color: #007700">(</span><span style="color: #0000BB">$type</span><span style="color: #007700">, </span><span style="color: #0000BB">$query</span><span style="color: #007700">) {</span></span></code>
<span class="code-highlight"><code><span style="color: #000000"><span style="color: #0000BB"> $results </span><span style="color: #007700">= </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">getDataSource</span><span style="color: #007700">()-></span><span style="color: #0000BB">read</span><span style="color: #007700">(</span><span style="color: #0000BB">$this</span><span style="color: #007700">, </span><span style="color: #0000BB">$query</span><span style="color: #007700">);</span></span></code></span>
<code><span style="color: #000000"><span style="color: #0000BB"> $this</span><span style="color: #007700">-></span><span style="color: #0000BB">resetAssociations</span><span style="color: #007700">();</span></span></code></pre></div> <div id="trace-args-4" class="cake-code-dump" style="display: none;"><pre>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_sef_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 != 82687 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) 5,
'offset' => null,
'order' => array(
(int) 0 => 'distance'
),
'page' => (int) 1,
'group' => null,
'callbacks' => true,
'contain' => array(
(int) 0 => 'Ville'
),
'recursive' => (int) 1
)</pre></div></li>
<li><a href="#" onclick="traceToggle(event, 'file-excerpt-5')">CORE/Cake/Model/Model.php line 2919</a> → <a href="#" onclick="traceToggle(event, 'trace-args-5')">Model->_readDataSource(string, array)</a> <div id="file-excerpt-5" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">return </span><span style="color: #0000BB">null</span><span style="color: #007700">;</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">}</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"></span></span></code>
<span class="code-highlight"><code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">return </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">_readDataSource</span><span style="color: #007700">(</span><span style="color: #0000BB">$type</span><span style="color: #007700">, </span><span style="color: #0000BB">$query</span><span style="color: #007700">);</span></span></code></span>
<code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">}</span></span></code></pre></div> <div id="trace-args-5" class="cake-code-dump" style="display: none;"><pre>'all'
array(
'conditions' => 'Etablissement.id != 82687 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) 5,
'offset' => null,
'order' => array(
(int) 0 => 'distance'
),
'page' => (int) 1,
'group' => null,
'callbacks' => true,
'contain' => array(
(int) 0 => 'Ville'
),
'recursive' => (int) 1
)</pre></div></li>
<li><a href="#" onclick="traceToggle(event, 'file-excerpt-6')">APP/Controller/EtablissementsController.php line 397</a> → <a href="#" onclick="traceToggle(event, 'trace-args-6')">Model->find(string, array)</a> <div id="file-excerpt-6" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #FF8000">// 'group' => 'Ville.id HAVING distance < 40000',</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #DD0000">'order' </span><span style="color: #007700">=> </span><span style="color: #DD0000">'distance'</span><span style="color: #007700">,</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #DD0000">'limit' </span><span style="color: #007700">=> </span><span style="color: #0000BB">5</span></span></code>
<span class="code-highlight"><code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">));</span></span></code></span>
<code><span style="color: #000000"><span style="color: #0000BB"> </span></span></code></pre></div> <div id="trace-args-6" class="cake-code-dump" style="display: none;"><pre>'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 != 82687 AND Etablissement.agregat_id=',
'contain' => array(
(int) 0 => 'Ville'
),
'order' => 'distance',
'limit' => (int) 5
)</pre></div></li>
<li><a href="#">[internal function]</a> → <a href="#" onclick="traceToggle(event, 'trace-args-7')">EtablissementsController->view(string, string)</a> <div id="trace-args-7" class="cake-code-dump" style="display: none;"><pre>'82687'
'maison-retraite-hopital-local-lamarche'</pre></div></li>
<li><a href="#" onclick="traceToggle(event, 'file-excerpt-8')">CORE/Cake/Controller/Controller.php line 490</a> → <a href="#" onclick="traceToggle(event, 'trace-args-8')">ReflectionMethod->invokeArgs(EtablissementsController, array)</a> <div id="file-excerpt-8" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #DD0000">'action' </span><span style="color: #007700">=> </span><span style="color: #0000BB">$request</span><span style="color: #007700">-></span><span style="color: #0000BB">params</span><span style="color: #007700">[</span><span style="color: #DD0000">'action'</span><span style="color: #007700">]</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">));</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">}</span></span></code>
<span class="code-highlight"><code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">return </span><span style="color: #0000BB">$method</span><span style="color: #007700">-></span><span style="color: #0000BB">invokeArgs</span><span style="color: #007700">(</span><span style="color: #0000BB">$this</span><span style="color: #007700">, </span><span style="color: #0000BB">$request</span><span style="color: #007700">-></span><span style="color: #0000BB">params</span><span style="color: #007700">[</span><span style="color: #DD0000">'pass'</span><span style="color: #007700">]);</span></span></code></span>
<code><span style="color: #000000"><span style="color: #0000BB"></span></span></code></pre></div> <div id="trace-args-8" class="cake-code-dump" style="display: none;"><pre>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) {}
Etablissement => object(Etablissement) {}
Virtuelle => object(AppModel) {}
[protected] _responseClass => 'CakeResponse'
[protected] _mergeParent => 'AppController'
[protected] _eventManager => object(CakeEventManager) {}
}
array(
(int) 0 => '82687',
(int) 1 => 'maison-retraite-hopital-local-lamarche'
)</pre></div></li>
<li><a href="#" onclick="traceToggle(event, 'file-excerpt-9')">CORE/Cake/Routing/Dispatcher.php line 191</a> → <a href="#" onclick="traceToggle(event, 'trace-args-9')">Controller->invokeAction(CakeRequest)</a> <div id="file-excerpt-9" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB"></span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> $response </span><span style="color: #007700">= </span><span style="color: #0000BB">$controller</span><span style="color: #007700">-></span><span style="color: #0000BB">response</span><span style="color: #007700">;</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> $render </span><span style="color: #007700">= </span><span style="color: #0000BB">true</span><span style="color: #007700">;</span></span></code>
<span class="code-highlight"><code><span style="color: #000000"><span style="color: #0000BB"> $result </span><span style="color: #007700">= </span><span style="color: #0000BB">$controller</span><span style="color: #007700">-></span><span style="color: #0000BB">invokeAction</span><span style="color: #007700">(</span><span style="color: #0000BB">$request</span><span style="color: #007700">);</span></span></code></span>
<code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">if (</span><span style="color: #0000BB">$result </span><span style="color: #007700">instanceof </span><span style="color: #0000BB">CakeResponse</span><span style="color: #007700">) {</span></span></code></pre></div> <div id="trace-args-9" class="cake-code-dump" style="display: none;"><pre>object(CakeRequest) {
params => array(
[maximum depth reached]
)
data => array([maximum depth reached])
query => array([maximum depth reached])
url => 'etablissement/82687-maison-retraite-hopital-local-lamarche'
base => ''
webroot => '/'
here => '/etablissement/82687-maison-retraite-hopital-local-lamarche'
[protected] _detectors => array(
[maximum depth reached]
)
[protected] _input => ''
}</pre></div></li>
<li><a href="#" onclick="traceToggle(event, 'file-excerpt-10')">CORE/Cake/Routing/Dispatcher.php line 165</a> → <a href="#" onclick="traceToggle(event, 'trace-args-10')">Dispatcher->_invoke(EtablissementsController, CakeRequest)</a> <div id="file-excerpt-10" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">));</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">}</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"></span></span></code>
<span class="code-highlight"><code><span style="color: #000000"><span style="color: #0000BB"> $response </span><span style="color: #007700">= </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">_invoke</span><span style="color: #007700">(</span><span style="color: #0000BB">$controller</span><span style="color: #007700">, </span><span style="color: #0000BB">$request</span><span style="color: #007700">);</span></span></code></span>
<code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">if (isset(</span><span style="color: #0000BB">$request</span><span style="color: #007700">-></span><span style="color: #0000BB">params</span><span style="color: #007700">[</span><span style="color: #DD0000">'return'</span><span style="color: #007700">])) {</span></span></code></pre></div> <div id="trace-args-10" class="cake-code-dump" style="display: none;"><pre>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) {}
Etablissement => object(Etablissement) {}
Virtuelle => object(AppModel) {}
[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/82687-maison-retraite-hopital-local-lamarche'
base => ''
webroot => '/'
here => '/etablissement/82687-maison-retraite-hopital-local-lamarche'
[protected] _detectors => array(
[maximum depth reached]
)
[protected] _input => ''
}</pre></div></li>
<li><a href="#" onclick="traceToggle(event, 'file-excerpt-11')">APP/webroot/index.php line 112</a> → <a href="#" onclick="traceToggle(event, 'trace-args-11')">Dispatcher->dispatch(CakeRequest, CakeResponse)</a> <div id="file-excerpt-11" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB">$Dispatcher</span><span style="color: #007700">-></span><span style="color: #0000BB">dispatch</span><span style="color: #007700">(</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">new </span><span style="color: #0000BB">CakeRequest</span><span style="color: #007700">(),</span></span></code>
<code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">new </span><span style="color: #0000BB">CakeResponse</span><span style="color: #007700">()</span></span></code>
<span class="code-highlight"><code><span style="color: #000000"><span style="color: #0000BB"></span><span style="color: #007700">);</span></span></code></span>
<code><span style="color: #000000"><span style="color: #0000BB"></span></span></code></pre></div> <div id="trace-args-11" class="cake-code-dump" style="display: none;"><pre>object(CakeRequest) {
params => array(
[maximum depth reached]
)
data => array([maximum depth reached])
query => array([maximum depth reached])
url => 'etablissement/82687-maison-retraite-hopital-local-lamarche'
base => ''
webroot => '/'
here => '/etablissement/82687-maison-retraite-hopital-local-lamarche'
[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]
)
}</pre></div></li>
</ul>
<script type="text/javascript">
function traceToggle(event, id) {
var el = document.getElementById(id);
el.style.display = (el.style.display === 'block') ? 'none' : 'block';
event.preventDefault();
return false;
}
</script>
'
$scripts_for_layout = ''
$title_for_layout = 'Errors'
$urlActuelle = '/etablissement/82687-maison-retraite-hopital-local-lamarche'
$redirection = 'https://www.santeenfrance.fr/pages/plandusite'header - [internal], line ??
include - APP/View/Layouts/default.ctp, line 10
View::_evaluate() - CORE/Cake/View/View.php, line 948
View::_render() - CORE/Cake/View/View.php, line 910
View::renderLayout() - CORE/Cake/View/View.php, line 542
View::render() - CORE/Cake/View/View.php, line 479
Controller::render() - CORE/Cake/Controller/Controller.php, line 954
ExceptionRenderer::_outputMessage() - CORE/Cake/Error/ExceptionRenderer.php, line 278
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 ??