Notice (8): Undefined index: STN [APP/Controller/SearchesController.php, line 283]
Warning (2): array_unique() expects parameter 1 to be array, null given [APP/Controller/SearchesController.php, line 283]
Warning (2): array_values() expects parameter 1 to be array, null given [APP/Controller/SearchesController.php, line 284]
Warning (512): Unable to emit headers. Headers sent in file=/usr/share/nginx/html/concierent.sate5/project/vendor/cakephp/cakephp/src/Error/Debugger.php line=822 [CORE/src/Http/ResponseEmitter.php, line 48]
Warning (2): Cannot modify header information - headers already sent by (output started at /usr/share/nginx/html/concierent.sate5/project/vendor/cakephp/cakephp/src/Error/Debugger.php:822) [CORE/src/Http/ResponseEmitter.php, line 148]
Warning (2): Cannot modify header information - headers already sent by (output started at /usr/share/nginx/html/concierent.sate5/project/vendor/cakephp/cakephp/src/Error/Debugger.php:822) [CORE/src/Http/ResponseEmitter.php, line 181]
Warning (2): Cannot modify header information - headers already sent by (output started at /usr/share/nginx/html/concierent.sate5/project/vendor/cakephp/cakephp/src/Error/Debugger.php:822) [CORE/src/Http/ResponseEmitter.php, line 181]
Error: Database Error

Database Error PDOException

Documentation API

Error: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OR stations_id_2 = OR stations_id_3 = OR stations_id_4 = OR stations_id_5 = )' at line 1

If you are using SQL keywords as table column names, you can enable identifier quoting for your database connection in config/app.php.

SQL Query:

