Notice (8): Undefined offset: 0 [APP/Controller/RoomController.php, line 60]Code Context$this->loadModel('Service');
$room = $this->Room->getRoomById($id);
$park = $room['0']['room']['Park'];
$id = '51' $room = array()RoomController::detail() - APP/Controller/RoomController.php, line 60 ReflectionMethod::invokeArgs() - [internal], line ?? Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 490 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 185 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 160 [main] - APP/webroot/index.php, line 108
Notice (8): Undefined offset: 0 [APP/Controller/RoomController.php, line 61]Code Context$room = $this->Room->getRoomById($id);
$park = $room['0']['room']['Park'];
$roomId = $room['0']['room']['Id'];
$id = '51' $room = array() $park = nullRoomController::detail() - APP/Controller/RoomController.php, line 61 ReflectionMethod::invokeArgs() - [internal], line ?? Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 490 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 185 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 160 [main] - APP/webroot/index.php, line 108
Notice (8): Undefined variable: lang [APP/View/Layouts/template.ctp, line 82]Code Context</div>
</div>
<div style="display: none;" id="language"><?php echo $lang;?></div>
$viewFile = '/home/thelotus/public_html/app/View/Layouts/template.ctp' $dataForView = array( 'code' => (int) 500, 'url' => '/room/detail/51', '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 'AND Id != AND Status != 4' at line 1', 'error' => object(PDOException) { errorInfo => array( [maximum depth reached] ) queryString => 'SELECT * FROM room WHERE Park = AND Id != AND Status != 4' [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 'AND Id != AND Status != 4' at line 1' [protected] code => '42000' [protected] file => '/home/thelotus/public_html/lib/Cake/Model/Datasource/DboSource.php' [protected] line => (int) 458 }, '_serialize' => array( (int) 0 => 'code', (int) 1 => 'url', (int) 2 => 'name', (int) 3 => '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 'AND Id != AND Status != 4' at line 1</p> <p class="notice"> <strong>SQL Query: </strong> SELECT * FROM room WHERE Park = AND Id != AND Status != 4 </p> <p class="notice"> <strong>Notice: </strong> If you want to customize this error message, create app/View/Errors/pdo_error.ctp</p> <h3>Stack Trace</h3> <ul class="cake-stack-trace"> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-0')">CORE/Cake/Model/Datasource/DboSource.php line 458</a> → <a href="#" onclick="traceToggle(event, 'trace-args-0')">PDOStatement->execute(array)</a> <div id="file-excerpt-0" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">try {</span></span></code> <code><span style="color: #000000"><span style="color: #0000BB"> $query </span><span style="color: #007700">= </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">_connection</span><span style="color: #007700">-></span><span style="color: #0000BB">prepare</span><span style="color: #007700">(</span><span style="color: #0000BB">$sql</span><span style="color: #007700">, </span><span style="color: #0000BB">$prepareOptions</span><span style="color: #007700">);</span></span></code> <code><span style="color: #000000"><span style="color: #0000BB"> $query</span><span style="color: #007700">-></span><span style="color: #0000BB">setFetchMode</span><span style="color: #007700">(</span><span style="color: #0000BB">PDO</span><span style="color: #007700">::</span><span style="color: #0000BB">FETCH_LAZY</span><span style="color: #007700">);</span></span></code> <span class="code-highlight"><code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">if (!</span><span style="color: #0000BB">$query</span><span style="color: #007700">-></span><span style="color: #0000BB">execute</span><span style="color: #007700">(</span><span style="color: #0000BB">$params</span><span style="color: #007700">)) {</span></span></code></span> <code><span style="color: #000000"><span style="color: #0000BB"> $this</span><span style="color: #007700">-></span><span style="color: #0000BB">_results </span><span style="color: #007700">= </span><span style="color: #0000BB">$query</span><span style="color: #007700">;</span></span></code></pre></div> <div id="trace-args-0" class="cake-code-dump" style="display: none;"><pre>array()</pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-1')">CORE/Cake/Model/Datasource/DboSource.php line 424</a> → <a href="#" onclick="traceToggle(event, 'trace-args-1')">DboSource->_execute(string, array)</a> <div id="file-excerpt-1" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB"> $options </span><span style="color: #007700">+= array(</span><span style="color: #DD0000">'log' </span><span style="color: #007700">=> </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">fullDebug</span><span style="color: #007700">);</span></span></code> <code><span style="color: #000000"><span style="color: #0000BB"></span></span></code> <code><span style="color: #000000"><span style="color: #0000BB"> $t </span><span style="color: #007700">= </span><span style="color: #0000BB">microtime</span><span style="color: #007700">(</span><span style="color: #0000BB">true</span><span style="color: #007700">);</span></span></code> <span class="code-highlight"><code><span style="color: #000000"><span style="color: #0000BB"> $this</span><span style="color: #007700">-></span><span style="color: #0000BB">_result </span><span style="color: #007700">= </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">_execute</span><span style="color: #007700">(</span><span style="color: #0000BB">$sql</span><span style="color: #007700">, </span><span style="color: #0000BB">$params</span><span style="color: #007700">);</span></span></code></span> <code><span style="color: #000000"><span style="color: #0000BB"></span></span></code></pre></div> <div id="trace-args-1" class="cake-code-dump" style="display: none;"><pre>'SELECT * FROM room WHERE Park = AND Id != AND Status != 4' array()</pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-2')">CORE/Cake/Model/Datasource/DboSource.php line 665</a> → <a href="#" onclick="traceToggle(event, 'trace-args-2')">DboSource->execute(string, array, array)</a> <div id="file-excerpt-2" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">if (</span><span style="color: #0000BB">$cache </span><span style="color: #007700">&& (</span><span style="color: #0000BB">$cached </span><span style="color: #007700">= </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">getQueryCache</span><span style="color: #007700">(</span><span style="color: #0000BB">$sql</span><span style="color: #007700">, </span><span style="color: #0000BB">$params</span><span style="color: #007700">)) !== </span><span style="color: #0000BB">false</span><span style="color: #007700">) {</span></span></code> <code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">return </span><span style="color: #0000BB">$cached</span><span style="color: #007700">;</span></span></code> <code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">}</span></span></code> <span class="code-highlight"><code><span style="color: #000000"><span style="color: #0000BB"> $result </span><span style="color: #007700">= </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">execute</span><span style="color: #007700">(</span><span style="color: #0000BB">$sql</span><span style="color: #007700">, array(), </span><span style="color: #0000BB">$params</span><span style="color: #007700">);</span></span></code></span> <code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">if (</span><span style="color: #0000BB">$result</span><span style="color: #007700">) {</span></span></code></pre></div> <div id="trace-args-2" class="cake-code-dump" style="display: none;"><pre>'SELECT * FROM room WHERE Park = AND Id != AND Status != 4' array() array()</pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-3')">CORE/Cake/Model/Datasource/DboSource.php line 537</a> → <a href="#" onclick="traceToggle(event, 'trace-args-3')">DboSource->fetchAll(string)</a> <div id="file-excerpt-3" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB"> $recursive </span><span style="color: #007700">= </span><span style="color: #0000BB">null</span><span style="color: #007700">;</span></span></code> <code><span style="color: #000000"><span style="color: #0000BB"></span></span></code> <code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">if (</span><span style="color: #0000BB">count</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></code></span> <code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">} elseif (</span><span style="color: #0000BB">count</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">strpos</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: #DD0000">'findBy'</span><span style="color: #007700">) === </span><span style="color: #0000BB">0 </span><span style="color: #007700">|| </span><span style="color: #0000BB">strpos</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: #DD0000">'findAllBy'</span><span style="color: #007700">) === </span><span style="color: #0000BB">0</span><span style="color: #007700">)) {</span></span></code></pre></div> <div id="trace-args-3" class="cake-code-dump" style="display: none;"><pre>'SELECT * FROM room WHERE Park = AND Id != AND Status != 4'</pre></div></li> <li><a href="#">[internal function]</a> → <a href="#" onclick="traceToggle(event, 'trace-args-4')">DboSource->query(string)</a> <div id="trace-args-4" class="cake-code-dump" style="display: none;"><pre>'SELECT * FROM room WHERE Park = AND Id != AND Status != 4'</pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-5')">CORE/Cake/Model/Model.php line 3306</a> → <a href="#" onclick="traceToggle(event, 'trace-args-5')">call_user_func_array(array, array)</a> <div id="file-excerpt-5" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">public function </span><span style="color: #0000BB">query</span><span style="color: #007700">(</span><span style="color: #0000BB">$sql</span><span style="color: #007700">) {</span></span></code> <code><span style="color: #000000"><span style="color: #0000BB"> $params </span><span style="color: #007700">= </span><span style="color: #0000BB">func_get_args</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-5" class="cake-code-dump" style="display: none;"><pre>array( (int) 0 => object(Mysql) {}, (int) 1 => 'query' ) array( (int) 0 => 'SELECT * FROM room WHERE Park = AND Id != AND Status != 4' )</pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-6')">APP/Model/Room.php line 21</a> → <a href="#" onclick="traceToggle(event, 'trace-args-6')">Model->query(string)</a> <div id="file-excerpt-6" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB"> </span></span></code> <code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">public function </span><span style="color: #0000BB">getRoomByPark</span><span style="color: #007700">(</span><span style="color: #0000BB">$park</span><span style="color: #007700">, </span><span style="color: #0000BB">$roomId</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: #DD0000">"SELECT * FROM room WHERE Park = </span><span style="color: #0000BB">$park</span><span style="color: #DD0000"> AND Id != </span><span style="color: #0000BB">$roomId</span><span style="color: #DD0000"> AND Status != 4"</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">query</span><span style="color: #007700">(</span><span style="color: #0000BB">$query</span><span style="color: #007700">);</span></span></code></span> <code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">return </span><span style="color: #0000BB">$result</span><span style="color: #007700">;</span></span></code></pre></div> <div id="trace-args-6" class="cake-code-dump" style="display: none;"><pre>'SELECT * FROM room WHERE Park = AND Id != AND Status != 4'</pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-7')">APP/Controller/RoomController.php line 62</a> → <a href="#" onclick="traceToggle(event, 'trace-args-7')">Room->getRoomByPark(null, null)</a> <div id="file-excerpt-7" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB"> $room </span><span style="color: #007700">= </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">Room</span><span style="color: #007700">-></span><span style="color: #0000BB">getRoomById</span><span style="color: #007700">(</span><span style="color: #0000BB">$id</span><span style="color: #007700">);</span></span></code> <code><span style="color: #000000"><span style="color: #0000BB"> $park </span><span style="color: #007700">= </span><span style="color: #0000BB">$room</span><span style="color: #007700">[</span><span style="color: #DD0000">'0'</span><span style="color: #007700">][</span><span style="color: #DD0000">'room'</span><span style="color: #007700">][</span><span style="color: #DD0000">'Park'</span><span style="color: #007700">];</span></span></code> <code><span style="color: #000000"><span style="color: #0000BB"> $roomId </span><span style="color: #007700">= </span><span style="color: #0000BB">$room</span><span style="color: #007700">[</span><span style="color: #DD0000">'0'</span><span style="color: #007700">][</span><span style="color: #DD0000">'room'</span><span style="color: #007700">][</span><span style="color: #DD0000">'Id'</span><span style="color: #007700">];</span></span></code> <span class="code-highlight"><code><span style="color: #000000"><span style="color: #0000BB"> $otherRoom </span><span style="color: #007700">= </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">Room</span><span style="color: #007700">-></span><span style="color: #0000BB">getRoomByPark</span><span style="color: #007700">(</span><span style="color: #0000BB">$park</span><span style="color: #007700">, </span><span style="color: #0000BB">$roomId</span><span style="color: #007700">);</span></span></code></span> <code><span style="color: #000000"><span style="color: #0000BB"> $serviceList </span><span style="color: #007700">= </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">Service</span><span style="color: #007700">-></span><span style="color: #0000BB">findListService</span><span style="color: #007700">();</span></span></code></pre></div> <div id="trace-args-7" class="cake-code-dump" style="display: none;"><pre>null null</pre></div></li> <li><a href="#">[internal function]</a> → <a href="#" onclick="traceToggle(event, 'trace-args-8')">RoomController->detail(string)</a> <div id="trace-args-8" class="cake-code-dump" style="display: none;"><pre>'51'</pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-9')">CORE/Cake/Controller/Controller.php line 490</a> → <a href="#" onclick="traceToggle(event, 'trace-args-9')">ReflectionMethod->invokeArgs(RoomController, array)</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: #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-9" class="cake-code-dump" style="display: none;"><pre>object(RoomController) { layout => 'template' helpers => array( [maximum depth reached] ) components => array( [maximum depth reached] ) name => 'Room' uses => array( [maximum depth reached] ) request => object(CakeRequest) {} response => object(CakeResponse) {} viewPath => 'Room' layoutPath => null viewVars => array([maximum depth reached]) view => 'detail' autoRender => true autoLayout => true Components => object(ComponentCollection) {} viewClass => 'View' View => null ext => '.ctp' plugin => null cacheAction => false passedArgs => array( [maximum depth reached] ) scaffold => false methods => array( [maximum depth reached] ) modelClass => 'Room' modelKey => 'room' validationErrors => null Util => object(UtilComponent) {} Cookie => object(CookieComponent) {} Session => object(SessionComponent) {} Room => object(Room) {} Service => object(Service) {} [protected] _responseClass => 'CakeResponse' [protected] _mergeParent => 'AppController' [protected] _eventManager => object(CakeEventManager) {} } array( (int) 0 => '51' )</pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-10')">CORE/Cake/Routing/Dispatcher.php line 185</a> → <a href="#" onclick="traceToggle(event, 'trace-args-10')">Controller->invokeAction(CakeRequest)</a> <div id="file-excerpt-10" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB"> $controller</span><span style="color: #007700">-></span><span style="color: #0000BB">startupProcess</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"> $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-10" class="cake-code-dump" style="display: none;"><pre>object(CakeRequest) { params => array( [maximum depth reached] ) data => array([maximum depth reached]) query => array([maximum depth reached]) url => 'room/detail/51' base => '' webroot => '/' here => '/room/detail/51' [protected] _detectors => array( [maximum depth reached] ) [protected] _input => '' }</pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-11')">CORE/Cake/Routing/Dispatcher.php line 160</a> → <a href="#" onclick="traceToggle(event, 'trace-args-11')">Dispatcher->_invoke(RoomController, CakeRequest, CakeResponse)</a> <div id="file-excerpt-11" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB"> </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 style="color: #0000BB">$response</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-11" class="cake-code-dump" style="display: none;"><pre>object(RoomController) { layout => 'template' helpers => array( [maximum depth reached] ) components => array( [maximum depth reached] ) name => 'Room' uses => array( [maximum depth reached] ) request => object(CakeRequest) {} response => object(CakeResponse) {} viewPath => 'Room' layoutPath => null viewVars => array([maximum depth reached]) view => 'detail' autoRender => true autoLayout => true Components => object(ComponentCollection) {} viewClass => 'View' View => null ext => '.ctp' plugin => null cacheAction => false passedArgs => array( [maximum depth reached] ) scaffold => false methods => array( [maximum depth reached] ) modelClass => 'Room' modelKey => 'room' validationErrors => null Util => object(UtilComponent) {} Cookie => object(CookieComponent) {} Session => object(SessionComponent) {} Room => object(Room) {} Service => object(Service) {} [protected] _responseClass => 'CakeResponse' [protected] _mergeParent => 'AppController' [protected] _eventManager => object(CakeEventManager) {} } object(CakeRequest) { params => array( [maximum depth reached] ) data => array([maximum depth reached]) query => array([maximum depth reached]) url => 'room/detail/51' base => '' webroot => '/' here => '/room/detail/51' [protected] _detectors => array( [maximum depth reached] ) [protected] _input => '' } object(CakeResponse) { [protected] _statusCodes => array( [maximum depth reached] ) [protected] _mimeTypes => array( [maximum depth reached] ) [protected] _protocol => 'HTTP/1.1' [protected] _status => (int) 200 [protected] _contentType => 'text/html' [protected] _headers => array([maximum depth reached]) [protected] _body => null [protected] _file => null [protected] _fileRange => null [protected] _charset => 'UTF-8' [protected] _cacheDirectives => array([maximum depth reached]) [protected] _cookies => array([maximum depth reached]) }</pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-12')">APP/webroot/index.php line 108</a> → <a href="#" onclick="traceToggle(event, 'trace-args-12')">Dispatcher->dispatch(CakeRequest, CakeResponse)</a> <div id="file-excerpt-12" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB">$Dispatcher</span><span style="color: #007700">-></span><span style="color: #0000BB">dispatch</span><span style="color: #007700">(</span></span></code> <code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">new </span><span style="color: #0000BB">CakeRequest</span><span style="color: #007700">(),</span></span></code> <code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">new </span><span style="color: #0000BB">CakeResponse</span><span style="color: #007700">()</span></span></code> <span class="code-highlight"><code><span style="color: #000000"><span style="color: #0000BB"></span><span style="color: #007700">);</span></span></code></span> <code><span style="color: #000000"><span style="color: #0000BB"></span></span></code></pre></div> <div id="trace-args-12" class="cake-code-dump" style="display: none;"><pre>object(CakeRequest) { params => array( [maximum depth reached] ) data => array([maximum depth reached]) query => array([maximum depth reached]) url => 'room/detail/51' base => '' webroot => '/' here => '/room/detail/51' [protected] _detectors => array( [maximum depth reached] ) [protected] _input => '' } object(CakeResponse) { [protected] _statusCodes => array( [maximum depth reached] ) [protected] _mimeTypes => array( [maximum depth reached] ) [protected] _protocol => 'HTTP/1.1' [protected] _status => (int) 200 [protected] _contentType => 'text/html' [protected] _headers => array([maximum depth reached]) [protected] _body => null [protected] _file => null [protected] _fileRange => null [protected] _charset => 'UTF-8' [protected] _cacheDirectives => array([maximum depth reached]) [protected] _cookies => array([maximum depth reached]) }</pre></div></li> </ul> <script type="text/javascript"> function traceToggle(event, id) { var el = document.getElementById(id); el.style.display = (el.style.display === 'block') ? 'none' : 'block'; event.preventDefault(); return false; } </script> ', 'scripts_for_layout' => '', 'title_for_layout' => 'Errors' ) $code = (int) 500 $url = '/room/detail/51' $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 'AND Id != AND Status != 4' at line 1' $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 'AND Id != AND Status != 4' at line 1' ) queryString => 'SELECT * FROM room WHERE Park = AND Id != AND Status != 4' [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 'AND Id != AND Status != 4' at line 1' [protected] code => '42000' [protected] file => '/home/thelotus/public_html/lib/Cake/Model/Datasource/DboSource.php' [protected] line => (int) 458 } $_serialize = array( (int) 0 => 'code', (int) 1 => 'url', (int) 2 => 'name', (int) 3 => '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 'AND Id != AND Status != 4' at line 1</p> <p class="notice"> <strong>SQL Query: </strong> SELECT * FROM room WHERE Park = AND Id != AND Status != 4 </p> <p class="notice"> <strong>Notice: </strong> If you want to customize this error message, create app/View/Errors/pdo_error.ctp</p> <h3>Stack Trace</h3> <ul class="cake-stack-trace"> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-0')">CORE/Cake/Model/Datasource/DboSource.php line 458</a> → <a href="#" onclick="traceToggle(event, 'trace-args-0')">PDOStatement->execute(array)</a> <div id="file-excerpt-0" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">try {</span></span></code> <code><span style="color: #000000"><span style="color: #0000BB"> $query </span><span style="color: #007700">= </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">_connection</span><span style="color: #007700">-></span><span style="color: #0000BB">prepare</span><span style="color: #007700">(</span><span style="color: #0000BB">$sql</span><span style="color: #007700">, </span><span style="color: #0000BB">$prepareOptions</span><span style="color: #007700">);</span></span></code> <code><span style="color: #000000"><span style="color: #0000BB"> $query</span><span style="color: #007700">-></span><span style="color: #0000BB">setFetchMode</span><span style="color: #007700">(</span><span style="color: #0000BB">PDO</span><span style="color: #007700">::</span><span style="color: #0000BB">FETCH_LAZY</span><span style="color: #007700">);</span></span></code> <span class="code-highlight"><code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">if (!</span><span style="color: #0000BB">$query</span><span style="color: #007700">-></span><span style="color: #0000BB">execute</span><span style="color: #007700">(</span><span style="color: #0000BB">$params</span><span style="color: #007700">)) {</span></span></code></span> <code><span style="color: #000000"><span style="color: #0000BB"> $this</span><span style="color: #007700">-></span><span style="color: #0000BB">_results </span><span style="color: #007700">= </span><span style="color: #0000BB">$query</span><span style="color: #007700">;</span></span></code></pre></div> <div id="trace-args-0" class="cake-code-dump" style="display: none;"><pre>array()</pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-1')">CORE/Cake/Model/Datasource/DboSource.php line 424</a> → <a href="#" onclick="traceToggle(event, 'trace-args-1')">DboSource->_execute(string, array)</a> <div id="file-excerpt-1" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB"> $options </span><span style="color: #007700">+= array(</span><span style="color: #DD0000">'log' </span><span style="color: #007700">=> </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">fullDebug</span><span style="color: #007700">);</span></span></code> <code><span style="color: #000000"><span style="color: #0000BB"></span></span></code> <code><span style="color: #000000"><span style="color: #0000BB"> $t </span><span style="color: #007700">= </span><span style="color: #0000BB">microtime</span><span style="color: #007700">(</span><span style="color: #0000BB">true</span><span style="color: #007700">);</span></span></code> <span class="code-highlight"><code><span style="color: #000000"><span style="color: #0000BB"> $this</span><span style="color: #007700">-></span><span style="color: #0000BB">_result </span><span style="color: #007700">= </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">_execute</span><span style="color: #007700">(</span><span style="color: #0000BB">$sql</span><span style="color: #007700">, </span><span style="color: #0000BB">$params</span><span style="color: #007700">);</span></span></code></span> <code><span style="color: #000000"><span style="color: #0000BB"></span></span></code></pre></div> <div id="trace-args-1" class="cake-code-dump" style="display: none;"><pre>'SELECT * FROM room WHERE Park = AND Id != AND Status != 4' array()</pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-2')">CORE/Cake/Model/Datasource/DboSource.php line 665</a> → <a href="#" onclick="traceToggle(event, 'trace-args-2')">DboSource->execute(string, array, array)</a> <div id="file-excerpt-2" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">if (</span><span style="color: #0000BB">$cache </span><span style="color: #007700">&& (</span><span style="color: #0000BB">$cached </span><span style="color: #007700">= </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">getQueryCache</span><span style="color: #007700">(</span><span style="color: #0000BB">$sql</span><span style="color: #007700">, </span><span style="color: #0000BB">$params</span><span style="color: #007700">)) !== </span><span style="color: #0000BB">false</span><span style="color: #007700">) {</span></span></code> <code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">return </span><span style="color: #0000BB">$cached</span><span style="color: #007700">;</span></span></code> <code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">}</span></span></code> <span class="code-highlight"><code><span style="color: #000000"><span style="color: #0000BB"> $result </span><span style="color: #007700">= </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">execute</span><span style="color: #007700">(</span><span style="color: #0000BB">$sql</span><span style="color: #007700">, array(), </span><span style="color: #0000BB">$params</span><span style="color: #007700">);</span></span></code></span> <code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">if (</span><span style="color: #0000BB">$result</span><span style="color: #007700">) {</span></span></code></pre></div> <div id="trace-args-2" class="cake-code-dump" style="display: none;"><pre>'SELECT * FROM room WHERE Park = AND Id != AND Status != 4' array() array()</pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-3')">CORE/Cake/Model/Datasource/DboSource.php line 537</a> → <a href="#" onclick="traceToggle(event, 'trace-args-3')">DboSource->fetchAll(string)</a> <div id="file-excerpt-3" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB"> $recursive </span><span style="color: #007700">= </span><span style="color: #0000BB">null</span><span style="color: #007700">;</span></span></code> <code><span style="color: #000000"><span style="color: #0000BB"></span></span></code> <code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">if (</span><span style="color: #0000BB">count</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></code></span> <code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">} elseif (</span><span style="color: #0000BB">count</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">strpos</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: #DD0000">'findBy'</span><span style="color: #007700">) === </span><span style="color: #0000BB">0 </span><span style="color: #007700">|| </span><span style="color: #0000BB">strpos</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: #DD0000">'findAllBy'</span><span style="color: #007700">) === </span><span style="color: #0000BB">0</span><span style="color: #007700">)) {</span></span></code></pre></div> <div id="trace-args-3" class="cake-code-dump" style="display: none;"><pre>'SELECT * FROM room WHERE Park = AND Id != AND Status != 4'</pre></div></li> <li><a href="#">[internal function]</a> → <a href="#" onclick="traceToggle(event, 'trace-args-4')">DboSource->query(string)</a> <div id="trace-args-4" class="cake-code-dump" style="display: none;"><pre>'SELECT * FROM room WHERE Park = AND Id != AND Status != 4'</pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-5')">CORE/Cake/Model/Model.php line 3306</a> → <a href="#" onclick="traceToggle(event, 'trace-args-5')">call_user_func_array(array, array)</a> <div id="file-excerpt-5" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">public function </span><span style="color: #0000BB">query</span><span style="color: #007700">(</span><span style="color: #0000BB">$sql</span><span style="color: #007700">) {</span></span></code> <code><span style="color: #000000"><span style="color: #0000BB"> $params </span><span style="color: #007700">= </span><span style="color: #0000BB">func_get_args</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-5" class="cake-code-dump" style="display: none;"><pre>array( (int) 0 => object(Mysql) {}, (int) 1 => 'query' ) array( (int) 0 => 'SELECT * FROM room WHERE Park = AND Id != AND Status != 4' )</pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-6')">APP/Model/Room.php line 21</a> → <a href="#" onclick="traceToggle(event, 'trace-args-6')">Model->query(string)</a> <div id="file-excerpt-6" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB"> </span></span></code> <code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">public function </span><span style="color: #0000BB">getRoomByPark</span><span style="color: #007700">(</span><span style="color: #0000BB">$park</span><span style="color: #007700">, </span><span style="color: #0000BB">$roomId</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: #DD0000">"SELECT * FROM room WHERE Park = </span><span style="color: #0000BB">$park</span><span style="color: #DD0000"> AND Id != </span><span style="color: #0000BB">$roomId</span><span style="color: #DD0000"> AND Status != 4"</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">query</span><span style="color: #007700">(</span><span style="color: #0000BB">$query</span><span style="color: #007700">);</span></span></code></span> <code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">return </span><span style="color: #0000BB">$result</span><span style="color: #007700">;</span></span></code></pre></div> <div id="trace-args-6" class="cake-code-dump" style="display: none;"><pre>'SELECT * FROM room WHERE Park = AND Id != AND Status != 4'</pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-7')">APP/Controller/RoomController.php line 62</a> → <a href="#" onclick="traceToggle(event, 'trace-args-7')">Room->getRoomByPark(null, null)</a> <div id="file-excerpt-7" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB"> $room </span><span style="color: #007700">= </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">Room</span><span style="color: #007700">-></span><span style="color: #0000BB">getRoomById</span><span style="color: #007700">(</span><span style="color: #0000BB">$id</span><span style="color: #007700">);</span></span></code> <code><span style="color: #000000"><span style="color: #0000BB"> $park </span><span style="color: #007700">= </span><span style="color: #0000BB">$room</span><span style="color: #007700">[</span><span style="color: #DD0000">'0'</span><span style="color: #007700">][</span><span style="color: #DD0000">'room'</span><span style="color: #007700">][</span><span style="color: #DD0000">'Park'</span><span style="color: #007700">];</span></span></code> <code><span style="color: #000000"><span style="color: #0000BB"> $roomId </span><span style="color: #007700">= </span><span style="color: #0000BB">$room</span><span style="color: #007700">[</span><span style="color: #DD0000">'0'</span><span style="color: #007700">][</span><span style="color: #DD0000">'room'</span><span style="color: #007700">][</span><span style="color: #DD0000">'Id'</span><span style="color: #007700">];</span></span></code> <span class="code-highlight"><code><span style="color: #000000"><span style="color: #0000BB"> $otherRoom </span><span style="color: #007700">= </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">Room</span><span style="color: #007700">-></span><span style="color: #0000BB">getRoomByPark</span><span style="color: #007700">(</span><span style="color: #0000BB">$park</span><span style="color: #007700">, </span><span style="color: #0000BB">$roomId</span><span style="color: #007700">);</span></span></code></span> <code><span style="color: #000000"><span style="color: #0000BB"> $serviceList </span><span style="color: #007700">= </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">Service</span><span style="color: #007700">-></span><span style="color: #0000BB">findListService</span><span style="color: #007700">();</span></span></code></pre></div> <div id="trace-args-7" class="cake-code-dump" style="display: none;"><pre>null null</pre></div></li> <li><a href="#">[internal function]</a> → <a href="#" onclick="traceToggle(event, 'trace-args-8')">RoomController->detail(string)</a> <div id="trace-args-8" class="cake-code-dump" style="display: none;"><pre>'51'</pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-9')">CORE/Cake/Controller/Controller.php line 490</a> → <a href="#" onclick="traceToggle(event, 'trace-args-9')">ReflectionMethod->invokeArgs(RoomController, array)</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: #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-9" class="cake-code-dump" style="display: none;"><pre>object(RoomController) { layout => 'template' helpers => array( [maximum depth reached] ) components => array( [maximum depth reached] ) name => 'Room' uses => array( [maximum depth reached] ) request => object(CakeRequest) {} response => object(CakeResponse) {} viewPath => 'Room' layoutPath => null viewVars => array([maximum depth reached]) view => 'detail' autoRender => true autoLayout => true Components => object(ComponentCollection) {} viewClass => 'View' View => null ext => '.ctp' plugin => null cacheAction => false passedArgs => array( [maximum depth reached] ) scaffold => false methods => array( [maximum depth reached] ) modelClass => 'Room' modelKey => 'room' validationErrors => null Util => object(UtilComponent) {} Cookie => object(CookieComponent) {} Session => object(SessionComponent) {} Room => object(Room) {} Service => object(Service) {} [protected] _responseClass => 'CakeResponse' [protected] _mergeParent => 'AppController' [protected] _eventManager => object(CakeEventManager) {} } array( (int) 0 => '51' )</pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-10')">CORE/Cake/Routing/Dispatcher.php line 185</a> → <a href="#" onclick="traceToggle(event, 'trace-args-10')">Controller->invokeAction(CakeRequest)</a> <div id="file-excerpt-10" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB"> $controller</span><span style="color: #007700">-></span><span style="color: #0000BB">startupProcess</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"> $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-10" class="cake-code-dump" style="display: none;"><pre>object(CakeRequest) { params => array( [maximum depth reached] ) data => array([maximum depth reached]) query => array([maximum depth reached]) url => 'room/detail/51' base => '' webroot => '/' here => '/room/detail/51' [protected] _detectors => array( [maximum depth reached] ) [protected] _input => '' }</pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-11')">CORE/Cake/Routing/Dispatcher.php line 160</a> → <a href="#" onclick="traceToggle(event, 'trace-args-11')">Dispatcher->_invoke(RoomController, CakeRequest, CakeResponse)</a> <div id="file-excerpt-11" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB"> </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 style="color: #0000BB">$response</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-11" class="cake-code-dump" style="display: none;"><pre>object(RoomController) { layout => 'template' helpers => array( [maximum depth reached] ) components => array( [maximum depth reached] ) name => 'Room' uses => array( [maximum depth reached] ) request => object(CakeRequest) {} response => object(CakeResponse) {} viewPath => 'Room' layoutPath => null viewVars => array([maximum depth reached]) view => 'detail' autoRender => true autoLayout => true Components => object(ComponentCollection) {} viewClass => 'View' View => null ext => '.ctp' plugin => null cacheAction => false passedArgs => array( [maximum depth reached] ) scaffold => false methods => array( [maximum depth reached] ) modelClass => 'Room' modelKey => 'room' validationErrors => null Util => object(UtilComponent) {} Cookie => object(CookieComponent) {} Session => object(SessionComponent) {} Room => object(Room) {} Service => object(Service) {} [protected] _responseClass => 'CakeResponse' [protected] _mergeParent => 'AppController' [protected] _eventManager => object(CakeEventManager) {} } object(CakeRequest) { params => array( [maximum depth reached] ) data => array([maximum depth reached]) query => array([maximum depth reached]) url => 'room/detail/51' base => '' webroot => '/' here => '/room/detail/51' [protected] _detectors => array( [maximum depth reached] ) [protected] _input => '' } object(CakeResponse) { [protected] _statusCodes => array( [maximum depth reached] ) [protected] _mimeTypes => array( [maximum depth reached] ) [protected] _protocol => 'HTTP/1.1' [protected] _status => (int) 200 [protected] _contentType => 'text/html' [protected] _headers => array([maximum depth reached]) [protected] _body => null [protected] _file => null [protected] _fileRange => null [protected] _charset => 'UTF-8' [protected] _cacheDirectives => array([maximum depth reached]) [protected] _cookies => array([maximum depth reached]) }</pre></div></li> <li><a href="#" onclick="traceToggle(event, 'file-excerpt-12')">APP/webroot/index.php line 108</a> → <a href="#" onclick="traceToggle(event, 'trace-args-12')">Dispatcher->dispatch(CakeRequest, CakeResponse)</a> <div id="file-excerpt-12" class="cake-code-dump" style="display:none;"><pre><code><span style="color: #000000"><span style="color: #0000BB">$Dispatcher</span><span style="color: #007700">-></span><span style="color: #0000BB">dispatch</span><span style="color: #007700">(</span></span></code> <code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">new </span><span style="color: #0000BB">CakeRequest</span><span style="color: #007700">(),</span></span></code> <code><span style="color: #000000"><span style="color: #0000BB"> </span><span style="color: #007700">new </span><span style="color: #0000BB">CakeResponse</span><span style="color: #007700">()</span></span></code> <span class="code-highlight"><code><span style="color: #000000"><span style="color: #0000BB"></span><span style="color: #007700">);</span></span></code></span> <code><span style="color: #000000"><span style="color: #0000BB"></span></span></code></pre></div> <div id="trace-args-12" class="cake-code-dump" style="display: none;"><pre>object(CakeRequest) { params => array( [maximum depth reached] ) data => array([maximum depth reached]) query => array([maximum depth reached]) url => 'room/detail/51' base => '' webroot => '/' here => '/room/detail/51' [protected] _detectors => array( [maximum depth reached] ) [protected] _input => '' } object(CakeResponse) { [protected] _statusCodes => array( [maximum depth reached] ) [protected] _mimeTypes => array( [maximum depth reached] ) [protected] _protocol => 'HTTP/1.1' [protected] _status => (int) 200 [protected] _contentType => 'text/html' [protected] _headers => array([maximum depth reached]) [protected] _body => null [protected] _file => null [protected] _fileRange => null [protected] _charset => 'UTF-8' [protected] _cacheDirectives => array([maximum depth reached]) [protected] _cookies => array([maximum depth reached]) }</pre></div></li> </ul> <script type="text/javascript"> function traceToggle(event, id) { var el = document.getElementById(id); el.style.display = (el.style.display === 'block') ? 'none' : 'block'; event.preventDefault(); return false; } </script> ' $scripts_for_layout = '' $title_for_layout = 'Errors'include - APP/View/Layouts/template.ctp, line 82 View::_evaluate() - CORE/Cake/View/View.php, line 935 View::_render() - CORE/Cake/View/View.php, line 897 View::renderLayout() - CORE/Cake/View/View.php, line 529 View::render() - CORE/Cake/View/View.php, line 474 Controller::render() - CORE/Cake/Controller/Controller.php, line 952 ExceptionRenderer::_outputMessage() - CORE/Cake/Error/ExceptionRenderer.php, line 273 ExceptionRenderer::pdoError() - CORE/Cake/Error/ExceptionRenderer.php, line 262 ExceptionRenderer::render() - CORE/Cake/Error/ExceptionRenderer.php, line 175 ErrorHandler::handleException() - CORE/Cake/Error/ErrorHandler.php, line 120 [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 'AND Id != AND Status != 4' at line 1
SQL Query: SELECT * FROM room WHERE Park = AND Id != AND Status != 4
Notice: If you want to customize this error message, create app/View/Errors/pdo_error.ctp
try {
$query = $this->_connection->prepare($sql, $prepareOptions);
$query->setFetchMode(PDO::FETCH_LAZY);
if (!$query->execute($params)) {
$this->_results = $query;
array()
$options += array('log' => $this->fullDebug);
$t = microtime(true);
$this->_result = $this->_execute($sql, $params);
'SELECT * FROM room WHERE Park = AND Id != AND Status != 4' array()
if ($cache && ($cached = $this->getQueryCache($sql, $params)) !== false) {
return $cached;
}
$result = $this->execute($sql, array(), $params);
if ($result) {
'SELECT * FROM room WHERE Park = AND Id != AND Status != 4' array() array()
$recursive = null;
if (count($args) === 1) {
return $this->fetchAll($args[0]);
} elseif (count($args) > 1 && (strpos($args[0], 'findBy') === 0 || strpos($args[0], 'findAllBy') === 0)) {
'SELECT * FROM room WHERE Park = AND Id != AND Status != 4'
'SELECT * FROM room WHERE Park = AND Id != AND Status != 4'
public function query($sql) {
$params = func_get_args();
$db = $this->getDataSource();
return call_user_func_array(array(&$db, 'query'), $params);
}
array( (int) 0 => object(Mysql) {}, (int) 1 => 'query' ) array( (int) 0 => 'SELECT * FROM room WHERE Park = AND Id != AND Status != 4' )
public function getRoomByPark($park, $roomId) {
$query = "SELECT * FROM room WHERE Park = $park AND Id != $roomId AND Status != 4";
$result = $this -> query($query);
return $result;
'SELECT * FROM room WHERE Park = AND Id != AND Status != 4'
$room = $this->Room->getRoomById($id);
$park = $room['0']['room']['Park'];
$roomId = $room['0']['room']['Id'];
$otherRoom = $this->Room->getRoomByPark($park, $roomId);
$serviceList = $this->Service->findListService();
null null
'51'
'action' => $request->params['action']
));
}
return $method->invokeArgs($this, $request->params['pass']);
object(RoomController) { layout => 'template' helpers => array( [maximum depth reached] ) components => array( [maximum depth reached] ) name => 'Room' uses => array( [maximum depth reached] ) request => object(CakeRequest) {} response => object(CakeResponse) {} viewPath => 'Room' layoutPath => null viewVars => array([maximum depth reached]) view => 'detail' autoRender => true autoLayout => true Components => object(ComponentCollection) {} viewClass => 'View' View => null ext => '.ctp' plugin => null cacheAction => false passedArgs => array( [maximum depth reached] ) scaffold => false methods => array( [maximum depth reached] ) modelClass => 'Room' modelKey => 'room' validationErrors => null Util => object(UtilComponent) {} Cookie => object(CookieComponent) {} Session => object(SessionComponent) {} Room => object(Room) {} Service => object(Service) {} [protected] _responseClass => 'CakeResponse' [protected] _mergeParent => 'AppController' [protected] _eventManager => object(CakeEventManager) {} } array( (int) 0 => '51' )
$controller->startupProcess();
$render = true;
$result = $controller->invokeAction($request);
if ($result instanceof CakeResponse) {
object(CakeRequest) { params => array( [maximum depth reached] ) data => array([maximum depth reached]) query => array([maximum depth reached]) url => 'room/detail/51' base => '' webroot => '/' here => '/room/detail/51' [protected] _detectors => array( [maximum depth reached] ) [protected] _input => '' }
));
}
$response = $this->_invoke($controller, $request, $response);
if (isset($request->params['return'])) {
object(RoomController) { layout => 'template' helpers => array( [maximum depth reached] ) components => array( [maximum depth reached] ) name => 'Room' uses => array( [maximum depth reached] ) request => object(CakeRequest) {} response => object(CakeResponse) {} viewPath => 'Room' layoutPath => null viewVars => array([maximum depth reached]) view => 'detail' autoRender => true autoLayout => true Components => object(ComponentCollection) {} viewClass => 'View' View => null ext => '.ctp' plugin => null cacheAction => false passedArgs => array( [maximum depth reached] ) scaffold => false methods => array( [maximum depth reached] ) modelClass => 'Room' modelKey => 'room' validationErrors => null Util => object(UtilComponent) {} Cookie => object(CookieComponent) {} Session => object(SessionComponent) {} Room => object(Room) {} Service => object(Service) {} [protected] _responseClass => 'CakeResponse' [protected] _mergeParent => 'AppController' [protected] _eventManager => object(CakeEventManager) {} } object(CakeRequest) { params => array( [maximum depth reached] ) data => array([maximum depth reached]) query => array([maximum depth reached]) url => 'room/detail/51' base => '' webroot => '/' here => '/room/detail/51' [protected] _detectors => array( [maximum depth reached] ) [protected] _input => '' } object(CakeResponse) { [protected] _statusCodes => array( [maximum depth reached] ) [protected] _mimeTypes => array( [maximum depth reached] ) [protected] _protocol => 'HTTP/1.1' [protected] _status => (int) 200 [protected] _contentType => 'text/html' [protected] _headers => array([maximum depth reached]) [protected] _body => null [protected] _file => null [protected] _fileRange => null [protected] _charset => 'UTF-8' [protected] _cacheDirectives => array([maximum depth reached]) [protected] _cookies => array([maximum depth reached]) }
$Dispatcher->dispatch(
new CakeRequest(),
new CakeResponse()
);
object(CakeRequest) { params => array( [maximum depth reached] ) data => array([maximum depth reached]) query => array([maximum depth reached]) url => 'room/detail/51' base => '' webroot => '/' here => '/room/detail/51' [protected] _detectors => array( [maximum depth reached] ) [protected] _input => '' } object(CakeResponse) { [protected] _statusCodes => array( [maximum depth reached] ) [protected] _mimeTypes => array( [maximum depth reached] ) [protected] _protocol => 'HTTP/1.1' [protected] _status => (int) 200 [protected] _contentType => 'text/html' [protected] _headers => array([maximum depth reached]) [protected] _body => null [protected] _file => null [protected] _fileRange => null [protected] _charset => 'UTF-8' [protected] _cacheDirectives => array([maximum depth reached]) [protected] _cookies => array([maximum depth reached]) }