Warning (2): count(): Parameter must be an array or an object that implements Countable [CORE/src/Database/QueryCompiler.php, line 128]Code Context{return function ($parts, $name) use (&$sql, $query, $generator) {if (!count($parts)) {$parts = null $name = 'having' $sql = 'SELECT Topics.id AS `Topics__id`, Topics.released AS `Topics__released`, Topics.content AS `Topics__content`, Topics.created AS `Topics__created`, Topics.modified AS `Topics__modified`, Topics.deleted AS `Topics__deleted` FROM topics Topics WHERE (deleted) IS NULL' $query = object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SQL could not be generated for this query as it is incomplete.', 'params' => [], 'defaultTypes' => [ 'Topics__id' => 'biginteger', 'Topics.id' => 'biginteger', 'id' => 'biginteger', 'Topics__released' => 'date', 'Topics.released' => 'date', 'released' => 'date', 'Topics__content' => 'string', 'Topics.content' => 'string', 'content' => 'string', 'Topics__created' => 'datetime', 'Topics.created' => 'datetime', 'created' => 'datetime', 'Topics__modified' => 'datetime', 'Topics.modified' => 'datetime', 'modified' => 'datetime', 'Topics__deleted' => 'datetime', 'Topics.deleted' => 'datetime', 'deleted' => 'datetime' ], 'decorators' => (int) 0, 'executed' => false, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [], 'matching' => [], 'extraOptions' => [], 'repository' => object(App\Model\Table\TopicsTable) {} } $generator = object(Cake\Database\ValueBinder) { [protected] _bindings => [] [protected] _bindingsCount => (int) 0 }count - [internal], line ?? Cake\Database\QueryCompiler::Cake\Database\{closure}() - CORE/src/Database/QueryCompiler.php, line 128 Cake\Database\Query::traverse() - CORE/src/Database/Query.php, line 311 Cake\Database\QueryCompiler::compile() - CORE/src/Database/QueryCompiler.php, line 99 Cake\Database\Driver::compileQuery() - CORE/src/Database/Driver.php, line 359 Cake\Database\Connection::compileQuery() - CORE/src/Database/Connection.php, line 299 Cake\Database\Query::sql() - CORE/src/Database/Query.php, line 282 Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 990 Cake\Database\Driver\Mysql::prepare() - CORE/src/Database/Driver/Mysql.php, line 136 Cake\Database\Connection::prepare() - CORE/src/Database/Connection.php, line 258 Cake\Database\Connection::run() - CORE/src/Database/Connection.php, line 311 Cake\Database\Query::execute() - CORE/src/Database/Query.php, line 213 Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 1011 Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276 Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 959 App\Controller\Component\TopicsComponent::find() - APP/Controller/Component/TopicsComponent.php, line 43 App\Controller\HomeController::index() - APP/Controller/HomeController.php, line 35
Warning (2): count() [<a href='http://php.net/function.count'>function.count</a>]: Parameter must be an array or an object that implements Countable [CORE/src/Database/QueryCompiler.php, line 128]Code Context{return function ($parts, $name) use (&$sql, $query, $generator) {if (!count($parts)) {$parts = null $name = 'limit' $sql = 'SELECT Topics.id AS `Topics__id`, Topics.released AS `Topics__released`, Topics.content AS `Topics__content`, Topics.created AS `Topics__created`, Topics.modified AS `Topics__modified`, Topics.deleted AS `Topics__deleted` FROM topics Topics WHERE (deleted) IS NULL ORDER BY id DESC' $query = object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SQL could not be generated for this query as it is incomplete.', 'params' => [], 'defaultTypes' => [ 'Topics__id' => 'biginteger', 'Topics.id' => 'biginteger', 'id' => 'biginteger', 'Topics__released' => 'date', 'Topics.released' => 'date', 'released' => 'date', 'Topics__content' => 'string', 'Topics.content' => 'string', 'content' => 'string', 'Topics__created' => 'datetime', 'Topics.created' => 'datetime', 'created' => 'datetime', 'Topics__modified' => 'datetime', 'Topics.modified' => 'datetime', 'modified' => 'datetime', 'Topics__deleted' => 'datetime', 'Topics.deleted' => 'datetime', 'deleted' => 'datetime' ], 'decorators' => (int) 0, 'executed' => false, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [], 'matching' => [], 'extraOptions' => [], 'repository' => object(App\Model\Table\TopicsTable) {} } $generator = object(Cake\Database\ValueBinder) { [protected] _bindings => [] [protected] _bindingsCount => (int) 0 }count - [internal], line ?? Cake\Database\QueryCompiler::Cake\Database\{closure}() - CORE/src/Database/QueryCompiler.php, line 128 Cake\Database\Query::traverse() - CORE/src/Database/Query.php, line 311 Cake\Database\QueryCompiler::compile() - CORE/src/Database/QueryCompiler.php, line 99 Cake\Database\Driver::compileQuery() - CORE/src/Database/Driver.php, line 359 Cake\Database\Connection::compileQuery() - CORE/src/Database/Connection.php, line 299 Cake\Database\Query::sql() - CORE/src/Database/Query.php, line 282 Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 990 Cake\Database\Driver\Mysql::prepare() - CORE/src/Database/Driver/Mysql.php, line 136 Cake\Database\Connection::prepare() - CORE/src/Database/Connection.php, line 258 Cake\Database\Connection::run() - CORE/src/Database/Connection.php, line 311 Cake\Database\Query::execute() - CORE/src/Database/Query.php, line 213 Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 1011 Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276 Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 959 App\Controller\Component\TopicsComponent::find() - APP/Controller/Component/TopicsComponent.php, line 43 App\Controller\HomeController::index() - APP/Controller/HomeController.php, line 35
Warning (2): count() [<a href='http://php.net/function.count'>function.count</a>]: Parameter must be an array or an object that implements Countable [CORE/src/Database/QueryCompiler.php, line 128]Code Context{return function ($parts, $name) use (&$sql, $query, $generator) {if (!count($parts)) {$parts = null $name = 'offset' $sql = 'SELECT Topics.id AS `Topics__id`, Topics.released AS `Topics__released`, Topics.content AS `Topics__content`, Topics.created AS `Topics__created`, Topics.modified AS `Topics__modified`, Topics.deleted AS `Topics__deleted` FROM topics Topics WHERE (deleted) IS NULL ORDER BY id DESC' $query = object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SQL could not be generated for this query as it is incomplete.', 'params' => [], 'defaultTypes' => [ 'Topics__id' => 'biginteger', 'Topics.id' => 'biginteger', 'id' => 'biginteger', 'Topics__released' => 'date', 'Topics.released' => 'date', 'released' => 'date', 'Topics__content' => 'string', 'Topics.content' => 'string', 'content' => 'string', 'Topics__created' => 'datetime', 'Topics.created' => 'datetime', 'created' => 'datetime', 'Topics__modified' => 'datetime', 'Topics.modified' => 'datetime', 'modified' => 'datetime', 'Topics__deleted' => 'datetime', 'Topics.deleted' => 'datetime', 'deleted' => 'datetime' ], 'decorators' => (int) 0, 'executed' => false, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [], 'matching' => [], 'extraOptions' => [], 'repository' => object(App\Model\Table\TopicsTable) {} } $generator = object(Cake\Database\ValueBinder) { [protected] _bindings => [] [protected] _bindingsCount => (int) 0 }count - [internal], line ?? Cake\Database\QueryCompiler::Cake\Database\{closure}() - CORE/src/Database/QueryCompiler.php, line 128 Cake\Database\Query::traverse() - CORE/src/Database/Query.php, line 311 Cake\Database\QueryCompiler::compile() - CORE/src/Database/QueryCompiler.php, line 99 Cake\Database\Driver::compileQuery() - CORE/src/Database/Driver.php, line 359 Cake\Database\Connection::compileQuery() - CORE/src/Database/Connection.php, line 299 Cake\Database\Query::sql() - CORE/src/Database/Query.php, line 282 Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 990 Cake\Database\Driver\Mysql::prepare() - CORE/src/Database/Driver/Mysql.php, line 136 Cake\Database\Connection::prepare() - CORE/src/Database/Connection.php, line 258 Cake\Database\Connection::run() - CORE/src/Database/Connection.php, line 311 Cake\Database\Query::execute() - CORE/src/Database/Query.php, line 213 Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 1011 Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276 Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 959 App\Controller\Component\TopicsComponent::find() - APP/Controller/Component/TopicsComponent.php, line 43 App\Controller\HomeController::index() - APP/Controller/HomeController.php, line 35
Warning (2): count() [<a href='http://php.net/function.count'>function.count</a>]: Parameter must be an array or an object that implements Countable [CORE/src/Database/QueryCompiler.php, line 128]Code Context{return function ($parts, $name) use (&$sql, $query, $generator) {if (!count($parts)) {$parts = null $name = 'epilog' $sql = 'SELECT Topics.id AS `Topics__id`, Topics.released AS `Topics__released`, Topics.content AS `Topics__content`, Topics.created AS `Topics__created`, Topics.modified AS `Topics__modified`, Topics.deleted AS `Topics__deleted` FROM topics Topics WHERE (deleted) IS NULL ORDER BY id DESC' $query = object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SQL could not be generated for this query as it is incomplete.', 'params' => [], 'defaultTypes' => [ 'Topics__id' => 'biginteger', 'Topics.id' => 'biginteger', 'id' => 'biginteger', 'Topics__released' => 'date', 'Topics.released' => 'date', 'released' => 'date', 'Topics__content' => 'string', 'Topics.content' => 'string', 'content' => 'string', 'Topics__created' => 'datetime', 'Topics.created' => 'datetime', 'created' => 'datetime', 'Topics__modified' => 'datetime', 'Topics.modified' => 'datetime', 'modified' => 'datetime', 'Topics__deleted' => 'datetime', 'Topics.deleted' => 'datetime', 'deleted' => 'datetime' ], 'decorators' => (int) 0, 'executed' => false, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [], 'matching' => [], 'extraOptions' => [], 'repository' => object(App\Model\Table\TopicsTable) {} } $generator = object(Cake\Database\ValueBinder) { [protected] _bindings => [] [protected] _bindingsCount => (int) 0 }count - [internal], line ?? Cake\Database\QueryCompiler::Cake\Database\{closure}() - CORE/src/Database/QueryCompiler.php, line 128 Cake\Database\Query::traverse() - CORE/src/Database/Query.php, line 311 Cake\Database\QueryCompiler::compile() - CORE/src/Database/QueryCompiler.php, line 99 Cake\Database\Driver::compileQuery() - CORE/src/Database/Driver.php, line 359 Cake\Database\Connection::compileQuery() - CORE/src/Database/Connection.php, line 299 Cake\Database\Query::sql() - CORE/src/Database/Query.php, line 282 Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 990 Cake\Database\Driver\Mysql::prepare() - CORE/src/Database/Driver/Mysql.php, line 136 Cake\Database\Connection::prepare() - CORE/src/Database/Connection.php, line 258 Cake\Database\Connection::run() - CORE/src/Database/Connection.php, line 311 Cake\Database\Query::execute() - CORE/src/Database/Query.php, line 213 Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 1011 Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276 Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 959 App\Controller\Component\TopicsComponent::find() - APP/Controller/Component/TopicsComponent.php, line 43 App\Controller\HomeController::index() - APP/Controller/HomeController.php, line 35
Notice (8): compact() [<a href='http://php.net/function.compact'>function.compact</a>]: Undefined variable: etagMatches [CORE/src/Http/Response.php, line 1865]Code Context$timeMatches = strtotime($this->modified()) === strtotime($modifiedSince);}$checks = compact('etagMatches', 'timeMatches');$request = object(Cake\Http\ServerRequest) { params => [ 'pass' => [[maximum depth reached]], 'controller' => 'Home', 'action' => 'index', 'plugin' => null, '_matchedRoute' => '/', '?' => [ [maximum depth reached] ], 'isAjax' => false ] data => [] query => [ 'area' => '札幌駅周辺', 'detailed' => 'true' ] cookies => [] url => '' base => '' webroot => '/' here => '/' trustProxy => false [protected] _environment => [ 'REDIRECT_REDIRECT_HTTPS' => 'on', 'REDIRECT_REDIRECT_STATUS' => '200', 'REDIRECT_HTTPS' => 'on', 'REDIRECT_STATUS' => '200', 'HTTPS' => 'on', 'HTTP_HOST' => 'www.pr.abucha.jp', 'HTTP_X_REAL_IP' => '216.73.216.120', 'HTTP_LISTEN_IPADDR' => '210.224.185.18', 'HTTP_ACCEPT' => '*/*', 'HTTP_USER_AGENT' => 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 'HTTP_ACCEPT_ENCODING' => 'gzip, br, zstd, deflate', 'PATH' => '/sbin:/bin:/usr/sbin:/usr/bin:/usr/local/sbin:/usr/local/bin', 'SERVER_SIGNATURE' => '', 'SERVER_SOFTWARE' => 'Apache', 'SERVER_NAME' => 'www.pr.abucha.jp', 'SERVER_ADDR' => '100.64.0.12', 'SERVER_PORT' => '443', 'REMOTE_ADDR' => '216.73.216.120', 'DOCUMENT_ROOT' => '/home/abucha/www/seed/release/', 'REQUEST_SCHEME' => 'https', 'CONTEXT_PREFIX' => '', 'CONTEXT_DOCUMENT_ROOT' => '/home/abucha/www/seed/release/', 'SERVER_ADMIN' => '[no address given]', 'SCRIPT_FILENAME' => '/home/abucha/www/seed/release/webroot/index.php', 'REMOTE_PORT' => '0', 'REDIRECT_URL' => '/webroot/', 'REDIRECT_QUERY_STRING' => 'area=%E6%9C%AD%E5%B9%8C%E9%A7%85%E5%91%A8%E8%BE%BA&detailed=true', 'GATEWAY_INTERFACE' => 'CGI/1.1', 'SERVER_PROTOCOL' => 'HTTP/1.1', 'REQUEST_METHOD' => 'GET', 'QUERY_STRING' => 'area=%E6%9C%AD%E5%B9%8C%E9%A7%85%E5%91%A8%E8%BE%BA&detailed=true', 'REQUEST_URI' => '/?area=%E6%9C%AD%E5%B9%8C%E9%A7%85%E5%91%A8%E8%BE%BA&detailed=true', 'SCRIPT_NAME' => '/webroot/index.php', 'PHP_SELF' => '/webroot/index.php', 'REQUEST_TIME_FLOAT' => (float) 1764991773.879, 'REQUEST_TIME' => (int) 1764991773, 'argv' => [ [maximum depth reached] ], 'argc' => (int) 1, 'ORIGINAL_REQUEST_METHOD' => 'GET', 'HTTP_X_REQUESTED_WITH' => null, 'HTTP_REFERER' => null, 'HTTP_IF_NONE_MATCH' => null, 'HTTP_IF_MODIFIED_SINCE' => null ] [protected] _input => null [protected] _detectors => [ 'get' => [ [maximum depth reached] ], 'post' => [ [maximum depth reached] ], 'put' => [ [maximum depth reached] ], 'patch' => [ [maximum depth reached] ], 'delete' => [ [maximum depth reached] ], 'head' => [ [maximum depth reached] ], 'options' => [ [maximum depth reached] ], 'ssl' => [ [maximum depth reached] ], 'ajax' => [ [maximum depth reached] ], 'flash' => [ [maximum depth reached] ], 'requested' => [ [maximum depth reached] ], 'json' => [ [maximum depth reached] ], 'xml' => [ [maximum depth reached] ], 'mobile' => object(Closure) {}, 'tablet' => object(Closure) {} ] [protected] _detectorCache => [ 'ajax' => false, 'get' => true, 'head' => false, 'options' => false ] [protected] stream => object(Zend\Diactoros\PhpInputStream) {} [protected] uri => object(Zend\Diactoros\Uri) {} [protected] session => object(Cake\Network\Session) {} [protected] attributes => [] [protected] emulatedAttributes => [ (int) 0 => 'session', (int) 1 => 'webroot', (int) 2 => 'base', (int) 3 => 'params' ] [protected] uploadedFiles => [] [protected] protocol => null [protected] requestTarget => null } $etags = [] $modifiedSince = null $responseTag = nullcompact - [internal], line ?? Cake\Http\Response::checkNotModified() - CORE/src/Http/Response.php, line 1865 Cake\Controller\Component\RequestHandlerComponent::beforeRender() - CORE/src/Controller/Component/RequestHandlerComponent.php, line 332 Cake\Event\EventManager::_callListener() - CORE/src/Event/EventManager.php, line 414 Cake\Event\EventManager::dispatch() - CORE/src/Event/EventManager.php, line 391 Cake\Controller\Controller::dispatchEvent() - CORE/src/Event/EventDispatcherTrait.php, line 78 Cake\Controller\Controller::render() - CORE/src/Controller/Controller.php, line 610 Cake\Http\ActionDispatcher::_invoke() - CORE/src/Http/ActionDispatcher.php, line 125 Cake\Http\ActionDispatcher::dispatch() - CORE/src/Http/ActionDispatcher.php, line 93 Cake\Http\BaseApplication::__invoke() - CORE/src/Http/BaseApplication.php, line 78 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 Cake\Routing\Middleware\RoutingMiddleware::__invoke() - CORE/src/Routing/Middleware/RoutingMiddleware.php, line 59 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 Cake\Routing\Middleware\AssetMiddleware::__invoke() - CORE/src/Routing/Middleware/AssetMiddleware.php, line 88 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 Cake\Error\Middleware\ErrorHandlerMiddleware::__invoke() - CORE/src/Error/Middleware/ErrorHandlerMiddleware.php, line 92 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65
Notice (8): compact() [<a href='http://php.net/function.compact'>function.compact</a>]: Undefined variable: timeMatches [CORE/src/Http/Response.php, line 1865]Code Context$timeMatches = strtotime($this->modified()) === strtotime($modifiedSince);}$checks = compact('etagMatches', 'timeMatches');$request = object(Cake\Http\ServerRequest) { params => [ 'pass' => [[maximum depth reached]], 'controller' => 'Home', 'action' => 'index', 'plugin' => null, '_matchedRoute' => '/', '?' => [ [maximum depth reached] ], 'isAjax' => false ] data => [] query => [ 'area' => '札幌駅周辺', 'detailed' => 'true' ] cookies => [] url => '' base => '' webroot => '/' here => '/' trustProxy => false [protected] _environment => [ 'REDIRECT_REDIRECT_HTTPS' => 'on', 'REDIRECT_REDIRECT_STATUS' => '200', 'REDIRECT_HTTPS' => 'on', 'REDIRECT_STATUS' => '200', 'HTTPS' => 'on', 'HTTP_HOST' => 'www.pr.abucha.jp', 'HTTP_X_REAL_IP' => '216.73.216.120', 'HTTP_LISTEN_IPADDR' => '210.224.185.18', 'HTTP_ACCEPT' => '*/*', 'HTTP_USER_AGENT' => 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 'HTTP_ACCEPT_ENCODING' => 'gzip, br, zstd, deflate', 'PATH' => '/sbin:/bin:/usr/sbin:/usr/bin:/usr/local/sbin:/usr/local/bin', 'SERVER_SIGNATURE' => '', 'SERVER_SOFTWARE' => 'Apache', 'SERVER_NAME' => 'www.pr.abucha.jp', 'SERVER_ADDR' => '100.64.0.12', 'SERVER_PORT' => '443', 'REMOTE_ADDR' => '216.73.216.120', 'DOCUMENT_ROOT' => '/home/abucha/www/seed/release/', 'REQUEST_SCHEME' => 'https', 'CONTEXT_PREFIX' => '', 'CONTEXT_DOCUMENT_ROOT' => '/home/abucha/www/seed/release/', 'SERVER_ADMIN' => '[no address given]', 'SCRIPT_FILENAME' => '/home/abucha/www/seed/release/webroot/index.php', 'REMOTE_PORT' => '0', 'REDIRECT_URL' => '/webroot/', 'REDIRECT_QUERY_STRING' => 'area=%E6%9C%AD%E5%B9%8C%E9%A7%85%E5%91%A8%E8%BE%BA&detailed=true', 'GATEWAY_INTERFACE' => 'CGI/1.1', 'SERVER_PROTOCOL' => 'HTTP/1.1', 'REQUEST_METHOD' => 'GET', 'QUERY_STRING' => 'area=%E6%9C%AD%E5%B9%8C%E9%A7%85%E5%91%A8%E8%BE%BA&detailed=true', 'REQUEST_URI' => '/?area=%E6%9C%AD%E5%B9%8C%E9%A7%85%E5%91%A8%E8%BE%BA&detailed=true', 'SCRIPT_NAME' => '/webroot/index.php', 'PHP_SELF' => '/webroot/index.php', 'REQUEST_TIME_FLOAT' => (float) 1764991773.879, 'REQUEST_TIME' => (int) 1764991773, 'argv' => [ [maximum depth reached] ], 'argc' => (int) 1, 'ORIGINAL_REQUEST_METHOD' => 'GET', 'HTTP_X_REQUESTED_WITH' => null, 'HTTP_REFERER' => null, 'HTTP_IF_NONE_MATCH' => null, 'HTTP_IF_MODIFIED_SINCE' => null ] [protected] _input => null [protected] _detectors => [ 'get' => [ [maximum depth reached] ], 'post' => [ [maximum depth reached] ], 'put' => [ [maximum depth reached] ], 'patch' => [ [maximum depth reached] ], 'delete' => [ [maximum depth reached] ], 'head' => [ [maximum depth reached] ], 'options' => [ [maximum depth reached] ], 'ssl' => [ [maximum depth reached] ], 'ajax' => [ [maximum depth reached] ], 'flash' => [ [maximum depth reached] ], 'requested' => [ [maximum depth reached] ], 'json' => [ [maximum depth reached] ], 'xml' => [ [maximum depth reached] ], 'mobile' => object(Closure) {}, 'tablet' => object(Closure) {} ] [protected] _detectorCache => [ 'ajax' => false, 'get' => true, 'head' => false, 'options' => false ] [protected] stream => object(Zend\Diactoros\PhpInputStream) {} [protected] uri => object(Zend\Diactoros\Uri) {} [protected] session => object(Cake\Network\Session) {} [protected] attributes => [] [protected] emulatedAttributes => [ (int) 0 => 'session', (int) 1 => 'webroot', (int) 2 => 'base', (int) 3 => 'params' ] [protected] uploadedFiles => [] [protected] protocol => null [protected] requestTarget => null } $etags = [] $modifiedSince = null $responseTag = nullcompact - [internal], line ?? Cake\Http\Response::checkNotModified() - CORE/src/Http/Response.php, line 1865 Cake\Controller\Component\RequestHandlerComponent::beforeRender() - CORE/src/Controller/Component/RequestHandlerComponent.php, line 332 Cake\Event\EventManager::_callListener() - CORE/src/Event/EventManager.php, line 414 Cake\Event\EventManager::dispatch() - CORE/src/Event/EventManager.php, line 391 Cake\Controller\Controller::dispatchEvent() - CORE/src/Event/EventDispatcherTrait.php, line 78 Cake\Controller\Controller::render() - CORE/src/Controller/Controller.php, line 610 Cake\Http\ActionDispatcher::_invoke() - CORE/src/Http/ActionDispatcher.php, line 125 Cake\Http\ActionDispatcher::dispatch() - CORE/src/Http/ActionDispatcher.php, line 93 Cake\Http\BaseApplication::__invoke() - CORE/src/Http/BaseApplication.php, line 78 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 Cake\Routing\Middleware\RoutingMiddleware::__invoke() - CORE/src/Routing/Middleware/RoutingMiddleware.php, line 59 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 Cake\Routing\Middleware\AssetMiddleware::__invoke() - CORE/src/Routing/Middleware/AssetMiddleware.php, line 88 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 Cake\Error\Middleware\ErrorHandlerMiddleware::__invoke() - CORE/src/Error/Middleware/ErrorHandlerMiddleware.php, line 92 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65
Warning (512): Unable to emit headers. Headers sent in file=/home/abucha/www/seed/release/vendor/cakephp/cakephp/src/Error/Debugger.php line=822 [CORE/src/Http/ResponseEmitter.php, line 48]Code Context$message = "Unable to emit headers. Headers sent in file=$file line=$line";if (Configure::read('debug')) {trigger_error($message, E_USER_WARNING);$response = object(Cake\Http\Response) { 'status' => (int) 200, 'contentType' => 'text/html', 'headers' => [ 'Content-Type' => [ [maximum depth reached] ] ], 'file' => null, 'fileRange' => [], 'cookies' => [], 'cacheDirectives' => [], 'body' => '' } $maxBufferLength = (int) 8192 $file = '/home/abucha/www/seed/release/vendor/cakephp/cakephp/src/Error/Debugger.php' $line = (int) 822 $message = 'Unable to emit headers. Headers sent in file=/home/abucha/www/seed/release/vendor/cakephp/cakephp/src/Error/Debugger.php line=822'Cake\Http\ResponseEmitter::emit() - CORE/src/Http/ResponseEmitter.php, line 48 Cake\Http\Server::emit() - CORE/src/Http/Server.php, line 106 [main] - ROOT/webroot/index.php, line 37
Warning (2): Cannot modify header information - headers already sent by (output started at /home/abucha/www/seed/release/vendor/cakephp/cakephp/src/Error/Debugger.php:822) [CORE/src/Http/ResponseEmitter.php, line 148]Code Context$response->getProtocolVersion(),$response->getStatusCode(),($reasonPhrase ? ' ' . $reasonPhrase : '')$response = object(Cake\Http\Response) { 'status' => (int) 200, 'contentType' => 'text/html', 'headers' => [ 'Content-Type' => [ [maximum depth reached] ] ], 'file' => null, 'fileRange' => [], 'cookies' => [], 'cacheDirectives' => [], 'body' => '' } $reasonPhrase = 'OK'header - [internal], line ?? Cake\Http\ResponseEmitter::emitStatusLine() - CORE/src/Http/ResponseEmitter.php, line 148 Cake\Http\ResponseEmitter::emit() - CORE/src/Http/ResponseEmitter.php, line 54 Cake\Http\Server::emit() - CORE/src/Http/Server.php, line 106 [main] - ROOT/webroot/index.php, line 37
Warning (2): Cannot modify header information - headers already sent by (output started at /home/abucha/www/seed/release/vendor/cakephp/cakephp/src/Error/Debugger.php:822) [CORE/src/Http/ResponseEmitter.php, line 177]Code Context$first = true;foreach ($values as $value) {header(sprintf($response = object(Cake\Http\Response) { 'status' => (int) 200, 'contentType' => 'text/html', 'headers' => [ 'Content-Type' => [ [maximum depth reached] ] ], 'file' => null, 'fileRange' => [], 'cookies' => [], 'cacheDirectives' => [], 'body' => '' } $cookies = [] $values = [ (int) 0 => 'text/html; charset=UTF-8' ] $name = 'Content-Type' $first = true $value = 'text/html; charset=UTF-8'header - [internal], line ?? Cake\Http\ResponseEmitter::emitHeaders() - CORE/src/Http/ResponseEmitter.php, line 177 Cake\Http\ResponseEmitter::emit() - CORE/src/Http/ResponseEmitter.php, line 55 Cake\Http\Server::emit() - CORE/src/Http/Server.php, line 106 [main] - ROOT/webroot/index.php, line 37
Warning (2): count() [<a href='http://php.net/function.count'>function.count</a>]: Parameter must be an array or an object that implements Countable [CORE/src/Database/QueryCompiler.php, line 128]Code Context{return function ($parts, $name) use (&$sql, $query, $generator) {if (!count($parts)) {$parts = null $name = 'where' $sql = 'SELECT Buildings.area AS `Buildings__area` FROM buildings Buildings' $query = object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SQL could not be generated for this query as it is incomplete.', 'params' => [], 'defaultTypes' => [ 'Buildings__id' => 'biginteger', 'Buildings.id' => 'biginteger', 'id' => 'biginteger', 'Buildings__estates_category' => 'string', 'Buildings.estates_category' => 'string', 'estates_category' => 'string', 'Buildings__owner_id' => 'biginteger', 'Buildings.owner_id' => 'biginteger', 'owner_id' => 'biginteger', 'Buildings__management_id' => 'biginteger', 'Buildings.management_id' => 'biginteger', 'management_id' => 'biginteger', 'Buildings__name' => 'string', 'Buildings.name' => 'string', 'name' => 'string', 'Buildings__yomi' => 'string', 'Buildings.yomi' => 'string', 'yomi' => 'string', 'Buildings__area' => 'string', 'Buildings.area' => 'string', 'area' => 'string', 'Buildings__zip' => 'string', 'Buildings.zip' => 'string', 'zip' => 'string', 'Buildings__address1' => 'string', 'Buildings.address1' => 'string', 'address1' => 'string', 'Buildings__address2' => 'string', 'Buildings.address2' => 'string', 'address2' => 'string', 'Buildings__address3' => 'string', 'Buildings.address3' => 'string', 'address3' => 'string', 'Buildings__address4' => 'string', 'Buildings.address4' => 'string', 'address4' => 'string', 'Buildings__photo' => 'string', 'Buildings.photo' => 'string', 'photo' => 'string', 'Buildings__created' => 'datetime', 'Buildings.created' => 'datetime', 'created' => 'datetime', 'Buildings__modified' => 'datetime', 'Buildings.modified' => 'datetime', 'modified' => 'datetime', 'Buildings__deleted' => 'datetime', 'Buildings.deleted' => 'datetime', 'deleted' => 'datetime' ], 'decorators' => (int) 0, 'executed' => false, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [], 'matching' => [], 'extraOptions' => [], 'repository' => object(App\Model\Table\BuildingsTable) {} } $generator = object(Cake\Database\ValueBinder) { [protected] _bindings => [] [protected] _bindingsCount => (int) 0 }count - [internal], line ?? Cake\Database\QueryCompiler::Cake\Database\{closure}() - CORE/src/Database/QueryCompiler.php, line 128 Cake\Database\Query::traverse() - CORE/src/Database/Query.php, line 311 Cake\Database\QueryCompiler::compile() - CORE/src/Database/QueryCompiler.php, line 99 Cake\Database\Driver::compileQuery() - CORE/src/Database/Driver.php, line 359 Cake\Database\Connection::compileQuery() - CORE/src/Database/Connection.php, line 299 Cake\Database\Query::sql() - CORE/src/Database/Query.php, line 282 Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 990 Cake\Database\Driver\Mysql::prepare() - CORE/src/Database/Driver/Mysql.php, line 136 Cake\Database\Connection::prepare() - CORE/src/Database/Connection.php, line 258 Cake\Database\Connection::run() - CORE/src/Database/Connection.php, line 311 Cake\Database\Query::execute() - CORE/src/Database/Query.php, line 213 Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 1011 Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276 Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 959 Cake\ORM\Query::toArray() - CORE/src/Datasource/QueryTrait.php, line 293 App\View\Helper\Select2Helper::area() - APP/View/Helper/Select2Helper.php, line 205
Warning (2): count() [<a href='http://php.net/function.count'>function.count</a>]: Parameter must be an array or an object that implements Countable [CORE/src/Database/QueryCompiler.php, line 128]Code Context{return function ($parts, $name) use (&$sql, $query, $generator) {if (!count($parts)) {$parts = null $name = 'having' $sql = 'SELECT Buildings.area AS `Buildings__area` FROM buildings Buildings GROUP BY area ' $query = object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SQL could not be generated for this query as it is incomplete.', 'params' => [], 'defaultTypes' => [ 'Buildings__id' => 'biginteger', 'Buildings.id' => 'biginteger', 'id' => 'biginteger', 'Buildings__estates_category' => 'string', 'Buildings.estates_category' => 'string', 'estates_category' => 'string', 'Buildings__owner_id' => 'biginteger', 'Buildings.owner_id' => 'biginteger', 'owner_id' => 'biginteger', 'Buildings__management_id' => 'biginteger', 'Buildings.management_id' => 'biginteger', 'management_id' => 'biginteger', 'Buildings__name' => 'string', 'Buildings.name' => 'string', 'name' => 'string', 'Buildings__yomi' => 'string', 'Buildings.yomi' => 'string', 'yomi' => 'string', 'Buildings__area' => 'string', 'Buildings.area' => 'string', 'area' => 'string', 'Buildings__zip' => 'string', 'Buildings.zip' => 'string', 'zip' => 'string', 'Buildings__address1' => 'string', 'Buildings.address1' => 'string', 'address1' => 'string', 'Buildings__address2' => 'string', 'Buildings.address2' => 'string', 'address2' => 'string', 'Buildings__address3' => 'string', 'Buildings.address3' => 'string', 'address3' => 'string', 'Buildings__address4' => 'string', 'Buildings.address4' => 'string', 'address4' => 'string', 'Buildings__photo' => 'string', 'Buildings.photo' => 'string', 'photo' => 'string', 'Buildings__created' => 'datetime', 'Buildings.created' => 'datetime', 'created' => 'datetime', 'Buildings__modified' => 'datetime', 'Buildings.modified' => 'datetime', 'modified' => 'datetime', 'Buildings__deleted' => 'datetime', 'Buildings.deleted' => 'datetime', 'deleted' => 'datetime' ], 'decorators' => (int) 0, 'executed' => false, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [], 'matching' => [], 'extraOptions' => [], 'repository' => object(App\Model\Table\BuildingsTable) {} } $generator = object(Cake\Database\ValueBinder) { [protected] _bindings => [] [protected] _bindingsCount => (int) 0 }count - [internal], line ?? Cake\Database\QueryCompiler::Cake\Database\{closure}() - CORE/src/Database/QueryCompiler.php, line 128 Cake\Database\Query::traverse() - CORE/src/Database/Query.php, line 311 Cake\Database\QueryCompiler::compile() - CORE/src/Database/QueryCompiler.php, line 99 Cake\Database\Driver::compileQuery() - CORE/src/Database/Driver.php, line 359 Cake\Database\Connection::compileQuery() - CORE/src/Database/Connection.php, line 299 Cake\Database\Query::sql() - CORE/src/Database/Query.php, line 282 Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 990 Cake\Database\Driver\Mysql::prepare() - CORE/src/Database/Driver/Mysql.php, line 136 Cake\Database\Connection::prepare() - CORE/src/Database/Connection.php, line 258 Cake\Database\Connection::run() - CORE/src/Database/Connection.php, line 311 Cake\Database\Query::execute() - CORE/src/Database/Query.php, line 213 Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 1011 Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276 Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 959 Cake\ORM\Query::toArray() - CORE/src/Datasource/QueryTrait.php, line 293 App\View\Helper\Select2Helper::area() - APP/View/Helper/Select2Helper.php, line 205
Warning (2): count() [<a href='http://php.net/function.count'>function.count</a>]: Parameter must be an array or an object that implements Countable [CORE/src/Database/QueryCompiler.php, line 128]Code Context{return function ($parts, $name) use (&$sql, $query, $generator) {if (!count($parts)) {$parts = null $name = 'limit' $sql = 'SELECT Buildings.area AS `Buildings__area` FROM buildings Buildings GROUP BY area ORDER BY Buildings.area ASC' $query = object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SQL could not be generated for this query as it is incomplete.', 'params' => [], 'defaultTypes' => [ 'Buildings__id' => 'biginteger', 'Buildings.id' => 'biginteger', 'id' => 'biginteger', 'Buildings__estates_category' => 'string', 'Buildings.estates_category' => 'string', 'estates_category' => 'string', 'Buildings__owner_id' => 'biginteger', 'Buildings.owner_id' => 'biginteger', 'owner_id' => 'biginteger', 'Buildings__management_id' => 'biginteger', 'Buildings.management_id' => 'biginteger', 'management_id' => 'biginteger', 'Buildings__name' => 'string', 'Buildings.name' => 'string', 'name' => 'string', 'Buildings__yomi' => 'string', 'Buildings.yomi' => 'string', 'yomi' => 'string', 'Buildings__area' => 'string', 'Buildings.area' => 'string', 'area' => 'string', 'Buildings__zip' => 'string', 'Buildings.zip' => 'string', 'zip' => 'string', 'Buildings__address1' => 'string', 'Buildings.address1' => 'string', 'address1' => 'string', 'Buildings__address2' => 'string', 'Buildings.address2' => 'string', 'address2' => 'string', 'Buildings__address3' => 'string', 'Buildings.address3' => 'string', 'address3' => 'string', 'Buildings__address4' => 'string', 'Buildings.address4' => 'string', 'address4' => 'string', 'Buildings__photo' => 'string', 'Buildings.photo' => 'string', 'photo' => 'string', 'Buildings__created' => 'datetime', 'Buildings.created' => 'datetime', 'created' => 'datetime', 'Buildings__modified' => 'datetime', 'Buildings.modified' => 'datetime', 'modified' => 'datetime', 'Buildings__deleted' => 'datetime', 'Buildings.deleted' => 'datetime', 'deleted' => 'datetime' ], 'decorators' => (int) 0, 'executed' => false, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [], 'matching' => [], 'extraOptions' => [], 'repository' => object(App\Model\Table\BuildingsTable) {} } $generator = object(Cake\Database\ValueBinder) { [protected] _bindings => [] [protected] _bindingsCount => (int) 0 }count - [internal], line ?? Cake\Database\QueryCompiler::Cake\Database\{closure}() - CORE/src/Database/QueryCompiler.php, line 128 Cake\Database\Query::traverse() - CORE/src/Database/Query.php, line 311 Cake\Database\QueryCompiler::compile() - CORE/src/Database/QueryCompiler.php, line 99 Cake\Database\Driver::compileQuery() - CORE/src/Database/Driver.php, line 359 Cake\Database\Connection::compileQuery() - CORE/src/Database/Connection.php, line 299 Cake\Database\Query::sql() - CORE/src/Database/Query.php, line 282 Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 990 Cake\Database\Driver\Mysql::prepare() - CORE/src/Database/Driver/Mysql.php, line 136 Cake\Database\Connection::prepare() - CORE/src/Database/Connection.php, line 258 Cake\Database\Connection::run() - CORE/src/Database/Connection.php, line 311 Cake\Database\Query::execute() - CORE/src/Database/Query.php, line 213 Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 1011 Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276 Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 959 Cake\ORM\Query::toArray() - CORE/src/Datasource/QueryTrait.php, line 293 App\View\Helper\Select2Helper::area() - APP/View/Helper/Select2Helper.php, line 205
Warning (2): count() [<a href='http://php.net/function.count'>function.count</a>]: Parameter must be an array or an object that implements Countable [CORE/src/Database/QueryCompiler.php, line 128]Code Context{return function ($parts, $name) use (&$sql, $query, $generator) {if (!count($parts)) {$parts = null $name = 'offset' $sql = 'SELECT Buildings.area AS `Buildings__area` FROM buildings Buildings GROUP BY area ORDER BY Buildings.area ASC' $query = object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SQL could not be generated for this query as it is incomplete.', 'params' => [], 'defaultTypes' => [ 'Buildings__id' => 'biginteger', 'Buildings.id' => 'biginteger', 'id' => 'biginteger', 'Buildings__estates_category' => 'string', 'Buildings.estates_category' => 'string', 'estates_category' => 'string', 'Buildings__owner_id' => 'biginteger', 'Buildings.owner_id' => 'biginteger', 'owner_id' => 'biginteger', 'Buildings__management_id' => 'biginteger', 'Buildings.management_id' => 'biginteger', 'management_id' => 'biginteger', 'Buildings__name' => 'string', 'Buildings.name' => 'string', 'name' => 'string', 'Buildings__yomi' => 'string', 'Buildings.yomi' => 'string', 'yomi' => 'string', 'Buildings__area' => 'string', 'Buildings.area' => 'string', 'area' => 'string', 'Buildings__zip' => 'string', 'Buildings.zip' => 'string', 'zip' => 'string', 'Buildings__address1' => 'string', 'Buildings.address1' => 'string', 'address1' => 'string', 'Buildings__address2' => 'string', 'Buildings.address2' => 'string', 'address2' => 'string', 'Buildings__address3' => 'string', 'Buildings.address3' => 'string', 'address3' => 'string', 'Buildings__address4' => 'string', 'Buildings.address4' => 'string', 'address4' => 'string', 'Buildings__photo' => 'string', 'Buildings.photo' => 'string', 'photo' => 'string', 'Buildings__created' => 'datetime', 'Buildings.created' => 'datetime', 'created' => 'datetime', 'Buildings__modified' => 'datetime', 'Buildings.modified' => 'datetime', 'modified' => 'datetime', 'Buildings__deleted' => 'datetime', 'Buildings.deleted' => 'datetime', 'deleted' => 'datetime' ], 'decorators' => (int) 0, 'executed' => false, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [], 'matching' => [], 'extraOptions' => [], 'repository' => object(App\Model\Table\BuildingsTable) {} } $generator = object(Cake\Database\ValueBinder) { [protected] _bindings => [] [protected] _bindingsCount => (int) 0 }count - [internal], line ?? Cake\Database\QueryCompiler::Cake\Database\{closure}() - CORE/src/Database/QueryCompiler.php, line 128 Cake\Database\Query::traverse() - CORE/src/Database/Query.php, line 311 Cake\Database\QueryCompiler::compile() - CORE/src/Database/QueryCompiler.php, line 99 Cake\Database\Driver::compileQuery() - CORE/src/Database/Driver.php, line 359 Cake\Database\Connection::compileQuery() - CORE/src/Database/Connection.php, line 299 Cake\Database\Query::sql() - CORE/src/Database/Query.php, line 282 Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 990 Cake\Database\Driver\Mysql::prepare() - CORE/src/Database/Driver/Mysql.php, line 136 Cake\Database\Connection::prepare() - CORE/src/Database/Connection.php, line 258 Cake\Database\Connection::run() - CORE/src/Database/Connection.php, line 311 Cake\Database\Query::execute() - CORE/src/Database/Query.php, line 213 Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 1011 Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276 Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 959 Cake\ORM\Query::toArray() - CORE/src/Datasource/QueryTrait.php, line 293 App\View\Helper\Select2Helper::area() - APP/View/Helper/Select2Helper.php, line 205
Warning (2): count() [<a href='http://php.net/function.count'>function.count</a>]: Parameter must be an array or an object that implements Countable [CORE/src/Database/QueryCompiler.php, line 128]Code Context{return function ($parts, $name) use (&$sql, $query, $generator) {if (!count($parts)) {$parts = null $name = 'epilog' $sql = 'SELECT Buildings.area AS `Buildings__area` FROM buildings Buildings GROUP BY area ORDER BY Buildings.area ASC' $query = object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SQL could not be generated for this query as it is incomplete.', 'params' => [], 'defaultTypes' => [ 'Buildings__id' => 'biginteger', 'Buildings.id' => 'biginteger', 'id' => 'biginteger', 'Buildings__estates_category' => 'string', 'Buildings.estates_category' => 'string', 'estates_category' => 'string', 'Buildings__owner_id' => 'biginteger', 'Buildings.owner_id' => 'biginteger', 'owner_id' => 'biginteger', 'Buildings__management_id' => 'biginteger', 'Buildings.management_id' => 'biginteger', 'management_id' => 'biginteger', 'Buildings__name' => 'string', 'Buildings.name' => 'string', 'name' => 'string', 'Buildings__yomi' => 'string', 'Buildings.yomi' => 'string', 'yomi' => 'string', 'Buildings__area' => 'string', 'Buildings.area' => 'string', 'area' => 'string', 'Buildings__zip' => 'string', 'Buildings.zip' => 'string', 'zip' => 'string', 'Buildings__address1' => 'string', 'Buildings.address1' => 'string', 'address1' => 'string', 'Buildings__address2' => 'string', 'Buildings.address2' => 'string', 'address2' => 'string', 'Buildings__address3' => 'string', 'Buildings.address3' => 'string', 'address3' => 'string', 'Buildings__address4' => 'string', 'Buildings.address4' => 'string', 'address4' => 'string', 'Buildings__photo' => 'string', 'Buildings.photo' => 'string', 'photo' => 'string', 'Buildings__created' => 'datetime', 'Buildings.created' => 'datetime', 'created' => 'datetime', 'Buildings__modified' => 'datetime', 'Buildings.modified' => 'datetime', 'modified' => 'datetime', 'Buildings__deleted' => 'datetime', 'Buildings.deleted' => 'datetime', 'deleted' => 'datetime' ], 'decorators' => (int) 0, 'executed' => false, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [], 'matching' => [], 'extraOptions' => [], 'repository' => object(App\Model\Table\BuildingsTable) {} } $generator = object(Cake\Database\ValueBinder) { [protected] _bindings => [] [protected] _bindingsCount => (int) 0 }count - [internal], line ?? Cake\Database\QueryCompiler::Cake\Database\{closure}() - CORE/src/Database/QueryCompiler.php, line 128 Cake\Database\Query::traverse() - CORE/src/Database/Query.php, line 311 Cake\Database\QueryCompiler::compile() - CORE/src/Database/QueryCompiler.php, line 99 Cake\Database\Driver::compileQuery() - CORE/src/Database/Driver.php, line 359 Cake\Database\Connection::compileQuery() - CORE/src/Database/Connection.php, line 299 Cake\Database\Query::sql() - CORE/src/Database/Query.php, line 282 Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 990 Cake\Database\Driver\Mysql::prepare() - CORE/src/Database/Driver/Mysql.php, line 136 Cake\Database\Connection::prepare() - CORE/src/Database/Connection.php, line 258 Cake\Database\Connection::run() - CORE/src/Database/Connection.php, line 311 Cake\Database\Query::execute() - CORE/src/Database/Query.php, line 213 Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 1011 Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276 Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 959 Cake\ORM\Query::toArray() - CORE/src/Datasource/QueryTrait.php, line 293 App\View\Helper\Select2Helper::area() - APP/View/Helper/Select2Helper.php, line 205
Warning (2): count() [<a href='http://php.net/function.count'>function.count</a>]: Parameter must be an array or an object that implements Countable [CORE/src/Database/QueryCompiler.php, line 128]Code Context{return function ($parts, $name) use (&$sql, $query, $generator) {if (!count($parts)) {$parts = null $name = 'having' $sql = 'SELECT Categories.id AS `Categories__id`, Categories.name AS `Categories__name`, Categories.sequence AS `Categories__sequence`, Categories.label AS `Categories__label`, Categories.value AS `Categories__value`, Categories.created AS `Categories__created`, Categories.modified AS `Categories__modified`, Categories.deleted AS `Categories__deleted` FROM categories Categories WHERE (name = :c0 AND (deleted) IS NULL)' $query = object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SQL could not be generated for this query as it is incomplete.', 'params' => [], 'defaultTypes' => [ 'Categories__id' => 'biginteger', 'Categories.id' => 'biginteger', 'id' => 'biginteger', 'Categories__name' => 'string', 'Categories.name' => 'string', 'name' => 'string', 'Categories__sequence' => 'biginteger', 'Categories.sequence' => 'biginteger', 'sequence' => 'biginteger', 'Categories__label' => 'string', 'Categories.label' => 'string', 'label' => 'string', 'Categories__value' => 'string', 'Categories.value' => 'string', 'value' => 'string', 'Categories__created' => 'datetime', 'Categories.created' => 'datetime', 'created' => 'datetime', 'Categories__modified' => 'datetime', 'Categories.modified' => 'datetime', 'modified' => 'datetime', 'Categories__deleted' => 'datetime', 'Categories.deleted' => 'datetime', 'deleted' => 'datetime' ], 'decorators' => (int) 0, 'executed' => false, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [], 'matching' => [], 'extraOptions' => [], 'repository' => object(App\Model\Table\CategoriesTable) {} } $generator = object(Cake\Database\ValueBinder) { [protected] _bindings => [ ':c0' => [ [maximum depth reached] ] ] [protected] _bindingsCount => (int) 1 }count - [internal], line ?? Cake\Database\QueryCompiler::Cake\Database\{closure}() - CORE/src/Database/QueryCompiler.php, line 128 Cake\Database\Query::traverse() - CORE/src/Database/Query.php, line 311 Cake\Database\QueryCompiler::compile() - CORE/src/Database/QueryCompiler.php, line 99 Cake\Database\Driver::compileQuery() - CORE/src/Database/Driver.php, line 359 Cake\Database\Connection::compileQuery() - CORE/src/Database/Connection.php, line 299 Cake\Database\Query::sql() - CORE/src/Database/Query.php, line 282 Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 990 Cake\Database\Driver\Mysql::prepare() - CORE/src/Database/Driver/Mysql.php, line 136 Cake\Database\Connection::prepare() - CORE/src/Database/Connection.php, line 258 Cake\Database\Connection::run() - CORE/src/Database/Connection.php, line 311 Cake\Database\Query::execute() - CORE/src/Database/Query.php, line 213 Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 1011 Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276 Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 959 Cake\ORM\Query::getIterator() - CORE/src/Datasource/QueryTrait.php, line 132 App\View\Helper\Select2Helper::category() - APP/View/Helper/Select2Helper.php, line 397
Warning (2): count() [<a href='http://php.net/function.count'>function.count</a>]: Parameter must be an array or an object that implements Countable [CORE/src/Database/QueryCompiler.php, line 128]Code Context{return function ($parts, $name) use (&$sql, $query, $generator) {if (!count($parts)) {$parts = null $name = 'limit' $sql = 'SELECT Categories.id AS `Categories__id`, Categories.name AS `Categories__name`, Categories.sequence AS `Categories__sequence`, Categories.label AS `Categories__label`, Categories.value AS `Categories__value`, Categories.created AS `Categories__created`, Categories.modified AS `Categories__modified`, Categories.deleted AS `Categories__deleted` FROM categories Categories WHERE (name = :c0 AND (deleted) IS NULL) ORDER BY sequence ASC' $query = object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SQL could not be generated for this query as it is incomplete.', 'params' => [], 'defaultTypes' => [ 'Categories__id' => 'biginteger', 'Categories.id' => 'biginteger', 'id' => 'biginteger', 'Categories__name' => 'string', 'Categories.name' => 'string', 'name' => 'string', 'Categories__sequence' => 'biginteger', 'Categories.sequence' => 'biginteger', 'sequence' => 'biginteger', 'Categories__label' => 'string', 'Categories.label' => 'string', 'label' => 'string', 'Categories__value' => 'string', 'Categories.value' => 'string', 'value' => 'string', 'Categories__created' => 'datetime', 'Categories.created' => 'datetime', 'created' => 'datetime', 'Categories__modified' => 'datetime', 'Categories.modified' => 'datetime', 'modified' => 'datetime', 'Categories__deleted' => 'datetime', 'Categories.deleted' => 'datetime', 'deleted' => 'datetime' ], 'decorators' => (int) 0, 'executed' => false, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [], 'matching' => [], 'extraOptions' => [], 'repository' => object(App\Model\Table\CategoriesTable) {} } $generator = object(Cake\Database\ValueBinder) { [protected] _bindings => [ ':c0' => [ [maximum depth reached] ] ] [protected] _bindingsCount => (int) 1 }count - [internal], line ?? Cake\Database\QueryCompiler::Cake\Database\{closure}() - CORE/src/Database/QueryCompiler.php, line 128 Cake\Database\Query::traverse() - CORE/src/Database/Query.php, line 311 Cake\Database\QueryCompiler::compile() - CORE/src/Database/QueryCompiler.php, line 99 Cake\Database\Driver::compileQuery() - CORE/src/Database/Driver.php, line 359 Cake\Database\Connection::compileQuery() - CORE/src/Database/Connection.php, line 299 Cake\Database\Query::sql() - CORE/src/Database/Query.php, line 282 Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 990 Cake\Database\Driver\Mysql::prepare() - CORE/src/Database/Driver/Mysql.php, line 136 Cake\Database\Connection::prepare() - CORE/src/Database/Connection.php, line 258 Cake\Database\Connection::run() - CORE/src/Database/Connection.php, line 311 Cake\Database\Query::execute() - CORE/src/Database/Query.php, line 213 Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 1011 Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276 Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 959 Cake\ORM\Query::getIterator() - CORE/src/Datasource/QueryTrait.php, line 132 App\View\Helper\Select2Helper::category() - APP/View/Helper/Select2Helper.php, line 397
Warning (2): count() [<a href='http://php.net/function.count'>function.count</a>]: Parameter must be an array or an object that implements Countable [CORE/src/Database/QueryCompiler.php, line 128]Code Context{return function ($parts, $name) use (&$sql, $query, $generator) {if (!count($parts)) {$parts = null $name = 'offset' $sql = 'SELECT Categories.id AS `Categories__id`, Categories.name AS `Categories__name`, Categories.sequence AS `Categories__sequence`, Categories.label AS `Categories__label`, Categories.value AS `Categories__value`, Categories.created AS `Categories__created`, Categories.modified AS `Categories__modified`, Categories.deleted AS `Categories__deleted` FROM categories Categories WHERE (name = :c0 AND (deleted) IS NULL) ORDER BY sequence ASC' $query = object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SQL could not be generated for this query as it is incomplete.', 'params' => [], 'defaultTypes' => [ 'Categories__id' => 'biginteger', 'Categories.id' => 'biginteger', 'id' => 'biginteger', 'Categories__name' => 'string', 'Categories.name' => 'string', 'name' => 'string', 'Categories__sequence' => 'biginteger', 'Categories.sequence' => 'biginteger', 'sequence' => 'biginteger', 'Categories__label' => 'string', 'Categories.label' => 'string', 'label' => 'string', 'Categories__value' => 'string', 'Categories.value' => 'string', 'value' => 'string', 'Categories__created' => 'datetime', 'Categories.created' => 'datetime', 'created' => 'datetime', 'Categories__modified' => 'datetime', 'Categories.modified' => 'datetime', 'modified' => 'datetime', 'Categories__deleted' => 'datetime', 'Categories.deleted' => 'datetime', 'deleted' => 'datetime' ], 'decorators' => (int) 0, 'executed' => false, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [], 'matching' => [], 'extraOptions' => [], 'repository' => object(App\Model\Table\CategoriesTable) {} } $generator = object(Cake\Database\ValueBinder) { [protected] _bindings => [ ':c0' => [ [maximum depth reached] ] ] [protected] _bindingsCount => (int) 1 }count - [internal], line ?? Cake\Database\QueryCompiler::Cake\Database\{closure}() - CORE/src/Database/QueryCompiler.php, line 128 Cake\Database\Query::traverse() - CORE/src/Database/Query.php, line 311 Cake\Database\QueryCompiler::compile() - CORE/src/Database/QueryCompiler.php, line 99 Cake\Database\Driver::compileQuery() - CORE/src/Database/Driver.php, line 359 Cake\Database\Connection::compileQuery() - CORE/src/Database/Connection.php, line 299 Cake\Database\Query::sql() - CORE/src/Database/Query.php, line 282 Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 990 Cake\Database\Driver\Mysql::prepare() - CORE/src/Database/Driver/Mysql.php, line 136 Cake\Database\Connection::prepare() - CORE/src/Database/Connection.php, line 258 Cake\Database\Connection::run() - CORE/src/Database/Connection.php, line 311 Cake\Database\Query::execute() - CORE/src/Database/Query.php, line 213 Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 1011 Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276 Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 959 Cake\ORM\Query::getIterator() - CORE/src/Datasource/QueryTrait.php, line 132 App\View\Helper\Select2Helper::category() - APP/View/Helper/Select2Helper.php, line 397
Warning (2): count() [<a href='http://php.net/function.count'>function.count</a>]: Parameter must be an array or an object that implements Countable [CORE/src/Database/QueryCompiler.php, line 128]Code Context{return function ($parts, $name) use (&$sql, $query, $generator) {if (!count($parts)) {$parts = null $name = 'epilog' $sql = 'SELECT Categories.id AS `Categories__id`, Categories.name AS `Categories__name`, Categories.sequence AS `Categories__sequence`, Categories.label AS `Categories__label`, Categories.value AS `Categories__value`, Categories.created AS `Categories__created`, Categories.modified AS `Categories__modified`, Categories.deleted AS `Categories__deleted` FROM categories Categories WHERE (name = :c0 AND (deleted) IS NULL) ORDER BY sequence ASC' $query = object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SQL could not be generated for this query as it is incomplete.', 'params' => [], 'defaultTypes' => [ 'Categories__id' => 'biginteger', 'Categories.id' => 'biginteger', 'id' => 'biginteger', 'Categories__name' => 'string', 'Categories.name' => 'string', 'name' => 'string', 'Categories__sequence' => 'biginteger', 'Categories.sequence' => 'biginteger', 'sequence' => 'biginteger', 'Categories__label' => 'string', 'Categories.label' => 'string', 'label' => 'string', 'Categories__value' => 'string', 'Categories.value' => 'string', 'value' => 'string', 'Categories__created' => 'datetime', 'Categories.created' => 'datetime', 'created' => 'datetime', 'Categories__modified' => 'datetime', 'Categories.modified' => 'datetime', 'modified' => 'datetime', 'Categories__deleted' => 'datetime', 'Categories.deleted' => 'datetime', 'deleted' => 'datetime' ], 'decorators' => (int) 0, 'executed' => false, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [], 'matching' => [], 'extraOptions' => [], 'repository' => object(App\Model\Table\CategoriesTable) {} } $generator = object(Cake\Database\ValueBinder) { [protected] _bindings => [ ':c0' => [ [maximum depth reached] ] ] [protected] _bindingsCount => (int) 1 }count - [internal], line ?? Cake\Database\QueryCompiler::Cake\Database\{closure}() - CORE/src/Database/QueryCompiler.php, line 128 Cake\Database\Query::traverse() - CORE/src/Database/Query.php, line 311 Cake\Database\QueryCompiler::compile() - CORE/src/Database/QueryCompiler.php, line 99 Cake\Database\Driver::compileQuery() - CORE/src/Database/Driver.php, line 359 Cake\Database\Connection::compileQuery() - CORE/src/Database/Connection.php, line 299 Cake\Database\Query::sql() - CORE/src/Database/Query.php, line 282 Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 990 Cake\Database\Driver\Mysql::prepare() - CORE/src/Database/Driver/Mysql.php, line 136 Cake\Database\Connection::prepare() - CORE/src/Database/Connection.php, line 258 Cake\Database\Connection::run() - CORE/src/Database/Connection.php, line 311 Cake\Database\Query::execute() - CORE/src/Database/Query.php, line 213 Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 1011 Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276 Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 959 Cake\ORM\Query::getIterator() - CORE/src/Datasource/QueryTrait.php, line 132 App\View\Helper\Select2Helper::category() - APP/View/Helper/Select2Helper.php, line 397
Warning (2): count() [<a href='http://php.net/function.count'>function.count</a>]: Parameter must be an array or an object that implements Countable [CORE/src/Database/QueryCompiler.php, line 128]Code Context{return function ($parts, $name) use (&$sql, $query, $generator) {if (!count($parts)) {$parts = null $name = 'where' $sql = 'SELECT Estates.business_category AS `Estates__business_category` FROM estates Estates' $query = object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SQL could not be generated for this query as it is incomplete.', 'params' => [], 'defaultTypes' => [ 'Estates__id' => 'biginteger', 'Estates.id' => 'biginteger', 'id' => 'biginteger', 'Estates__type' => 'string', 'Estates.type' => 'string', 'type' => 'string', 'Estates__invalid' => 'string', 'Estates.invalid' => 'string', 'invalid' => 'string', 'Estates__special_selection' => 'integer', 'Estates.special_selection' => 'integer', 'special_selection' => 'integer', 'Estates__new_sign' => 'integer', 'Estates.new_sign' => 'integer', 'new_sign' => 'integer', 'Estates__building_id' => 'biginteger', 'Estates.building_id' => 'biginteger', 'building_id' => 'biginteger', 'Estates__address1' => 'string', 'Estates.address1' => 'string', 'address1' => 'string', 'Estates__address2' => 'string', 'Estates.address2' => 'string', 'address2' => 'string', 'Estates__name' => 'string', 'Estates.name' => 'string', 'name' => 'string', 'Estates__floor' => 'string', 'Estates.floor' => 'string', 'floor' => 'string', 'Estates__floor_sequence' => 'integer', 'Estates.floor_sequence' => 'integer', 'floor_sequence' => 'integer', 'Estates__tsubo' => 'decimal', 'Estates.tsubo' => 'decimal', 'tsubo' => 'decimal', 'Estates__space' => 'decimal', 'Estates.space' => 'decimal', 'space' => 'decimal', 'Estates__rent_category' => 'string', 'Estates.rent_category' => 'string', 'rent_category' => 'string', 'Estates__rent_expense' => 'biginteger', 'Estates.rent_expense' => 'biginteger', 'rent_expense' => 'biginteger', 'Estates__common_service_category' => 'string', 'Estates.common_service_category' => 'string', 'common_service_category' => 'string', 'Estates__common_service_expense' => 'biginteger', 'Estates.common_service_expense' => 'biginteger', 'common_service_expense' => 'biginteger', 'Estates__air_conditioning_category' => 'string', 'Estates.air_conditioning_category' => 'string', 'air_conditioning_category' => 'string', 'Estates__air_conditioning_expense' => 'biginteger', 'Estates.air_conditioning_expense' => 'biginteger', 'air_conditioning_expense' => 'biginteger', 'Estates__caution_money_category' => 'string', 'Estates.caution_money_category' => 'string', 'caution_money_category' => 'string', 'Estates__caution_money_expense' => 'biginteger', 'Estates.caution_money_expense' => 'biginteger', 'caution_money_expense' => 'biginteger', 'Estates__security_money_category' => 'string', 'Estates.security_money_category' => 'string', 'security_money_category' => 'string', 'Estates__security_money_expense' => 'biginteger', 'Estates.security_money_expense' => 'biginteger', 'security_money_expense' => 'biginteger', 'Estates__key_money_category' => 'string', 'Estates.key_money_category' => 'string', 'key_money_category' => 'string', 'Estates__key_money_expense' => 'biginteger', 'Estates.key_money_expense' => 'biginteger', 'key_money_expense' => 'biginteger', 'Estates__contract' => 'string', 'Estates.contract' => 'string', 'contract' => 'string', 'Estates__business_category' => 'string', 'Estates.business_category' => 'string', 'business_category' => 'string', 'Estates__transfer' => 'string', 'Estates.transfer' => 'string', 'transfer' => 'string', 'Estates__area' => 'string', 'Estates.area' => 'string', 'area' => 'string', 'Estates__note1' => 'string', 'Estates.note1' => 'string', 'note1' => 'string', 'Estates__note2' => 'string', 'Estates.note2' => 'string', 'note2' => 'string', 'Estates__note3' => 'string', 'Estates.note3' => 'string', 'note3' => 'string', 'Estates__internal_note1' => 'string', 'Estates.internal_note1' => 'string', 'internal_note1' => 'string', 'Estates__internal_note2' => 'string', 'Estates.internal_note2' => 'string', 'internal_note2' => 'string', 'Estates__secret' => 'string', 'Estates.secret' => 'string', 'secret' => 'string', 'Estates__staff' => 'string', 'Estates.staff' => 'string', 'staff' => 'string', 'Estates__inputter' => 'string', 'Estates.inputter' => 'string', 'inputter' => 'string', 'Estates__photo_sign' => 'string', 'Estates.photo_sign' => 'string', 'photo_sign' => 'string', 'Estates__photo1' => 'string', 'Estates.photo1' => 'string', 'photo1' => 'string', 'Estates__photo2' => 'string', 'Estates.photo2' => 'string', 'photo2' => 'string', 'Estates__photo3' => 'string', 'Estates.photo3' => 'string', 'photo3' => 'string', 'Estates__photo4' => 'string', 'Estates.photo4' => 'string', 'photo4' => 'string', 'Estates__photo5' => 'string', 'Estates.photo5' => 'string', 'photo5' => 'string', 'Estates__photo6' => 'string', 'Estates.photo6' => 'string', 'photo6' => 'string', 'Estates__floor_plan' => 'string', 'Estates.floor_plan' => 'string', 'floor_plan' => 'string', 'Estates__created' => 'datetime', 'Estates.created' => 'datetime', 'created' => 'datetime', 'Estates__modified' => 'datetime', 'Estates.modified' => 'datetime', 'modified' => 'datetime', 'Estates__deleted' => 'datetime', 'Estates.deleted' => 'datetime', 'deleted' => 'datetime' ], 'decorators' => (int) 0, 'executed' => false, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [], 'matching' => [], 'extraOptions' => [], 'repository' => object(App\Model\Table\EstatesTable) {} } $generator = object(Cake\Database\ValueBinder) { [protected] _bindings => [] [protected] _bindingsCount => (int) 0 }count - [internal], line ?? Cake\Database\QueryCompiler::Cake\Database\{closure}() - CORE/src/Database/QueryCompiler.php, line 128 Cake\Database\Query::traverse() - CORE/src/Database/Query.php, line 311 Cake\Database\QueryCompiler::compile() - CORE/src/Database/QueryCompiler.php, line 99 Cake\Database\Driver::compileQuery() - CORE/src/Database/Driver.php, line 359 Cake\Database\Connection::compileQuery() - CORE/src/Database/Connection.php, line 299 Cake\Database\Query::sql() - CORE/src/Database/Query.php, line 282 Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 990 Cake\Database\Driver\Mysql::prepare() - CORE/src/Database/Driver/Mysql.php, line 136 Cake\Database\Connection::prepare() - CORE/src/Database/Connection.php, line 258 Cake\Database\Connection::run() - CORE/src/Database/Connection.php, line 311 Cake\Database\Query::execute() - CORE/src/Database/Query.php, line 213 Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 1011 Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276 Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 959 Cake\ORM\Query::toArray() - CORE/src/Datasource/QueryTrait.php, line 293 App\View\Helper\Select2Helper::business_category() - APP/View/Helper/Select2Helper.php, line 265
Warning (2): count() [<a href='http://php.net/function.count'>function.count</a>]: Parameter must be an array or an object that implements Countable [CORE/src/Database/QueryCompiler.php, line 128]Code Context{return function ($parts, $name) use (&$sql, $query, $generator) {if (!count($parts)) {$parts = null $name = 'having' $sql = 'SELECT Estates.business_category AS `Estates__business_category` FROM estates Estates GROUP BY business_category ' $query = object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SQL could not be generated for this query as it is incomplete.', 'params' => [], 'defaultTypes' => [ 'Estates__id' => 'biginteger', 'Estates.id' => 'biginteger', 'id' => 'biginteger', 'Estates__type' => 'string', 'Estates.type' => 'string', 'type' => 'string', 'Estates__invalid' => 'string', 'Estates.invalid' => 'string', 'invalid' => 'string', 'Estates__special_selection' => 'integer', 'Estates.special_selection' => 'integer', 'special_selection' => 'integer', 'Estates__new_sign' => 'integer', 'Estates.new_sign' => 'integer', 'new_sign' => 'integer', 'Estates__building_id' => 'biginteger', 'Estates.building_id' => 'biginteger', 'building_id' => 'biginteger', 'Estates__address1' => 'string', 'Estates.address1' => 'string', 'address1' => 'string', 'Estates__address2' => 'string', 'Estates.address2' => 'string', 'address2' => 'string', 'Estates__name' => 'string', 'Estates.name' => 'string', 'name' => 'string', 'Estates__floor' => 'string', 'Estates.floor' => 'string', 'floor' => 'string', 'Estates__floor_sequence' => 'integer', 'Estates.floor_sequence' => 'integer', 'floor_sequence' => 'integer', 'Estates__tsubo' => 'decimal', 'Estates.tsubo' => 'decimal', 'tsubo' => 'decimal', 'Estates__space' => 'decimal', 'Estates.space' => 'decimal', 'space' => 'decimal', 'Estates__rent_category' => 'string', 'Estates.rent_category' => 'string', 'rent_category' => 'string', 'Estates__rent_expense' => 'biginteger', 'Estates.rent_expense' => 'biginteger', 'rent_expense' => 'biginteger', 'Estates__common_service_category' => 'string', 'Estates.common_service_category' => 'string', 'common_service_category' => 'string', 'Estates__common_service_expense' => 'biginteger', 'Estates.common_service_expense' => 'biginteger', 'common_service_expense' => 'biginteger', 'Estates__air_conditioning_category' => 'string', 'Estates.air_conditioning_category' => 'string', 'air_conditioning_category' => 'string', 'Estates__air_conditioning_expense' => 'biginteger', 'Estates.air_conditioning_expense' => 'biginteger', 'air_conditioning_expense' => 'biginteger', 'Estates__caution_money_category' => 'string', 'Estates.caution_money_category' => 'string', 'caution_money_category' => 'string', 'Estates__caution_money_expense' => 'biginteger', 'Estates.caution_money_expense' => 'biginteger', 'caution_money_expense' => 'biginteger', 'Estates__security_money_category' => 'string', 'Estates.security_money_category' => 'string', 'security_money_category' => 'string', 'Estates__security_money_expense' => 'biginteger', 'Estates.security_money_expense' => 'biginteger', 'security_money_expense' => 'biginteger', 'Estates__key_money_category' => 'string', 'Estates.key_money_category' => 'string', 'key_money_category' => 'string', 'Estates__key_money_expense' => 'biginteger', 'Estates.key_money_expense' => 'biginteger', 'key_money_expense' => 'biginteger', 'Estates__contract' => 'string', 'Estates.contract' => 'string', 'contract' => 'string', 'Estates__business_category' => 'string', 'Estates.business_category' => 'string', 'business_category' => 'string', 'Estates__transfer' => 'string', 'Estates.transfer' => 'string', 'transfer' => 'string', 'Estates__area' => 'string', 'Estates.area' => 'string', 'area' => 'string', 'Estates__note1' => 'string', 'Estates.note1' => 'string', 'note1' => 'string', 'Estates__note2' => 'string', 'Estates.note2' => 'string', 'note2' => 'string', 'Estates__note3' => 'string', 'Estates.note3' => 'string', 'note3' => 'string', 'Estates__internal_note1' => 'string', 'Estates.internal_note1' => 'string', 'internal_note1' => 'string', 'Estates__internal_note2' => 'string', 'Estates.internal_note2' => 'string', 'internal_note2' => 'string', 'Estates__secret' => 'string', 'Estates.secret' => 'string', 'secret' => 'string', 'Estates__staff' => 'string', 'Estates.staff' => 'string', 'staff' => 'string', 'Estates__inputter' => 'string', 'Estates.inputter' => 'string', 'inputter' => 'string', 'Estates__photo_sign' => 'string', 'Estates.photo_sign' => 'string', 'photo_sign' => 'string', 'Estates__photo1' => 'string', 'Estates.photo1' => 'string', 'photo1' => 'string', 'Estates__photo2' => 'string', 'Estates.photo2' => 'string', 'photo2' => 'string', 'Estates__photo3' => 'string', 'Estates.photo3' => 'string', 'photo3' => 'string', 'Estates__photo4' => 'string', 'Estates.photo4' => 'string', 'photo4' => 'string', 'Estates__photo5' => 'string', 'Estates.photo5' => 'string', 'photo5' => 'string', 'Estates__photo6' => 'string', 'Estates.photo6' => 'string', 'photo6' => 'string', 'Estates__floor_plan' => 'string', 'Estates.floor_plan' => 'string', 'floor_plan' => 'string', 'Estates__created' => 'datetime', 'Estates.created' => 'datetime', 'created' => 'datetime', 'Estates__modified' => 'datetime', 'Estates.modified' => 'datetime', 'modified' => 'datetime', 'Estates__deleted' => 'datetime', 'Estates.deleted' => 'datetime', 'deleted' => 'datetime' ], 'decorators' => (int) 0, 'executed' => false, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [], 'matching' => [], 'extraOptions' => [], 'repository' => object(App\Model\Table\EstatesTable) {} } $generator = object(Cake\Database\ValueBinder) { [protected] _bindings => [] [protected] _bindingsCount => (int) 0 }count - [internal], line ?? Cake\Database\QueryCompiler::Cake\Database\{closure}() - CORE/src/Database/QueryCompiler.php, line 128 Cake\Database\Query::traverse() - CORE/src/Database/Query.php, line 311 Cake\Database\QueryCompiler::compile() - CORE/src/Database/QueryCompiler.php, line 99 Cake\Database\Driver::compileQuery() - CORE/src/Database/Driver.php, line 359 Cake\Database\Connection::compileQuery() - CORE/src/Database/Connection.php, line 299 Cake\Database\Query::sql() - CORE/src/Database/Query.php, line 282 Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 990 Cake\Database\Driver\Mysql::prepare() - CORE/src/Database/Driver/Mysql.php, line 136 Cake\Database\Connection::prepare() - CORE/src/Database/Connection.php, line 258 Cake\Database\Connection::run() - CORE/src/Database/Connection.php, line 311 Cake\Database\Query::execute() - CORE/src/Database/Query.php, line 213 Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 1011 Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276 Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 959 Cake\ORM\Query::toArray() - CORE/src/Datasource/QueryTrait.php, line 293 App\View\Helper\Select2Helper::business_category() - APP/View/Helper/Select2Helper.php, line 265
Warning (2): count() [<a href='http://php.net/function.count'>function.count</a>]: Parameter must be an array or an object that implements Countable [CORE/src/Database/QueryCompiler.php, line 128]Code Context{return function ($parts, $name) use (&$sql, $query, $generator) {if (!count($parts)) {$parts = null $name = 'limit' $sql = 'SELECT Estates.business_category AS `Estates__business_category` FROM estates Estates GROUP BY business_category ORDER BY Estates.business_category ASC' $query = object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SQL could not be generated for this query as it is incomplete.', 'params' => [], 'defaultTypes' => [ 'Estates__id' => 'biginteger', 'Estates.id' => 'biginteger', 'id' => 'biginteger', 'Estates__type' => 'string', 'Estates.type' => 'string', 'type' => 'string', 'Estates__invalid' => 'string', 'Estates.invalid' => 'string', 'invalid' => 'string', 'Estates__special_selection' => 'integer', 'Estates.special_selection' => 'integer', 'special_selection' => 'integer', 'Estates__new_sign' => 'integer', 'Estates.new_sign' => 'integer', 'new_sign' => 'integer', 'Estates__building_id' => 'biginteger', 'Estates.building_id' => 'biginteger', 'building_id' => 'biginteger', 'Estates__address1' => 'string', 'Estates.address1' => 'string', 'address1' => 'string', 'Estates__address2' => 'string', 'Estates.address2' => 'string', 'address2' => 'string', 'Estates__name' => 'string', 'Estates.name' => 'string', 'name' => 'string', 'Estates__floor' => 'string', 'Estates.floor' => 'string', 'floor' => 'string', 'Estates__floor_sequence' => 'integer', 'Estates.floor_sequence' => 'integer', 'floor_sequence' => 'integer', 'Estates__tsubo' => 'decimal', 'Estates.tsubo' => 'decimal', 'tsubo' => 'decimal', 'Estates__space' => 'decimal', 'Estates.space' => 'decimal', 'space' => 'decimal', 'Estates__rent_category' => 'string', 'Estates.rent_category' => 'string', 'rent_category' => 'string', 'Estates__rent_expense' => 'biginteger', 'Estates.rent_expense' => 'biginteger', 'rent_expense' => 'biginteger', 'Estates__common_service_category' => 'string', 'Estates.common_service_category' => 'string', 'common_service_category' => 'string', 'Estates__common_service_expense' => 'biginteger', 'Estates.common_service_expense' => 'biginteger', 'common_service_expense' => 'biginteger', 'Estates__air_conditioning_category' => 'string', 'Estates.air_conditioning_category' => 'string', 'air_conditioning_category' => 'string', 'Estates__air_conditioning_expense' => 'biginteger', 'Estates.air_conditioning_expense' => 'biginteger', 'air_conditioning_expense' => 'biginteger', 'Estates__caution_money_category' => 'string', 'Estates.caution_money_category' => 'string', 'caution_money_category' => 'string', 'Estates__caution_money_expense' => 'biginteger', 'Estates.caution_money_expense' => 'biginteger', 'caution_money_expense' => 'biginteger', 'Estates__security_money_category' => 'string', 'Estates.security_money_category' => 'string', 'security_money_category' => 'string', 'Estates__security_money_expense' => 'biginteger', 'Estates.security_money_expense' => 'biginteger', 'security_money_expense' => 'biginteger', 'Estates__key_money_category' => 'string', 'Estates.key_money_category' => 'string', 'key_money_category' => 'string', 'Estates__key_money_expense' => 'biginteger', 'Estates.key_money_expense' => 'biginteger', 'key_money_expense' => 'biginteger', 'Estates__contract' => 'string', 'Estates.contract' => 'string', 'contract' => 'string', 'Estates__business_category' => 'string', 'Estates.business_category' => 'string', 'business_category' => 'string', 'Estates__transfer' => 'string', 'Estates.transfer' => 'string', 'transfer' => 'string', 'Estates__area' => 'string', 'Estates.area' => 'string', 'area' => 'string', 'Estates__note1' => 'string', 'Estates.note1' => 'string', 'note1' => 'string', 'Estates__note2' => 'string', 'Estates.note2' => 'string', 'note2' => 'string', 'Estates__note3' => 'string', 'Estates.note3' => 'string', 'note3' => 'string', 'Estates__internal_note1' => 'string', 'Estates.internal_note1' => 'string', 'internal_note1' => 'string', 'Estates__internal_note2' => 'string', 'Estates.internal_note2' => 'string', 'internal_note2' => 'string', 'Estates__secret' => 'string', 'Estates.secret' => 'string', 'secret' => 'string', 'Estates__staff' => 'string', 'Estates.staff' => 'string', 'staff' => 'string', 'Estates__inputter' => 'string', 'Estates.inputter' => 'string', 'inputter' => 'string', 'Estates__photo_sign' => 'string', 'Estates.photo_sign' => 'string', 'photo_sign' => 'string', 'Estates__photo1' => 'string', 'Estates.photo1' => 'string', 'photo1' => 'string', 'Estates__photo2' => 'string', 'Estates.photo2' => 'string', 'photo2' => 'string', 'Estates__photo3' => 'string', 'Estates.photo3' => 'string', 'photo3' => 'string', 'Estates__photo4' => 'string', 'Estates.photo4' => 'string', 'photo4' => 'string', 'Estates__photo5' => 'string', 'Estates.photo5' => 'string', 'photo5' => 'string', 'Estates__photo6' => 'string', 'Estates.photo6' => 'string', 'photo6' => 'string', 'Estates__floor_plan' => 'string', 'Estates.floor_plan' => 'string', 'floor_plan' => 'string', 'Estates__created' => 'datetime', 'Estates.created' => 'datetime', 'created' => 'datetime', 'Estates__modified' => 'datetime', 'Estates.modified' => 'datetime', 'modified' => 'datetime', 'Estates__deleted' => 'datetime', 'Estates.deleted' => 'datetime', 'deleted' => 'datetime' ], 'decorators' => (int) 0, 'executed' => false, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [], 'matching' => [], 'extraOptions' => [], 'repository' => object(App\Model\Table\EstatesTable) {} } $generator = object(Cake\Database\ValueBinder) { [protected] _bindings => [] [protected] _bindingsCount => (int) 0 }count - [internal], line ?? Cake\Database\QueryCompiler::Cake\Database\{closure}() - CORE/src/Database/QueryCompiler.php, line 128 Cake\Database\Query::traverse() - CORE/src/Database/Query.php, line 311 Cake\Database\QueryCompiler::compile() - CORE/src/Database/QueryCompiler.php, line 99 Cake\Database\Driver::compileQuery() - CORE/src/Database/Driver.php, line 359 Cake\Database\Connection::compileQuery() - CORE/src/Database/Connection.php, line 299 Cake\Database\Query::sql() - CORE/src/Database/Query.php, line 282 Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 990 Cake\Database\Driver\Mysql::prepare() - CORE/src/Database/Driver/Mysql.php, line 136 Cake\Database\Connection::prepare() - CORE/src/Database/Connection.php, line 258 Cake\Database\Connection::run() - CORE/src/Database/Connection.php, line 311 Cake\Database\Query::execute() - CORE/src/Database/Query.php, line 213 Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 1011 Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276 Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 959 Cake\ORM\Query::toArray() - CORE/src/Datasource/QueryTrait.php, line 293 App\View\Helper\Select2Helper::business_category() - APP/View/Helper/Select2Helper.php, line 265
Warning (2): count() [<a href='http://php.net/function.count'>function.count</a>]: Parameter must be an array or an object that implements Countable [CORE/src/Database/QueryCompiler.php, line 128]Code Context{return function ($parts, $name) use (&$sql, $query, $generator) {if (!count($parts)) {$parts = null $name = 'offset' $sql = 'SELECT Estates.business_category AS `Estates__business_category` FROM estates Estates GROUP BY business_category ORDER BY Estates.business_category ASC' $query = object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SQL could not be generated for this query as it is incomplete.', 'params' => [], 'defaultTypes' => [ 'Estates__id' => 'biginteger', 'Estates.id' => 'biginteger', 'id' => 'biginteger', 'Estates__type' => 'string', 'Estates.type' => 'string', 'type' => 'string', 'Estates__invalid' => 'string', 'Estates.invalid' => 'string', 'invalid' => 'string', 'Estates__special_selection' => 'integer', 'Estates.special_selection' => 'integer', 'special_selection' => 'integer', 'Estates__new_sign' => 'integer', 'Estates.new_sign' => 'integer', 'new_sign' => 'integer', 'Estates__building_id' => 'biginteger', 'Estates.building_id' => 'biginteger', 'building_id' => 'biginteger', 'Estates__address1' => 'string', 'Estates.address1' => 'string', 'address1' => 'string', 'Estates__address2' => 'string', 'Estates.address2' => 'string', 'address2' => 'string', 'Estates__name' => 'string', 'Estates.name' => 'string', 'name' => 'string', 'Estates__floor' => 'string', 'Estates.floor' => 'string', 'floor' => 'string', 'Estates__floor_sequence' => 'integer', 'Estates.floor_sequence' => 'integer', 'floor_sequence' => 'integer', 'Estates__tsubo' => 'decimal', 'Estates.tsubo' => 'decimal', 'tsubo' => 'decimal', 'Estates__space' => 'decimal', 'Estates.space' => 'decimal', 'space' => 'decimal', 'Estates__rent_category' => 'string', 'Estates.rent_category' => 'string', 'rent_category' => 'string', 'Estates__rent_expense' => 'biginteger', 'Estates.rent_expense' => 'biginteger', 'rent_expense' => 'biginteger', 'Estates__common_service_category' => 'string', 'Estates.common_service_category' => 'string', 'common_service_category' => 'string', 'Estates__common_service_expense' => 'biginteger', 'Estates.common_service_expense' => 'biginteger', 'common_service_expense' => 'biginteger', 'Estates__air_conditioning_category' => 'string', 'Estates.air_conditioning_category' => 'string', 'air_conditioning_category' => 'string', 'Estates__air_conditioning_expense' => 'biginteger', 'Estates.air_conditioning_expense' => 'biginteger', 'air_conditioning_expense' => 'biginteger', 'Estates__caution_money_category' => 'string', 'Estates.caution_money_category' => 'string', 'caution_money_category' => 'string', 'Estates__caution_money_expense' => 'biginteger', 'Estates.caution_money_expense' => 'biginteger', 'caution_money_expense' => 'biginteger', 'Estates__security_money_category' => 'string', 'Estates.security_money_category' => 'string', 'security_money_category' => 'string', 'Estates__security_money_expense' => 'biginteger', 'Estates.security_money_expense' => 'biginteger', 'security_money_expense' => 'biginteger', 'Estates__key_money_category' => 'string', 'Estates.key_money_category' => 'string', 'key_money_category' => 'string', 'Estates__key_money_expense' => 'biginteger', 'Estates.key_money_expense' => 'biginteger', 'key_money_expense' => 'biginteger', 'Estates__contract' => 'string', 'Estates.contract' => 'string', 'contract' => 'string', 'Estates__business_category' => 'string', 'Estates.business_category' => 'string', 'business_category' => 'string', 'Estates__transfer' => 'string', 'Estates.transfer' => 'string', 'transfer' => 'string', 'Estates__area' => 'string', 'Estates.area' => 'string', 'area' => 'string', 'Estates__note1' => 'string', 'Estates.note1' => 'string', 'note1' => 'string', 'Estates__note2' => 'string', 'Estates.note2' => 'string', 'note2' => 'string', 'Estates__note3' => 'string', 'Estates.note3' => 'string', 'note3' => 'string', 'Estates__internal_note1' => 'string', 'Estates.internal_note1' => 'string', 'internal_note1' => 'string', 'Estates__internal_note2' => 'string', 'Estates.internal_note2' => 'string', 'internal_note2' => 'string', 'Estates__secret' => 'string', 'Estates.secret' => 'string', 'secret' => 'string', 'Estates__staff' => 'string', 'Estates.staff' => 'string', 'staff' => 'string', 'Estates__inputter' => 'string', 'Estates.inputter' => 'string', 'inputter' => 'string', 'Estates__photo_sign' => 'string', 'Estates.photo_sign' => 'string', 'photo_sign' => 'string', 'Estates__photo1' => 'string', 'Estates.photo1' => 'string', 'photo1' => 'string', 'Estates__photo2' => 'string', 'Estates.photo2' => 'string', 'photo2' => 'string', 'Estates__photo3' => 'string', 'Estates.photo3' => 'string', 'photo3' => 'string', 'Estates__photo4' => 'string', 'Estates.photo4' => 'string', 'photo4' => 'string', 'Estates__photo5' => 'string', 'Estates.photo5' => 'string', 'photo5' => 'string', 'Estates__photo6' => 'string', 'Estates.photo6' => 'string', 'photo6' => 'string', 'Estates__floor_plan' => 'string', 'Estates.floor_plan' => 'string', 'floor_plan' => 'string', 'Estates__created' => 'datetime', 'Estates.created' => 'datetime', 'created' => 'datetime', 'Estates__modified' => 'datetime', 'Estates.modified' => 'datetime', 'modified' => 'datetime', 'Estates__deleted' => 'datetime', 'Estates.deleted' => 'datetime', 'deleted' => 'datetime' ], 'decorators' => (int) 0, 'executed' => false, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [], 'matching' => [], 'extraOptions' => [], 'repository' => object(App\Model\Table\EstatesTable) {} } $generator = object(Cake\Database\ValueBinder) { [protected] _bindings => [] [protected] _bindingsCount => (int) 0 }count - [internal], line ?? Cake\Database\QueryCompiler::Cake\Database\{closure}() - CORE/src/Database/QueryCompiler.php, line 128 Cake\Database\Query::traverse() - CORE/src/Database/Query.php, line 311 Cake\Database\QueryCompiler::compile() - CORE/src/Database/QueryCompiler.php, line 99 Cake\Database\Driver::compileQuery() - CORE/src/Database/Driver.php, line 359 Cake\Database\Connection::compileQuery() - CORE/src/Database/Connection.php, line 299 Cake\Database\Query::sql() - CORE/src/Database/Query.php, line 282 Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 990 Cake\Database\Driver\Mysql::prepare() - CORE/src/Database/Driver/Mysql.php, line 136 Cake\Database\Connection::prepare() - CORE/src/Database/Connection.php, line 258 Cake\Database\Connection::run() - CORE/src/Database/Connection.php, line 311 Cake\Database\Query::execute() - CORE/src/Database/Query.php, line 213 Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 1011 Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276 Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 959 Cake\ORM\Query::toArray() - CORE/src/Datasource/QueryTrait.php, line 293 App\View\Helper\Select2Helper::business_category() - APP/View/Helper/Select2Helper.php, line 265
Warning (2): count() [<a href='http://php.net/function.count'>function.count</a>]: Parameter must be an array or an object that implements Countable [CORE/src/Database/QueryCompiler.php, line 128]Code Context{return function ($parts, $name) use (&$sql, $query, $generator) {if (!count($parts)) {$parts = null $name = 'epilog' $sql = 'SELECT Estates.business_category AS `Estates__business_category` FROM estates Estates GROUP BY business_category ORDER BY Estates.business_category ASC' $query = object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SQL could not be generated for this query as it is incomplete.', 'params' => [], 'defaultTypes' => [ 'Estates__id' => 'biginteger', 'Estates.id' => 'biginteger', 'id' => 'biginteger', 'Estates__type' => 'string', 'Estates.type' => 'string', 'type' => 'string', 'Estates__invalid' => 'string', 'Estates.invalid' => 'string', 'invalid' => 'string', 'Estates__special_selection' => 'integer', 'Estates.special_selection' => 'integer', 'special_selection' => 'integer', 'Estates__new_sign' => 'integer', 'Estates.new_sign' => 'integer', 'new_sign' => 'integer', 'Estates__building_id' => 'biginteger', 'Estates.building_id' => 'biginteger', 'building_id' => 'biginteger', 'Estates__address1' => 'string', 'Estates.address1' => 'string', 'address1' => 'string', 'Estates__address2' => 'string', 'Estates.address2' => 'string', 'address2' => 'string', 'Estates__name' => 'string', 'Estates.name' => 'string', 'name' => 'string', 'Estates__floor' => 'string', 'Estates.floor' => 'string', 'floor' => 'string', 'Estates__floor_sequence' => 'integer', 'Estates.floor_sequence' => 'integer', 'floor_sequence' => 'integer', 'Estates__tsubo' => 'decimal', 'Estates.tsubo' => 'decimal', 'tsubo' => 'decimal', 'Estates__space' => 'decimal', 'Estates.space' => 'decimal', 'space' => 'decimal', 'Estates__rent_category' => 'string', 'Estates.rent_category' => 'string', 'rent_category' => 'string', 'Estates__rent_expense' => 'biginteger', 'Estates.rent_expense' => 'biginteger', 'rent_expense' => 'biginteger', 'Estates__common_service_category' => 'string', 'Estates.common_service_category' => 'string', 'common_service_category' => 'string', 'Estates__common_service_expense' => 'biginteger', 'Estates.common_service_expense' => 'biginteger', 'common_service_expense' => 'biginteger', 'Estates__air_conditioning_category' => 'string', 'Estates.air_conditioning_category' => 'string', 'air_conditioning_category' => 'string', 'Estates__air_conditioning_expense' => 'biginteger', 'Estates.air_conditioning_expense' => 'biginteger', 'air_conditioning_expense' => 'biginteger', 'Estates__caution_money_category' => 'string', 'Estates.caution_money_category' => 'string', 'caution_money_category' => 'string', 'Estates__caution_money_expense' => 'biginteger', 'Estates.caution_money_expense' => 'biginteger', 'caution_money_expense' => 'biginteger', 'Estates__security_money_category' => 'string', 'Estates.security_money_category' => 'string', 'security_money_category' => 'string', 'Estates__security_money_expense' => 'biginteger', 'Estates.security_money_expense' => 'biginteger', 'security_money_expense' => 'biginteger', 'Estates__key_money_category' => 'string', 'Estates.key_money_category' => 'string', 'key_money_category' => 'string', 'Estates__key_money_expense' => 'biginteger', 'Estates.key_money_expense' => 'biginteger', 'key_money_expense' => 'biginteger', 'Estates__contract' => 'string', 'Estates.contract' => 'string', 'contract' => 'string', 'Estates__business_category' => 'string', 'Estates.business_category' => 'string', 'business_category' => 'string', 'Estates__transfer' => 'string', 'Estates.transfer' => 'string', 'transfer' => 'string', 'Estates__area' => 'string', 'Estates.area' => 'string', 'area' => 'string', 'Estates__note1' => 'string', 'Estates.note1' => 'string', 'note1' => 'string', 'Estates__note2' => 'string', 'Estates.note2' => 'string', 'note2' => 'string', 'Estates__note3' => 'string', 'Estates.note3' => 'string', 'note3' => 'string', 'Estates__internal_note1' => 'string', 'Estates.internal_note1' => 'string', 'internal_note1' => 'string', 'Estates__internal_note2' => 'string', 'Estates.internal_note2' => 'string', 'internal_note2' => 'string', 'Estates__secret' => 'string', 'Estates.secret' => 'string', 'secret' => 'string', 'Estates__staff' => 'string', 'Estates.staff' => 'string', 'staff' => 'string', 'Estates__inputter' => 'string', 'Estates.inputter' => 'string', 'inputter' => 'string', 'Estates__photo_sign' => 'string', 'Estates.photo_sign' => 'string', 'photo_sign' => 'string', 'Estates__photo1' => 'string', 'Estates.photo1' => 'string', 'photo1' => 'string', 'Estates__photo2' => 'string', 'Estates.photo2' => 'string', 'photo2' => 'string', 'Estates__photo3' => 'string', 'Estates.photo3' => 'string', 'photo3' => 'string', 'Estates__photo4' => 'string', 'Estates.photo4' => 'string', 'photo4' => 'string', 'Estates__photo5' => 'string', 'Estates.photo5' => 'string', 'photo5' => 'string', 'Estates__photo6' => 'string', 'Estates.photo6' => 'string', 'photo6' => 'string', 'Estates__floor_plan' => 'string', 'Estates.floor_plan' => 'string', 'floor_plan' => 'string', 'Estates__created' => 'datetime', 'Estates.created' => 'datetime', 'created' => 'datetime', 'Estates__modified' => 'datetime', 'Estates.modified' => 'datetime', 'modified' => 'datetime', 'Estates__deleted' => 'datetime', 'Estates.deleted' => 'datetime', 'deleted' => 'datetime' ], 'decorators' => (int) 0, 'executed' => false, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [], 'matching' => [], 'extraOptions' => [], 'repository' => object(App\Model\Table\EstatesTable) {} } $generator = object(Cake\Database\ValueBinder) { [protected] _bindings => [] [protected] _bindingsCount => (int) 0 }count - [internal], line ?? Cake\Database\QueryCompiler::Cake\Database\{closure}() - CORE/src/Database/QueryCompiler.php, line 128 Cake\Database\Query::traverse() - CORE/src/Database/Query.php, line 311 Cake\Database\QueryCompiler::compile() - CORE/src/Database/QueryCompiler.php, line 99 Cake\Database\Driver::compileQuery() - CORE/src/Database/Driver.php, line 359 Cake\Database\Connection::compileQuery() - CORE/src/Database/Connection.php, line 299 Cake\Database\Query::sql() - CORE/src/Database/Query.php, line 282 Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 990 Cake\Database\Driver\Mysql::prepare() - CORE/src/Database/Driver/Mysql.php, line 136 Cake\Database\Connection::prepare() - CORE/src/Database/Connection.php, line 258 Cake\Database\Connection::run() - CORE/src/Database/Connection.php, line 311 Cake\Database\Query::execute() - CORE/src/Database/Query.php, line 213 Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 1011 Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276 Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 959 Cake\ORM\Query::toArray() - CORE/src/Datasource/QueryTrait.php, line 293 App\View\Helper\Select2Helper::business_category() - APP/View/Helper/Select2Helper.php, line 265
Warning (2): count() [<a href='http://php.net/function.count'>function.count</a>]: Parameter must be an array or an object that implements Countable [CORE/src/Database/QueryCompiler.php, line 128]Code Context{return function ($parts, $name) use (&$sql, $query, $generator) {if (!count($parts)) {$parts = null $name = 'having' $sql = 'SELECT Estates.id AS `Estates__id`, Estates.type AS `Estates__type`, Estates.invalid AS `Estates__invalid`, Estates.special_selection AS `Estates__special_selection`, Estates.new_sign AS `Estates__new_sign`, Estates.building_id AS `Estates__building_id`, Estates.address1 AS `Estates__address1`, Estates.address2 AS `Estates__address2`, Estates.name AS `Estates__name`, Estates.floor AS `Estates__floor`, Estates.floor_sequence AS `Estates__floor_sequence`, Estates.tsubo AS `Estates__tsubo`, Estates.space AS `Estates__space`, Estates.rent_category AS `Estates__rent_category`, Estates.rent_expense AS `Estates__rent_expense`, Estates.common_service_category AS `Estates__common_service_category`, Estates.common_service_expense AS `Estates__common_service_expense`, Estates.air_conditioning_category AS `Estates__air_conditioning_category`, Estates.air_conditioning_expense AS `Estates__air_conditioning_expense`, Estates.caution_money_category AS `Estates__caution_money_category`, Estates.caution_money_expense AS `Estates__caution_money_expense`, Estates.security_money_category AS `Estates__security_money_category`, Estates.security_money_expense AS `Estates__security_money_expense`, Estates.key_money_category AS `Estates__key_money_category`, Estates.key_money_expense AS `Estates__key_money_expense`, Estates.contract AS `Estates__contract`, Estates.business_category AS `Estates__business_category`, Estates.transfer AS `Estates__transfer`, Estates.area AS `Estates__area`, Estates.note1 AS `Estates__note1`, Estates.note2 AS `Estates__note2`, Estates.note3 AS `Estates__note3`, Estates.internal_note1 AS `Estates__internal_note1`, Estates.internal_note2 AS `Estates__internal_note2`, Estates.secret AS `Estates__secret`, Estates.staff AS `Estates__staff`, Estates.inputter AS `Estates__inputter`, Estates.photo_sign AS `Estates__photo_sign`, Estates.photo1 AS `Estates__photo1`, Estates.photo2 AS `Estates__photo2`, Estates.photo3 AS `Estates__photo3`, Estates.photo4 AS `Estates__photo4`, Estates.photo5 AS `Estates__photo5`, Estates.photo6 AS `Estates__photo6`, Estates.floor_plan AS `Estates__floor_plan`, Estates.created AS `Estates__created`, Estates.modified AS `Estates__modified`, Estates.deleted AS `Estates__deleted`, Buildings.id AS `Buildings__id`, Buildings.estates_category AS `Buildings__estates_category`, Buildings.owner_id AS `Buildings__owner_id`, Buildings.management_id AS `Buildings__management_id`, Buildings.name AS `Buildings__name`, Buildings.yomi AS `Buildings__yomi`, Buildings.area AS `Buildings__area`, Buildings.zip AS `Buildings__zip`, Buildings.address1 AS `Buildings__address1`, Buildings.address2 AS `Buildings__address2`, Buildings.address3 AS `Buildings__address3`, Buildings.address4 AS `Buildings__address4`, Buildings.photo AS `Buildings__photo`, Buildings.created AS `Buildings__created`, Buildings.modified AS `Buildings__modified`, Buildings.deleted AS `Buildings__deleted` FROM estates Estates LEFT JOIN buildings Buildings ON Buildings.id = (Estates.building_id) WHERE (Estates.new_sign IS NULL AND Buildings.area LIKE :c0 AND (Estates.secret IS NULL OR Estates.secret != :c1) AND (Estates.invalid IS NULL OR Estates.invalid != :c2))' $query = object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SQL could not be generated for this query as it is incomplete.', 'params' => [], 'defaultTypes' => [ 'Estates__id' => 'biginteger', 'Estates.id' => 'biginteger', 'id' => 'biginteger', 'Estates__type' => 'string', 'Estates.type' => 'string', 'type' => 'string', 'Estates__invalid' => 'string', 'Estates.invalid' => 'string', 'invalid' => 'string', 'Estates__special_selection' => 'integer', 'Estates.special_selection' => 'integer', 'special_selection' => 'integer', 'Estates__new_sign' => 'integer', 'Estates.new_sign' => 'integer', 'new_sign' => 'integer', 'Estates__building_id' => 'biginteger', 'Estates.building_id' => 'biginteger', 'building_id' => 'biginteger', 'Estates__address1' => 'string', 'Estates.address1' => 'string', 'address1' => 'string', 'Estates__address2' => 'string', 'Estates.address2' => 'string', 'address2' => 'string', 'Estates__name' => 'string', 'Estates.name' => 'string', 'name' => 'string', 'Estates__floor' => 'string', 'Estates.floor' => 'string', 'floor' => 'string', 'Estates__floor_sequence' => 'integer', 'Estates.floor_sequence' => 'integer', 'floor_sequence' => 'integer', 'Estates__tsubo' => 'decimal', 'Estates.tsubo' => 'decimal', 'tsubo' => 'decimal', 'Estates__space' => 'decimal', 'Estates.space' => 'decimal', 'space' => 'decimal', 'Estates__rent_category' => 'string', 'Estates.rent_category' => 'string', 'rent_category' => 'string', 'Estates__rent_expense' => 'biginteger', 'Estates.rent_expense' => 'biginteger', 'rent_expense' => 'biginteger', 'Estates__common_service_category' => 'string', 'Estates.common_service_category' => 'string', 'common_service_category' => 'string', 'Estates__common_service_expense' => 'biginteger', 'Estates.common_service_expense' => 'biginteger', 'common_service_expense' => 'biginteger', 'Estates__air_conditioning_category' => 'string', 'Estates.air_conditioning_category' => 'string', 'air_conditioning_category' => 'string', 'Estates__air_conditioning_expense' => 'biginteger', 'Estates.air_conditioning_expense' => 'biginteger', 'air_conditioning_expense' => 'biginteger', 'Estates__caution_money_category' => 'string', 'Estates.caution_money_category' => 'string', 'caution_money_category' => 'string', 'Estates__caution_money_expense' => 'biginteger', 'Estates.caution_money_expense' => 'biginteger', 'caution_money_expense' => 'biginteger', 'Estates__security_money_category' => 'string', 'Estates.security_money_category' => 'string', 'security_money_category' => 'string', 'Estates__security_money_expense' => 'biginteger', 'Estates.security_money_expense' => 'biginteger', 'security_money_expense' => 'biginteger', 'Estates__key_money_category' => 'string', 'Estates.key_money_category' => 'string', 'key_money_category' => 'string', 'Estates__key_money_expense' => 'biginteger', 'Estates.key_money_expense' => 'biginteger', 'key_money_expense' => 'biginteger', 'Estates__contract' => 'string', 'Estates.contract' => 'string', 'contract' => 'string', 'Estates__business_category' => 'string', 'Estates.business_category' => 'string', 'business_category' => 'string', 'Estates__transfer' => 'string', 'Estates.transfer' => 'string', 'transfer' => 'string', 'Estates__area' => 'string', 'Estates.area' => 'string', 'area' => 'string', 'Estates__note1' => 'string', 'Estates.note1' => 'string', 'note1' => 'string', 'Estates__note2' => 'string', 'Estates.note2' => 'string', 'note2' => 'string', 'Estates__note3' => 'string', 'Estates.note3' => 'string', 'note3' => 'string', 'Estates__internal_note1' => 'string', 'Estates.internal_note1' => 'string', 'internal_note1' => 'string', 'Estates__internal_note2' => 'string', 'Estates.internal_note2' => 'string', 'internal_note2' => 'string', 'Estates__secret' => 'string', 'Estates.secret' => 'string', 'secret' => 'string', 'Estates__staff' => 'string', 'Estates.staff' => 'string', 'staff' => 'string', 'Estates__inputter' => 'string', 'Estates.inputter' => 'string', 'inputter' => 'string', 'Estates__photo_sign' => 'string', 'Estates.photo_sign' => 'string', 'photo_sign' => 'string', 'Estates__photo1' => 'string', 'Estates.photo1' => 'string', 'photo1' => 'string', 'Estates__photo2' => 'string', 'Estates.photo2' => 'string', 'photo2' => 'string', 'Estates__photo3' => 'string', 'Estates.photo3' => 'string', 'photo3' => 'string', 'Estates__photo4' => 'string', 'Estates.photo4' => 'string', 'photo4' => 'string', 'Estates__photo5' => 'string', 'Estates.photo5' => 'string', 'photo5' => 'string', 'Estates__photo6' => 'string', 'Estates.photo6' => 'string', 'photo6' => 'string', 'Estates__floor_plan' => 'string', 'Estates.floor_plan' => 'string', 'floor_plan' => 'string', 'Estates__created' => 'datetime', 'Estates.created' => 'datetime', 'created' => 'datetime', 'Estates__modified' => 'datetime', 'Estates.modified' => 'datetime', 'modified' => 'datetime', 'Estates__deleted' => 'datetime', 'Estates.deleted' => 'datetime', 'deleted' => 'datetime', 'Buildings__id' => 'biginteger', 'Buildings.id' => 'biginteger', 'Buildings__estates_category' => 'string', 'Buildings.estates_category' => 'string', 'estates_category' => 'string', 'Buildings__owner_id' => 'biginteger', 'Buildings.owner_id' => 'biginteger', 'owner_id' => 'biginteger', 'Buildings__management_id' => 'biginteger', 'Buildings.management_id' => 'biginteger', 'management_id' => 'biginteger', 'Buildings__name' => 'string', 'Buildings.name' => 'string', 'Buildings__yomi' => 'string', 'Buildings.yomi' => 'string', 'yomi' => 'string', 'Buildings__area' => 'string', 'Buildings.area' => 'string', 'Buildings__zip' => 'string', 'Buildings.zip' => 'string', 'zip' => 'string', 'Buildings__address1' => 'string', 'Buildings.address1' => 'string', 'Buildings__address2' => 'string', 'Buildings.address2' => 'string', 'Buildings__address3' => 'string', 'Buildings.address3' => 'string', 'address3' => 'string', 'Buildings__address4' => 'string', 'Buildings.address4' => 'string', 'address4' => 'string', 'Buildings__photo' => 'string', 'Buildings.photo' => 'string', 'photo' => 'string', 'Buildings__created' => 'datetime', 'Buildings.created' => 'datetime', 'Buildings__modified' => 'datetime', 'Buildings.modified' => 'datetime', 'Buildings__deleted' => 'datetime', 'Buildings.deleted' => 'datetime' ], 'decorators' => (int) 0, 'executed' => false, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [ 'Buildings' => [[maximum depth reached]] ], 'matching' => [], 'extraOptions' => [], 'repository' => object(App\Model\Table\EstatesTable) {} } $generator = object(Cake\Database\ValueBinder) { [protected] _bindings => [ ':c0' => [ [maximum depth reached] ], ':c1' => [ [maximum depth reached] ], ':c2' => [ [maximum depth reached] ] ] [protected] _bindingsCount => (int) 3 }count - [internal], line ?? Cake\Database\QueryCompiler::Cake\Database\{closure}() - CORE/src/Database/QueryCompiler.php, line 128 Cake\Database\Query::traverse() - CORE/src/Database/Query.php, line 311 Cake\Database\QueryCompiler::compile() - CORE/src/Database/QueryCompiler.php, line 99 Cake\Database\Driver::compileQuery() - CORE/src/Database/Driver.php, line 359 Cake\Database\Connection::compileQuery() - CORE/src/Database/Connection.php, line 299 Cake\Database\Query::sql() - CORE/src/Database/Query.php, line 282 Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 990 Cake\Database\Driver\Mysql::prepare() - CORE/src/Database/Driver/Mysql.php, line 136 Cake\Database\Connection::prepare() - CORE/src/Database/Connection.php, line 258 Cake\Database\Connection::run() - CORE/src/Database/Connection.php, line 311 Cake\Database\Query::execute() - CORE/src/Database/Query.php, line 213 Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 1011 Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276 Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 959 Cake\ORM\Query::getIterator() - CORE/src/Datasource/QueryTrait.php, line 132 include - APP/Template/Element/estate.ctp, line 71
Warning (2): count() [<a href='http://php.net/function.count'>function.count</a>]: Parameter must be an array or an object that implements Countable [CORE/src/Database/QueryCompiler.php, line 128]Code Context{return function ($parts, $name) use (&$sql, $query, $generator) {if (!count($parts)) {$parts = null $name = 'limit' $sql = 'SELECT Estates.id AS `Estates__id`, Estates.type AS `Estates__type`, Estates.invalid AS `Estates__invalid`, Estates.special_selection AS `Estates__special_selection`, Estates.new_sign AS `Estates__new_sign`, Estates.building_id AS `Estates__building_id`, Estates.address1 AS `Estates__address1`, Estates.address2 AS `Estates__address2`, Estates.name AS `Estates__name`, Estates.floor AS `Estates__floor`, Estates.floor_sequence AS `Estates__floor_sequence`, Estates.tsubo AS `Estates__tsubo`, Estates.space AS `Estates__space`, Estates.rent_category AS `Estates__rent_category`, Estates.rent_expense AS `Estates__rent_expense`, Estates.common_service_category AS `Estates__common_service_category`, Estates.common_service_expense AS `Estates__common_service_expense`, Estates.air_conditioning_category AS `Estates__air_conditioning_category`, Estates.air_conditioning_expense AS `Estates__air_conditioning_expense`, Estates.caution_money_category AS `Estates__caution_money_category`, Estates.caution_money_expense AS `Estates__caution_money_expense`, Estates.security_money_category AS `Estates__security_money_category`, Estates.security_money_expense AS `Estates__security_money_expense`, Estates.key_money_category AS `Estates__key_money_category`, Estates.key_money_expense AS `Estates__key_money_expense`, Estates.contract AS `Estates__contract`, Estates.business_category AS `Estates__business_category`, Estates.transfer AS `Estates__transfer`, Estates.area AS `Estates__area`, Estates.note1 AS `Estates__note1`, Estates.note2 AS `Estates__note2`, Estates.note3 AS `Estates__note3`, Estates.internal_note1 AS `Estates__internal_note1`, Estates.internal_note2 AS `Estates__internal_note2`, Estates.secret AS `Estates__secret`, Estates.staff AS `Estates__staff`, Estates.inputter AS `Estates__inputter`, Estates.photo_sign AS `Estates__photo_sign`, Estates.photo1 AS `Estates__photo1`, Estates.photo2 AS `Estates__photo2`, Estates.photo3 AS `Estates__photo3`, Estates.photo4 AS `Estates__photo4`, Estates.photo5 AS `Estates__photo5`, Estates.photo6 AS `Estates__photo6`, Estates.floor_plan AS `Estates__floor_plan`, Estates.created AS `Estates__created`, Estates.modified AS `Estates__modified`, Estates.deleted AS `Estates__deleted`, Buildings.id AS `Buildings__id`, Buildings.estates_category AS `Buildings__estates_category`, Buildings.owner_id AS `Buildings__owner_id`, Buildings.management_id AS `Buildings__management_id`, Buildings.name AS `Buildings__name`, Buildings.yomi AS `Buildings__yomi`, Buildings.area AS `Buildings__area`, Buildings.zip AS `Buildings__zip`, Buildings.address1 AS `Buildings__address1`, Buildings.address2 AS `Buildings__address2`, Buildings.address3 AS `Buildings__address3`, Buildings.address4 AS `Buildings__address4`, Buildings.photo AS `Buildings__photo`, Buildings.created AS `Buildings__created`, Buildings.modified AS `Buildings__modified`, Buildings.deleted AS `Buildings__deleted` FROM estates Estates LEFT JOIN buildings Buildings ON Buildings.id = (Estates.building_id) WHERE (Estates.new_sign IS NULL AND Buildings.area LIKE :c0 AND (Estates.secret IS NULL OR Estates.secret != :c1) AND (Estates.invalid IS NULL OR Estates.invalid != :c2)) ORDER BY Estates.photo_sign DESC, Estates.modified DESC, Estates.id DESC' $query = object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SQL could not be generated for this query as it is incomplete.', 'params' => [], 'defaultTypes' => [ 'Estates__id' => 'biginteger', 'Estates.id' => 'biginteger', 'id' => 'biginteger', 'Estates__type' => 'string', 'Estates.type' => 'string', 'type' => 'string', 'Estates__invalid' => 'string', 'Estates.invalid' => 'string', 'invalid' => 'string', 'Estates__special_selection' => 'integer', 'Estates.special_selection' => 'integer', 'special_selection' => 'integer', 'Estates__new_sign' => 'integer', 'Estates.new_sign' => 'integer', 'new_sign' => 'integer', 'Estates__building_id' => 'biginteger', 'Estates.building_id' => 'biginteger', 'building_id' => 'biginteger', 'Estates__address1' => 'string', 'Estates.address1' => 'string', 'address1' => 'string', 'Estates__address2' => 'string', 'Estates.address2' => 'string', 'address2' => 'string', 'Estates__name' => 'string', 'Estates.name' => 'string', 'name' => 'string', 'Estates__floor' => 'string', 'Estates.floor' => 'string', 'floor' => 'string', 'Estates__floor_sequence' => 'integer', 'Estates.floor_sequence' => 'integer', 'floor_sequence' => 'integer', 'Estates__tsubo' => 'decimal', 'Estates.tsubo' => 'decimal', 'tsubo' => 'decimal', 'Estates__space' => 'decimal', 'Estates.space' => 'decimal', 'space' => 'decimal', 'Estates__rent_category' => 'string', 'Estates.rent_category' => 'string', 'rent_category' => 'string', 'Estates__rent_expense' => 'biginteger', 'Estates.rent_expense' => 'biginteger', 'rent_expense' => 'biginteger', 'Estates__common_service_category' => 'string', 'Estates.common_service_category' => 'string', 'common_service_category' => 'string', 'Estates__common_service_expense' => 'biginteger', 'Estates.common_service_expense' => 'biginteger', 'common_service_expense' => 'biginteger', 'Estates__air_conditioning_category' => 'string', 'Estates.air_conditioning_category' => 'string', 'air_conditioning_category' => 'string', 'Estates__air_conditioning_expense' => 'biginteger', 'Estates.air_conditioning_expense' => 'biginteger', 'air_conditioning_expense' => 'biginteger', 'Estates__caution_money_category' => 'string', 'Estates.caution_money_category' => 'string', 'caution_money_category' => 'string', 'Estates__caution_money_expense' => 'biginteger', 'Estates.caution_money_expense' => 'biginteger', 'caution_money_expense' => 'biginteger', 'Estates__security_money_category' => 'string', 'Estates.security_money_category' => 'string', 'security_money_category' => 'string', 'Estates__security_money_expense' => 'biginteger', 'Estates.security_money_expense' => 'biginteger', 'security_money_expense' => 'biginteger', 'Estates__key_money_category' => 'string', 'Estates.key_money_category' => 'string', 'key_money_category' => 'string', 'Estates__key_money_expense' => 'biginteger', 'Estates.key_money_expense' => 'biginteger', 'key_money_expense' => 'biginteger', 'Estates__contract' => 'string', 'Estates.contract' => 'string', 'contract' => 'string', 'Estates__business_category' => 'string', 'Estates.business_category' => 'string', 'business_category' => 'string', 'Estates__transfer' => 'string', 'Estates.transfer' => 'string', 'transfer' => 'string', 'Estates__area' => 'string', 'Estates.area' => 'string', 'area' => 'string', 'Estates__note1' => 'string', 'Estates.note1' => 'string', 'note1' => 'string', 'Estates__note2' => 'string', 'Estates.note2' => 'string', 'note2' => 'string', 'Estates__note3' => 'string', 'Estates.note3' => 'string', 'note3' => 'string', 'Estates__internal_note1' => 'string', 'Estates.internal_note1' => 'string', 'internal_note1' => 'string', 'Estates__internal_note2' => 'string', 'Estates.internal_note2' => 'string', 'internal_note2' => 'string', 'Estates__secret' => 'string', 'Estates.secret' => 'string', 'secret' => 'string', 'Estates__staff' => 'string', 'Estates.staff' => 'string', 'staff' => 'string', 'Estates__inputter' => 'string', 'Estates.inputter' => 'string', 'inputter' => 'string', 'Estates__photo_sign' => 'string', 'Estates.photo_sign' => 'string', 'photo_sign' => 'string', 'Estates__photo1' => 'string', 'Estates.photo1' => 'string', 'photo1' => 'string', 'Estates__photo2' => 'string', 'Estates.photo2' => 'string', 'photo2' => 'string', 'Estates__photo3' => 'string', 'Estates.photo3' => 'string', 'photo3' => 'string', 'Estates__photo4' => 'string', 'Estates.photo4' => 'string', 'photo4' => 'string', 'Estates__photo5' => 'string', 'Estates.photo5' => 'string', 'photo5' => 'string', 'Estates__photo6' => 'string', 'Estates.photo6' => 'string', 'photo6' => 'string', 'Estates__floor_plan' => 'string', 'Estates.floor_plan' => 'string', 'floor_plan' => 'string', 'Estates__created' => 'datetime', 'Estates.created' => 'datetime', 'created' => 'datetime', 'Estates__modified' => 'datetime', 'Estates.modified' => 'datetime', 'modified' => 'datetime', 'Estates__deleted' => 'datetime', 'Estates.deleted' => 'datetime', 'deleted' => 'datetime', 'Buildings__id' => 'biginteger', 'Buildings.id' => 'biginteger', 'Buildings__estates_category' => 'string', 'Buildings.estates_category' => 'string', 'estates_category' => 'string', 'Buildings__owner_id' => 'biginteger', 'Buildings.owner_id' => 'biginteger', 'owner_id' => 'biginteger', 'Buildings__management_id' => 'biginteger', 'Buildings.management_id' => 'biginteger', 'management_id' => 'biginteger', 'Buildings__name' => 'string', 'Buildings.name' => 'string', 'Buildings__yomi' => 'string', 'Buildings.yomi' => 'string', 'yomi' => 'string', 'Buildings__area' => 'string', 'Buildings.area' => 'string', 'Buildings__zip' => 'string', 'Buildings.zip' => 'string', 'zip' => 'string', 'Buildings__address1' => 'string', 'Buildings.address1' => 'string', 'Buildings__address2' => 'string', 'Buildings.address2' => 'string', 'Buildings__address3' => 'string', 'Buildings.address3' => 'string', 'address3' => 'string', 'Buildings__address4' => 'string', 'Buildings.address4' => 'string', 'address4' => 'string', 'Buildings__photo' => 'string', 'Buildings.photo' => 'string', 'photo' => 'string', 'Buildings__created' => 'datetime', 'Buildings.created' => 'datetime', 'Buildings__modified' => 'datetime', 'Buildings.modified' => 'datetime', 'Buildings__deleted' => 'datetime', 'Buildings.deleted' => 'datetime' ], 'decorators' => (int) 0, 'executed' => false, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [ 'Buildings' => [[maximum depth reached]] ], 'matching' => [], 'extraOptions' => [], 'repository' => object(App\Model\Table\EstatesTable) {} } $generator = object(Cake\Database\ValueBinder) { [protected] _bindings => [ ':c0' => [ [maximum depth reached] ], ':c1' => [ [maximum depth reached] ], ':c2' => [ [maximum depth reached] ] ] [protected] _bindingsCount => (int) 3 }count - [internal], line ?? Cake\Database\QueryCompiler::Cake\Database\{closure}() - CORE/src/Database/QueryCompiler.php, line 128 Cake\Database\Query::traverse() - CORE/src/Database/Query.php, line 311 Cake\Database\QueryCompiler::compile() - CORE/src/Database/QueryCompiler.php, line 99 Cake\Database\Driver::compileQuery() - CORE/src/Database/Driver.php, line 359 Cake\Database\Connection::compileQuery() - CORE/src/Database/Connection.php, line 299 Cake\Database\Query::sql() - CORE/src/Database/Query.php, line 282 Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 990 Cake\Database\Driver\Mysql::prepare() - CORE/src/Database/Driver/Mysql.php, line 136 Cake\Database\Connection::prepare() - CORE/src/Database/Connection.php, line 258 Cake\Database\Connection::run() - CORE/src/Database/Connection.php, line 311 Cake\Database\Query::execute() - CORE/src/Database/Query.php, line 213 Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 1011 Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276 Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 959 Cake\ORM\Query::getIterator() - CORE/src/Datasource/QueryTrait.php, line 132 include - APP/Template/Element/estate.ctp, line 71
Warning (2): count() [<a href='http://php.net/function.count'>function.count</a>]: Parameter must be an array or an object that implements Countable [CORE/src/Database/QueryCompiler.php, line 128]Code Context{return function ($parts, $name) use (&$sql, $query, $generator) {if (!count($parts)) {$parts = null $name = 'offset' $sql = 'SELECT Estates.id AS `Estates__id`, Estates.type AS `Estates__type`, Estates.invalid AS `Estates__invalid`, Estates.special_selection AS `Estates__special_selection`, Estates.new_sign AS `Estates__new_sign`, Estates.building_id AS `Estates__building_id`, Estates.address1 AS `Estates__address1`, Estates.address2 AS `Estates__address2`, Estates.name AS `Estates__name`, Estates.floor AS `Estates__floor`, Estates.floor_sequence AS `Estates__floor_sequence`, Estates.tsubo AS `Estates__tsubo`, Estates.space AS `Estates__space`, Estates.rent_category AS `Estates__rent_category`, Estates.rent_expense AS `Estates__rent_expense`, Estates.common_service_category AS `Estates__common_service_category`, Estates.common_service_expense AS `Estates__common_service_expense`, Estates.air_conditioning_category AS `Estates__air_conditioning_category`, Estates.air_conditioning_expense AS `Estates__air_conditioning_expense`, Estates.caution_money_category AS `Estates__caution_money_category`, Estates.caution_money_expense AS `Estates__caution_money_expense`, Estates.security_money_category AS `Estates__security_money_category`, Estates.security_money_expense AS `Estates__security_money_expense`, Estates.key_money_category AS `Estates__key_money_category`, Estates.key_money_expense AS `Estates__key_money_expense`, Estates.contract AS `Estates__contract`, Estates.business_category AS `Estates__business_category`, Estates.transfer AS `Estates__transfer`, Estates.area AS `Estates__area`, Estates.note1 AS `Estates__note1`, Estates.note2 AS `Estates__note2`, Estates.note3 AS `Estates__note3`, Estates.internal_note1 AS `Estates__internal_note1`, Estates.internal_note2 AS `Estates__internal_note2`, Estates.secret AS `Estates__secret`, Estates.staff AS `Estates__staff`, Estates.inputter AS `Estates__inputter`, Estates.photo_sign AS `Estates__photo_sign`, Estates.photo1 AS `Estates__photo1`, Estates.photo2 AS `Estates__photo2`, Estates.photo3 AS `Estates__photo3`, Estates.photo4 AS `Estates__photo4`, Estates.photo5 AS `Estates__photo5`, Estates.photo6 AS `Estates__photo6`, Estates.floor_plan AS `Estates__floor_plan`, Estates.created AS `Estates__created`, Estates.modified AS `Estates__modified`, Estates.deleted AS `Estates__deleted`, Buildings.id AS `Buildings__id`, Buildings.estates_category AS `Buildings__estates_category`, Buildings.owner_id AS `Buildings__owner_id`, Buildings.management_id AS `Buildings__management_id`, Buildings.name AS `Buildings__name`, Buildings.yomi AS `Buildings__yomi`, Buildings.area AS `Buildings__area`, Buildings.zip AS `Buildings__zip`, Buildings.address1 AS `Buildings__address1`, Buildings.address2 AS `Buildings__address2`, Buildings.address3 AS `Buildings__address3`, Buildings.address4 AS `Buildings__address4`, Buildings.photo AS `Buildings__photo`, Buildings.created AS `Buildings__created`, Buildings.modified AS `Buildings__modified`, Buildings.deleted AS `Buildings__deleted` FROM estates Estates LEFT JOIN buildings Buildings ON Buildings.id = (Estates.building_id) WHERE (Estates.new_sign IS NULL AND Buildings.area LIKE :c0 AND (Estates.secret IS NULL OR Estates.secret != :c1) AND (Estates.invalid IS NULL OR Estates.invalid != :c2)) ORDER BY Estates.photo_sign DESC, Estates.modified DESC, Estates.id DESC' $query = object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SQL could not be generated for this query as it is incomplete.', 'params' => [], 'defaultTypes' => [ 'Estates__id' => 'biginteger', 'Estates.id' => 'biginteger', 'id' => 'biginteger', 'Estates__type' => 'string', 'Estates.type' => 'string', 'type' => 'string', 'Estates__invalid' => 'string', 'Estates.invalid' => 'string', 'invalid' => 'string', 'Estates__special_selection' => 'integer', 'Estates.special_selection' => 'integer', 'special_selection' => 'integer', 'Estates__new_sign' => 'integer', 'Estates.new_sign' => 'integer', 'new_sign' => 'integer', 'Estates__building_id' => 'biginteger', 'Estates.building_id' => 'biginteger', 'building_id' => 'biginteger', 'Estates__address1' => 'string', 'Estates.address1' => 'string', 'address1' => 'string', 'Estates__address2' => 'string', 'Estates.address2' => 'string', 'address2' => 'string', 'Estates__name' => 'string', 'Estates.name' => 'string', 'name' => 'string', 'Estates__floor' => 'string', 'Estates.floor' => 'string', 'floor' => 'string', 'Estates__floor_sequence' => 'integer', 'Estates.floor_sequence' => 'integer', 'floor_sequence' => 'integer', 'Estates__tsubo' => 'decimal', 'Estates.tsubo' => 'decimal', 'tsubo' => 'decimal', 'Estates__space' => 'decimal', 'Estates.space' => 'decimal', 'space' => 'decimal', 'Estates__rent_category' => 'string', 'Estates.rent_category' => 'string', 'rent_category' => 'string', 'Estates__rent_expense' => 'biginteger', 'Estates.rent_expense' => 'biginteger', 'rent_expense' => 'biginteger', 'Estates__common_service_category' => 'string', 'Estates.common_service_category' => 'string', 'common_service_category' => 'string', 'Estates__common_service_expense' => 'biginteger', 'Estates.common_service_expense' => 'biginteger', 'common_service_expense' => 'biginteger', 'Estates__air_conditioning_category' => 'string', 'Estates.air_conditioning_category' => 'string', 'air_conditioning_category' => 'string', 'Estates__air_conditioning_expense' => 'biginteger', 'Estates.air_conditioning_expense' => 'biginteger', 'air_conditioning_expense' => 'biginteger', 'Estates__caution_money_category' => 'string', 'Estates.caution_money_category' => 'string', 'caution_money_category' => 'string', 'Estates__caution_money_expense' => 'biginteger', 'Estates.caution_money_expense' => 'biginteger', 'caution_money_expense' => 'biginteger', 'Estates__security_money_category' => 'string', 'Estates.security_money_category' => 'string', 'security_money_category' => 'string', 'Estates__security_money_expense' => 'biginteger', 'Estates.security_money_expense' => 'biginteger', 'security_money_expense' => 'biginteger', 'Estates__key_money_category' => 'string', 'Estates.key_money_category' => 'string', 'key_money_category' => 'string', 'Estates__key_money_expense' => 'biginteger', 'Estates.key_money_expense' => 'biginteger', 'key_money_expense' => 'biginteger', 'Estates__contract' => 'string', 'Estates.contract' => 'string', 'contract' => 'string', 'Estates__business_category' => 'string', 'Estates.business_category' => 'string', 'business_category' => 'string', 'Estates__transfer' => 'string', 'Estates.transfer' => 'string', 'transfer' => 'string', 'Estates__area' => 'string', 'Estates.area' => 'string', 'area' => 'string', 'Estates__note1' => 'string', 'Estates.note1' => 'string', 'note1' => 'string', 'Estates__note2' => 'string', 'Estates.note2' => 'string', 'note2' => 'string', 'Estates__note3' => 'string', 'Estates.note3' => 'string', 'note3' => 'string', 'Estates__internal_note1' => 'string', 'Estates.internal_note1' => 'string', 'internal_note1' => 'string', 'Estates__internal_note2' => 'string', 'Estates.internal_note2' => 'string', 'internal_note2' => 'string', 'Estates__secret' => 'string', 'Estates.secret' => 'string', 'secret' => 'string', 'Estates__staff' => 'string', 'Estates.staff' => 'string', 'staff' => 'string', 'Estates__inputter' => 'string', 'Estates.inputter' => 'string', 'inputter' => 'string', 'Estates__photo_sign' => 'string', 'Estates.photo_sign' => 'string', 'photo_sign' => 'string', 'Estates__photo1' => 'string', 'Estates.photo1' => 'string', 'photo1' => 'string', 'Estates__photo2' => 'string', 'Estates.photo2' => 'string', 'photo2' => 'string', 'Estates__photo3' => 'string', 'Estates.photo3' => 'string', 'photo3' => 'string', 'Estates__photo4' => 'string', 'Estates.photo4' => 'string', 'photo4' => 'string', 'Estates__photo5' => 'string', 'Estates.photo5' => 'string', 'photo5' => 'string', 'Estates__photo6' => 'string', 'Estates.photo6' => 'string', 'photo6' => 'string', 'Estates__floor_plan' => 'string', 'Estates.floor_plan' => 'string', 'floor_plan' => 'string', 'Estates__created' => 'datetime', 'Estates.created' => 'datetime', 'created' => 'datetime', 'Estates__modified' => 'datetime', 'Estates.modified' => 'datetime', 'modified' => 'datetime', 'Estates__deleted' => 'datetime', 'Estates.deleted' => 'datetime', 'deleted' => 'datetime', 'Buildings__id' => 'biginteger', 'Buildings.id' => 'biginteger', 'Buildings__estates_category' => 'string', 'Buildings.estates_category' => 'string', 'estates_category' => 'string', 'Buildings__owner_id' => 'biginteger', 'Buildings.owner_id' => 'biginteger', 'owner_id' => 'biginteger', 'Buildings__management_id' => 'biginteger', 'Buildings.management_id' => 'biginteger', 'management_id' => 'biginteger', 'Buildings__name' => 'string', 'Buildings.name' => 'string', 'Buildings__yomi' => 'string', 'Buildings.yomi' => 'string', 'yomi' => 'string', 'Buildings__area' => 'string', 'Buildings.area' => 'string', 'Buildings__zip' => 'string', 'Buildings.zip' => 'string', 'zip' => 'string', 'Buildings__address1' => 'string', 'Buildings.address1' => 'string', 'Buildings__address2' => 'string', 'Buildings.address2' => 'string', 'Buildings__address3' => 'string', 'Buildings.address3' => 'string', 'address3' => 'string', 'Buildings__address4' => 'string', 'Buildings.address4' => 'string', 'address4' => 'string', 'Buildings__photo' => 'string', 'Buildings.photo' => 'string', 'photo' => 'string', 'Buildings__created' => 'datetime', 'Buildings.created' => 'datetime', 'Buildings__modified' => 'datetime', 'Buildings.modified' => 'datetime', 'Buildings__deleted' => 'datetime', 'Buildings.deleted' => 'datetime' ], 'decorators' => (int) 0, 'executed' => false, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [ 'Buildings' => [[maximum depth reached]] ], 'matching' => [], 'extraOptions' => [], 'repository' => object(App\Model\Table\EstatesTable) {} } $generator = object(Cake\Database\ValueBinder) { [protected] _bindings => [ ':c0' => [ [maximum depth reached] ], ':c1' => [ [maximum depth reached] ], ':c2' => [ [maximum depth reached] ] ] [protected] _bindingsCount => (int) 3 }count - [internal], line ?? Cake\Database\QueryCompiler::Cake\Database\{closure}() - CORE/src/Database/QueryCompiler.php, line 128 Cake\Database\Query::traverse() - CORE/src/Database/Query.php, line 311 Cake\Database\QueryCompiler::compile() - CORE/src/Database/QueryCompiler.php, line 99 Cake\Database\Driver::compileQuery() - CORE/src/Database/Driver.php, line 359 Cake\Database\Connection::compileQuery() - CORE/src/Database/Connection.php, line 299 Cake\Database\Query::sql() - CORE/src/Database/Query.php, line 282 Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 990 Cake\Database\Driver\Mysql::prepare() - CORE/src/Database/Driver/Mysql.php, line 136 Cake\Database\Connection::prepare() - CORE/src/Database/Connection.php, line 258 Cake\Database\Connection::run() - CORE/src/Database/Connection.php, line 311 Cake\Database\Query::execute() - CORE/src/Database/Query.php, line 213 Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 1011 Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276 Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 959 Cake\ORM\Query::getIterator() - CORE/src/Datasource/QueryTrait.php, line 132 include - APP/Template/Element/estate.ctp, line 71
Warning (2): count() [<a href='http://php.net/function.count'>function.count</a>]: Parameter must be an array or an object that implements Countable [CORE/src/Database/QueryCompiler.php, line 128]Code Context{return function ($parts, $name) use (&$sql, $query, $generator) {if (!count($parts)) {$parts = null $name = 'epilog' $sql = 'SELECT Estates.id AS `Estates__id`, Estates.type AS `Estates__type`, Estates.invalid AS `Estates__invalid`, Estates.special_selection AS `Estates__special_selection`, Estates.new_sign AS `Estates__new_sign`, Estates.building_id AS `Estates__building_id`, Estates.address1 AS `Estates__address1`, Estates.address2 AS `Estates__address2`, Estates.name AS `Estates__name`, Estates.floor AS `Estates__floor`, Estates.floor_sequence AS `Estates__floor_sequence`, Estates.tsubo AS `Estates__tsubo`, Estates.space AS `Estates__space`, Estates.rent_category AS `Estates__rent_category`, Estates.rent_expense AS `Estates__rent_expense`, Estates.common_service_category AS `Estates__common_service_category`, Estates.common_service_expense AS `Estates__common_service_expense`, Estates.air_conditioning_category AS `Estates__air_conditioning_category`, Estates.air_conditioning_expense AS `Estates__air_conditioning_expense`, Estates.caution_money_category AS `Estates__caution_money_category`, Estates.caution_money_expense AS `Estates__caution_money_expense`, Estates.security_money_category AS `Estates__security_money_category`, Estates.security_money_expense AS `Estates__security_money_expense`, Estates.key_money_category AS `Estates__key_money_category`, Estates.key_money_expense AS `Estates__key_money_expense`, Estates.contract AS `Estates__contract`, Estates.business_category AS `Estates__business_category`, Estates.transfer AS `Estates__transfer`, Estates.area AS `Estates__area`, Estates.note1 AS `Estates__note1`, Estates.note2 AS `Estates__note2`, Estates.note3 AS `Estates__note3`, Estates.internal_note1 AS `Estates__internal_note1`, Estates.internal_note2 AS `Estates__internal_note2`, Estates.secret AS `Estates__secret`, Estates.staff AS `Estates__staff`, Estates.inputter AS `Estates__inputter`, Estates.photo_sign AS `Estates__photo_sign`, Estates.photo1 AS `Estates__photo1`, Estates.photo2 AS `Estates__photo2`, Estates.photo3 AS `Estates__photo3`, Estates.photo4 AS `Estates__photo4`, Estates.photo5 AS `Estates__photo5`, Estates.photo6 AS `Estates__photo6`, Estates.floor_plan AS `Estates__floor_plan`, Estates.created AS `Estates__created`, Estates.modified AS `Estates__modified`, Estates.deleted AS `Estates__deleted`, Buildings.id AS `Buildings__id`, Buildings.estates_category AS `Buildings__estates_category`, Buildings.owner_id AS `Buildings__owner_id`, Buildings.management_id AS `Buildings__management_id`, Buildings.name AS `Buildings__name`, Buildings.yomi AS `Buildings__yomi`, Buildings.area AS `Buildings__area`, Buildings.zip AS `Buildings__zip`, Buildings.address1 AS `Buildings__address1`, Buildings.address2 AS `Buildings__address2`, Buildings.address3 AS `Buildings__address3`, Buildings.address4 AS `Buildings__address4`, Buildings.photo AS `Buildings__photo`, Buildings.created AS `Buildings__created`, Buildings.modified AS `Buildings__modified`, Buildings.deleted AS `Buildings__deleted` FROM estates Estates LEFT JOIN buildings Buildings ON Buildings.id = (Estates.building_id) WHERE (Estates.new_sign IS NULL AND Buildings.area LIKE :c0 AND (Estates.secret IS NULL OR Estates.secret != :c1) AND (Estates.invalid IS NULL OR Estates.invalid != :c2)) ORDER BY Estates.photo_sign DESC, Estates.modified DESC, Estates.id DESC' $query = object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SQL could not be generated for this query as it is incomplete.', 'params' => [], 'defaultTypes' => [ 'Estates__id' => 'biginteger', 'Estates.id' => 'biginteger', 'id' => 'biginteger', 'Estates__type' => 'string', 'Estates.type' => 'string', 'type' => 'string', 'Estates__invalid' => 'string', 'Estates.invalid' => 'string', 'invalid' => 'string', 'Estates__special_selection' => 'integer', 'Estates.special_selection' => 'integer', 'special_selection' => 'integer', 'Estates__new_sign' => 'integer', 'Estates.new_sign' => 'integer', 'new_sign' => 'integer', 'Estates__building_id' => 'biginteger', 'Estates.building_id' => 'biginteger', 'building_id' => 'biginteger', 'Estates__address1' => 'string', 'Estates.address1' => 'string', 'address1' => 'string', 'Estates__address2' => 'string', 'Estates.address2' => 'string', 'address2' => 'string', 'Estates__name' => 'string', 'Estates.name' => 'string', 'name' => 'string', 'Estates__floor' => 'string', 'Estates.floor' => 'string', 'floor' => 'string', 'Estates__floor_sequence' => 'integer', 'Estates.floor_sequence' => 'integer', 'floor_sequence' => 'integer', 'Estates__tsubo' => 'decimal', 'Estates.tsubo' => 'decimal', 'tsubo' => 'decimal', 'Estates__space' => 'decimal', 'Estates.space' => 'decimal', 'space' => 'decimal', 'Estates__rent_category' => 'string', 'Estates.rent_category' => 'string', 'rent_category' => 'string', 'Estates__rent_expense' => 'biginteger', 'Estates.rent_expense' => 'biginteger', 'rent_expense' => 'biginteger', 'Estates__common_service_category' => 'string', 'Estates.common_service_category' => 'string', 'common_service_category' => 'string', 'Estates__common_service_expense' => 'biginteger', 'Estates.common_service_expense' => 'biginteger', 'common_service_expense' => 'biginteger', 'Estates__air_conditioning_category' => 'string', 'Estates.air_conditioning_category' => 'string', 'air_conditioning_category' => 'string', 'Estates__air_conditioning_expense' => 'biginteger', 'Estates.air_conditioning_expense' => 'biginteger', 'air_conditioning_expense' => 'biginteger', 'Estates__caution_money_category' => 'string', 'Estates.caution_money_category' => 'string', 'caution_money_category' => 'string', 'Estates__caution_money_expense' => 'biginteger', 'Estates.caution_money_expense' => 'biginteger', 'caution_money_expense' => 'biginteger', 'Estates__security_money_category' => 'string', 'Estates.security_money_category' => 'string', 'security_money_category' => 'string', 'Estates__security_money_expense' => 'biginteger', 'Estates.security_money_expense' => 'biginteger', 'security_money_expense' => 'biginteger', 'Estates__key_money_category' => 'string', 'Estates.key_money_category' => 'string', 'key_money_category' => 'string', 'Estates__key_money_expense' => 'biginteger', 'Estates.key_money_expense' => 'biginteger', 'key_money_expense' => 'biginteger', 'Estates__contract' => 'string', 'Estates.contract' => 'string', 'contract' => 'string', 'Estates__business_category' => 'string', 'Estates.business_category' => 'string', 'business_category' => 'string', 'Estates__transfer' => 'string', 'Estates.transfer' => 'string', 'transfer' => 'string', 'Estates__area' => 'string', 'Estates.area' => 'string', 'area' => 'string', 'Estates__note1' => 'string', 'Estates.note1' => 'string', 'note1' => 'string', 'Estates__note2' => 'string', 'Estates.note2' => 'string', 'note2' => 'string', 'Estates__note3' => 'string', 'Estates.note3' => 'string', 'note3' => 'string', 'Estates__internal_note1' => 'string', 'Estates.internal_note1' => 'string', 'internal_note1' => 'string', 'Estates__internal_note2' => 'string', 'Estates.internal_note2' => 'string', 'internal_note2' => 'string', 'Estates__secret' => 'string', 'Estates.secret' => 'string', 'secret' => 'string', 'Estates__staff' => 'string', 'Estates.staff' => 'string', 'staff' => 'string', 'Estates__inputter' => 'string', 'Estates.inputter' => 'string', 'inputter' => 'string', 'Estates__photo_sign' => 'string', 'Estates.photo_sign' => 'string', 'photo_sign' => 'string', 'Estates__photo1' => 'string', 'Estates.photo1' => 'string', 'photo1' => 'string', 'Estates__photo2' => 'string', 'Estates.photo2' => 'string', 'photo2' => 'string', 'Estates__photo3' => 'string', 'Estates.photo3' => 'string', 'photo3' => 'string', 'Estates__photo4' => 'string', 'Estates.photo4' => 'string', 'photo4' => 'string', 'Estates__photo5' => 'string', 'Estates.photo5' => 'string', 'photo5' => 'string', 'Estates__photo6' => 'string', 'Estates.photo6' => 'string', 'photo6' => 'string', 'Estates__floor_plan' => 'string', 'Estates.floor_plan' => 'string', 'floor_plan' => 'string', 'Estates__created' => 'datetime', 'Estates.created' => 'datetime', 'created' => 'datetime', 'Estates__modified' => 'datetime', 'Estates.modified' => 'datetime', 'modified' => 'datetime', 'Estates__deleted' => 'datetime', 'Estates.deleted' => 'datetime', 'deleted' => 'datetime', 'Buildings__id' => 'biginteger', 'Buildings.id' => 'biginteger', 'Buildings__estates_category' => 'string', 'Buildings.estates_category' => 'string', 'estates_category' => 'string', 'Buildings__owner_id' => 'biginteger', 'Buildings.owner_id' => 'biginteger', 'owner_id' => 'biginteger', 'Buildings__management_id' => 'biginteger', 'Buildings.management_id' => 'biginteger', 'management_id' => 'biginteger', 'Buildings__name' => 'string', 'Buildings.name' => 'string', 'Buildings__yomi' => 'string', 'Buildings.yomi' => 'string', 'yomi' => 'string', 'Buildings__area' => 'string', 'Buildings.area' => 'string', 'Buildings__zip' => 'string', 'Buildings.zip' => 'string', 'zip' => 'string', 'Buildings__address1' => 'string', 'Buildings.address1' => 'string', 'Buildings__address2' => 'string', 'Buildings.address2' => 'string', 'Buildings__address3' => 'string', 'Buildings.address3' => 'string', 'address3' => 'string', 'Buildings__address4' => 'string', 'Buildings.address4' => 'string', 'address4' => 'string', 'Buildings__photo' => 'string', 'Buildings.photo' => 'string', 'photo' => 'string', 'Buildings__created' => 'datetime', 'Buildings.created' => 'datetime', 'Buildings__modified' => 'datetime', 'Buildings.modified' => 'datetime', 'Buildings__deleted' => 'datetime', 'Buildings.deleted' => 'datetime' ], 'decorators' => (int) 0, 'executed' => false, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [ 'Buildings' => [[maximum depth reached]] ], 'matching' => [], 'extraOptions' => [], 'repository' => object(App\Model\Table\EstatesTable) {} } $generator = object(Cake\Database\ValueBinder) { [protected] _bindings => [ ':c0' => [ [maximum depth reached] ], ':c1' => [ [maximum depth reached] ], ':c2' => [ [maximum depth reached] ] ] [protected] _bindingsCount => (int) 3 }count - [internal], line ?? Cake\Database\QueryCompiler::Cake\Database\{closure}() - CORE/src/Database/QueryCompiler.php, line 128 Cake\Database\Query::traverse() - CORE/src/Database/Query.php, line 311 Cake\Database\QueryCompiler::compile() - CORE/src/Database/QueryCompiler.php, line 99 Cake\Database\Driver::compileQuery() - CORE/src/Database/Driver.php, line 359 Cake\Database\Connection::compileQuery() - CORE/src/Database/Connection.php, line 299 Cake\Database\Query::sql() - CORE/src/Database/Query.php, line 282 Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 990 Cake\Database\Driver\Mysql::prepare() - CORE/src/Database/Driver/Mysql.php, line 136 Cake\Database\Connection::prepare() - CORE/src/Database/Connection.php, line 258 Cake\Database\Connection::run() - CORE/src/Database/Connection.php, line 311 Cake\Database\Query::execute() - CORE/src/Database/Query.php, line 213 Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 1011 Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276 Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 959 Cake\ORM\Query::getIterator() - CORE/src/Datasource/QueryTrait.php, line 132 include - APP/Template/Element/estate.ctp, line 71
