Notice (8): Undefined index: Product [APP/Controller/PagesController.php, line 761]Code Context
$this->set('title_for_layout', 'Geo4net - Liste des produits - '.$product['Product']['name']);
$marq = '35-TTJ' $id = null $idprod = array( (int) 0 => '' ) $product = array()PagesController::detail_product() - APP/Controller/PagesController.php, line 761 ReflectionMethod::invokeArgs() - [internal], line ?? Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167 [main] - APP/webroot/index.php, line 117
Notice (8): Trying to access array offset on value of type null [APP/Controller/PagesController.php, line 761]Code Context
$this->set('title_for_layout', 'Geo4net - Liste des produits - '.$product['Product']['name']);
$marq = '35-TTJ' $id = null $idprod = array( (int) 0 => '' ) $product = array()PagesController::detail_product() - APP/Controller/PagesController.php, line 761 ReflectionMethod::invokeArgs() - [internal], line ?? Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167 [main] - APP/webroot/index.php, line 117
Notice (8): Undefined index: Product [APP/Controller/PagesController.php, line 763]Code Context$this->set('title_for_layout', 'Geo4net - Liste des produits - '.$product['Product']['name']);
$products = $this->Product->find('all', array('conditions' => array('Product.status' => 1, 'Product.category_product_id' => $product['Product']['category_product_id'], 'Product.id <> ' => $product['Product']['id'])));
$marq = '35-TTJ' $id = null $idprod = array( (int) 0 => '' ) $product = array()PagesController::detail_product() - APP/Controller/PagesController.php, line 763 ReflectionMethod::invokeArgs() - [internal], line ?? Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167 [main] - APP/webroot/index.php, line 117
Notice (8): Trying to access array offset on value of type null [APP/Controller/PagesController.php, line 763]Code Context$this->set('title_for_layout', 'Geo4net - Liste des produits - '.$product['Product']['name']);
$products = $this->Product->find('all', array('conditions' => array('Product.status' => 1, 'Product.category_product_id' => $product['Product']['category_product_id'], 'Product.id <> ' => $product['Product']['id'])));
$marq = '35-TTJ' $id = null $idprod = array( (int) 0 => '' ) $product = array()PagesController::detail_product() - APP/Controller/PagesController.php, line 763 ReflectionMethod::invokeArgs() - [internal], line ?? Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167 [main] - APP/webroot/index.php, line 117
Notice (8): Undefined index: Product [APP/Controller/PagesController.php, line 763]Code Context$this->set('title_for_layout', 'Geo4net - Liste des produits - '.$product['Product']['name']);
$products = $this->Product->find('all', array('conditions' => array('Product.status' => 1, 'Product.category_product_id' => $product['Product']['category_product_id'], 'Product.id <> ' => $product['Product']['id'])));
$marq = '35-TTJ' $id = null $idprod = array( (int) 0 => '' ) $product = array()PagesController::detail_product() - APP/Controller/PagesController.php, line 763 ReflectionMethod::invokeArgs() - [internal], line ?? Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167 [main] - APP/webroot/index.php, line 117
Notice (8): Trying to access array offset on value of type null [APP/Controller/PagesController.php, line 763]Code Context$this->set('title_for_layout', 'Geo4net - Liste des produits - '.$product['Product']['name']);
$products = $this->Product->find('all', array('conditions' => array('Product.status' => 1, 'Product.category_product_id' => $product['Product']['category_product_id'], 'Product.id <> ' => $product['Product']['id'])));
$marq = '35-TTJ' $id = null $idprod = array( (int) 0 => '' ) $product = array()PagesController::detail_product() - APP/Controller/PagesController.php, line 763 ReflectionMethod::invokeArgs() - [internal], line ?? Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167 [main] - APP/webroot/index.php, line 117
Notice (8): Undefined variable: comparators [APP/View/Layouts/default.ctp, line 551]Code Context
<li class="drodown-show">
<a href="#"><span class="icon icon-MusicMixer"></span><span id="totcomp" class="total-pro"><?php echo count($comparators); ?></span></a>
$viewFile = '/home/geo4net/web/geo4net.com/public_html/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 'GROUP BY pfc.id' 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 'GROUP BY pfc.id' at line 1', 'url' => '/produit/35-TTJ', 'error' => object(PDOException) { errorInfo => array( [maximum depth reached] ) queryString => 'SELECT pfc.id as cat_id, pfc.name as cat_name FROM product_field_categories pfc, product_fields pf, product_extras pe WHERE pf.product_field_category_id = pfc.id and pe.product_field_id = pf.id and pe.product_id = GROUP BY pfc.id' [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 'GROUP BY pfc.id' at line 1' [protected] code => '42000' [protected] file => '/home/geo4net/web/geo4net.com/public_html/lib/Cake/Model/Datasource/DboSource.php' [protected] line => (int) 502 }, '_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 'GROUP BY pfc.id' at line 1</p> <p class="notice"> <strong>SQL Query: </strong> SELECT pfc.id as cat_id, pfc.name as cat_name FROM product_field_categories pfc, product_fields pf, product_extras pe WHERE pf.product_field_category_id = pfc.id and pe.product_field_id = pf.id and pe.product_id = GROUP BY pfc.id </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 502</a> → <a href="#" onclick="traceToggle(event, 'trace-args-0')">PDOStatement->execute()</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">_result </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></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-1')">CORE/Cake/Model/Datasource/DboSource.php line 468</a> → <a href="#" onclick="traceToggle(event, 'trace-args-1')">DboSource->_execute()</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></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-2')">CORE/Cake/Model/Datasource/DboSource.php line 715</a> → <a href="#" onclick="traceToggle(event, 'trace-args-2')">DboSource->execute()</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></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-3')">CORE/Cake/Model/Datasource/DboSource.php line 641</a> → <a href="#" onclick="traceToggle(event, 'trace-args-3')">DboSource->fetchAll()</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: #007700">if (isset(</span><span style="color: #0000BB">$args</span><span style="color: #007700">[</span><span style="color: #0000BB">1</span><span style="color: #007700">]) && </span><span style="color: #0000BB">$args</span><span style="color: #007700">[</span><span style="color: #0000BB">1</span><span style="color: #007700">] === </span><span style="color: #0000BB">true</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">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">fetchAll</span><span style="color: #007700">(</span><span style="color: #0000BB">$args</span><span style="color: #007700">[</span><span style="color: #0000BB">0</span><span style="color: #007700">], </span><span style="color: #0000BB">true</span><span style="color: #007700">);</span></span></code> <code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">} elseif (isset(</span><span style="color: #0000BB">$args</span><span style="color: #007700">[</span><span style="color: #0000BB">1</span><span style="color: #007700">]) && !</span><span style="color: #0000BB">is_array</span><span style="color: #007700">(</span><span style="color: #0000BB">$args</span><span style="color: #007700">[</span><span style="color: #0000BB">1</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">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">fetchAll</span><span style="color: #007700">(</span><span style="color: #0000BB">$args</span><span style="color: #007700">[</span><span style="color: #0000BB">0</span><span style="color: #007700">], </span><span style="color: #0000BB">false</span><span style="color: #007700">);</span></span></code></span> <code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">} elseif (isset(</span><span style="color: #0000BB">$args</span><span style="color: #007700">[</span><span style="color: #0000BB">1</span><span style="color: #007700">]) && </span><span style="color: #0000BB">is_array</span><span style="color: #007700">(</span><span style="color: #0000BB">$args</span><span style="color: #007700">[</span><span style="color: #0000BB">1</span><span style="color: #007700">])) {</span></span></code></pre></div> <div id="trace-args-3" class="cake-code-dump" style="display: none;"><pre></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-4')">CORE/Cake/Model/Model.php line 3489</a> → <a href="#" onclick="traceToggle(event, 'trace-args-4')">DboSource->query()</a> <div id="file-excerpt-4" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB"> $params</span><span style="color: #007700">[] = </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">cacheQueries</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"> $db </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></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">call_user_func_array</span><span style="color: #007700">(array(&</span><span style="color: #0000BB">$db</span><span style="color: #007700">, </span><span style="color: #DD0000">'query'</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 style="color: #007700">}</span></span></code></pre></div> <div id="trace-args-4" class="cake-code-dump" style="display: none;"><pre></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-5')">APP/Controller/PagesController.php line 767</a> → <a href="#" onclick="traceToggle(event, 'trace-args-5')">Model->query()</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></code> <code><span style="color: #000000"><span style="color: #0000BB"> $sqlcarac </span><span style="color: #007700">= </span><span style="color: #DD0000">"SELECT pfc.id as cat_id, pfc.name as cat_name FROM product_field_categories pfc, product_fields pf, product_extras pe WHERE pf.product_field_category_id = pfc.id and pe.product_field_id = pf.id and pe.product_id = "</span><span style="color: #007700">.</span><span style="color: #0000BB">$idprod</span><span style="color: #007700">[</span><span style="color: #0000BB">0</span><span style="color: #007700">]. </span><span style="color: #DD0000">" GROUP BY pfc.id"</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"> $category_fields </span><span style="color: #007700">= </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">Product</span><span style="color: #007700">-></span><span style="color: #0000BB">query</span><span style="color: #007700">(</span><span style="color: #0000BB">$sqlcarac</span><span style="color: #007700">);</span></span></code></span> <code><span style="color: #000000"><span style="color: #0000BB"> $tabcarac </span><span style="color: #007700">= array();</span></span></code></pre></div> <div id="trace-args-5" class="cake-code-dump" style="display: none;"><pre></pre></div></li> <li><a href="#">[internal function]</a> → <a href="#" onclick="traceToggle(event, 'trace-args-6')">PagesController->detail_product()</a> <div id="trace-args-6" class="cake-code-dump" style="display: none;"><pre></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-7')">CORE/Cake/Controller/Controller.php line 499</a> → <a href="#" onclick="traceToggle(event, 'trace-args-7')">ReflectionMethod->invokeArgs()</a> <div id="file-excerpt-7" 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-7" class="cake-code-dump" style="display: none;"><pre></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-8')">CORE/Cake/Routing/Dispatcher.php line 193</a> → <a href="#" onclick="traceToggle(event, 'trace-args-8')">Controller->invokeAction()</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></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-8" class="cake-code-dump" style="display: none;"><pre></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-9')">CORE/Cake/Routing/Dispatcher.php line 167</a> → <a href="#" onclick="traceToggle(event, 'trace-args-9')">Dispatcher->_invoke()</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 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-9" class="cake-code-dump" style="display: none;"><pre></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-10')">APP/webroot/index.php line 117</a> → <a href="#" onclick="traceToggle(event, 'trace-args-10')">Dispatcher->dispatch()</a> <div id="file-excerpt-10" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB">$Dispatcher </span><span style="color: #007700">= new </span><span style="color: #0000BB">Dispatcher</span><span style="color: #007700">();</span></span></code> <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> <span class="code-highlight"><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> <code><span style="color: #000000"><span style="color: #0000BB"></span><span style="color: #007700">);</span></span></code></pre></div> <div id="trace-args-10" class="cake-code-dump" style="display: none;"><pre></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 'GROUP BY pfc.id' 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 'GROUP BY pfc.id' at line 1' $url = '/produit/35-TTJ' $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 'GROUP BY pfc.id' at line 1' ) queryString => 'SELECT pfc.id as cat_id, pfc.name as cat_name FROM product_field_categories pfc, product_fields pf, product_extras pe WHERE pf.product_field_category_id = pfc.id and pe.product_field_id = pf.id and pe.product_id = GROUP BY pfc.id' [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 'GROUP BY pfc.id' at line 1' [protected] code => '42000' [protected] file => '/home/geo4net/web/geo4net.com/public_html/lib/Cake/Model/Datasource/DboSource.php' [protected] line => (int) 502 } $_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 'GROUP BY pfc.id' at line 1</p> <p class="notice"> <strong>SQL Query: </strong> SELECT pfc.id as cat_id, pfc.name as cat_name FROM product_field_categories pfc, product_fields pf, product_extras pe WHERE pf.product_field_category_id = pfc.id and pe.product_field_id = pf.id and pe.product_id = GROUP BY pfc.id </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 502</a> → <a href="#" onclick="traceToggle(event, 'trace-args-0')">PDOStatement->execute()</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">_result </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></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-1')">CORE/Cake/Model/Datasource/DboSource.php line 468</a> → <a href="#" onclick="traceToggle(event, 'trace-args-1')">DboSource->_execute()</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></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-2')">CORE/Cake/Model/Datasource/DboSource.php line 715</a> → <a href="#" onclick="traceToggle(event, 'trace-args-2')">DboSource->execute()</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></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-3')">CORE/Cake/Model/Datasource/DboSource.php line 641</a> → <a href="#" onclick="traceToggle(event, 'trace-args-3')">DboSource->fetchAll()</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: #007700">if (isset(</span><span style="color: #0000BB">$args</span><span style="color: #007700">[</span><span style="color: #0000BB">1</span><span style="color: #007700">]) && </span><span style="color: #0000BB">$args</span><span style="color: #007700">[</span><span style="color: #0000BB">1</span><span style="color: #007700">] === </span><span style="color: #0000BB">true</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">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">fetchAll</span><span style="color: #007700">(</span><span style="color: #0000BB">$args</span><span style="color: #007700">[</span><span style="color: #0000BB">0</span><span style="color: #007700">], </span><span style="color: #0000BB">true</span><span style="color: #007700">);</span></span></code> <code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">} elseif (isset(</span><span style="color: #0000BB">$args</span><span style="color: #007700">[</span><span style="color: #0000BB">1</span><span style="color: #007700">]) && !</span><span style="color: #0000BB">is_array</span><span style="color: #007700">(</span><span style="color: #0000BB">$args</span><span style="color: #007700">[</span><span style="color: #0000BB">1</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">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">fetchAll</span><span style="color: #007700">(</span><span style="color: #0000BB">$args</span><span style="color: #007700">[</span><span style="color: #0000BB">0</span><span style="color: #007700">], </span><span style="color: #0000BB">false</span><span style="color: #007700">);</span></span></code></span> <code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">} elseif (isset(</span><span style="color: #0000BB">$args</span><span style="color: #007700">[</span><span style="color: #0000BB">1</span><span style="color: #007700">]) && </span><span style="color: #0000BB">is_array</span><span style="color: #007700">(</span><span style="color: #0000BB">$args</span><span style="color: #007700">[</span><span style="color: #0000BB">1</span><span style="color: #007700">])) {</span></span></code></pre></div> <div id="trace-args-3" class="cake-code-dump" style="display: none;"><pre></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-4')">CORE/Cake/Model/Model.php line 3489</a> → <a href="#" onclick="traceToggle(event, 'trace-args-4')">DboSource->query()</a> <div id="file-excerpt-4" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB"> $params</span><span style="color: #007700">[] = </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">cacheQueries</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"> $db </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></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">call_user_func_array</span><span style="color: #007700">(array(&</span><span style="color: #0000BB">$db</span><span style="color: #007700">, </span><span style="color: #DD0000">'query'</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 style="color: #007700">}</span></span></code></pre></div> <div id="trace-args-4" class="cake-code-dump" style="display: none;"><pre></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-5')">APP/Controller/PagesController.php line 767</a> → <a href="#" onclick="traceToggle(event, 'trace-args-5')">Model->query()</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></code> <code><span style="color: #000000"><span style="color: #0000BB"> $sqlcarac </span><span style="color: #007700">= </span><span style="color: #DD0000">"SELECT pfc.id as cat_id, pfc.name as cat_name FROM product_field_categories pfc, product_fields pf, product_extras pe WHERE pf.product_field_category_id = pfc.id and pe.product_field_id = pf.id and pe.product_id = "</span><span style="color: #007700">.</span><span style="color: #0000BB">$idprod</span><span style="color: #007700">[</span><span style="color: #0000BB">0</span><span style="color: #007700">]. </span><span style="color: #DD0000">" GROUP BY pfc.id"</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"> $category_fields </span><span style="color: #007700">= </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">Product</span><span style="color: #007700">-></span><span style="color: #0000BB">query</span><span style="color: #007700">(</span><span style="color: #0000BB">$sqlcarac</span><span style="color: #007700">);</span></span></code></span> <code><span style="color: #000000"><span style="color: #0000BB"> $tabcarac </span><span style="color: #007700">= array();</span></span></code></pre></div> <div id="trace-args-5" class="cake-code-dump" style="display: none;"><pre></pre></div></li> <li><a href="#">[internal function]</a> → <a href="#" onclick="traceToggle(event, 'trace-args-6')">PagesController->detail_product()</a> <div id="trace-args-6" class="cake-code-dump" style="display: none;"><pre></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-7')">CORE/Cake/Controller/Controller.php line 499</a> → <a href="#" onclick="traceToggle(event, 'trace-args-7')">ReflectionMethod->invokeArgs()</a> <div id="file-excerpt-7" 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-7" class="cake-code-dump" style="display: none;"><pre></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-8')">CORE/Cake/Routing/Dispatcher.php line 193</a> → <a href="#" onclick="traceToggle(event, 'trace-args-8')">Controller->invokeAction()</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></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-8" class="cake-code-dump" style="display: none;"><pre></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-9')">CORE/Cake/Routing/Dispatcher.php line 167</a> → <a href="#" onclick="traceToggle(event, 'trace-args-9')">Dispatcher->_invoke()</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 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-9" class="cake-code-dump" style="display: none;"><pre></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-10')">APP/webroot/index.php line 117</a> → <a href="#" onclick="traceToggle(event, 'trace-args-10')">Dispatcher->dispatch()</a> <div id="file-excerpt-10" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB">$Dispatcher </span><span style="color: #007700">= new </span><span style="color: #0000BB">Dispatcher</span><span style="color: #007700">();</span></span></code> <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> <span class="code-highlight"><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> <code><span style="color: #000000"><span style="color: #0000BB"></span><span style="color: #007700">);</span></span></code></pre></div> <div id="trace-args-10" class="cake-code-dump" style="display: none;"><pre></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'include - APP/View/Layouts/default.ctp, line 551 View::_evaluate() - CORE/Cake/View/View.php, line 971 View::_render() - CORE/Cake/View/View.php, line 933 View::renderLayout() - CORE/Cake/View/View.php, line 546 View::render() - CORE/Cake/View/View.php, line 481 Controller::render() - CORE/Cake/Controller/Controller.php, line 968 ExceptionRenderer::_outputMessage() - CORE/Cake/Error/ExceptionRenderer.php, line 292 ExceptionRenderer::pdoError() - CORE/Cake/Error/ExceptionRenderer.php, line 281 ExceptionRenderer::render() - CORE/Cake/Error/ExceptionRenderer.php, line 190 ErrorHandler::handleException() - CORE/Cake/Error/ErrorHandler.php, line 127 [main] - [internal], line ??
Warning (2): count(): Parameter must be an array or an object that implements Countable [APP/View/Layouts/default.ctp, line 551]0Code Context
<li class="drodown-show">
<a href="#"><span class="icon icon-MusicMixer"></span><span id="totcomp" class="total-pro"><?php echo count($comparators); ?></span></a>
$viewFile = '/home/geo4net/web/geo4net.com/public_html/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 'GROUP BY pfc.id' 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 'GROUP BY pfc.id' at line 1', 'url' => '/produit/35-TTJ', 'error' => object(PDOException) { errorInfo => array( [maximum depth reached] ) queryString => 'SELECT pfc.id as cat_id, pfc.name as cat_name FROM product_field_categories pfc, product_fields pf, product_extras pe WHERE pf.product_field_category_id = pfc.id and pe.product_field_id = pf.id and pe.product_id = GROUP BY pfc.id' [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 'GROUP BY pfc.id' at line 1' [protected] code => '42000' [protected] file => '/home/geo4net/web/geo4net.com/public_html/lib/Cake/Model/Datasource/DboSource.php' [protected] line => (int) 502 }, '_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 'GROUP BY pfc.id' at line 1</p> <p class="notice"> <strong>SQL Query: </strong> SELECT pfc.id as cat_id, pfc.name as cat_name FROM product_field_categories pfc, product_fields pf, product_extras pe WHERE pf.product_field_category_id = pfc.id and pe.product_field_id = pf.id and pe.product_id = GROUP BY pfc.id </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 502</a> → <a href="#" onclick="traceToggle(event, 'trace-args-0')">PDOStatement->execute()</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">_result </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></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-1')">CORE/Cake/Model/Datasource/DboSource.php line 468</a> → <a href="#" onclick="traceToggle(event, 'trace-args-1')">DboSource->_execute()</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></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-2')">CORE/Cake/Model/Datasource/DboSource.php line 715</a> → <a href="#" onclick="traceToggle(event, 'trace-args-2')">DboSource->execute()</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></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-3')">CORE/Cake/Model/Datasource/DboSource.php line 641</a> → <a href="#" onclick="traceToggle(event, 'trace-args-3')">DboSource->fetchAll()</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: #007700">if (isset(</span><span style="color: #0000BB">$args</span><span style="color: #007700">[</span><span style="color: #0000BB">1</span><span style="color: #007700">]) && </span><span style="color: #0000BB">$args</span><span style="color: #007700">[</span><span style="color: #0000BB">1</span><span style="color: #007700">] === </span><span style="color: #0000BB">true</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">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">fetchAll</span><span style="color: #007700">(</span><span style="color: #0000BB">$args</span><span style="color: #007700">[</span><span style="color: #0000BB">0</span><span style="color: #007700">], </span><span style="color: #0000BB">true</span><span style="color: #007700">);</span></span></code> <code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">} elseif (isset(</span><span style="color: #0000BB">$args</span><span style="color: #007700">[</span><span style="color: #0000BB">1</span><span style="color: #007700">]) && !</span><span style="color: #0000BB">is_array</span><span style="color: #007700">(</span><span style="color: #0000BB">$args</span><span style="color: #007700">[</span><span style="color: #0000BB">1</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">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">fetchAll</span><span style="color: #007700">(</span><span style="color: #0000BB">$args</span><span style="color: #007700">[</span><span style="color: #0000BB">0</span><span style="color: #007700">], </span><span style="color: #0000BB">false</span><span style="color: #007700">);</span></span></code></span> <code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">} elseif (isset(</span><span style="color: #0000BB">$args</span><span style="color: #007700">[</span><span style="color: #0000BB">1</span><span style="color: #007700">]) && </span><span style="color: #0000BB">is_array</span><span style="color: #007700">(</span><span style="color: #0000BB">$args</span><span style="color: #007700">[</span><span style="color: #0000BB">1</span><span style="color: #007700">])) {</span></span></code></pre></div> <div id="trace-args-3" class="cake-code-dump" style="display: none;"><pre></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-4')">CORE/Cake/Model/Model.php line 3489</a> → <a href="#" onclick="traceToggle(event, 'trace-args-4')">DboSource->query()</a> <div id="file-excerpt-4" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB"> $params</span><span style="color: #007700">[] = </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">cacheQueries</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"> $db </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></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">call_user_func_array</span><span style="color: #007700">(array(&</span><span style="color: #0000BB">$db</span><span style="color: #007700">, </span><span style="color: #DD0000">'query'</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 style="color: #007700">}</span></span></code></pre></div> <div id="trace-args-4" class="cake-code-dump" style="display: none;"><pre></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-5')">APP/Controller/PagesController.php line 767</a> → <a href="#" onclick="traceToggle(event, 'trace-args-5')">Model->query()</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></code> <code><span style="color: #000000"><span style="color: #0000BB"> $sqlcarac </span><span style="color: #007700">= </span><span style="color: #DD0000">"SELECT pfc.id as cat_id, pfc.name as cat_name FROM product_field_categories pfc, product_fields pf, product_extras pe WHERE pf.product_field_category_id = pfc.id and pe.product_field_id = pf.id and pe.product_id = "</span><span style="color: #007700">.</span><span style="color: #0000BB">$idprod</span><span style="color: #007700">[</span><span style="color: #0000BB">0</span><span style="color: #007700">]. </span><span style="color: #DD0000">" GROUP BY pfc.id"</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"> $category_fields </span><span style="color: #007700">= </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">Product</span><span style="color: #007700">-></span><span style="color: #0000BB">query</span><span style="color: #007700">(</span><span style="color: #0000BB">$sqlcarac</span><span style="color: #007700">);</span></span></code></span> <code><span style="color: #000000"><span style="color: #0000BB"> $tabcarac </span><span style="color: #007700">= array();</span></span></code></pre></div> <div id="trace-args-5" class="cake-code-dump" style="display: none;"><pre></pre></div></li> <li><a href="#">[internal function]</a> → <a href="#" onclick="traceToggle(event, 'trace-args-6')">PagesController->detail_product()</a> <div id="trace-args-6" class="cake-code-dump" style="display: none;"><pre></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-7')">CORE/Cake/Controller/Controller.php line 499</a> → <a href="#" onclick="traceToggle(event, 'trace-args-7')">ReflectionMethod->invokeArgs()</a> <div id="file-excerpt-7" 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-7" class="cake-code-dump" style="display: none;"><pre></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-8')">CORE/Cake/Routing/Dispatcher.php line 193</a> → <a href="#" onclick="traceToggle(event, 'trace-args-8')">Controller->invokeAction()</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></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-8" class="cake-code-dump" style="display: none;"><pre></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-9')">CORE/Cake/Routing/Dispatcher.php line 167</a> → <a href="#" onclick="traceToggle(event, 'trace-args-9')">Dispatcher->_invoke()</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 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-9" class="cake-code-dump" style="display: none;"><pre></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-10')">APP/webroot/index.php line 117</a> → <a href="#" onclick="traceToggle(event, 'trace-args-10')">Dispatcher->dispatch()</a> <div id="file-excerpt-10" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB">$Dispatcher </span><span style="color: #007700">= new </span><span style="color: #0000BB">Dispatcher</span><span style="color: #007700">();</span></span></code> <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> <span class="code-highlight"><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> <code><span style="color: #000000"><span style="color: #0000BB"></span><span style="color: #007700">);</span></span></code></pre></div> <div id="trace-args-10" class="cake-code-dump" style="display: none;"><pre></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 'GROUP BY pfc.id' 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 'GROUP BY pfc.id' at line 1' $url = '/produit/35-TTJ' $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 'GROUP BY pfc.id' at line 1' ) queryString => 'SELECT pfc.id as cat_id, pfc.name as cat_name FROM product_field_categories pfc, product_fields pf, product_extras pe WHERE pf.product_field_category_id = pfc.id and pe.product_field_id = pf.id and pe.product_id = GROUP BY pfc.id' [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 'GROUP BY pfc.id' at line 1' [protected] code => '42000' [protected] file => '/home/geo4net/web/geo4net.com/public_html/lib/Cake/Model/Datasource/DboSource.php' [protected] line => (int) 502 } $_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 'GROUP BY pfc.id' at line 1</p> <p class="notice"> <strong>SQL Query: </strong> SELECT pfc.id as cat_id, pfc.name as cat_name FROM product_field_categories pfc, product_fields pf, product_extras pe WHERE pf.product_field_category_id = pfc.id and pe.product_field_id = pf.id and pe.product_id = GROUP BY pfc.id </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 502</a> → <a href="#" onclick="traceToggle(event, 'trace-args-0')">PDOStatement->execute()</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">_result </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></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-1')">CORE/Cake/Model/Datasource/DboSource.php line 468</a> → <a href="#" onclick="traceToggle(event, 'trace-args-1')">DboSource->_execute()</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></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-2')">CORE/Cake/Model/Datasource/DboSource.php line 715</a> → <a href="#" onclick="traceToggle(event, 'trace-args-2')">DboSource->execute()</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></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-3')">CORE/Cake/Model/Datasource/DboSource.php line 641</a> → <a href="#" onclick="traceToggle(event, 'trace-args-3')">DboSource->fetchAll()</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: #007700">if (isset(</span><span style="color: #0000BB">$args</span><span style="color: #007700">[</span><span style="color: #0000BB">1</span><span style="color: #007700">]) && </span><span style="color: #0000BB">$args</span><span style="color: #007700">[</span><span style="color: #0000BB">1</span><span style="color: #007700">] === </span><span style="color: #0000BB">true</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">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">fetchAll</span><span style="color: #007700">(</span><span style="color: #0000BB">$args</span><span style="color: #007700">[</span><span style="color: #0000BB">0</span><span style="color: #007700">], </span><span style="color: #0000BB">true</span><span style="color: #007700">);</span></span></code> <code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">} elseif (isset(</span><span style="color: #0000BB">$args</span><span style="color: #007700">[</span><span style="color: #0000BB">1</span><span style="color: #007700">]) && !</span><span style="color: #0000BB">is_array</span><span style="color: #007700">(</span><span style="color: #0000BB">$args</span><span style="color: #007700">[</span><span style="color: #0000BB">1</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">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">fetchAll</span><span style="color: #007700">(</span><span style="color: #0000BB">$args</span><span style="color: #007700">[</span><span style="color: #0000BB">0</span><span style="color: #007700">], </span><span style="color: #0000BB">false</span><span style="color: #007700">);</span></span></code></span> <code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">} elseif (isset(</span><span style="color: #0000BB">$args</span><span style="color: #007700">[</span><span style="color: #0000BB">1</span><span style="color: #007700">]) && </span><span style="color: #0000BB">is_array</span><span style="color: #007700">(</span><span style="color: #0000BB">$args</span><span style="color: #007700">[</span><span style="color: #0000BB">1</span><span style="color: #007700">])) {</span></span></code></pre></div> <div id="trace-args-3" class="cake-code-dump" style="display: none;"><pre></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-4')">CORE/Cake/Model/Model.php line 3489</a> → <a href="#" onclick="traceToggle(event, 'trace-args-4')">DboSource->query()</a> <div id="file-excerpt-4" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB"> $params</span><span style="color: #007700">[] = </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">cacheQueries</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"> $db </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></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">call_user_func_array</span><span style="color: #007700">(array(&</span><span style="color: #0000BB">$db</span><span style="color: #007700">, </span><span style="color: #DD0000">'query'</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 style="color: #007700">}</span></span></code></pre></div> <div id="trace-args-4" class="cake-code-dump" style="display: none;"><pre></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-5')">APP/Controller/PagesController.php line 767</a> → <a href="#" onclick="traceToggle(event, 'trace-args-5')">Model->query()</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></code> <code><span style="color: #000000"><span style="color: #0000BB"> $sqlcarac </span><span style="color: #007700">= </span><span style="color: #DD0000">"SELECT pfc.id as cat_id, pfc.name as cat_name FROM product_field_categories pfc, product_fields pf, product_extras pe WHERE pf.product_field_category_id = pfc.id and pe.product_field_id = pf.id and pe.product_id = "</span><span style="color: #007700">.</span><span style="color: #0000BB">$idprod</span><span style="color: #007700">[</span><span style="color: #0000BB">0</span><span style="color: #007700">]. </span><span style="color: #DD0000">" GROUP BY pfc.id"</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"> $category_fields </span><span style="color: #007700">= </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">Product</span><span style="color: #007700">-></span><span style="color: #0000BB">query</span><span style="color: #007700">(</span><span style="color: #0000BB">$sqlcarac</span><span style="color: #007700">);</span></span></code></span> <code><span style="color: #000000"><span style="color: #0000BB"> $tabcarac </span><span style="color: #007700">= array();</span></span></code></pre></div> <div id="trace-args-5" class="cake-code-dump" style="display: none;"><pre></pre></div></li> <li><a href="#">[internal function]</a> → <a href="#" onclick="traceToggle(event, 'trace-args-6')">PagesController->detail_product()</a> <div id="trace-args-6" class="cake-code-dump" style="display: none;"><pre></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-7')">CORE/Cake/Controller/Controller.php line 499</a> → <a href="#" onclick="traceToggle(event, 'trace-args-7')">ReflectionMethod->invokeArgs()</a> <div id="file-excerpt-7" 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-7" class="cake-code-dump" style="display: none;"><pre></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-8')">CORE/Cake/Routing/Dispatcher.php line 193</a> → <a href="#" onclick="traceToggle(event, 'trace-args-8')">Controller->invokeAction()</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></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-8" class="cake-code-dump" style="display: none;"><pre></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-9')">CORE/Cake/Routing/Dispatcher.php line 167</a> → <a href="#" onclick="traceToggle(event, 'trace-args-9')">Dispatcher->_invoke()</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 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-9" class="cake-code-dump" style="display: none;"><pre></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-10')">APP/webroot/index.php line 117</a> → <a href="#" onclick="traceToggle(event, 'trace-args-10')">Dispatcher->dispatch()</a> <div id="file-excerpt-10" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB">$Dispatcher </span><span style="color: #007700">= new </span><span style="color: #0000BB">Dispatcher</span><span style="color: #007700">();</span></span></code> <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> <span class="code-highlight"><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> <code><span style="color: #000000"><span style="color: #0000BB"></span><span style="color: #007700">);</span></span></code></pre></div> <div id="trace-args-10" class="cake-code-dump" style="display: none;"><pre></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'include - APP/View/Layouts/default.ctp, line 551 View::_evaluate() - CORE/Cake/View/View.php, line 971 View::_render() - CORE/Cake/View/View.php, line 933 View::renderLayout() - CORE/Cake/View/View.php, line 546 View::render() - CORE/Cake/View/View.php, line 481 Controller::render() - CORE/Cake/Controller/Controller.php, line 968 ExceptionRenderer::_outputMessage() - CORE/Cake/Error/ExceptionRenderer.php, line 292 ExceptionRenderer::pdoError() - CORE/Cake/Error/ExceptionRenderer.php, line 281 ExceptionRenderer::render() - CORE/Cake/Error/ExceptionRenderer.php, line 190 ErrorHandler::handleException() - CORE/Cake/Error/ErrorHandler.php, line 127 [main] - [internal], line ??
Notice (8): Undefined variable: comparators [APP/View/Layouts/default.ctp, line 555]Code Context<li>
<?php
foreach($comparators as $comparator)
$viewFile = '/home/geo4net/web/geo4net.com/public_html/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 'GROUP BY pfc.id' 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 'GROUP BY pfc.id' at line 1', 'url' => '/produit/35-TTJ', 'error' => object(PDOException) { errorInfo => array( [maximum depth reached] ) queryString => 'SELECT pfc.id as cat_id, pfc.name as cat_name FROM product_field_categories pfc, product_fields pf, product_extras pe WHERE pf.product_field_category_id = pfc.id and pe.product_field_id = pf.id and pe.product_id = GROUP BY pfc.id' [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 'GROUP BY pfc.id' at line 1' [protected] code => '42000' [protected] file => '/home/geo4net/web/geo4net.com/public_html/lib/Cake/Model/Datasource/DboSource.php' [protected] line => (int) 502 }, '_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 'GROUP BY pfc.id' at line 1</p> <p class="notice"> <strong>SQL Query: </strong> SELECT pfc.id as cat_id, pfc.name as cat_name FROM product_field_categories pfc, product_fields pf, product_extras pe WHERE pf.product_field_category_id = pfc.id and pe.product_field_id = pf.id and pe.product_id = GROUP BY pfc.id </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 502</a> → <a href="#" onclick="traceToggle(event, 'trace-args-0')">PDOStatement->execute()</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">_result </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></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-1')">CORE/Cake/Model/Datasource/DboSource.php line 468</a> → <a href="#" onclick="traceToggle(event, 'trace-args-1')">DboSource->_execute()</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></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-2')">CORE/Cake/Model/Datasource/DboSource.php line 715</a> → <a href="#" onclick="traceToggle(event, 'trace-args-2')">DboSource->execute()</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></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-3')">CORE/Cake/Model/Datasource/DboSource.php line 641</a> → <a href="#" onclick="traceToggle(event, 'trace-args-3')">DboSource->fetchAll()</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: #007700">if (isset(</span><span style="color: #0000BB">$args</span><span style="color: #007700">[</span><span style="color: #0000BB">1</span><span style="color: #007700">]) && </span><span style="color: #0000BB">$args</span><span style="color: #007700">[</span><span style="color: #0000BB">1</span><span style="color: #007700">] === </span><span style="color: #0000BB">true</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">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">fetchAll</span><span style="color: #007700">(</span><span style="color: #0000BB">$args</span><span style="color: #007700">[</span><span style="color: #0000BB">0</span><span style="color: #007700">], </span><span style="color: #0000BB">true</span><span style="color: #007700">);</span></span></code> <code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">} elseif (isset(</span><span style="color: #0000BB">$args</span><span style="color: #007700">[</span><span style="color: #0000BB">1</span><span style="color: #007700">]) && !</span><span style="color: #0000BB">is_array</span><span style="color: #007700">(</span><span style="color: #0000BB">$args</span><span style="color: #007700">[</span><span style="color: #0000BB">1</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">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">fetchAll</span><span style="color: #007700">(</span><span style="color: #0000BB">$args</span><span style="color: #007700">[</span><span style="color: #0000BB">0</span><span style="color: #007700">], </span><span style="color: #0000BB">false</span><span style="color: #007700">);</span></span></code></span> <code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">} elseif (isset(</span><span style="color: #0000BB">$args</span><span style="color: #007700">[</span><span style="color: #0000BB">1</span><span style="color: #007700">]) && </span><span style="color: #0000BB">is_array</span><span style="color: #007700">(</span><span style="color: #0000BB">$args</span><span style="color: #007700">[</span><span style="color: #0000BB">1</span><span style="color: #007700">])) {</span></span></code></pre></div> <div id="trace-args-3" class="cake-code-dump" style="display: none;"><pre></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-4')">CORE/Cake/Model/Model.php line 3489</a> → <a href="#" onclick="traceToggle(event, 'trace-args-4')">DboSource->query()</a> <div id="file-excerpt-4" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB"> $params</span><span style="color: #007700">[] = </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">cacheQueries</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"> $db </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></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">call_user_func_array</span><span style="color: #007700">(array(&</span><span style="color: #0000BB">$db</span><span style="color: #007700">, </span><span style="color: #DD0000">'query'</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 style="color: #007700">}</span></span></code></pre></div> <div id="trace-args-4" class="cake-code-dump" style="display: none;"><pre></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-5')">APP/Controller/PagesController.php line 767</a> → <a href="#" onclick="traceToggle(event, 'trace-args-5')">Model->query()</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></code> <code><span style="color: #000000"><span style="color: #0000BB"> $sqlcarac </span><span style="color: #007700">= </span><span style="color: #DD0000">"SELECT pfc.id as cat_id, pfc.name as cat_name FROM product_field_categories pfc, product_fields pf, product_extras pe WHERE pf.product_field_category_id = pfc.id and pe.product_field_id = pf.id and pe.product_id = "</span><span style="color: #007700">.</span><span style="color: #0000BB">$idprod</span><span style="color: #007700">[</span><span style="color: #0000BB">0</span><span style="color: #007700">]. </span><span style="color: #DD0000">" GROUP BY pfc.id"</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"> $category_fields </span><span style="color: #007700">= </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">Product</span><span style="color: #007700">-></span><span style="color: #0000BB">query</span><span style="color: #007700">(</span><span style="color: #0000BB">$sqlcarac</span><span style="color: #007700">);</span></span></code></span> <code><span style="color: #000000"><span style="color: #0000BB"> $tabcarac </span><span style="color: #007700">= array();</span></span></code></pre></div> <div id="trace-args-5" class="cake-code-dump" style="display: none;"><pre></pre></div></li> <li><a href="#">[internal function]</a> → <a href="#" onclick="traceToggle(event, 'trace-args-6')">PagesController->detail_product()</a> <div id="trace-args-6" class="cake-code-dump" style="display: none;"><pre></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-7')">CORE/Cake/Controller/Controller.php line 499</a> → <a href="#" onclick="traceToggle(event, 'trace-args-7')">ReflectionMethod->invokeArgs()</a> <div id="file-excerpt-7" 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-7" class="cake-code-dump" style="display: none;"><pre></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-8')">CORE/Cake/Routing/Dispatcher.php line 193</a> → <a href="#" onclick="traceToggle(event, 'trace-args-8')">Controller->invokeAction()</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></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-8" class="cake-code-dump" style="display: none;"><pre></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-9')">CORE/Cake/Routing/Dispatcher.php line 167</a> → <a href="#" onclick="traceToggle(event, 'trace-args-9')">Dispatcher->_invoke()</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 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-9" class="cake-code-dump" style="display: none;"><pre></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-10')">APP/webroot/index.php line 117</a> → <a href="#" onclick="traceToggle(event, 'trace-args-10')">Dispatcher->dispatch()</a> <div id="file-excerpt-10" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB">$Dispatcher </span><span style="color: #007700">= new </span><span style="color: #0000BB">Dispatcher</span><span style="color: #007700">();</span></span></code> <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> <span class="code-highlight"><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> <code><span style="color: #000000"><span style="color: #0000BB"></span><span style="color: #007700">);</span></span></code></pre></div> <div id="trace-args-10" class="cake-code-dump" style="display: none;"><pre></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 'GROUP BY pfc.id' 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 'GROUP BY pfc.id' at line 1' $url = '/produit/35-TTJ' $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 'GROUP BY pfc.id' at line 1' ) queryString => 'SELECT pfc.id as cat_id, pfc.name as cat_name FROM product_field_categories pfc, product_fields pf, product_extras pe WHERE pf.product_field_category_id = pfc.id and pe.product_field_id = pf.id and pe.product_id = GROUP BY pfc.id' [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 'GROUP BY pfc.id' at line 1' [protected] code => '42000' [protected] file => '/home/geo4net/web/geo4net.com/public_html/lib/Cake/Model/Datasource/DboSource.php' [protected] line => (int) 502 } $_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 'GROUP BY pfc.id' at line 1</p> <p class="notice"> <strong>SQL Query: </strong> SELECT pfc.id as cat_id, pfc.name as cat_name FROM product_field_categories pfc, product_fields pf, product_extras pe WHERE pf.product_field_category_id = pfc.id and pe.product_field_id = pf.id and pe.product_id = GROUP BY pfc.id </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 502</a> → <a href="#" onclick="traceToggle(event, 'trace-args-0')">PDOStatement->execute()</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">_result </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></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-1')">CORE/Cake/Model/Datasource/DboSource.php line 468</a> → <a href="#" onclick="traceToggle(event, 'trace-args-1')">DboSource->_execute()</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></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-2')">CORE/Cake/Model/Datasource/DboSource.php line 715</a> → <a href="#" onclick="traceToggle(event, 'trace-args-2')">DboSource->execute()</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></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-3')">CORE/Cake/Model/Datasource/DboSource.php line 641</a> → <a href="#" onclick="traceToggle(event, 'trace-args-3')">DboSource->fetchAll()</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: #007700">if (isset(</span><span style="color: #0000BB">$args</span><span style="color: #007700">[</span><span style="color: #0000BB">1</span><span style="color: #007700">]) && </span><span style="color: #0000BB">$args</span><span style="color: #007700">[</span><span style="color: #0000BB">1</span><span style="color: #007700">] === </span><span style="color: #0000BB">true</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">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">fetchAll</span><span style="color: #007700">(</span><span style="color: #0000BB">$args</span><span style="color: #007700">[</span><span style="color: #0000BB">0</span><span style="color: #007700">], </span><span style="color: #0000BB">true</span><span style="color: #007700">);</span></span></code> <code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">} elseif (isset(</span><span style="color: #0000BB">$args</span><span style="color: #007700">[</span><span style="color: #0000BB">1</span><span style="color: #007700">]) && !</span><span style="color: #0000BB">is_array</span><span style="color: #007700">(</span><span style="color: #0000BB">$args</span><span style="color: #007700">[</span><span style="color: #0000BB">1</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">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">fetchAll</span><span style="color: #007700">(</span><span style="color: #0000BB">$args</span><span style="color: #007700">[</span><span style="color: #0000BB">0</span><span style="color: #007700">], </span><span style="color: #0000BB">false</span><span style="color: #007700">);</span></span></code></span> <code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">} elseif (isset(</span><span style="color: #0000BB">$args</span><span style="color: #007700">[</span><span style="color: #0000BB">1</span><span style="color: #007700">]) && </span><span style="color: #0000BB">is_array</span><span style="color: #007700">(</span><span style="color: #0000BB">$args</span><span style="color: #007700">[</span><span style="color: #0000BB">1</span><span style="color: #007700">])) {</span></span></code></pre></div> <div id="trace-args-3" class="cake-code-dump" style="display: none;"><pre></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-4')">CORE/Cake/Model/Model.php line 3489</a> → <a href="#" onclick="traceToggle(event, 'trace-args-4')">DboSource->query()</a> <div id="file-excerpt-4" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB"> $params</span><span style="color: #007700">[] = </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">cacheQueries</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"> $db </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></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">call_user_func_array</span><span style="color: #007700">(array(&</span><span style="color: #0000BB">$db</span><span style="color: #007700">, </span><span style="color: #DD0000">'query'</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 style="color: #007700">}</span></span></code></pre></div> <div id="trace-args-4" class="cake-code-dump" style="display: none;"><pre></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-5')">APP/Controller/PagesController.php line 767</a> → <a href="#" onclick="traceToggle(event, 'trace-args-5')">Model->query()</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></code> <code><span style="color: #000000"><span style="color: #0000BB"> $sqlcarac </span><span style="color: #007700">= </span><span style="color: #DD0000">"SELECT pfc.id as cat_id, pfc.name as cat_name FROM product_field_categories pfc, product_fields pf, product_extras pe WHERE pf.product_field_category_id = pfc.id and pe.product_field_id = pf.id and pe.product_id = "</span><span style="color: #007700">.</span><span style="color: #0000BB">$idprod</span><span style="color: #007700">[</span><span style="color: #0000BB">0</span><span style="color: #007700">]. </span><span style="color: #DD0000">" GROUP BY pfc.id"</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"> $category_fields </span><span style="color: #007700">= </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">Product</span><span style="color: #007700">-></span><span style="color: #0000BB">query</span><span style="color: #007700">(</span><span style="color: #0000BB">$sqlcarac</span><span style="color: #007700">);</span></span></code></span> <code><span style="color: #000000"><span style="color: #0000BB"> $tabcarac </span><span style="color: #007700">= array();</span></span></code></pre></div> <div id="trace-args-5" class="cake-code-dump" style="display: none;"><pre></pre></div></li> <li><a href="#">[internal function]</a> → <a href="#" onclick="traceToggle(event, 'trace-args-6')">PagesController->detail_product()</a> <div id="trace-args-6" class="cake-code-dump" style="display: none;"><pre></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-7')">CORE/Cake/Controller/Controller.php line 499</a> → <a href="#" onclick="traceToggle(event, 'trace-args-7')">ReflectionMethod->invokeArgs()</a> <div id="file-excerpt-7" 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-7" class="cake-code-dump" style="display: none;"><pre></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-8')">CORE/Cake/Routing/Dispatcher.php line 193</a> → <a href="#" onclick="traceToggle(event, 'trace-args-8')">Controller->invokeAction()</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></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-8" class="cake-code-dump" style="display: none;"><pre></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-9')">CORE/Cake/Routing/Dispatcher.php line 167</a> → <a href="#" onclick="traceToggle(event, 'trace-args-9')">Dispatcher->_invoke()</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 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-9" class="cake-code-dump" style="display: none;"><pre></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-10')">APP/webroot/index.php line 117</a> → <a href="#" onclick="traceToggle(event, 'trace-args-10')">Dispatcher->dispatch()</a> <div id="file-excerpt-10" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB">$Dispatcher </span><span style="color: #007700">= new </span><span style="color: #0000BB">Dispatcher</span><span style="color: #007700">();</span></span></code> <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> <span class="code-highlight"><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> <code><span style="color: #000000"><span style="color: #0000BB"></span><span style="color: #007700">);</span></span></code></pre></div> <div id="trace-args-10" class="cake-code-dump" style="display: none;"><pre></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'include - APP/View/Layouts/default.ctp, line 555 View::_evaluate() - CORE/Cake/View/View.php, line 971 View::_render() - CORE/Cake/View/View.php, line 933 View::renderLayout() - CORE/Cake/View/View.php, line 546 View::render() - CORE/Cake/View/View.php, line 481 Controller::render() - CORE/Cake/Controller/Controller.php, line 968 ExceptionRenderer::_outputMessage() - CORE/Cake/Error/ExceptionRenderer.php, line 292 ExceptionRenderer::pdoError() - CORE/Cake/Error/ExceptionRenderer.php, line 281 ExceptionRenderer::render() - CORE/Cake/Error/ExceptionRenderer.php, line 190 ErrorHandler::handleException() - CORE/Cake/Error/ErrorHandler.php, line 127 [main] - [internal], line ??
Warning (2): Invalid argument supplied for foreach() [APP/View/Layouts/default.ctp, line 555]Code Context<li>
<?php
foreach($comparators as $comparator)
$viewFile = '/home/geo4net/web/geo4net.com/public_html/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 'GROUP BY pfc.id' 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 'GROUP BY pfc.id' at line 1', 'url' => '/produit/35-TTJ', 'error' => object(PDOException) { errorInfo => array( [maximum depth reached] ) queryString => 'SELECT pfc.id as cat_id, pfc.name as cat_name FROM product_field_categories pfc, product_fields pf, product_extras pe WHERE pf.product_field_category_id = pfc.id and pe.product_field_id = pf.id and pe.product_id = GROUP BY pfc.id' [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 'GROUP BY pfc.id' at line 1' [protected] code => '42000' [protected] file => '/home/geo4net/web/geo4net.com/public_html/lib/Cake/Model/Datasource/DboSource.php' [protected] line => (int) 502 }, '_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 'GROUP BY pfc.id' at line 1</p> <p class="notice"> <strong>SQL Query: </strong> SELECT pfc.id as cat_id, pfc.name as cat_name FROM product_field_categories pfc, product_fields pf, product_extras pe WHERE pf.product_field_category_id = pfc.id and pe.product_field_id = pf.id and pe.product_id = GROUP BY pfc.id </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 502</a> → <a href="#" onclick="traceToggle(event, 'trace-args-0')">PDOStatement->execute()</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">_result </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></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-1')">CORE/Cake/Model/Datasource/DboSource.php line 468</a> → <a href="#" onclick="traceToggle(event, 'trace-args-1')">DboSource->_execute()</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></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-2')">CORE/Cake/Model/Datasource/DboSource.php line 715</a> → <a href="#" onclick="traceToggle(event, 'trace-args-2')">DboSource->execute()</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></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-3')">CORE/Cake/Model/Datasource/DboSource.php line 641</a> → <a href="#" onclick="traceToggle(event, 'trace-args-3')">DboSource->fetchAll()</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: #007700">if (isset(</span><span style="color: #0000BB">$args</span><span style="color: #007700">[</span><span style="color: #0000BB">1</span><span style="color: #007700">]) && </span><span style="color: #0000BB">$args</span><span style="color: #007700">[</span><span style="color: #0000BB">1</span><span style="color: #007700">] === </span><span style="color: #0000BB">true</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">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">fetchAll</span><span style="color: #007700">(</span><span style="color: #0000BB">$args</span><span style="color: #007700">[</span><span style="color: #0000BB">0</span><span style="color: #007700">], </span><span style="color: #0000BB">true</span><span style="color: #007700">);</span></span></code> <code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">} elseif (isset(</span><span style="color: #0000BB">$args</span><span style="color: #007700">[</span><span style="color: #0000BB">1</span><span style="color: #007700">]) && !</span><span style="color: #0000BB">is_array</span><span style="color: #007700">(</span><span style="color: #0000BB">$args</span><span style="color: #007700">[</span><span style="color: #0000BB">1</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">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">fetchAll</span><span style="color: #007700">(</span><span style="color: #0000BB">$args</span><span style="color: #007700">[</span><span style="color: #0000BB">0</span><span style="color: #007700">], </span><span style="color: #0000BB">false</span><span style="color: #007700">);</span></span></code></span> <code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">} elseif (isset(</span><span style="color: #0000BB">$args</span><span style="color: #007700">[</span><span style="color: #0000BB">1</span><span style="color: #007700">]) && </span><span style="color: #0000BB">is_array</span><span style="color: #007700">(</span><span style="color: #0000BB">$args</span><span style="color: #007700">[</span><span style="color: #0000BB">1</span><span style="color: #007700">])) {</span></span></code></pre></div> <div id="trace-args-3" class="cake-code-dump" style="display: none;"><pre></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-4')">CORE/Cake/Model/Model.php line 3489</a> → <a href="#" onclick="traceToggle(event, 'trace-args-4')">DboSource->query()</a> <div id="file-excerpt-4" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB"> $params</span><span style="color: #007700">[] = </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">cacheQueries</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"> $db </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></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">call_user_func_array</span><span style="color: #007700">(array(&</span><span style="color: #0000BB">$db</span><span style="color: #007700">, </span><span style="color: #DD0000">'query'</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 style="color: #007700">}</span></span></code></pre></div> <div id="trace-args-4" class="cake-code-dump" style="display: none;"><pre></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-5')">APP/Controller/PagesController.php line 767</a> → <a href="#" onclick="traceToggle(event, 'trace-args-5')">Model->query()</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></code> <code><span style="color: #000000"><span style="color: #0000BB"> $sqlcarac </span><span style="color: #007700">= </span><span style="color: #DD0000">"SELECT pfc.id as cat_id, pfc.name as cat_name FROM product_field_categories pfc, product_fields pf, product_extras pe WHERE pf.product_field_category_id = pfc.id and pe.product_field_id = pf.id and pe.product_id = "</span><span style="color: #007700">.</span><span style="color: #0000BB">$idprod</span><span style="color: #007700">[</span><span style="color: #0000BB">0</span><span style="color: #007700">]. </span><span style="color: #DD0000">" GROUP BY pfc.id"</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"> $category_fields </span><span style="color: #007700">= </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">Product</span><span style="color: #007700">-></span><span style="color: #0000BB">query</span><span style="color: #007700">(</span><span style="color: #0000BB">$sqlcarac</span><span style="color: #007700">);</span></span></code></span> <code><span style="color: #000000"><span style="color: #0000BB"> $tabcarac </span><span style="color: #007700">= array();</span></span></code></pre></div> <div id="trace-args-5" class="cake-code-dump" style="display: none;"><pre></pre></div></li> <li><a href="#">[internal function]</a> → <a href="#" onclick="traceToggle(event, 'trace-args-6')">PagesController->detail_product()</a> <div id="trace-args-6" class="cake-code-dump" style="display: none;"><pre></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-7')">CORE/Cake/Controller/Controller.php line 499</a> → <a href="#" onclick="traceToggle(event, 'trace-args-7')">ReflectionMethod->invokeArgs()</a> <div id="file-excerpt-7" 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-7" class="cake-code-dump" style="display: none;"><pre></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-8')">CORE/Cake/Routing/Dispatcher.php line 193</a> → <a href="#" onclick="traceToggle(event, 'trace-args-8')">Controller->invokeAction()</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></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-8" class="cake-code-dump" style="display: none;"><pre></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-9')">CORE/Cake/Routing/Dispatcher.php line 167</a> → <a href="#" onclick="traceToggle(event, 'trace-args-9')">Dispatcher->_invoke()</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 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-9" class="cake-code-dump" style="display: none;"><pre></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-10')">APP/webroot/index.php line 117</a> → <a href="#" onclick="traceToggle(event, 'trace-args-10')">Dispatcher->dispatch()</a> <div id="file-excerpt-10" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB">$Dispatcher </span><span style="color: #007700">= new </span><span style="color: #0000BB">Dispatcher</span><span style="color: #007700">();</span></span></code> <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> <span class="code-highlight"><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> <code><span style="color: #000000"><span style="color: #0000BB"></span><span style="color: #007700">);</span></span></code></pre></div> <div id="trace-args-10" class="cake-code-dump" style="display: none;"><pre></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 'GROUP BY pfc.id' 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 'GROUP BY pfc.id' at line 1' $url = '/produit/35-TTJ' $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 'GROUP BY pfc.id' at line 1' ) queryString => 'SELECT pfc.id as cat_id, pfc.name as cat_name FROM product_field_categories pfc, product_fields pf, product_extras pe WHERE pf.product_field_category_id = pfc.id and pe.product_field_id = pf.id and pe.product_id = GROUP BY pfc.id' [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 'GROUP BY pfc.id' at line 1' [protected] code => '42000' [protected] file => '/home/geo4net/web/geo4net.com/public_html/lib/Cake/Model/Datasource/DboSource.php' [protected] line => (int) 502 } $_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 'GROUP BY pfc.id' at line 1</p> <p class="notice"> <strong>SQL Query: </strong> SELECT pfc.id as cat_id, pfc.name as cat_name FROM product_field_categories pfc, product_fields pf, product_extras pe WHERE pf.product_field_category_id = pfc.id and pe.product_field_id = pf.id and pe.product_id = GROUP BY pfc.id </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 502</a> → <a href="#" onclick="traceToggle(event, 'trace-args-0')">PDOStatement->execute()</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">_result </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></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-1')">CORE/Cake/Model/Datasource/DboSource.php line 468</a> → <a href="#" onclick="traceToggle(event, 'trace-args-1')">DboSource->_execute()</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></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-2')">CORE/Cake/Model/Datasource/DboSource.php line 715</a> → <a href="#" onclick="traceToggle(event, 'trace-args-2')">DboSource->execute()</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></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-3')">CORE/Cake/Model/Datasource/DboSource.php line 641</a> → <a href="#" onclick="traceToggle(event, 'trace-args-3')">DboSource->fetchAll()</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: #007700">if (isset(</span><span style="color: #0000BB">$args</span><span style="color: #007700">[</span><span style="color: #0000BB">1</span><span style="color: #007700">]) && </span><span style="color: #0000BB">$args</span><span style="color: #007700">[</span><span style="color: #0000BB">1</span><span style="color: #007700">] === </span><span style="color: #0000BB">true</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">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">fetchAll</span><span style="color: #007700">(</span><span style="color: #0000BB">$args</span><span style="color: #007700">[</span><span style="color: #0000BB">0</span><span style="color: #007700">], </span><span style="color: #0000BB">true</span><span style="color: #007700">);</span></span></code> <code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">} elseif (isset(</span><span style="color: #0000BB">$args</span><span style="color: #007700">[</span><span style="color: #0000BB">1</span><span style="color: #007700">]) && !</span><span style="color: #0000BB">is_array</span><span style="color: #007700">(</span><span style="color: #0000BB">$args</span><span style="color: #007700">[</span><span style="color: #0000BB">1</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">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">fetchAll</span><span style="color: #007700">(</span><span style="color: #0000BB">$args</span><span style="color: #007700">[</span><span style="color: #0000BB">0</span><span style="color: #007700">], </span><span style="color: #0000BB">false</span><span style="color: #007700">);</span></span></code></span> <code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">} elseif (isset(</span><span style="color: #0000BB">$args</span><span style="color: #007700">[</span><span style="color: #0000BB">1</span><span style="color: #007700">]) && </span><span style="color: #0000BB">is_array</span><span style="color: #007700">(</span><span style="color: #0000BB">$args</span><span style="color: #007700">[</span><span style="color: #0000BB">1</span><span style="color: #007700">])) {</span></span></code></pre></div> <div id="trace-args-3" class="cake-code-dump" style="display: none;"><pre></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-4')">CORE/Cake/Model/Model.php line 3489</a> → <a href="#" onclick="traceToggle(event, 'trace-args-4')">DboSource->query()</a> <div id="file-excerpt-4" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB"> $params</span><span style="color: #007700">[] = </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">cacheQueries</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"> $db </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></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">call_user_func_array</span><span style="color: #007700">(array(&</span><span style="color: #0000BB">$db</span><span style="color: #007700">, </span><span style="color: #DD0000">'query'</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 style="color: #007700">}</span></span></code></pre></div> <div id="trace-args-4" class="cake-code-dump" style="display: none;"><pre></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-5')">APP/Controller/PagesController.php line 767</a> → <a href="#" onclick="traceToggle(event, 'trace-args-5')">Model->query()</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></code> <code><span style="color: #000000"><span style="color: #0000BB"> $sqlcarac </span><span style="color: #007700">= </span><span style="color: #DD0000">"SELECT pfc.id as cat_id, pfc.name as cat_name FROM product_field_categories pfc, product_fields pf, product_extras pe WHERE pf.product_field_category_id = pfc.id and pe.product_field_id = pf.id and pe.product_id = "</span><span style="color: #007700">.</span><span style="color: #0000BB">$idprod</span><span style="color: #007700">[</span><span style="color: #0000BB">0</span><span style="color: #007700">]. </span><span style="color: #DD0000">" GROUP BY pfc.id"</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"> $category_fields </span><span style="color: #007700">= </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">Product</span><span style="color: #007700">-></span><span style="color: #0000BB">query</span><span style="color: #007700">(</span><span style="color: #0000BB">$sqlcarac</span><span style="color: #007700">);</span></span></code></span> <code><span style="color: #000000"><span style="color: #0000BB"> $tabcarac </span><span style="color: #007700">= array();</span></span></code></pre></div> <div id="trace-args-5" class="cake-code-dump" style="display: none;"><pre></pre></div></li> <li><a href="#">[internal function]</a> → <a href="#" onclick="traceToggle(event, 'trace-args-6')">PagesController->detail_product()</a> <div id="trace-args-6" class="cake-code-dump" style="display: none;"><pre></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-7')">CORE/Cake/Controller/Controller.php line 499</a> → <a href="#" onclick="traceToggle(event, 'trace-args-7')">ReflectionMethod->invokeArgs()</a> <div id="file-excerpt-7" 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-7" class="cake-code-dump" style="display: none;"><pre></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-8')">CORE/Cake/Routing/Dispatcher.php line 193</a> → <a href="#" onclick="traceToggle(event, 'trace-args-8')">Controller->invokeAction()</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></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-8" class="cake-code-dump" style="display: none;"><pre></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-9')">CORE/Cake/Routing/Dispatcher.php line 167</a> → <a href="#" onclick="traceToggle(event, 'trace-args-9')">Dispatcher->_invoke()</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 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-9" class="cake-code-dump" style="display: none;"><pre></pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-10')">APP/webroot/index.php line 117</a> → <a href="#" onclick="traceToggle(event, 'trace-args-10')">Dispatcher->dispatch()</a> <div id="file-excerpt-10" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB">$Dispatcher </span><span style="color: #007700">= new </span><span style="color: #0000BB">Dispatcher</span><span style="color: #007700">();</span></span></code> <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> <span class="code-highlight"><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> <code><span style="color: #000000"><span style="color: #0000BB"></span><span style="color: #007700">);</span></span></code></pre></div> <div id="trace-args-10" class="cake-code-dump" style="display: none;"><pre></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'include - APP/View/Layouts/default.ctp, line 555 View::_evaluate() - CORE/Cake/View/View.php, line 971 View::_render() - CORE/Cake/View/View.php, line 933 View::renderLayout() - CORE/Cake/View/View.php, line 546 View::render() - CORE/Cake/View/View.php, line 481 Controller::render() - CORE/Cake/Controller/Controller.php, line 968 ExceptionRenderer::_outputMessage() - CORE/Cake/Error/ExceptionRenderer.php, line 292 ExceptionRenderer::pdoError() - CORE/Cake/Error/ExceptionRenderer.php, line 281 ExceptionRenderer::render() - CORE/Cake/Error/ExceptionRenderer.php, line 190 ErrorHandler::handleException() - CORE/Cake/Error/ErrorHandler.php, line 127 [main] - [internal], line ??
Error: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'GROUP BY pfc.id' at line 1
SQL Query: SELECT pfc.id as cat_id, pfc.name as cat_name FROM product_field_categories pfc, product_fields pf, product_extras pe WHERE pf.product_field_category_id = pfc.id and pe.product_field_id = pf.id and pe.product_id = GROUP BY pfc.id
Notice: If you want to customize this error message, create app/View/Errors/pdo_error.ctp
try {
$query = $this->_connection->prepare($sql, $prepareOptions);
$query->setFetchMode(PDO::FETCH_LAZY);
if (!$query->execute($params)) {
$this->_result = $query;
$options += array('log' => $this->fullDebug);
$t = microtime(true);
$this->_result = $this->_execute($sql, $params);
if ($cache && ($cached = $this->getQueryCache($sql, $params)) !== false) {
return $cached;
}
$result = $this->execute($sql, array(), $params);
if ($result) {
if (isset($args[1]) && $args[1] === true) {
return $this->fetchAll($args[0], true);
} elseif (isset($args[1]) && !is_array($args[1])) {
return $this->fetchAll($args[0], false);
} elseif (isset($args[1]) && is_array($args[1])) {
$params[] = $this->cacheQueries;
}
$db = $this->getDataSource();
return call_user_func_array(array(&$db, 'query'), $params);
}
$sqlcarac = "SELECT pfc.id as cat_id, pfc.name as cat_name FROM product_field_categories pfc, product_fields pf, product_extras pe WHERE pf.product_field_category_id = pfc.id and pe.product_field_id = pf.id and pe.product_id = ".$idprod[0]. " GROUP BY pfc.id";
$category_fields = $this->Product->query($sqlcarac);
$tabcarac = array();
'action' => $request->params['action']
));
}
return $method->invokeArgs($this, $request->params['pass']);
$response = $controller->response;
$render = true;
$result = $controller->invokeAction($request);
if ($result instanceof CakeResponse) {
));
}
$response = $this->_invoke($controller, $request);
if (isset($request->params['return'])) {
$Dispatcher = new Dispatcher();
$Dispatcher->dispatch(
new CakeRequest(),
new CakeResponse()
);