SELECT id AS `text`, articles.id AS `articles__id`, articles.class AS `articles__class`, articles.shops_id AS `articles__shops_id`, (SELECT title FROM shops WHERE flag = 2 AND id = articles.shops_id LIMIT 1) AS `shops_title`, articles.title AS `articles__title`, articles.title_kana AS `articles__title_kana`, articles.title_hide AS `articles__title_hide`, articles.address AS `articles__address`, articles.address_etc AS `articles__address_etc`, articles.year AS `articles__year`, articles.month AS `articles__month`, articles.lat AS `articles__lat`, articles.lng AS `articles__lng`, (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`, 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.type AS `articles__type`, articles.floor AS `articles__floor`, articles.floor_under AS `articles__floor_under`, COALESCE((SELECT id FROM imgs WHERE type = 1 AND trait_id = articles.id ORDER BY class = 900 DESC, class ASC LIMIT 1), 0) AS `imgs_id`, (SELECT explanation FROM rooms WHERE articles_id = articles.id ORDER BY id ASC LIMIT 1) AS `room_explanation`, COALESCE((SELECT rent FROM rooms WHERE flag = 2 AND articles_id = articles.id ORDER BY rent ASC LIMIT 1), 0) AS `rent_min`, COALESCE((SELECT rent FROM rooms WHERE flag = 2 AND articles_id = articles.id ORDER BY rent DESC LIMIT 1), 0) AS `rent_max`, COALESCE((SELECT maintenance FROM rooms WHERE flag = 2 AND articles_id = articles.id ORDER BY maintenance ASC LIMIT 1), 0) AS `maintenance_min`, COALESCE((SELECT maintenance FROM rooms WHERE flag = 2 AND articles_id = articles.id ORDER BY maintenance DESC LIMIT 1), 0) AS `maintenance_max`, COALESCE((SELECT common FROM rooms WHERE flag = 2 AND articles_id = articles.id ORDER BY common ASC LIMIT 1), 0) AS `common_min`, COALESCE((SELECT common FROM rooms WHERE flag = 2 AND articles_id = articles.id ORDER BY common DESC LIMIT 1), 0) AS `common_max`, (SELECT security_deposit FROM rooms WHERE flag = 2 AND articles_id = articles.id ORDER BY security_deposit ASC LIMIT 1) AS `security_deposit_min`, (SELECT security_deposit FROM rooms WHERE flag = 2 AND articles_id = articles.id ORDER BY security_deposit DESC LIMIT 1) AS `security_deposit_max`, (SELECT reward FROM rooms WHERE flag = 2 AND articles_id = articles.id ORDER BY reward ASC LIMIT 1) AS `reward_min`, (SELECT reward FROM rooms WHERE flag = 2 AND articles_id = articles.id ORDER BY reward DESC LIMIT 1) AS `reward_max`, (SELECT room_number FROM rooms WHERE flag = 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 flag = 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 flag = 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 flag = 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`, articles.structures_id AS `articles__structures_id`, (SELECT area FROM rooms WHERE flag = 2 AND articles_id = articles.id ORDER BY area ASC LIMIT 1) AS `area_min`, (SELECT area FROM rooms WHERE flag = 2 AND articles_id = articles.id ORDER BY area DESC LIMIT 1) AS `area_max`, (SELECT '新 築' FROM articles b WHERE b.id = articles.id AND CONCAT(b.year, LPAD(b.month, 2, '0')) >= 201806 limit 1) AS `icon1`, (SELECT 'ペット相談可' FROM facilities_trait WHERE flag = 2 AND trait_id = articles.id AND type = 1 AND (facilities_id = 3 OR facilities_id = 23 OR facilities_id = 308) LIMIT 1) AS `icon2`, (SELECT '分 譲' FROM facilities_trait WHERE flag = 2 AND trait_id = articles.id AND type = 1 AND (facilities_id = 5 OR facilities_id = 17 OR facilities_id = 320) LIMIT 1) AS `icon3`, (SELECT 'デザイナーズ' FROM facilities_trait WHERE flag = 2 AND trait_id = articles.id AND type = 1 AND facilities_id = 20 LIMIT 1) AS `icon4`, (SELECT '防犯カメラ' FROM facilities_trait WHERE flag = 2 AND trait_id = articles.id AND type = 1 AND facilities_id = 357 LIMIT 1) AS `icon5`, (SELECT '24時間セキュリティ' FROM facilities_trait WHERE flag = 2 AND trait_id = articles.id AND type = 1 AND facilities_id = 205 LIMIT 1) AS `icon6`, COALESCE((SELECT __created FROM rooms WHERE articles_id = articles.id ORDER BY __created DESC LIMIT 1), (SELECT created FROM rooms WHERE articles_id = articles.id ORDER BY created DESC LIMIT 1)) AS `created`, COALESCE((SELECT __modified FROM rooms WHERE articles_id = articles.id ORDER BY __modified DESC LIMIT 1), (SELECT modified FROM rooms WHERE articles_id = articles.id ORDER BY modified DESC LIMIT 1)) AS `modified`, (SELECT count(*) FROM rooms WHERE articles_id = articles.id AND status = 2 AND flag = 2) AS `vacancy` FROM articles articles WHERE (articles.flag = :c0 AND articles.class = :c1 AND EXISTS (SELECT rooms.articles_id AS `rooms__articles_id` FROM rooms rooms WHERE (rooms.flag = 2 AND EXISTS (SELECT id FROM articles WHERE id = rooms.articles_id AND flag = 2 LIMIT 1) AND rooms.status = :c0 AND rooms.articles_id IN (SELECT id FROM articles WHERE routes_id_1 = 99301 OR routes_id_2 = 99301 OR routes_id_3 = 99301 OR routes_id_4 = 99301 OR routes_id_5 = 99301) AND rooms.articles_id IN (SELECT id FROM articles WHERE stations_id_1 =  OR stations_id_2 =  OR stations_id_3 =  OR stations_id_4 =  OR stations_id_5 = ) AND articles.id = rooms.articles_id))) ORDER BY articles.created asc LIMIT 10 OFFSET 0

If you want to customize this error message, create src/Template/Error/pdo_error.ctp

toggle vendor stack frames