Notice (8): Trying to get property of non-object [APP/Model/Table/ArticlesTable.php, line 1211]Code Context $entity = $find->first();
// 緯度・経度取得
if ((!$entity->lat || !$entity->lng) && $entity->address)
$id = '24752'
$find = object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT articles.id AS `articles__id`, articles.source_id AS `articles__source_id`, articles.title AS `articles__title`, articles.explanation AS `articles__explanation`, articles.recommend AS `articles__recommend`, articles.shops_id AS `articles__shops_id`, articles.staffs_id AS `articles__staffs_id`, articles.address AS `articles__address`, articles.routes_id_1 AS `articles__routes_id_1`, articles.routes_id_2 AS `articles__routes_id_2`, articles.routes_id_3 AS `articles__routes_id_3`, articles.routes_id_4 AS `articles__routes_id_4`, articles.routes_id_5 AS `articles__routes_id_5`, articles.stations_id_1 AS `articles__stations_id_1`, articles.stations_id_2 AS `articles__stations_id_2`, articles.stations_id_3 AS `articles__stations_id_3`, articles.stations_id_4 AS `articles__stations_id_4`, articles.stations_id_5 AS `articles__stations_id_5`, articles.station_walk_1 AS `articles__station_walk_1`, articles.station_walk_2 AS `articles__station_walk_2`, articles.station_walk_3 AS `articles__station_walk_3`, articles.station_walk_4 AS `articles__station_walk_4`, articles.station_walk_5 AS `articles__station_walk_5`, articles.bus_time_1 AS `articles__bus_time_1`, articles.bus_time_2 AS `articles__bus_time_2`, articles.bus_time_3 AS `articles__bus_time_3`, articles.bus_time_4 AS `articles__bus_time_4`, articles.bus_time_5 AS `articles__bus_time_5`, articles.bus_stop_1 AS `articles__bus_stop_1`, articles.bus_stop_2 AS `articles__bus_stop_2`, articles.bus_stop_3 AS `articles__bus_stop_3`, articles.bus_stop_4 AS `articles__bus_stop_4`, articles.bus_stop_5 AS `articles__bus_stop_5`, articles.bus_stop_walk_1 AS `articles__bus_stop_walk_1`, articles.bus_stop_walk_2 AS `articles__bus_stop_walk_2`, articles.bus_stop_walk_3 AS `articles__bus_stop_walk_3`, articles.bus_stop_walk_4 AS `articles__bus_stop_walk_4`, articles.bus_stop_walk_5 AS `articles__bus_stop_walk_5`, articles.floor AS `articles__floor`, articles.floor_under AS `articles__floor_under`, articles.year AS `articles__year`, articles.month AS `articles__month`, articles.information AS `articles__information`, articles.rooms AS `articles__rooms`, articles.lat AS `articles__lat`, articles.lng AS `articles__lng`, articles.parking AS `articles__parking`, articles.seo_keywords AS `articles__seo_keywords`, articles.seo_description AS `articles__seo_description`, articles.remarks AS `articles__remarks`, (SELECT explanation FROM rooms WHERE articles_id = articles.id ORDER BY id ASC LIMIT 1) AS `room_explanation`, COALESCE((SELECT id FROM imgs WHERE type = 1 AND trait_id = articles.id ORDER BY class = 1 DESC, id ASC LIMIT 1 OFFSET 2), 0) AS `imgs_id`, (SELECT title FROM routes WHERE id = articles.routes_id_1 LIMIT 1) AS `route1`, (SELECT title FROM routes WHERE id = articles.routes_id_2 LIMIT 1) AS `route2`, (SELECT title FROM routes WHERE id = articles.routes_id_3 LIMIT 1) AS `route3`, (SELECT title FROM routes WHERE id = articles.routes_id_4 LIMIT 1) AS `route4`, (SELECT title FROM routes WHERE id = articles.routes_id_5 LIMIT 1) AS `route5`, (SELECT title FROM stations WHERE routes_id = articles.routes_id_1 AND stations_id = articles.stations_id_1 LIMIT 1) AS `station1`, (SELECT title FROM stations WHERE routes_id = articles.routes_id_2 AND stations_id = articles.stations_id_2 LIMIT 1) AS `station2`, (SELECT title FROM stations WHERE routes_id = articles.routes_id_3 AND stations_id = articles.stations_id_3 LIMIT 1) AS `station3`, (SELECT title FROM stations WHERE routes_id = articles.routes_id_4 AND stations_id = articles.stations_id_4 LIMIT 1) AS `station4`, (SELECT title FROM stations WHERE routes_id = articles.routes_id_5 AND stations_id = articles.stations_id_5 LIMIT 1) AS `station5`, COALESCE((SELECT rent FROM rooms WHERE flg = 2 AND articles_id = articles.id ORDER BY rent ASC LIMIT 1), 0) AS `rent_min`, COALESCE((SELECT rent FROM rooms WHERE flg = 2 AND articles_id = articles.id ORDER BY rent DESC LIMIT 1), 0) AS `rent_max`, COALESCE((SELECT maintenance FROM rooms WHERE flg = 2 AND articles_id = articles.id ORDER BY maintenance ASC LIMIT 1), 0) AS `maintenance_min`, COALESCE((SELECT maintenance FROM rooms WHERE flg = 2 AND articles_id = articles.id ORDER BY maintenance DESC LIMIT 1), 0) AS `maintenance_max`, (SELECT security_deposit FROM rooms WHERE flg = 2 AND articles_id = articles.id ORDER BY security_deposit ASC LIMIT 1) AS `security_deposit_min`, (SELECT security_deposit FROM rooms WHERE flg = 2 AND articles_id = articles.id ORDER BY security_deposit DESC LIMIT 1) AS `security_deposit_max`, (SELECT reward FROM rooms WHERE flg = 2 AND articles_id = articles.id ORDER BY reward ASC LIMIT 1) AS `reward_min`, (SELECT reward FROM rooms WHERE flg = 2 AND articles_id = articles.id ORDER BY reward DESC LIMIT 1) AS `reward_max`, (SELECT room_number FROM rooms WHERE flg = 2 AND articles_id = articles.id ORDER BY CAST(CONCAT(room_number, '.', room_layout) AS DECIMAL(2, 1)) ASC LIMIT 1) AS `room_number_min`, (SELECT room_number FROM rooms WHERE flg = 2 AND articles_id = articles.id ORDER BY CAST(CONCAT(room_number, '.', room_layout) AS DECIMAL(2, 1)) DESC LIMIT 1) AS `room_number_max`, (SELECT room_layout FROM rooms WHERE flg = 2 AND articles_id = articles.id ORDER BY CAST(CONCAT(room_number, '.', room_layout) AS DECIMAL(2, 1)) ASC LIMIT 1) AS `room_layout_min`, (SELECT room_layout FROM rooms WHERE flg = 2 AND articles_id = articles.id ORDER BY CAST(CONCAT(room_number, '.', room_layout) AS DECIMAL(2, 1)) DESC LIMIT 1) AS `room_layout_max`, (SELECT title FROM structures WHERE id = articles.structures_id LIMIT 1) AS `structure`, (SELECT area FROM rooms WHERE flg = 2 AND articles_id = articles.id ORDER BY area ASC LIMIT 1) AS `area_min`, (SELECT area FROM rooms WHERE flg = 2 AND articles_id = articles.id ORDER BY area DESC LIMIT 1) AS `area_max`, (SELECT 'ペット相談可' FROM facilities_trait WHERE type = 4 AND facilities_id = 30002 AND trait_id IN (SELECT id FROM rooms WHERE flg = 2 AND articles_id = articles.id) limit 1) AS `icon1`, (SELECT 'バス・トイレ別' FROM facilities_trait WHERE type = 4 AND facilities_id = 20 AND trait_id IN (SELECT id FROM rooms WHERE flg = 2 AND articles_id = articles.id) limit 1) AS `icon2`, (SELECT '駐車場あり' FROM facilities_trait WHERE type = 1 AND trait_id = articles.id AND (facilities_id = 105 OR facilities_id = 134 OR facilities_id = 10133) limit 1) AS `icon3`, (SELECT '室内洗濯機置場' FROM facilities_trait WHERE type = 4 AND facilities_id = 61 AND trait_id IN (SELECT id FROM rooms WHERE flg = 2 AND articles_id = articles.id) limit 1) AS `icon4`, (SELECT 'フローリング' FROM facilities_trait WHERE type = 4 AND (facilities_id = 101 OR facilities_id = 103 OR facilities_id = 10207 OR facilities_id = 10208) AND trait_id IN (SELECT id FROM rooms WHERE flg = 2 AND articles_id = articles.id) limit 1) AS `icon5`, (SELECT '洗面所独立' FROM facilities_trait WHERE type = 4 AND facilities_id = 58 AND trait_id IN (SELECT id FROM rooms WHERE flg = 2 AND articles_id = articles.id) limit 1) AS `icon6`, (SELECT 'エレベーター' FROM facilities_trait WHERE type = 4 AND facilities_id = 10219 AND trait_id IN (SELECT id FROM rooms WHERE flg = 2 AND articles_id = articles.id) limit 1) AS `icon7`, (SELECT created FROM rooms WHERE articles_id = articles.id ORDER BY created DESC LIMIT 1) AS `created`, (SELECT modified FROM rooms WHERE articles_id = articles.id ORDER BY modified DESC LIMIT 1) AS `modified`, (SELECT flag FROM external_links WHERE article_id = articles.id) AS `show_external_link_flag` FROM articles articles WHERE articles.id = :c0 LIMIT 1',
'params' => [
':c0' => [
[maximum depth reached]
]
],
'defaultTypes' => [
'articles__id' => 'biginteger',
'articles.id' => 'biginteger',
'id' => 'biginteger',
'articles__source_id' => 'biginteger',
'articles.source_id' => 'biginteger',
'source_id' => 'biginteger',
'articles__flg' => 'integer',
'articles.flg' => 'integer',
'flg' => 'integer',
'articles__title' => 'string',
'articles.title' => 'string',
'title' => 'string',
'articles__title_hide' => 'integer',
'articles.title_hide' => 'integer',
'title_hide' => 'integer',
'articles__title_kana' => 'string',
'articles.title_kana' => 'string',
'title_kana' => 'string',
'articles__sub_title' => 'string',
'articles.sub_title' => 'string',
'sub_title' => 'string',
'articles__explanation' => 'text',
'articles.explanation' => 'text',
'explanation' => 'text',
'articles__recommend' => 'text',
'articles.recommend' => 'text',
'recommend' => 'text',
'articles__shops_id' => 'biginteger',
'articles.shops_id' => 'biginteger',
'shops_id' => 'biginteger',
'articles__staffs_id' => 'biginteger',
'articles.staffs_id' => 'biginteger',
'staffs_id' => 'biginteger',
'articles__postcode' => 'string',
'articles.postcode' => 'string',
'postcode' => 'string',
'articles__address' => 'string',
'articles.address' => 'string',
'address' => 'string',
'articles__address_etc' => 'text',
'articles.address_etc' => 'text',
'address_etc' => 'text',
'articles__routes_id_1' => 'biginteger',
'articles.routes_id_1' => 'biginteger',
'routes_id_1' => 'biginteger',
'articles__stations_id_1' => 'biginteger',
'articles.stations_id_1' => 'biginteger',
'stations_id_1' => 'biginteger',
'articles__station_walk_1' => 'integer',
'articles.station_walk_1' => 'integer',
'station_walk_1' => 'integer',
'articles__bus_time_1' => 'integer',
'articles.bus_time_1' => 'integer',
'bus_time_1' => 'integer',
'articles__bus_stop_1' => 'string',
'articles.bus_stop_1' => 'string',
'bus_stop_1' => 'string',
'articles__bus_stop_walk_1' => 'integer',
'articles.bus_stop_walk_1' => 'integer',
'bus_stop_walk_1' => 'integer',
'articles__routes_id_2' => 'biginteger',
'articles.routes_id_2' => 'biginteger',
'routes_id_2' => 'biginteger',
'articles__stations_id_2' => 'biginteger',
'articles.stations_id_2' => 'biginteger',
'stations_id_2' => 'biginteger',
'articles__station_walk_2' => 'integer',
'articles.station_walk_2' => 'integer',
'station_walk_2' => 'integer',
'articles__bus_time_2' => 'integer',
'articles.bus_time_2' => 'integer',
'bus_time_2' => 'integer',
'articles__bus_stop_2' => 'string',
'articles.bus_stop_2' => 'string',
'bus_stop_2' => 'string',
'articles__bus_stop_walk_2' => 'integer',
'articles.bus_stop_walk_2' => 'integer',
'bus_stop_walk_2' => 'integer',
'articles__routes_id_3' => 'biginteger',
'articles.routes_id_3' => 'biginteger',
'routes_id_3' => 'biginteger',
'articles__stations_id_3' => 'biginteger',
'articles.stations_id_3' => 'biginteger',
'stations_id_3' => 'biginteger',
'articles__station_walk_3' => 'integer',
'articles.station_walk_3' => 'integer',
'station_walk_3' => 'integer',
'articles__bus_time_3' => 'integer',
'articles.bus_time_3' => 'integer',
'bus_time_3' => 'integer',
'articles__bus_stop_3' => 'string',
'articles.bus_stop_3' => 'string',
'bus_stop_3' => 'string',
'articles__bus_stop_walk_3' => 'integer',
'articles.bus_stop_walk_3' => 'integer',
'bus_stop_walk_3' => 'integer',
'articles__routes_id_4' => 'biginteger',
'articles.routes_id_4' => 'biginteger',
'routes_id_4' => 'biginteger',
'articles__stations_id_4' => 'biginteger',
'articles.stations_id_4' => 'biginteger',
'stations_id_4' => 'biginteger',
'articles__station_walk_4' => 'integer',
'articles.station_walk_4' => 'integer',
'station_walk_4' => 'integer',
'articles__bus_time_4' => 'integer',
'articles.bus_time_4' => 'integer',
'bus_time_4' => 'integer',
'articles__bus_stop_4' => 'string',
'articles.bus_stop_4' => 'string',
'bus_stop_4' => 'string',
'articles__bus_stop_walk_4' => 'integer',
'articles.bus_stop_walk_4' => 'integer',
'bus_stop_walk_4' => 'integer',
'articles__routes_id_5' => 'biginteger',
'articles.routes_id_5' => 'biginteger',
'routes_id_5' => 'biginteger',
'articles__stations_id_5' => 'biginteger',
'articles.stations_id_5' => 'biginteger',
'stations_id_5' => 'biginteger',
'articles__station_walk_5' => 'integer',
'articles.station_walk_5' => 'integer',
'station_walk_5' => 'integer',
'articles__bus_time_5' => 'integer',
'articles.bus_time_5' => 'integer',
'bus_time_5' => 'integer',
'articles__bus_stop_5' => 'string',
'articles.bus_stop_5' => 'string',
'bus_stop_5' => 'string',
'articles__bus_stop_walk_5' => 'integer',
'articles.bus_stop_walk_5' => 'integer',
'bus_stop_walk_5' => 'integer',
'articles__type' => 'integer',
'articles.type' => 'integer',
'type' => 'integer',
'articles__structures_id' => 'biginteger',
'articles.structures_id' => 'biginteger',
'structures_id' => 'biginteger',
'articles__parking' => 'text',
'articles.parking' => 'text',
'parking' => 'text',
'articles__rooms' => 'integer',
'articles.rooms' => 'integer',
'rooms' => 'integer',
'articles__floor' => 'integer',
'articles.floor' => 'integer',
'floor' => 'integer',
'articles__floor_under' => 'integer',
'articles.floor_under' => 'integer',
'floor_under' => 'integer',
'articles__year' => 'integer',
'articles.year' => 'integer',
'year' => 'integer',
'articles__month' => 'integer',
'articles.month' => 'integer',
'month' => 'integer',
'articles__information' => 'json',
'articles.information' => 'json',
'information' => 'json',
'articles__youtube' => 'string',
'articles.youtube' => 'string',
'youtube' => 'string',
'articles__remarks' => 'text',
'articles.remarks' => 'text',
'remarks' => 'text',
'articles__memo' => 'text',
'articles.memo' => 'text',
'memo' => 'text',
'articles__mcompanies_id' => 'biginteger',
'articles.mcompanies_id' => 'biginteger',
'mcompanies_id' => 'biginteger',
'articles__lat' => 'float',
'articles.lat' => 'float',
'lat' => 'float',
'articles__lng' => 'float',
'articles.lng' => 'float',
'lng' => 'float',
'articles__seo_keywords' => 'text',
'articles.seo_keywords' => 'text',
'seo_keywords' => 'text',
'articles__seo_description' => 'text',
'articles.seo_description' => 'text',
'seo_description' => 'text',
'articles__rooms_count' => 'integer',
'articles.rooms_count' => 'integer',
'rooms_count' => 'integer',
'articles__rooms_release_count' => 'integer',
'articles.rooms_release_count' => 'integer',
'rooms_release_count' => 'integer',
'articles__rooms_wanted_count' => 'integer',
'articles.rooms_wanted_count' => 'integer',
'rooms_wanted_count' => 'integer',
'articles__admins_id' => 'biginteger',
'articles.admins_id' => 'biginteger',
'admins_id' => 'biginteger',
'articles__created' => 'datetime',
'articles.created' => 'datetime',
'created' => 'datetime',
'articles__modified' => 'datetime',
'articles.modified' => 'datetime',
'modified' => 'datetime'
],
'decorators' => (int) 1,
'executed' => true,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [],
'matching' => [],
'extraOptions' => [],
'repository' => object(App\Model\Table\ArticlesTable) {}
}
$entity = nullApp\Model\Table\ArticlesTable::getData() - APP/Model/Table/ArticlesTable.php, line 1211
App\Controller\ContactsController::MainSiteRedirect() - APP/Controller/ContactsController.php, line 29
App\Controller\ContactsController::initialize() - APP/Controller/ContactsController.php, line 23
Cake\Controller\Controller::__construct() - CORE/src/Controller/Controller.php, line 262
ReflectionClass::newInstance() - [internal], line ??
Cake\Http\ControllerFactory::create() - CORE/src/Http/ControllerFactory.php, line 77
Cake\Http\ActionDispatcher::dispatch() - CORE/src/Http/ActionDispatcher.php, line 90
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
Cake\Http\Runner::run() - CORE/src/Http/Runner.php, line 51
Cake\Http\Server::run() - CORE/src/Http/Server.php, line 80
Notice (8): Trying to get property of non-object [APP/Model/Table/ArticlesTable.php, line 1211]Code Context $entity = $find->first();
// 緯度・経度取得
if ((!$entity->lat || !$entity->lng) && $entity->address)
$id = '24752'
$find = object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT articles.id AS `articles__id`, articles.source_id AS `articles__source_id`, articles.title AS `articles__title`, articles.explanation AS `articles__explanation`, articles.recommend AS `articles__recommend`, articles.shops_id AS `articles__shops_id`, articles.staffs_id AS `articles__staffs_id`, articles.address AS `articles__address`, articles.routes_id_1 AS `articles__routes_id_1`, articles.routes_id_2 AS `articles__routes_id_2`, articles.routes_id_3 AS `articles__routes_id_3`, articles.routes_id_4 AS `articles__routes_id_4`, articles.routes_id_5 AS `articles__routes_id_5`, articles.stations_id_1 AS `articles__stations_id_1`, articles.stations_id_2 AS `articles__stations_id_2`, articles.stations_id_3 AS `articles__stations_id_3`, articles.stations_id_4 AS `articles__stations_id_4`, articles.stations_id_5 AS `articles__stations_id_5`, articles.station_walk_1 AS `articles__station_walk_1`, articles.station_walk_2 AS `articles__station_walk_2`, articles.station_walk_3 AS `articles__station_walk_3`, articles.station_walk_4 AS `articles__station_walk_4`, articles.station_walk_5 AS `articles__station_walk_5`, articles.bus_time_1 AS `articles__bus_time_1`, articles.bus_time_2 AS `articles__bus_time_2`, articles.bus_time_3 AS `articles__bus_time_3`, articles.bus_time_4 AS `articles__bus_time_4`, articles.bus_time_5 AS `articles__bus_time_5`, articles.bus_stop_1 AS `articles__bus_stop_1`, articles.bus_stop_2 AS `articles__bus_stop_2`, articles.bus_stop_3 AS `articles__bus_stop_3`, articles.bus_stop_4 AS `articles__bus_stop_4`, articles.bus_stop_5 AS `articles__bus_stop_5`, articles.bus_stop_walk_1 AS `articles__bus_stop_walk_1`, articles.bus_stop_walk_2 AS `articles__bus_stop_walk_2`, articles.bus_stop_walk_3 AS `articles__bus_stop_walk_3`, articles.bus_stop_walk_4 AS `articles__bus_stop_walk_4`, articles.bus_stop_walk_5 AS `articles__bus_stop_walk_5`, articles.floor AS `articles__floor`, articles.floor_under AS `articles__floor_under`, articles.year AS `articles__year`, articles.month AS `articles__month`, articles.information AS `articles__information`, articles.rooms AS `articles__rooms`, articles.lat AS `articles__lat`, articles.lng AS `articles__lng`, articles.parking AS `articles__parking`, articles.seo_keywords AS `articles__seo_keywords`, articles.seo_description AS `articles__seo_description`, articles.remarks AS `articles__remarks`, (SELECT explanation FROM rooms WHERE articles_id = articles.id ORDER BY id ASC LIMIT 1) AS `room_explanation`, COALESCE((SELECT id FROM imgs WHERE type = 1 AND trait_id = articles.id ORDER BY class = 1 DESC, id ASC LIMIT 1 OFFSET 2), 0) AS `imgs_id`, (SELECT title FROM routes WHERE id = articles.routes_id_1 LIMIT 1) AS `route1`, (SELECT title FROM routes WHERE id = articles.routes_id_2 LIMIT 1) AS `route2`, (SELECT title FROM routes WHERE id = articles.routes_id_3 LIMIT 1) AS `route3`, (SELECT title FROM routes WHERE id = articles.routes_id_4 LIMIT 1) AS `route4`, (SELECT title FROM routes WHERE id = articles.routes_id_5 LIMIT 1) AS `route5`, (SELECT title FROM stations WHERE routes_id = articles.routes_id_1 AND stations_id = articles.stations_id_1 LIMIT 1) AS `station1`, (SELECT title FROM stations WHERE routes_id = articles.routes_id_2 AND stations_id = articles.stations_id_2 LIMIT 1) AS `station2`, (SELECT title FROM stations WHERE routes_id = articles.routes_id_3 AND stations_id = articles.stations_id_3 LIMIT 1) AS `station3`, (SELECT title FROM stations WHERE routes_id = articles.routes_id_4 AND stations_id = articles.stations_id_4 LIMIT 1) AS `station4`, (SELECT title FROM stations WHERE routes_id = articles.routes_id_5 AND stations_id = articles.stations_id_5 LIMIT 1) AS `station5`, COALESCE((SELECT rent FROM rooms WHERE flg = 2 AND articles_id = articles.id ORDER BY rent ASC LIMIT 1), 0) AS `rent_min`, COALESCE((SELECT rent FROM rooms WHERE flg = 2 AND articles_id = articles.id ORDER BY rent DESC LIMIT 1), 0) AS `rent_max`, COALESCE((SELECT maintenance FROM rooms WHERE flg = 2 AND articles_id = articles.id ORDER BY maintenance ASC LIMIT 1), 0) AS `maintenance_min`, COALESCE((SELECT maintenance FROM rooms WHERE flg = 2 AND articles_id = articles.id ORDER BY maintenance DESC LIMIT 1), 0) AS `maintenance_max`, (SELECT security_deposit FROM rooms WHERE flg = 2 AND articles_id = articles.id ORDER BY security_deposit ASC LIMIT 1) AS `security_deposit_min`, (SELECT security_deposit FROM rooms WHERE flg = 2 AND articles_id = articles.id ORDER BY security_deposit DESC LIMIT 1) AS `security_deposit_max`, (SELECT reward FROM rooms WHERE flg = 2 AND articles_id = articles.id ORDER BY reward ASC LIMIT 1) AS `reward_min`, (SELECT reward FROM rooms WHERE flg = 2 AND articles_id = articles.id ORDER BY reward DESC LIMIT 1) AS `reward_max`, (SELECT room_number FROM rooms WHERE flg = 2 AND articles_id = articles.id ORDER BY CAST(CONCAT(room_number, '.', room_layout) AS DECIMAL(2, 1)) ASC LIMIT 1) AS `room_number_min`, (SELECT room_number FROM rooms WHERE flg = 2 AND articles_id = articles.id ORDER BY CAST(CONCAT(room_number, '.', room_layout) AS DECIMAL(2, 1)) DESC LIMIT 1) AS `room_number_max`, (SELECT room_layout FROM rooms WHERE flg = 2 AND articles_id = articles.id ORDER BY CAST(CONCAT(room_number, '.', room_layout) AS DECIMAL(2, 1)) ASC LIMIT 1) AS `room_layout_min`, (SELECT room_layout FROM rooms WHERE flg = 2 AND articles_id = articles.id ORDER BY CAST(CONCAT(room_number, '.', room_layout) AS DECIMAL(2, 1)) DESC LIMIT 1) AS `room_layout_max`, (SELECT title FROM structures WHERE id = articles.structures_id LIMIT 1) AS `structure`, (SELECT area FROM rooms WHERE flg = 2 AND articles_id = articles.id ORDER BY area ASC LIMIT 1) AS `area_min`, (SELECT area FROM rooms WHERE flg = 2 AND articles_id = articles.id ORDER BY area DESC LIMIT 1) AS `area_max`, (SELECT 'ペット相談可' FROM facilities_trait WHERE type = 4 AND facilities_id = 30002 AND trait_id IN (SELECT id FROM rooms WHERE flg = 2 AND articles_id = articles.id) limit 1) AS `icon1`, (SELECT 'バス・トイレ別' FROM facilities_trait WHERE type = 4 AND facilities_id = 20 AND trait_id IN (SELECT id FROM rooms WHERE flg = 2 AND articles_id = articles.id) limit 1) AS `icon2`, (SELECT '駐車場あり' FROM facilities_trait WHERE type = 1 AND trait_id = articles.id AND (facilities_id = 105 OR facilities_id = 134 OR facilities_id = 10133) limit 1) AS `icon3`, (SELECT '室内洗濯機置場' FROM facilities_trait WHERE type = 4 AND facilities_id = 61 AND trait_id IN (SELECT id FROM rooms WHERE flg = 2 AND articles_id = articles.id) limit 1) AS `icon4`, (SELECT 'フローリング' FROM facilities_trait WHERE type = 4 AND (facilities_id = 101 OR facilities_id = 103 OR facilities_id = 10207 OR facilities_id = 10208) AND trait_id IN (SELECT id FROM rooms WHERE flg = 2 AND articles_id = articles.id) limit 1) AS `icon5`, (SELECT '洗面所独立' FROM facilities_trait WHERE type = 4 AND facilities_id = 58 AND trait_id IN (SELECT id FROM rooms WHERE flg = 2 AND articles_id = articles.id) limit 1) AS `icon6`, (SELECT 'エレベーター' FROM facilities_trait WHERE type = 4 AND facilities_id = 10219 AND trait_id IN (SELECT id FROM rooms WHERE flg = 2 AND articles_id = articles.id) limit 1) AS `icon7`, (SELECT created FROM rooms WHERE articles_id = articles.id ORDER BY created DESC LIMIT 1) AS `created`, (SELECT modified FROM rooms WHERE articles_id = articles.id ORDER BY modified DESC LIMIT 1) AS `modified`, (SELECT flag FROM external_links WHERE article_id = articles.id) AS `show_external_link_flag` FROM articles articles WHERE articles.id = :c0 LIMIT 1',
'params' => [
':c0' => [
[maximum depth reached]
]
],
'defaultTypes' => [
'articles__id' => 'biginteger',
'articles.id' => 'biginteger',
'id' => 'biginteger',
'articles__source_id' => 'biginteger',
'articles.source_id' => 'biginteger',
'source_id' => 'biginteger',
'articles__flg' => 'integer',
'articles.flg' => 'integer',
'flg' => 'integer',
'articles__title' => 'string',
'articles.title' => 'string',
'title' => 'string',
'articles__title_hide' => 'integer',
'articles.title_hide' => 'integer',
'title_hide' => 'integer',
'articles__title_kana' => 'string',
'articles.title_kana' => 'string',
'title_kana' => 'string',
'articles__sub_title' => 'string',
'articles.sub_title' => 'string',
'sub_title' => 'string',
'articles__explanation' => 'text',
'articles.explanation' => 'text',
'explanation' => 'text',
'articles__recommend' => 'text',
'articles.recommend' => 'text',
'recommend' => 'text',
'articles__shops_id' => 'biginteger',
'articles.shops_id' => 'biginteger',
'shops_id' => 'biginteger',
'articles__staffs_id' => 'biginteger',
'articles.staffs_id' => 'biginteger',
'staffs_id' => 'biginteger',
'articles__postcode' => 'string',
'articles.postcode' => 'string',
'postcode' => 'string',
'articles__address' => 'string',
'articles.address' => 'string',
'address' => 'string',
'articles__address_etc' => 'text',
'articles.address_etc' => 'text',
'address_etc' => 'text',
'articles__routes_id_1' => 'biginteger',
'articles.routes_id_1' => 'biginteger',
'routes_id_1' => 'biginteger',
'articles__stations_id_1' => 'biginteger',
'articles.stations_id_1' => 'biginteger',
'stations_id_1' => 'biginteger',
'articles__station_walk_1' => 'integer',
'articles.station_walk_1' => 'integer',
'station_walk_1' => 'integer',
'articles__bus_time_1' => 'integer',
'articles.bus_time_1' => 'integer',
'bus_time_1' => 'integer',
'articles__bus_stop_1' => 'string',
'articles.bus_stop_1' => 'string',
'bus_stop_1' => 'string',
'articles__bus_stop_walk_1' => 'integer',
'articles.bus_stop_walk_1' => 'integer',
'bus_stop_walk_1' => 'integer',
'articles__routes_id_2' => 'biginteger',
'articles.routes_id_2' => 'biginteger',
'routes_id_2' => 'biginteger',
'articles__stations_id_2' => 'biginteger',
'articles.stations_id_2' => 'biginteger',
'stations_id_2' => 'biginteger',
'articles__station_walk_2' => 'integer',
'articles.station_walk_2' => 'integer',
'station_walk_2' => 'integer',
'articles__bus_time_2' => 'integer',
'articles.bus_time_2' => 'integer',
'bus_time_2' => 'integer',
'articles__bus_stop_2' => 'string',
'articles.bus_stop_2' => 'string',
'bus_stop_2' => 'string',
'articles__bus_stop_walk_2' => 'integer',
'articles.bus_stop_walk_2' => 'integer',
'bus_stop_walk_2' => 'integer',
'articles__routes_id_3' => 'biginteger',
'articles.routes_id_3' => 'biginteger',
'routes_id_3' => 'biginteger',
'articles__stations_id_3' => 'biginteger',
'articles.stations_id_3' => 'biginteger',
'stations_id_3' => 'biginteger',
'articles__station_walk_3' => 'integer',
'articles.station_walk_3' => 'integer',
'station_walk_3' => 'integer',
'articles__bus_time_3' => 'integer',
'articles.bus_time_3' => 'integer',
'bus_time_3' => 'integer',
'articles__bus_stop_3' => 'string',
'articles.bus_stop_3' => 'string',
'bus_stop_3' => 'string',
'articles__bus_stop_walk_3' => 'integer',
'articles.bus_stop_walk_3' => 'integer',
'bus_stop_walk_3' => 'integer',
'articles__routes_id_4' => 'biginteger',
'articles.routes_id_4' => 'biginteger',
'routes_id_4' => 'biginteger',
'articles__stations_id_4' => 'biginteger',
'articles.stations_id_4' => 'biginteger',
'stations_id_4' => 'biginteger',
'articles__station_walk_4' => 'integer',
'articles.station_walk_4' => 'integer',
'station_walk_4' => 'integer',
'articles__bus_time_4' => 'integer',
'articles.bus_time_4' => 'integer',
'bus_time_4' => 'integer',
'articles__bus_stop_4' => 'string',
'articles.bus_stop_4' => 'string',
'bus_stop_4' => 'string',
'articles__bus_stop_walk_4' => 'integer',
'articles.bus_stop_walk_4' => 'integer',
'bus_stop_walk_4' => 'integer',
'articles__routes_id_5' => 'biginteger',
'articles.routes_id_5' => 'biginteger',
'routes_id_5' => 'biginteger',
'articles__stations_id_5' => 'biginteger',
'articles.stations_id_5' => 'biginteger',
'stations_id_5' => 'biginteger',
'articles__station_walk_5' => 'integer',
'articles.station_walk_5' => 'integer',
'station_walk_5' => 'integer',
'articles__bus_time_5' => 'integer',
'articles.bus_time_5' => 'integer',
'bus_time_5' => 'integer',
'articles__bus_stop_5' => 'string',
'articles.bus_stop_5' => 'string',
'bus_stop_5' => 'string',
'articles__bus_stop_walk_5' => 'integer',
'articles.bus_stop_walk_5' => 'integer',
'bus_stop_walk_5' => 'integer',
'articles__type' => 'integer',
'articles.type' => 'integer',
'type' => 'integer',
'articles__structures_id' => 'biginteger',
'articles.structures_id' => 'biginteger',
'structures_id' => 'biginteger',
'articles__parking' => 'text',
'articles.parking' => 'text',
'parking' => 'text',
'articles__rooms' => 'integer',
'articles.rooms' => 'integer',
'rooms' => 'integer',
'articles__floor' => 'integer',
'articles.floor' => 'integer',
'floor' => 'integer',
'articles__floor_under' => 'integer',
'articles.floor_under' => 'integer',
'floor_under' => 'integer',
'articles__year' => 'integer',
'articles.year' => 'integer',
'year' => 'integer',
'articles__month' => 'integer',
'articles.month' => 'integer',
'month' => 'integer',
'articles__information' => 'json',
'articles.information' => 'json',
'information' => 'json',
'articles__youtube' => 'string',
'articles.youtube' => 'string',
'youtube' => 'string',
'articles__remarks' => 'text',
'articles.remarks' => 'text',
'remarks' => 'text',
'articles__memo' => 'text',
'articles.memo' => 'text',
'memo' => 'text',
'articles__mcompanies_id' => 'biginteger',
'articles.mcompanies_id' => 'biginteger',
'mcompanies_id' => 'biginteger',
'articles__lat' => 'float',
'articles.lat' => 'float',
'lat' => 'float',
'articles__lng' => 'float',
'articles.lng' => 'float',
'lng' => 'float',
'articles__seo_keywords' => 'text',
'articles.seo_keywords' => 'text',
'seo_keywords' => 'text',
'articles__seo_description' => 'text',
'articles.seo_description' => 'text',
'seo_description' => 'text',
'articles__rooms_count' => 'integer',
'articles.rooms_count' => 'integer',
'rooms_count' => 'integer',
'articles__rooms_release_count' => 'integer',
'articles.rooms_release_count' => 'integer',
'rooms_release_count' => 'integer',
'articles__rooms_wanted_count' => 'integer',
'articles.rooms_wanted_count' => 'integer',
'rooms_wanted_count' => 'integer',
'articles__admins_id' => 'biginteger',
'articles.admins_id' => 'biginteger',
'admins_id' => 'biginteger',
'articles__created' => 'datetime',
'articles.created' => 'datetime',
'created' => 'datetime',
'articles__modified' => 'datetime',
'articles.modified' => 'datetime',
'modified' => 'datetime'
],
'decorators' => (int) 1,
'executed' => true,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [],
'matching' => [],
'extraOptions' => [],
'repository' => object(App\Model\Table\ArticlesTable) {}
}
$entity = nullApp\Model\Table\ArticlesTable::getData() - APP/Model/Table/ArticlesTable.php, line 1211
App\Controller\ContactsController::MainSiteRedirect() - APP/Controller/ContactsController.php, line 29
App\Controller\ContactsController::initialize() - APP/Controller/ContactsController.php, line 23
Cake\Controller\Controller::__construct() - CORE/src/Controller/Controller.php, line 262
ReflectionClass::newInstance() - [internal], line ??
Cake\Http\ControllerFactory::create() - CORE/src/Http/ControllerFactory.php, line 77
Cake\Http\ActionDispatcher::dispatch() - CORE/src/Http/ActionDispatcher.php, line 90
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
Cake\Http\Runner::run() - CORE/src/Http/Runner.php, line 51
Cake\Http\Server::run() - CORE/src/Http/Server.php, line 80
Notice (8): Trying to get property of non-object [APP/Controller/ContactsController.php, line 29]Code Context {
if ($id = $this->request->getQuery('articles_id')) {
$source_id = $this->Articles->getData($id)->source_id;
$id = '24752'
App\Controller\ContactsController::MainSiteRedirect() - APP/Controller/ContactsController.php, line 29
App\Controller\ContactsController::initialize() - APP/Controller/ContactsController.php, line 23
Cake\Controller\Controller::__construct() - CORE/src/Controller/Controller.php, line 262
ReflectionClass::newInstance() - [internal], line ??
Cake\Http\ControllerFactory::create() - CORE/src/Http/ControllerFactory.php, line 77
Cake\Http\ActionDispatcher::dispatch() - CORE/src/Http/ActionDispatcher.php, line 90
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
Cake\Http\Runner::run() - CORE/src/Http/Runner.php, line 51
Cake\Http\Server::run() - CORE/src/Http/Server.php, line 80
[main] - /usr/share/nginx/html/chemenviron.org/webroot/index.php, line 39
Warning (512): Unable to emit headers. Headers sent in file=/usr/share/nginx/html/chemenviron.org/project/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) 302,
'contentType' => 'text/html',
'headers' => [
'Content-Type' => [
[maximum depth reached]
],
'Location' => [
[maximum depth reached]
]
],
'file' => null,
'fileRange' => [],
'cookies' => [],
'cacheDirectives' => [],
'body' => ''
}
$maxBufferLength = (int) 8192
$file = '/usr/share/nginx/html/chemenviron.org/project/vendor/cakephp/cakephp/src/Error/Debugger.php'
$line = (int) 822
$message = 'Unable to emit headers. Headers sent in file=/usr/share/nginx/html/chemenviron.org/project/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 105
[main] - /usr/share/nginx/html/chemenviron.org/webroot/index.php, line 39
Warning (2): Cannot modify header information - headers already sent by (output started at /usr/share/nginx/html/chemenviron.org/project/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) 302,
'contentType' => 'text/html',
'headers' => [
'Content-Type' => [
[maximum depth reached]
],
'Location' => [
[maximum depth reached]
]
],
'file' => null,
'fileRange' => [],
'cookies' => [],
'cacheDirectives' => [],
'body' => ''
}
$reasonPhrase = 'Found'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 105
[main] - /usr/share/nginx/html/chemenviron.org/webroot/index.php, line 39
Warning (2): Cannot modify header information - headers already sent by (output started at /usr/share/nginx/html/chemenviron.org/project/vendor/cakephp/cakephp/src/Error/Debugger.php:822) [CORE/src/Http/ResponseEmitter.php, line 181]Code Context $name,
$value
), $first);
$response = object(Cake\Http\Response) {
'status' => (int) 302,
'contentType' => 'text/html',
'headers' => [
'Content-Type' => [
[maximum depth reached]
],
'Location' => [
[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 181
Cake\Http\ResponseEmitter::emit() - CORE/src/Http/ResponseEmitter.php, line 55
Cake\Http\Server::emit() - CORE/src/Http/Server.php, line 105
[main] - /usr/share/nginx/html/chemenviron.org/webroot/index.php, line 39
Warning (2): Cannot modify header information - headers already sent by (output started at /usr/share/nginx/html/chemenviron.org/project/vendor/cakephp/cakephp/src/Error/Debugger.php:822) [CORE/src/Http/ResponseEmitter.php, line 181]Code Context $name,
$value
), $first);
$response = object(Cake\Http\Response) {
'status' => (int) 302,
'contentType' => 'text/html',
'headers' => [
'Content-Type' => [
[maximum depth reached]
],
'Location' => [
[maximum depth reached]
]
],
'file' => null,
'fileRange' => [],
'cookies' => [],
'cacheDirectives' => [],
'body' => ''
}
$cookies = []
$values = [
(int) 0 => 'https://excerent.jp/contact/?a='
]
$name = 'Location'
$first = true
$value = 'https://excerent.jp/contact/?a='header - [internal], line ??
Cake\Http\ResponseEmitter::emitHeaders() - CORE/src/Http/ResponseEmitter.php, line 181
Cake\Http\ResponseEmitter::emit() - CORE/src/Http/ResponseEmitter.php, line 55
Cake\Http\Server::emit() - CORE/src/Http/Server.php, line 105
[main] - /usr/share/nginx/html/chemenviron.org/webroot/index.php, line 39