Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form
Warning (2): count() [function.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 `Properties`.`id` AS `Properties__id`, `Properties`.`enabled` AS `Properties__enabled`, `Properties`.`title` AS `Properties__title`, `Properties`.`main_image_path` AS `Properties__main_image_path`, `Properties`.`header_image_path` AS `Properties__header_image_path`, `Properties`.`reference` AS `Properties__reference`, `Properties`.`property_type_id` AS `Properties__property_type_id`, `Properties`.`longitude` AS `Properties__longitude`, `Properties`.`latitude` AS `Properties__latitude`, `Properties`.`zoom` AS `Properties__zoom`, `Properties`.`display_map` AS `Properties__display_map`, `Properties`.`property_pic_id` AS `Properties__property_pic_id`, `Properties`.`price` AS `Properties__price`, `Properties`.`price_xcd` AS `Properties__price_xcd`, `Properties`.`property_price_type_id` AS `Properties__property_price_type_id`, `Properties`.`duration` AS `Properties__duration`, `Properties`.`bedrooms` AS `Properties__bedrooms`, `Properties`.`bathrooms` AS `Properties__bathrooms`, `Properties`.`floors` AS `Properties__floors`, `Properties`.`rooms` AS `Properties__rooms`, `Properties`.`furnished` AS `Properties__furnished`, `Properties`.`property_status_id` AS `Properties__property_status_id`, `Properties`.`general_location_id` AS `Properties__general_location_id`, `Properties`.`district_id` AS `Properties__district_id`, `Properties`.`address_line_1` AS `Properties__address_line_1`, `Properties`.`address_line_2` AS `Properties__address_line_2`, `Properties`.`city` AS `Properties__city`, `Properties`.`state_province` AS `Properties__state_province`, `Properties`.`zip` AS `Properties__zip`, `Properties`.`country_id` AS `Properties__country_id`, `Properties`.`region` AS `Properties__region`, `Properties`.`property_offer_type_id` AS `Properties__property_offer_type_id`, `Properties`.`description` AS `Properties__description`, `Properties`.`lot_size` AS `Properties__lot_size`, `Properties`.`lot_size_unit` AS `Properties__lot_size_unit`, `Properties`.`property_size` AS `Properties__property_size`, `Properties`.`year_built` AS `Properties__year_built`, `Properties`.`property_style_id` AS `Properties__property_style_id`, `Properties`.`client_id` AS `Properties__client_id`, `Properties`.`availability_date` AS `Properties__availability_date`, `Properties`.`created` AS `Properties__created`, `Properties`.`modified` AS `Properties__modified`, `PropertyTypes`.`id` AS `PropertyTypes__id`, `PropertyTypes`.`title` AS `PropertyTypes__title`, `PropertyTypes`.`description` AS `PropertyTypes__description`, `PropertyPriceTypes`.`id` AS `PropertyPriceTypes__id`, `PropertyPriceTypes`.`title` AS `PropertyPriceTypes__title`, `PropertyPriceTypes`.`description` AS `PropertyPriceTypes__description`, `PropertyStatuses`.`id` AS `PropertyStatuses__id`, `PropertyStatuses`.`title` AS `PropertyStatuses__title`, `PropertyStatuses`.`description` AS `PropertyStatuses__description`, `PropertyStatuses`.`icon_path` AS `PropertyStatuses__icon_path`, `PropertyStatuses`.`created` AS `PropertyStatuses__created`, `PropertyStatuses`.`modified` AS `PropertyStatuses__modified`, `GeneralLocations`.`id` AS `GeneralLocations__id`, `GeneralLocations`.`title` AS `GeneralLocations__title`, `GeneralLocations`.`description` AS `GeneralLocations__description`, `Districts`.`id` AS `Districts__id`, `Districts`.`title` AS `Districts__title`, `Districts`.`description` AS `Districts__description`, `Countries`.`id` AS `Countries__id`, `Countries`.`common_name` AS `Countries__common_name`, `Countries`.`formal_name` AS `Countries__formal_name`, `Countries`.`type` AS `Countries__type`, `Countries`.`sub_type` AS `Countries__sub_type`, `Countries`.`sovereignty` AS `Countries__sovereignty`, `Countries`.`capital` AS `Countries__capital`, `Countries`.`ISO_4217_currency_code` AS `Countries__ISO_4217_currency_code`, `Countries`.`ISO_4217_currency_name` AS `Countries__ISO_4217_currency_name`, `Countries`.`ITU-T_telephone_code` AS `Countries__ITU-T_telephone_code`, `Countries`.`ISO_3166-1_2_letter_code` AS `Countries__ISO_3166-1_2_letter_code`, `Countries`.`ISO_3166-1_3_letter_code` AS `Countries__ISO_3166-1_3_letter_code`, `Countries`.`ISO_3166-1_number` AS `Countries__ISO_3166-1_number`, `Countries`.`IANA_country_code_TLD` AS `Countries__IANA_country_code_TLD`, `PropertyOfferTypes`.`id` AS `PropertyOfferTypes__id`, `PropertyOfferTypes`.`title` AS `PropertyOfferTypes__title`, `PropertyOfferTypes`.`description` AS `PropertyOfferTypes__description`, `PropertyStyles`.`id` AS `PropertyStyles__id`, `PropertyStyles`.`title` AS `PropertyStyles__title`, `PropertyStyles`.`description` AS `PropertyStyles__description`, `Clients`.`id` AS `Clients__id`, `Clients`.`first_name` AS `Clients__first_name`, `Clients`.`last_name` AS `Clients__last_name`, `Clients`.`full_name` AS `Clients__full_name`, `Clients`.`address_line_1` AS `Clients__address_line_1`, `Clients`.`address_line_2` AS `Clients__address_line_2`, `Clients`.`city` AS `Clients__city`, `Clients`.`state_province` AS `Clients__state_province`, `Clients`.`zip` AS `Clients__zip`, `Clients`.`country_id` AS `Clients__country_id`, `Clients`.`region` AS `Clients__region`, `Clients`.`phone` AS `Clients__phone`, `Clients`.`alt_phone` AS `Clients__alt_phone`, `Clients`.`fax` AS `Clients__fax`, `Clients`.`mobile` AS `Clients__mobile` FROM `re_properties` `Properties` LEFT JOIN `re_property_types` `PropertyTypes` ON `PropertyTypes`.`id` = (`Properties`.`property_type_id`) LEFT JOIN `re_property_price_types` `PropertyPriceTypes` ON `PropertyPriceTypes`.`id` = (`Properties`.`property_price_type_id`) LEFT JOIN `re_property_statuses` `PropertyStatuses` ON `PropertyStatuses`.`id` = (`Properties`.`property_status_id`) LEFT JOIN `re_general_locations` `GeneralLocations` ON `GeneralLocations`.`id` = (`Properties`.`general_location_id`) LEFT JOIN `re_districts` `Districts` ON `Districts`.`id` = (`Properties`.`district_id`) LEFT JOIN `re_countries` `Countries` ON `Countries`.`id` = (`Properties`.`country_id`) LEFT JOIN `re_property_offer_types` `PropertyOfferTypes` ON `PropertyOfferTypes`.`id` = (`Properties`.`property_offer_type_id`) LEFT JOIN `re_property_styles` `PropertyStyles` ON `PropertyStyles`.`id` = (`Properties`.`property_style_id`) LEFT JOIN `re_clients` `Clients` ON `Clients`.`id` = (`Properties`.`client_id`) WHERE `Properties`.`id` = :c0' $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' => [ 'Properties__id' => 'integer', 'Properties.id' => 'integer', 'id' => 'integer', 'Properties__enabled' => 'boolean', 'Properties.enabled' => 'boolean', 'enabled' => 'boolean', 'Properties__title' => 'string', 'Properties.title' => 'string', 'title' => 'string', 'Properties__main_image_path' => 'string', 'Properties.main_image_path' => 'string', 'main_image_path' => 'string', 'Properties__header_image_path' => 'string', 'Properties.header_image_path' => 'string', 'header_image_path' => 'string', 'Properties__reference' => 'string', 'Properties.reference' => 'string', 'reference' => 'string', 'Properties__property_type_id' => 'integer', 'Properties.property_type_id' => 'integer', 'property_type_id' => 'integer', 'Properties__longitude' => 'string', 'Properties.longitude' => 'string', 'longitude' => 'string', 'Properties__latitude' => 'string', 'Properties.latitude' => 'string', 'latitude' => 'string', 'Properties__zoom' => 'integer', 'Properties.zoom' => 'integer', 'zoom' => 'integer', 'Properties__display_map' => 'boolean', 'Properties.display_map' => 'boolean', 'display_map' => 'boolean', 'Properties__property_pic_id' => 'integer', 'Properties.property_pic_id' => 'integer', 'property_pic_id' => 'integer', 'Properties__price' => 'decimal', 'Properties.price' => 'decimal', 'price' => 'decimal', 'Properties__price_xcd' => 'decimal', 'Properties.price_xcd' => 'decimal', 'price_xcd' => 'decimal', 'Properties__property_price_type_id' => 'integer', 'Properties.property_price_type_id' => 'integer', 'property_price_type_id' => 'integer', 'Properties__duration' => 'string', 'Properties.duration' => 'string', 'duration' => 'string', 'Properties__bedrooms' => 'integer', 'Properties.bedrooms' => 'integer', 'bedrooms' => 'integer', 'Properties__bathrooms' => 'float', 'Properties.bathrooms' => 'float', 'bathrooms' => 'float', 'Properties__floors' => 'integer', 'Properties.floors' => 'integer', 'floors' => 'integer', 'Properties__rooms' => 'integer', 'Properties.rooms' => 'integer', 'rooms' => 'integer', 'Properties__furnished' => 'integer', 'Properties.furnished' => 'integer', 'furnished' => 'integer', 'Properties__property_status_id' => 'integer', 'Properties.property_status_id' => 'integer', 'property_status_id' => 'integer', 'Properties__general_location_id' => 'integer', 'Properties.general_location_id' => 'integer', 'general_location_id' => 'integer', 'Properties__district_id' => 'integer', 'Properties.district_id' => 'integer', 'district_id' => 'integer', 'Properties__address_line_1' => 'string', 'Properties.address_line_1' => 'string', 'address_line_1' => 'string', 'Properties__address_line_2' => 'string', 'Properties.address_line_2' => 'string', 'address_line_2' => 'string', 'Properties__city' => 'string', 'Properties.city' => 'string', 'city' => 'string', 'Properties__state_province' => 'string', 'Properties.state_province' => 'string', 'state_province' => 'string', 'Properties__zip' => 'string', 'Properties.zip' => 'string', 'zip' => 'string', 'Properties__country_id' => 'integer', 'Properties.country_id' => 'integer', 'country_id' => 'integer', 'Properties__region' => 'string', 'Properties.region' => 'string', 'region' => 'string', 'Properties__property_offer_type_id' => 'integer', 'Properties.property_offer_type_id' => 'integer', 'property_offer_type_id' => 'integer', 'Properties__description' => 'text', 'Properties.description' => 'text', 'description' => 'text', 'Properties__lot_size' => 'float', 'Properties.lot_size' => 'float', 'lot_size' => 'float', 'Properties__lot_size_unit' => 'string', 'Properties.lot_size_unit' => 'string', 'lot_size_unit' => 'string', 'Properties__property_size' => 'integer', 'Properties.property_size' => 'integer', 'property_size' => 'integer', 'Properties__year_built' => 'text', 'Properties.year_built' => 'text', 'year_built' => 'text', 'Properties__property_style_id' => 'integer', 'Properties.property_style_id' => 'integer', 'property_style_id' => 'integer', 'Properties__client_id' => 'integer', 'Properties.client_id' => 'integer', 'client_id' => 'integer', 'Properties__availability_date' => 'date', 'Properties.availability_date' => 'date', 'availability_date' => 'date', 'Properties__created' => 'date', 'Properties.created' => 'date', 'created' => 'date', 'Properties__modified' => 'date', 'Properties.modified' => 'date', 'modified' => 'date', 'PropertyTypes__id' => 'integer', 'PropertyTypes.id' => 'integer', 'PropertyTypes__title' => 'string', 'PropertyTypes.title' => 'string', 'PropertyTypes__description' => 'text', 'PropertyTypes.description' => 'text', 'PropertyPriceTypes__id' => 'integer', 'PropertyPriceTypes.id' => 'integer', 'PropertyPriceTypes__title' => 'string', 'PropertyPriceTypes.title' => 'string', 'PropertyPriceTypes__description' => 'text', 'PropertyPriceTypes.description' => 'text', 'PropertyStatuses__id' => 'integer', 'PropertyStatuses.id' => 'integer', 'PropertyStatuses__title' => 'string', 'PropertyStatuses.title' => 'string', 'PropertyStatuses__description' => 'text', 'PropertyStatuses.description' => 'text', 'PropertyStatuses__icon_path' => 'string', 'PropertyStatuses.icon_path' => 'string', 'icon_path' => 'string', 'PropertyStatuses__created' => 'datetime', 'PropertyStatuses.created' => 'datetime', 'PropertyStatuses__modified' => 'datetime', 'PropertyStatuses.modified' => 'datetime', 'GeneralLocations__id' => 'integer', 'GeneralLocations.id' => 'integer', 'GeneralLocations__title' => 'string', 'GeneralLocations.title' => 'string', 'GeneralLocations__description' => 'text', 'GeneralLocations.description' => 'text', 'Districts__id' => 'integer', 'Districts.id' => 'integer', 'Districts__title' => 'string', 'Districts.title' => 'string', 'Districts__description' => 'text', 'Districts.description' => 'text', 'Countries__id' => 'integer', 'Countries.id' => 'integer', 'Countries__common_name' => 'string', 'Countries.common_name' => 'string', 'common_name' => 'string', 'Countries__formal_name' => 'string', 'Countries.formal_name' => 'string', 'formal_name' => 'string', 'Countries__type' => 'string', 'Countries.type' => 'string', 'type' => 'string', 'Countries__sub_type' => 'string', 'Countries.sub_type' => 'string', 'sub_type' => 'string', 'Countries__sovereignty' => 'string', 'Countries.sovereignty' => 'string', 'sovereignty' => 'string', 'Countries__capital' => 'string', 'Countries.capital' => 'string', 'capital' => 'string', 'Countries__ISO_4217_currency_code' => 'string', 'Countries.ISO_4217_currency_code' => 'string', 'ISO_4217_currency_code' => 'string', 'Countries__ISO_4217_currency_name' => 'string', 'Countries.ISO_4217_currency_name' => 'string', 'ISO_4217_currency_name' => 'string', 'Countries__ITU-T_telephone_code' => 'string', 'Countries.ITU-T_telephone_code' => 'string', 'ITU-T_telephone_code' => 'string', 'Countries__ISO_3166-1_2_letter_code' => 'string', 'Countries.ISO_3166-1_2_letter_code' => 'string', 'ISO_3166-1_2_letter_code' => 'string', 'Countries__ISO_3166-1_3_letter_code' => 'string', 'Countries.ISO_3166-1_3_letter_code' => 'string', 'ISO_3166-1_3_letter_code' => 'string', 'Countries__ISO_3166-1_number' => 'string', 'Countries.ISO_3166-1_number' => 'string', 'ISO_3166-1_number' => 'string', 'Countries__IANA_country_code_TLD' => 'string', 'Countries.IANA_country_code_TLD' => 'string', 'IANA_country_code_TLD' => 'string', 'PropertyOfferTypes__id' => 'integer', 'PropertyOfferTypes.id' => 'integer', 'PropertyOfferTypes__title' => 'string', 'PropertyOfferTypes.title' => 'string', 'PropertyOfferTypes__description' => 'text', 'PropertyOfferTypes.description' => 'text', 'PropertyStyles__id' => 'integer', 'PropertyStyles.id' => 'integer', 'PropertyStyles__title' => 'string', 'PropertyStyles.title' => 'string', 'PropertyStyles__description' => 'text', 'PropertyStyles.description' => 'text', 'Clients__id' => 'integer', 'Clients.id' => 'integer', 'Clients__first_name' => 'string', 'Clients.first_name' => 'string', 'first_name' => 'string', 'Clients__last_name' => 'string', 'Clients.last_name' => 'string', 'last_name' => 'string', 'Clients__full_name' => 'string', 'Clients.full_name' => 'string', 'full_name' => 'string', 'Clients__address_line_1' => 'string', 'Clients.address_line_1' => 'string', 'Clients__address_line_2' => 'string', 'Clients.address_line_2' => 'string', 'Clients__city' => 'string', 'Clients.city' => 'string', 'Clients__state_province' => 'string', 'Clients.state_province' => 'string', 'Clients__zip' => 'string', 'Clients.zip' => 'string', 'Clients__country_id' => 'integer', 'Clients.country_id' => 'integer', 'Clients__region' => 'string', 'Clients.region' => 'string', 'Clients__phone' => 'string', 'Clients.phone' => 'string', 'phone' => 'string', 'Clients__alt_phone' => 'string', 'Clients.alt_phone' => 'string', 'alt_phone' => 'string', 'Clients__fax' => 'string', 'Clients.fax' => 'string', 'fax' => 'string', 'Clients__mobile' => 'string', 'Clients.mobile' => 'string', 'mobile' => 'string', 'PropertyFeatures__id' => 'integer', 'PropertyFeatures.id' => 'integer', 'PropertyFeatures__title' => 'string', 'PropertyFeatures.title' => 'string', 'PropertyFeatures__description' => 'text', 'PropertyFeatures.description' => 'text', 'PropertyPics__id' => 'integer', 'PropertyPics.id' => 'integer', 'PropertyPics__title' => 'string', 'PropertyPics.title' => 'string', 'PropertyPics__sub_title' => 'string', 'PropertyPics.sub_title' => 'string', 'sub_title' => 'string', 'PropertyPics__description' => 'text', 'PropertyPics.description' => 'text', 'PropertyPics__order' => 'integer', 'PropertyPics.order' => 'integer', 'order' => 'integer', 'PropertyPics__url' => 'string', 'PropertyPics.url' => 'string', 'url' => 'string', 'PropertyPics__url_title' => 'string', 'PropertyPics.url_title' => 'string', 'url_title' => 'string', 'PropertyPics__path' => 'text', 'PropertyPics.path' => 'text', 'path' => 'text', 'PropertyPics__property_id' => 'integer', 'PropertyPics.property_id' => 'integer', 'property_id' => 'integer', 'PropertyPics__filename' => 'string', 'PropertyPics.filename' => 'string', 'filename' => 'string', 'PropertyPics__webpath' => 'string', 'PropertyPics.webpath' => 'string', 'webpath' => 'string', 'PropertyPics__size' => 'integer', 'PropertyPics.size' => 'integer', 'size' => 'integer', 'PropertyPics__small' => 'string', 'PropertyPics.small' => 'string', 'small' => 'string', 'PropertyPics__large' => 'string', 'PropertyPics.large' => 'string', 'large' => 'string', 'PropertyPics__original' => 'string', 'PropertyPics.original' => 'string', 'original' => 'string', 'PropertyPics__created' => 'datetime', 'PropertyPics.created' => 'datetime', 'PropertyPics__modified' => 'datetime', 'PropertyPics.modified' => 'datetime' ], 'decorators' => (int) 0, 'executed' => false, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [ 'PropertyTypes' => [[maximum depth reached]], 'PropertyPriceTypes' => [[maximum depth reached]], 'PropertyStatuses' => [[maximum depth reached]], 'GeneralLocations' => [[maximum depth reached]], 'Districts' => [[maximum depth reached]], 'Countries' => [[maximum depth reached]], 'PropertyOfferTypes' => [[maximum depth reached]], 'PropertyStyles' => [[maximum depth reached]], 'Clients' => [[maximum depth reached]], 'PropertyFeatures' => [[maximum depth reached]], 'PropertyPics' => [[maximum depth reached]] ], 'matching' => [], 'extraOptions' => [], 'repository' => object(RealEstate\Model\Table\PropertiesTable) {} } $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 256 Cake\Database\QueryCompiler::compile() - CORE/src/Database/QueryCompiler.php, line 99 Cake\Database\Driver::compileQuery() - CORE/src/Database/Driver.php, line 333 Cake\Database\Connection::compileQuery() - CORE/src/Database/Connection.php, line 262 Cake\Database\Query::sql() - CORE/src/Database/Query.php, line 227 Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 937 Cake\Database\Driver\Mysql::prepare() - CORE/src/Database/Driver/Mysql.php, line 136 Cake\Database\Connection::prepare() - CORE/src/Database/Connection.php, line 221 Cake\Database\Connection::run() - CORE/src/Database/Connection.php, line 274 Cake\Database\Query::execute() - CORE/src/Database/Query.php, line 189 Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 958 Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276 Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 906 Cake\ORM\Query::first() - CORE/src/Datasource/QueryTrait.php, line 404 Cake\ORM\Query::firstOrFail() - CORE/src/Datasource/QueryTrait.php, line 415
Warning (2): count() [function.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 = 'order' $sql = 'SELECT `Properties`.`id` AS `Properties__id`, `Properties`.`enabled` AS `Properties__enabled`, `Properties`.`title` AS `Properties__title`, `Properties`.`main_image_path` AS `Properties__main_image_path`, `Properties`.`header_image_path` AS `Properties__header_image_path`, `Properties`.`reference` AS `Properties__reference`, `Properties`.`property_type_id` AS `Properties__property_type_id`, `Properties`.`longitude` AS `Properties__longitude`, `Properties`.`latitude` AS `Properties__latitude`, `Properties`.`zoom` AS `Properties__zoom`, `Properties`.`display_map` AS `Properties__display_map`, `Properties`.`property_pic_id` AS `Properties__property_pic_id`, `Properties`.`price` AS `Properties__price`, `Properties`.`price_xcd` AS `Properties__price_xcd`, `Properties`.`property_price_type_id` AS `Properties__property_price_type_id`, `Properties`.`duration` AS `Properties__duration`, `Properties`.`bedrooms` AS `Properties__bedrooms`, `Properties`.`bathrooms` AS `Properties__bathrooms`, `Properties`.`floors` AS `Properties__floors`, `Properties`.`rooms` AS `Properties__rooms`, `Properties`.`furnished` AS `Properties__furnished`, `Properties`.`property_status_id` AS `Properties__property_status_id`, `Properties`.`general_location_id` AS `Properties__general_location_id`, `Properties`.`district_id` AS `Properties__district_id`, `Properties`.`address_line_1` AS `Properties__address_line_1`, `Properties`.`address_line_2` AS `Properties__address_line_2`, `Properties`.`city` AS `Properties__city`, `Properties`.`state_province` AS `Properties__state_province`, `Properties`.`zip` AS `Properties__zip`, `Properties`.`country_id` AS `Properties__country_id`, `Properties`.`region` AS `Properties__region`, `Properties`.`property_offer_type_id` AS `Properties__property_offer_type_id`, `Properties`.`description` AS `Properties__description`, `Properties`.`lot_size` AS `Properties__lot_size`, `Properties`.`lot_size_unit` AS `Properties__lot_size_unit`, `Properties`.`property_size` AS `Properties__property_size`, `Properties`.`year_built` AS `Properties__year_built`, `Properties`.`property_style_id` AS `Properties__property_style_id`, `Properties`.`client_id` AS `Properties__client_id`, `Properties`.`availability_date` AS `Properties__availability_date`, `Properties`.`created` AS `Properties__created`, `Properties`.`modified` AS `Properties__modified`, `PropertyTypes`.`id` AS `PropertyTypes__id`, `PropertyTypes`.`title` AS `PropertyTypes__title`, `PropertyTypes`.`description` AS `PropertyTypes__description`, `PropertyPriceTypes`.`id` AS `PropertyPriceTypes__id`, `PropertyPriceTypes`.`title` AS `PropertyPriceTypes__title`, `PropertyPriceTypes`.`description` AS `PropertyPriceTypes__description`, `PropertyStatuses`.`id` AS `PropertyStatuses__id`, `PropertyStatuses`.`title` AS `PropertyStatuses__title`, `PropertyStatuses`.`description` AS `PropertyStatuses__description`, `PropertyStatuses`.`icon_path` AS `PropertyStatuses__icon_path`, `PropertyStatuses`.`created` AS `PropertyStatuses__created`, `PropertyStatuses`.`modified` AS `PropertyStatuses__modified`, `GeneralLocations`.`id` AS `GeneralLocations__id`, `GeneralLocations`.`title` AS `GeneralLocations__title`, `GeneralLocations`.`description` AS `GeneralLocations__description`, `Districts`.`id` AS `Districts__id`, `Districts`.`title` AS `Districts__title`, `Districts`.`description` AS `Districts__description`, `Countries`.`id` AS `Countries__id`, `Countries`.`common_name` AS `Countries__common_name`, `Countries`.`formal_name` AS `Countries__formal_name`, `Countries`.`type` AS `Countries__type`, `Countries`.`sub_type` AS `Countries__sub_type`, `Countries`.`sovereignty` AS `Countries__sovereignty`, `Countries`.`capital` AS `Countries__capital`, `Countries`.`ISO_4217_currency_code` AS `Countries__ISO_4217_currency_code`, `Countries`.`ISO_4217_currency_name` AS `Countries__ISO_4217_currency_name`, `Countries`.`ITU-T_telephone_code` AS `Countries__ITU-T_telephone_code`, `Countries`.`ISO_3166-1_2_letter_code` AS `Countries__ISO_3166-1_2_letter_code`, `Countries`.`ISO_3166-1_3_letter_code` AS `Countries__ISO_3166-1_3_letter_code`, `Countries`.`ISO_3166-1_number` AS `Countries__ISO_3166-1_number`, `Countries`.`IANA_country_code_TLD` AS `Countries__IANA_country_code_TLD`, `PropertyOfferTypes`.`id` AS `PropertyOfferTypes__id`, `PropertyOfferTypes`.`title` AS `PropertyOfferTypes__title`, `PropertyOfferTypes`.`description` AS `PropertyOfferTypes__description`, `PropertyStyles`.`id` AS `PropertyStyles__id`, `PropertyStyles`.`title` AS `PropertyStyles__title`, `PropertyStyles`.`description` AS `PropertyStyles__description`, `Clients`.`id` AS `Clients__id`, `Clients`.`first_name` AS `Clients__first_name`, `Clients`.`last_name` AS `Clients__last_name`, `Clients`.`full_name` AS `Clients__full_name`, `Clients`.`address_line_1` AS `Clients__address_line_1`, `Clients`.`address_line_2` AS `Clients__address_line_2`, `Clients`.`city` AS `Clients__city`, `Clients`.`state_province` AS `Clients__state_province`, `Clients`.`zip` AS `Clients__zip`, `Clients`.`country_id` AS `Clients__country_id`, `Clients`.`region` AS `Clients__region`, `Clients`.`phone` AS `Clients__phone`, `Clients`.`alt_phone` AS `Clients__alt_phone`, `Clients`.`fax` AS `Clients__fax`, `Clients`.`mobile` AS `Clients__mobile` FROM `re_properties` `Properties` LEFT JOIN `re_property_types` `PropertyTypes` ON `PropertyTypes`.`id` = (`Properties`.`property_type_id`) LEFT JOIN `re_property_price_types` `PropertyPriceTypes` ON `PropertyPriceTypes`.`id` = (`Properties`.`property_price_type_id`) LEFT JOIN `re_property_statuses` `PropertyStatuses` ON `PropertyStatuses`.`id` = (`Properties`.`property_status_id`) LEFT JOIN `re_general_locations` `GeneralLocations` ON `GeneralLocations`.`id` = (`Properties`.`general_location_id`) LEFT JOIN `re_districts` `Districts` ON `Districts`.`id` = (`Properties`.`district_id`) LEFT JOIN `re_countries` `Countries` ON `Countries`.`id` = (`Properties`.`country_id`) LEFT JOIN `re_property_offer_types` `PropertyOfferTypes` ON `PropertyOfferTypes`.`id` = (`Properties`.`property_offer_type_id`) LEFT JOIN `re_property_styles` `PropertyStyles` ON `PropertyStyles`.`id` = (`Properties`.`property_style_id`) LEFT JOIN `re_clients` `Clients` ON `Clients`.`id` = (`Properties`.`client_id`) WHERE `Properties`.`id` = :c0' $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' => [ 'Properties__id' => 'integer', 'Properties.id' => 'integer', 'id' => 'integer', 'Properties__enabled' => 'boolean', 'Properties.enabled' => 'boolean', 'enabled' => 'boolean', 'Properties__title' => 'string', 'Properties.title' => 'string', 'title' => 'string', 'Properties__main_image_path' => 'string', 'Properties.main_image_path' => 'string', 'main_image_path' => 'string', 'Properties__header_image_path' => 'string', 'Properties.header_image_path' => 'string', 'header_image_path' => 'string', 'Properties__reference' => 'string', 'Properties.reference' => 'string', 'reference' => 'string', 'Properties__property_type_id' => 'integer', 'Properties.property_type_id' => 'integer', 'property_type_id' => 'integer', 'Properties__longitude' => 'string', 'Properties.longitude' => 'string', 'longitude' => 'string', 'Properties__latitude' => 'string', 'Properties.latitude' => 'string', 'latitude' => 'string', 'Properties__zoom' => 'integer', 'Properties.zoom' => 'integer', 'zoom' => 'integer', 'Properties__display_map' => 'boolean', 'Properties.display_map' => 'boolean', 'display_map' => 'boolean', 'Properties__property_pic_id' => 'integer', 'Properties.property_pic_id' => 'integer', 'property_pic_id' => 'integer', 'Properties__price' => 'decimal', 'Properties.price' => 'decimal', 'price' => 'decimal', 'Properties__price_xcd' => 'decimal', 'Properties.price_xcd' => 'decimal', 'price_xcd' => 'decimal', 'Properties__property_price_type_id' => 'integer', 'Properties.property_price_type_id' => 'integer', 'property_price_type_id' => 'integer', 'Properties__duration' => 'string', 'Properties.duration' => 'string', 'duration' => 'string', 'Properties__bedrooms' => 'integer', 'Properties.bedrooms' => 'integer', 'bedrooms' => 'integer', 'Properties__bathrooms' => 'float', 'Properties.bathrooms' => 'float', 'bathrooms' => 'float', 'Properties__floors' => 'integer', 'Properties.floors' => 'integer', 'floors' => 'integer', 'Properties__rooms' => 'integer', 'Properties.rooms' => 'integer', 'rooms' => 'integer', 'Properties__furnished' => 'integer', 'Properties.furnished' => 'integer', 'furnished' => 'integer', 'Properties__property_status_id' => 'integer', 'Properties.property_status_id' => 'integer', 'property_status_id' => 'integer', 'Properties__general_location_id' => 'integer', 'Properties.general_location_id' => 'integer', 'general_location_id' => 'integer', 'Properties__district_id' => 'integer', 'Properties.district_id' => 'integer', 'district_id' => 'integer', 'Properties__address_line_1' => 'string', 'Properties.address_line_1' => 'string', 'address_line_1' => 'string', 'Properties__address_line_2' => 'string', 'Properties.address_line_2' => 'string', 'address_line_2' => 'string', 'Properties__city' => 'string', 'Properties.city' => 'string', 'city' => 'string', 'Properties__state_province' => 'string', 'Properties.state_province' => 'string', 'state_province' => 'string', 'Properties__zip' => 'string', 'Properties.zip' => 'string', 'zip' => 'string', 'Properties__country_id' => 'integer', 'Properties.country_id' => 'integer', 'country_id' => 'integer', 'Properties__region' => 'string', 'Properties.region' => 'string', 'region' => 'string', 'Properties__property_offer_type_id' => 'integer', 'Properties.property_offer_type_id' => 'integer', 'property_offer_type_id' => 'integer', 'Properties__description' => 'text', 'Properties.description' => 'text', 'description' => 'text', 'Properties__lot_size' => 'float', 'Properties.lot_size' => 'float', 'lot_size' => 'float', 'Properties__lot_size_unit' => 'string', 'Properties.lot_size_unit' => 'string', 'lot_size_unit' => 'string', 'Properties__property_size' => 'integer', 'Properties.property_size' => 'integer', 'property_size' => 'integer', 'Properties__year_built' => 'text', 'Properties.year_built' => 'text', 'year_built' => 'text', 'Properties__property_style_id' => 'integer', 'Properties.property_style_id' => 'integer', 'property_style_id' => 'integer', 'Properties__client_id' => 'integer', 'Properties.client_id' => 'integer', 'client_id' => 'integer', 'Properties__availability_date' => 'date', 'Properties.availability_date' => 'date', 'availability_date' => 'date', 'Properties__created' => 'date', 'Properties.created' => 'date', 'created' => 'date', 'Properties__modified' => 'date', 'Properties.modified' => 'date', 'modified' => 'date', 'PropertyTypes__id' => 'integer', 'PropertyTypes.id' => 'integer', 'PropertyTypes__title' => 'string', 'PropertyTypes.title' => 'string', 'PropertyTypes__description' => 'text', 'PropertyTypes.description' => 'text', 'PropertyPriceTypes__id' => 'integer', 'PropertyPriceTypes.id' => 'integer', 'PropertyPriceTypes__title' => 'string', 'PropertyPriceTypes.title' => 'string', 'PropertyPriceTypes__description' => 'text', 'PropertyPriceTypes.description' => 'text', 'PropertyStatuses__id' => 'integer', 'PropertyStatuses.id' => 'integer', 'PropertyStatuses__title' => 'string', 'PropertyStatuses.title' => 'string', 'PropertyStatuses__description' => 'text', 'PropertyStatuses.description' => 'text', 'PropertyStatuses__icon_path' => 'string', 'PropertyStatuses.icon_path' => 'string', 'icon_path' => 'string', 'PropertyStatuses__created' => 'datetime', 'PropertyStatuses.created' => 'datetime', 'PropertyStatuses__modified' => 'datetime', 'PropertyStatuses.modified' => 'datetime', 'GeneralLocations__id' => 'integer', 'GeneralLocations.id' => 'integer', 'GeneralLocations__title' => 'string', 'GeneralLocations.title' => 'string', 'GeneralLocations__description' => 'text', 'GeneralLocations.description' => 'text', 'Districts__id' => 'integer', 'Districts.id' => 'integer', 'Districts__title' => 'string', 'Districts.title' => 'string', 'Districts__description' => 'text', 'Districts.description' => 'text', 'Countries__id' => 'integer', 'Countries.id' => 'integer', 'Countries__common_name' => 'string', 'Countries.common_name' => 'string', 'common_name' => 'string', 'Countries__formal_name' => 'string', 'Countries.formal_name' => 'string', 'formal_name' => 'string', 'Countries__type' => 'string', 'Countries.type' => 'string', 'type' => 'string', 'Countries__sub_type' => 'string', 'Countries.sub_type' => 'string', 'sub_type' => 'string', 'Countries__sovereignty' => 'string', 'Countries.sovereignty' => 'string', 'sovereignty' => 'string', 'Countries__capital' => 'string', 'Countries.capital' => 'string', 'capital' => 'string', 'Countries__ISO_4217_currency_code' => 'string', 'Countries.ISO_4217_currency_code' => 'string', 'ISO_4217_currency_code' => 'string', 'Countries__ISO_4217_currency_name' => 'string', 'Countries.ISO_4217_currency_name' => 'string', 'ISO_4217_currency_name' => 'string', 'Countries__ITU-T_telephone_code' => 'string', 'Countries.ITU-T_telephone_code' => 'string', 'ITU-T_telephone_code' => 'string', 'Countries__ISO_3166-1_2_letter_code' => 'string', 'Countries.ISO_3166-1_2_letter_code' => 'string', 'ISO_3166-1_2_letter_code' => 'string', 'Countries__ISO_3166-1_3_letter_code' => 'string', 'Countries.ISO_3166-1_3_letter_code' => 'string', 'ISO_3166-1_3_letter_code' => 'string', 'Countries__ISO_3166-1_number' => 'string', 'Countries.ISO_3166-1_number' => 'string', 'ISO_3166-1_number' => 'string', 'Countries__IANA_country_code_TLD' => 'string', 'Countries.IANA_country_code_TLD' => 'string', 'IANA_country_code_TLD' => 'string', 'PropertyOfferTypes__id' => 'integer', 'PropertyOfferTypes.id' => 'integer', 'PropertyOfferTypes__title' => 'string', 'PropertyOfferTypes.title' => 'string', 'PropertyOfferTypes__description' => 'text', 'PropertyOfferTypes.description' => 'text', 'PropertyStyles__id' => 'integer', 'PropertyStyles.id' => 'integer', 'PropertyStyles__title' => 'string', 'PropertyStyles.title' => 'string', 'PropertyStyles__description' => 'text', 'PropertyStyles.description' => 'text', 'Clients__id' => 'integer', 'Clients.id' => 'integer', 'Clients__first_name' => 'string', 'Clients.first_name' => 'string', 'first_name' => 'string', 'Clients__last_name' => 'string', 'Clients.last_name' => 'string', 'last_name' => 'string', 'Clients__full_name' => 'string', 'Clients.full_name' => 'string', 'full_name' => 'string', 'Clients__address_line_1' => 'string', 'Clients.address_line_1' => 'string', 'Clients__address_line_2' => 'string', 'Clients.address_line_2' => 'string', 'Clients__city' => 'string', 'Clients.city' => 'string', 'Clients__state_province' => 'string', 'Clients.state_province' => 'string', 'Clients__zip' => 'string', 'Clients.zip' => 'string', 'Clients__country_id' => 'integer', 'Clients.country_id' => 'integer', 'Clients__region' => 'string', 'Clients.region' => 'string', 'Clients__phone' => 'string', 'Clients.phone' => 'string', 'phone' => 'string', 'Clients__alt_phone' => 'string', 'Clients.alt_phone' => 'string', 'alt_phone' => 'string', 'Clients__fax' => 'string', 'Clients.fax' => 'string', 'fax' => 'string', 'Clients__mobile' => 'string', 'Clients.mobile' => 'string', 'mobile' => 'string', 'PropertyFeatures__id' => 'integer', 'PropertyFeatures.id' => 'integer', 'PropertyFeatures__title' => 'string', 'PropertyFeatures.title' => 'string', 'PropertyFeatures__description' => 'text', 'PropertyFeatures.description' => 'text', 'PropertyPics__id' => 'integer', 'PropertyPics.id' => 'integer', 'PropertyPics__title' => 'string', 'PropertyPics.title' => 'string', 'PropertyPics__sub_title' => 'string', 'PropertyPics.sub_title' => 'string', 'sub_title' => 'string', 'PropertyPics__description' => 'text', 'PropertyPics.description' => 'text', 'PropertyPics__order' => 'integer', 'PropertyPics.order' => 'integer', 'order' => 'integer', 'PropertyPics__url' => 'string', 'PropertyPics.url' => 'string', 'url' => 'string', 'PropertyPics__url_title' => 'string', 'PropertyPics.url_title' => 'string', 'url_title' => 'string', 'PropertyPics__path' => 'text', 'PropertyPics.path' => 'text', 'path' => 'text', 'PropertyPics__property_id' => 'integer', 'PropertyPics.property_id' => 'integer', 'property_id' => 'integer', 'PropertyPics__filename' => 'string', 'PropertyPics.filename' => 'string', 'filename' => 'string', 'PropertyPics__webpath' => 'string', 'PropertyPics.webpath' => 'string', 'webpath' => 'string', 'PropertyPics__size' => 'integer', 'PropertyPics.size' => 'integer', 'size' => 'integer', 'PropertyPics__small' => 'string', 'PropertyPics.small' => 'string', 'small' => 'string', 'PropertyPics__large' => 'string', 'PropertyPics.large' => 'string', 'large' => 'string', 'PropertyPics__original' => 'string', 'PropertyPics.original' => 'string', 'original' => 'string', 'PropertyPics__created' => 'datetime', 'PropertyPics.created' => 'datetime', 'PropertyPics__modified' => 'datetime', 'PropertyPics.modified' => 'datetime' ], 'decorators' => (int) 0, 'executed' => false, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [ 'PropertyTypes' => [[maximum depth reached]], 'PropertyPriceTypes' => [[maximum depth reached]], 'PropertyStatuses' => [[maximum depth reached]], 'GeneralLocations' => [[maximum depth reached]], 'Districts' => [[maximum depth reached]], 'Countries' => [[maximum depth reached]], 'PropertyOfferTypes' => [[maximum depth reached]], 'PropertyStyles' => [[maximum depth reached]], 'Clients' => [[maximum depth reached]], 'PropertyFeatures' => [[maximum depth reached]], 'PropertyPics' => [[maximum depth reached]] ], 'matching' => [], 'extraOptions' => [], 'repository' => object(RealEstate\Model\Table\PropertiesTable) {} } $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 256 Cake\Database\QueryCompiler::compile() - CORE/src/Database/QueryCompiler.php, line 99 Cake\Database\Driver::compileQuery() - CORE/src/Database/Driver.php, line 333 Cake\Database\Connection::compileQuery() - CORE/src/Database/Connection.php, line 262 Cake\Database\Query::sql() - CORE/src/Database/Query.php, line 227 Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 937 Cake\Database\Driver\Mysql::prepare() - CORE/src/Database/Driver/Mysql.php, line 136 Cake\Database\Connection::prepare() - CORE/src/Database/Connection.php, line 221 Cake\Database\Connection::run() - CORE/src/Database/Connection.php, line 274 Cake\Database\Query::execute() - CORE/src/Database/Query.php, line 189 Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 958 Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276 Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 906 Cake\ORM\Query::first() - CORE/src/Datasource/QueryTrait.php, line 404 Cake\ORM\Query::firstOrFail() - CORE/src/Datasource/QueryTrait.php, line 415
Warning (2): count() [function.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 = (int) 1 $name = 'limit' $sql = 'SELECT `Properties`.`id` AS `Properties__id`, `Properties`.`enabled` AS `Properties__enabled`, `Properties`.`title` AS `Properties__title`, `Properties`.`main_image_path` AS `Properties__main_image_path`, `Properties`.`header_image_path` AS `Properties__header_image_path`, `Properties`.`reference` AS `Properties__reference`, `Properties`.`property_type_id` AS `Properties__property_type_id`, `Properties`.`longitude` AS `Properties__longitude`, `Properties`.`latitude` AS `Properties__latitude`, `Properties`.`zoom` AS `Properties__zoom`, `Properties`.`display_map` AS `Properties__display_map`, `Properties`.`property_pic_id` AS `Properties__property_pic_id`, `Properties`.`price` AS `Properties__price`, `Properties`.`price_xcd` AS `Properties__price_xcd`, `Properties`.`property_price_type_id` AS `Properties__property_price_type_id`, `Properties`.`duration` AS `Properties__duration`, `Properties`.`bedrooms` AS `Properties__bedrooms`, `Properties`.`bathrooms` AS `Properties__bathrooms`, `Properties`.`floors` AS `Properties__floors`, `Properties`.`rooms` AS `Properties__rooms`, `Properties`.`furnished` AS `Properties__furnished`, `Properties`.`property_status_id` AS `Properties__property_status_id`, `Properties`.`general_location_id` AS `Properties__general_location_id`, `Properties`.`district_id` AS `Properties__district_id`, `Properties`.`address_line_1` AS `Properties__address_line_1`, `Properties`.`address_line_2` AS `Properties__address_line_2`, `Properties`.`city` AS `Properties__city`, `Properties`.`state_province` AS `Properties__state_province`, `Properties`.`zip` AS `Properties__zip`, `Properties`.`country_id` AS `Properties__country_id`, `Properties`.`region` AS `Properties__region`, `Properties`.`property_offer_type_id` AS `Properties__property_offer_type_id`, `Properties`.`description` AS `Properties__description`, `Properties`.`lot_size` AS `Properties__lot_size`, `Properties`.`lot_size_unit` AS `Properties__lot_size_unit`, `Properties`.`property_size` AS `Properties__property_size`, `Properties`.`year_built` AS `Properties__year_built`, `Properties`.`property_style_id` AS `Properties__property_style_id`, `Properties`.`client_id` AS `Properties__client_id`, `Properties`.`availability_date` AS `Properties__availability_date`, `Properties`.`created` AS `Properties__created`, `Properties`.`modified` AS `Properties__modified`, `PropertyTypes`.`id` AS `PropertyTypes__id`, `PropertyTypes`.`title` AS `PropertyTypes__title`, `PropertyTypes`.`description` AS `PropertyTypes__description`, `PropertyPriceTypes`.`id` AS `PropertyPriceTypes__id`, `PropertyPriceTypes`.`title` AS `PropertyPriceTypes__title`, `PropertyPriceTypes`.`description` AS `PropertyPriceTypes__description`, `PropertyStatuses`.`id` AS `PropertyStatuses__id`, `PropertyStatuses`.`title` AS `PropertyStatuses__title`, `PropertyStatuses`.`description` AS `PropertyStatuses__description`, `PropertyStatuses`.`icon_path` AS `PropertyStatuses__icon_path`, `PropertyStatuses`.`created` AS `PropertyStatuses__created`, `PropertyStatuses`.`modified` AS `PropertyStatuses__modified`, `GeneralLocations`.`id` AS `GeneralLocations__id`, `GeneralLocations`.`title` AS `GeneralLocations__title`, `GeneralLocations`.`description` AS `GeneralLocations__description`, `Districts`.`id` AS `Districts__id`, `Districts`.`title` AS `Districts__title`, `Districts`.`description` AS `Districts__description`, `Countries`.`id` AS `Countries__id`, `Countries`.`common_name` AS `Countries__common_name`, `Countries`.`formal_name` AS `Countries__formal_name`, `Countries`.`type` AS `Countries__type`, `Countries`.`sub_type` AS `Countries__sub_type`, `Countries`.`sovereignty` AS `Countries__sovereignty`, `Countries`.`capital` AS `Countries__capital`, `Countries`.`ISO_4217_currency_code` AS `Countries__ISO_4217_currency_code`, `Countries`.`ISO_4217_currency_name` AS `Countries__ISO_4217_currency_name`, `Countries`.`ITU-T_telephone_code` AS `Countries__ITU-T_telephone_code`, `Countries`.`ISO_3166-1_2_letter_code` AS `Countries__ISO_3166-1_2_letter_code`, `Countries`.`ISO_3166-1_3_letter_code` AS `Countries__ISO_3166-1_3_letter_code`, `Countries`.`ISO_3166-1_number` AS `Countries__ISO_3166-1_number`, `Countries`.`IANA_country_code_TLD` AS `Countries__IANA_country_code_TLD`, `PropertyOfferTypes`.`id` AS `PropertyOfferTypes__id`, `PropertyOfferTypes`.`title` AS `PropertyOfferTypes__title`, `PropertyOfferTypes`.`description` AS `PropertyOfferTypes__description`, `PropertyStyles`.`id` AS `PropertyStyles__id`, `PropertyStyles`.`title` AS `PropertyStyles__title`, `PropertyStyles`.`description` AS `PropertyStyles__description`, `Clients`.`id` AS `Clients__id`, `Clients`.`first_name` AS `Clients__first_name`, `Clients`.`last_name` AS `Clients__last_name`, `Clients`.`full_name` AS `Clients__full_name`, `Clients`.`address_line_1` AS `Clients__address_line_1`, `Clients`.`address_line_2` AS `Clients__address_line_2`, `Clients`.`city` AS `Clients__city`, `Clients`.`state_province` AS `Clients__state_province`, `Clients`.`zip` AS `Clients__zip`, `Clients`.`country_id` AS `Clients__country_id`, `Clients`.`region` AS `Clients__region`, `Clients`.`phone` AS `Clients__phone`, `Clients`.`alt_phone` AS `Clients__alt_phone`, `Clients`.`fax` AS `Clients__fax`, `Clients`.`mobile` AS `Clients__mobile` FROM `re_properties` `Properties` LEFT JOIN `re_property_types` `PropertyTypes` ON `PropertyTypes`.`id` = (`Properties`.`property_type_id`) LEFT JOIN `re_property_price_types` `PropertyPriceTypes` ON `PropertyPriceTypes`.`id` = (`Properties`.`property_price_type_id`) LEFT JOIN `re_property_statuses` `PropertyStatuses` ON `PropertyStatuses`.`id` = (`Properties`.`property_status_id`) LEFT JOIN `re_general_locations` `GeneralLocations` ON `GeneralLocations`.`id` = (`Properties`.`general_location_id`) LEFT JOIN `re_districts` `Districts` ON `Districts`.`id` = (`Properties`.`district_id`) LEFT JOIN `re_countries` `Countries` ON `Countries`.`id` = (`Properties`.`country_id`) LEFT JOIN `re_property_offer_types` `PropertyOfferTypes` ON `PropertyOfferTypes`.`id` = (`Properties`.`property_offer_type_id`) LEFT JOIN `re_property_styles` `PropertyStyles` ON `PropertyStyles`.`id` = (`Properties`.`property_style_id`) LEFT JOIN `re_clients` `Clients` ON `Clients`.`id` = (`Properties`.`client_id`) WHERE `Properties`.`id` = :c0' $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' => [ 'Properties__id' => 'integer', 'Properties.id' => 'integer', 'id' => 'integer', 'Properties__enabled' => 'boolean', 'Properties.enabled' => 'boolean', 'enabled' => 'boolean', 'Properties__title' => 'string', 'Properties.title' => 'string', 'title' => 'string', 'Properties__main_image_path' => 'string', 'Properties.main_image_path' => 'string', 'main_image_path' => 'string', 'Properties__header_image_path' => 'string', 'Properties.header_image_path' => 'string', 'header_image_path' => 'string', 'Properties__reference' => 'string', 'Properties.reference' => 'string', 'reference' => 'string', 'Properties__property_type_id' => 'integer', 'Properties.property_type_id' => 'integer', 'property_type_id' => 'integer', 'Properties__longitude' => 'string', 'Properties.longitude' => 'string', 'longitude' => 'string', 'Properties__latitude' => 'string', 'Properties.latitude' => 'string', 'latitude' => 'string', 'Properties__zoom' => 'integer', 'Properties.zoom' => 'integer', 'zoom' => 'integer', 'Properties__display_map' => 'boolean', 'Properties.display_map' => 'boolean', 'display_map' => 'boolean', 'Properties__property_pic_id' => 'integer', 'Properties.property_pic_id' => 'integer', 'property_pic_id' => 'integer', 'Properties__price' => 'decimal', 'Properties.price' => 'decimal', 'price' => 'decimal', 'Properties__price_xcd' => 'decimal', 'Properties.price_xcd' => 'decimal', 'price_xcd' => 'decimal', 'Properties__property_price_type_id' => 'integer', 'Properties.property_price_type_id' => 'integer', 'property_price_type_id' => 'integer', 'Properties__duration' => 'string', 'Properties.duration' => 'string', 'duration' => 'string', 'Properties__bedrooms' => 'integer', 'Properties.bedrooms' => 'integer', 'bedrooms' => 'integer', 'Properties__bathrooms' => 'float', 'Properties.bathrooms' => 'float', 'bathrooms' => 'float', 'Properties__floors' => 'integer', 'Properties.floors' => 'integer', 'floors' => 'integer', 'Properties__rooms' => 'integer', 'Properties.rooms' => 'integer', 'rooms' => 'integer', 'Properties__furnished' => 'integer', 'Properties.furnished' => 'integer', 'furnished' => 'integer', 'Properties__property_status_id' => 'integer', 'Properties.property_status_id' => 'integer', 'property_status_id' => 'integer', 'Properties__general_location_id' => 'integer', 'Properties.general_location_id' => 'integer', 'general_location_id' => 'integer', 'Properties__district_id' => 'integer', 'Properties.district_id' => 'integer', 'district_id' => 'integer', 'Properties__address_line_1' => 'string', 'Properties.address_line_1' => 'string', 'address_line_1' => 'string', 'Properties__address_line_2' => 'string', 'Properties.address_line_2' => 'string', 'address_line_2' => 'string', 'Properties__city' => 'string', 'Properties.city' => 'string', 'city' => 'string', 'Properties__state_province' => 'string', 'Properties.state_province' => 'string', 'state_province' => 'string', 'Properties__zip' => 'string', 'Properties.zip' => 'string', 'zip' => 'string', 'Properties__country_id' => 'integer', 'Properties.country_id' => 'integer', 'country_id' => 'integer', 'Properties__region' => 'string', 'Properties.region' => 'string', 'region' => 'string', 'Properties__property_offer_type_id' => 'integer', 'Properties.property_offer_type_id' => 'integer', 'property_offer_type_id' => 'integer', 'Properties__description' => 'text', 'Properties.description' => 'text', 'description' => 'text', 'Properties__lot_size' => 'float', 'Properties.lot_size' => 'float', 'lot_size' => 'float', 'Properties__lot_size_unit' => 'string', 'Properties.lot_size_unit' => 'string', 'lot_size_unit' => 'string', 'Properties__property_size' => 'integer', 'Properties.property_size' => 'integer', 'property_size' => 'integer', 'Properties__year_built' => 'text', 'Properties.year_built' => 'text', 'year_built' => 'text', 'Properties__property_style_id' => 'integer', 'Properties.property_style_id' => 'integer', 'property_style_id' => 'integer', 'Properties__client_id' => 'integer', 'Properties.client_id' => 'integer', 'client_id' => 'integer', 'Properties__availability_date' => 'date', 'Properties.availability_date' => 'date', 'availability_date' => 'date', 'Properties__created' => 'date', 'Properties.created' => 'date', 'created' => 'date', 'Properties__modified' => 'date', 'Properties.modified' => 'date', 'modified' => 'date', 'PropertyTypes__id' => 'integer', 'PropertyTypes.id' => 'integer', 'PropertyTypes__title' => 'string', 'PropertyTypes.title' => 'string', 'PropertyTypes__description' => 'text', 'PropertyTypes.description' => 'text', 'PropertyPriceTypes__id' => 'integer', 'PropertyPriceTypes.id' => 'integer', 'PropertyPriceTypes__title' => 'string', 'PropertyPriceTypes.title' => 'string', 'PropertyPriceTypes__description' => 'text', 'PropertyPriceTypes.description' => 'text', 'PropertyStatuses__id' => 'integer', 'PropertyStatuses.id' => 'integer', 'PropertyStatuses__title' => 'string', 'PropertyStatuses.title' => 'string', 'PropertyStatuses__description' => 'text', 'PropertyStatuses.description' => 'text', 'PropertyStatuses__icon_path' => 'string', 'PropertyStatuses.icon_path' => 'string', 'icon_path' => 'string', 'PropertyStatuses__created' => 'datetime', 'PropertyStatuses.created' => 'datetime', 'PropertyStatuses__modified' => 'datetime', 'PropertyStatuses.modified' => 'datetime', 'GeneralLocations__id' => 'integer', 'GeneralLocations.id' => 'integer', 'GeneralLocations__title' => 'string', 'GeneralLocations.title' => 'string', 'GeneralLocations__description' => 'text', 'GeneralLocations.description' => 'text', 'Districts__id' => 'integer', 'Districts.id' => 'integer', 'Districts__title' => 'string', 'Districts.title' => 'string', 'Districts__description' => 'text', 'Districts.description' => 'text', 'Countries__id' => 'integer', 'Countries.id' => 'integer', 'Countries__common_name' => 'string', 'Countries.common_name' => 'string', 'common_name' => 'string', 'Countries__formal_name' => 'string', 'Countries.formal_name' => 'string', 'formal_name' => 'string', 'Countries__type' => 'string', 'Countries.type' => 'string', 'type' => 'string', 'Countries__sub_type' => 'string', 'Countries.sub_type' => 'string', 'sub_type' => 'string', 'Countries__sovereignty' => 'string', 'Countries.sovereignty' => 'string', 'sovereignty' => 'string', 'Countries__capital' => 'string', 'Countries.capital' => 'string', 'capital' => 'string', 'Countries__ISO_4217_currency_code' => 'string', 'Countries.ISO_4217_currency_code' => 'string', 'ISO_4217_currency_code' => 'string', 'Countries__ISO_4217_currency_name' => 'string', 'Countries.ISO_4217_currency_name' => 'string', 'ISO_4217_currency_name' => 'string', 'Countries__ITU-T_telephone_code' => 'string', 'Countries.ITU-T_telephone_code' => 'string', 'ITU-T_telephone_code' => 'string', 'Countries__ISO_3166-1_2_letter_code' => 'string', 'Countries.ISO_3166-1_2_letter_code' => 'string', 'ISO_3166-1_2_letter_code' => 'string', 'Countries__ISO_3166-1_3_letter_code' => 'string', 'Countries.ISO_3166-1_3_letter_code' => 'string', 'ISO_3166-1_3_letter_code' => 'string', 'Countries__ISO_3166-1_number' => 'string', 'Countries.ISO_3166-1_number' => 'string', 'ISO_3166-1_number' => 'string', 'Countries__IANA_country_code_TLD' => 'string', 'Countries.IANA_country_code_TLD' => 'string', 'IANA_country_code_TLD' => 'string', 'PropertyOfferTypes__id' => 'integer', 'PropertyOfferTypes.id' => 'integer', 'PropertyOfferTypes__title' => 'string', 'PropertyOfferTypes.title' => 'string', 'PropertyOfferTypes__description' => 'text', 'PropertyOfferTypes.description' => 'text', 'PropertyStyles__id' => 'integer', 'PropertyStyles.id' => 'integer', 'PropertyStyles__title' => 'string', 'PropertyStyles.title' => 'string', 'PropertyStyles__description' => 'text', 'PropertyStyles.description' => 'text', 'Clients__id' => 'integer', 'Clients.id' => 'integer', 'Clients__first_name' => 'string', 'Clients.first_name' => 'string', 'first_name' => 'string', 'Clients__last_name' => 'string', 'Clients.last_name' => 'string', 'last_name' => 'string', 'Clients__full_name' => 'string', 'Clients.full_name' => 'string', 'full_name' => 'string', 'Clients__address_line_1' => 'string', 'Clients.address_line_1' => 'string', 'Clients__address_line_2' => 'string', 'Clients.address_line_2' => 'string', 'Clients__city' => 'string', 'Clients.city' => 'string', 'Clients__state_province' => 'string', 'Clients.state_province' => 'string', 'Clients__zip' => 'string', 'Clients.zip' => 'string', 'Clients__country_id' => 'integer', 'Clients.country_id' => 'integer', 'Clients__region' => 'string', 'Clients.region' => 'string', 'Clients__phone' => 'string', 'Clients.phone' => 'string', 'phone' => 'string', 'Clients__alt_phone' => 'string', 'Clients.alt_phone' => 'string', 'alt_phone' => 'string', 'Clients__fax' => 'string', 'Clients.fax' => 'string', 'fax' => 'string', 'Clients__mobile' => 'string', 'Clients.mobile' => 'string', 'mobile' => 'string', 'PropertyFeatures__id' => 'integer', 'PropertyFeatures.id' => 'integer', 'PropertyFeatures__title' => 'string', 'PropertyFeatures.title' => 'string', 'PropertyFeatures__description' => 'text', 'PropertyFeatures.description' => 'text', 'PropertyPics__id' => 'integer', 'PropertyPics.id' => 'integer', 'PropertyPics__title' => 'string', 'PropertyPics.title' => 'string', 'PropertyPics__sub_title' => 'string', 'PropertyPics.sub_title' => 'string', 'sub_title' => 'string', 'PropertyPics__description' => 'text', 'PropertyPics.description' => 'text', 'PropertyPics__order' => 'integer', 'PropertyPics.order' => 'integer', 'order' => 'integer', 'PropertyPics__url' => 'string', 'PropertyPics.url' => 'string', 'url' => 'string', 'PropertyPics__url_title' => 'string', 'PropertyPics.url_title' => 'string', 'url_title' => 'string', 'PropertyPics__path' => 'text', 'PropertyPics.path' => 'text', 'path' => 'text', 'PropertyPics__property_id' => 'integer', 'PropertyPics.property_id' => 'integer', 'property_id' => 'integer', 'PropertyPics__filename' => 'string', 'PropertyPics.filename' => 'string', 'filename' => 'string', 'PropertyPics__webpath' => 'string', 'PropertyPics.webpath' => 'string', 'webpath' => 'string', 'PropertyPics__size' => 'integer', 'PropertyPics.size' => 'integer', 'size' => 'integer', 'PropertyPics__small' => 'string', 'PropertyPics.small' => 'string', 'small' => 'string', 'PropertyPics__large' => 'string', 'PropertyPics.large' => 'string', 'large' => 'string', 'PropertyPics__original' => 'string', 'PropertyPics.original' => 'string', 'original' => 'string', 'PropertyPics__created' => 'datetime', 'PropertyPics.created' => 'datetime', 'PropertyPics__modified' => 'datetime', 'PropertyPics.modified' => 'datetime' ], 'decorators' => (int) 0, 'executed' => false, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [ 'PropertyTypes' => [[maximum depth reached]], 'PropertyPriceTypes' => [[maximum depth reached]], 'PropertyStatuses' => [[maximum depth reached]], 'GeneralLocations' => [[maximum depth reached]], 'Districts' => [[maximum depth reached]], 'Countries' => [[maximum depth reached]], 'PropertyOfferTypes' => [[maximum depth reached]], 'PropertyStyles' => [[maximum depth reached]], 'Clients' => [[maximum depth reached]], 'PropertyFeatures' => [[maximum depth reached]], 'PropertyPics' => [[maximum depth reached]] ], 'matching' => [], 'extraOptions' => [], 'repository' => object(RealEstate\Model\Table\PropertiesTable) {} } $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 256 Cake\Database\QueryCompiler::compile() - CORE/src/Database/QueryCompiler.php, line 99 Cake\Database\Driver::compileQuery() - CORE/src/Database/Driver.php, line 333 Cake\Database\Connection::compileQuery() - CORE/src/Database/Connection.php, line 262 Cake\Database\Query::sql() - CORE/src/Database/Query.php, line 227 Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 937 Cake\Database\Driver\Mysql::prepare() - CORE/src/Database/Driver/Mysql.php, line 136 Cake\Database\Connection::prepare() - CORE/src/Database/Connection.php, line 221 Cake\Database\Connection::run() - CORE/src/Database/Connection.php, line 274 Cake\Database\Query::execute() - CORE/src/Database/Query.php, line 189 Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 958 Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276 Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 906 Cake\ORM\Query::first() - CORE/src/Datasource/QueryTrait.php, line 404 Cake\ORM\Query::firstOrFail() - CORE/src/Datasource/QueryTrait.php, line 415
Warning (2): count() [function.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 = 'offset' $sql = 'SELECT `Properties`.`id` AS `Properties__id`, `Properties`.`enabled` AS `Properties__enabled`, `Properties`.`title` AS `Properties__title`, `Properties`.`main_image_path` AS `Properties__main_image_path`, `Properties`.`header_image_path` AS `Properties__header_image_path`, `Properties`.`reference` AS `Properties__reference`, `Properties`.`property_type_id` AS `Properties__property_type_id`, `Properties`.`longitude` AS `Properties__longitude`, `Properties`.`latitude` AS `Properties__latitude`, `Properties`.`zoom` AS `Properties__zoom`, `Properties`.`display_map` AS `Properties__display_map`, `Properties`.`property_pic_id` AS `Properties__property_pic_id`, `Properties`.`price` AS `Properties__price`, `Properties`.`price_xcd` AS `Properties__price_xcd`, `Properties`.`property_price_type_id` AS `Properties__property_price_type_id`, `Properties`.`duration` AS `Properties__duration`, `Properties`.`bedrooms` AS `Properties__bedrooms`, `Properties`.`bathrooms` AS `Properties__bathrooms`, `Properties`.`floors` AS `Properties__floors`, `Properties`.`rooms` AS `Properties__rooms`, `Properties`.`furnished` AS `Properties__furnished`, `Properties`.`property_status_id` AS `Properties__property_status_id`, `Properties`.`general_location_id` AS `Properties__general_location_id`, `Properties`.`district_id` AS `Properties__district_id`, `Properties`.`address_line_1` AS `Properties__address_line_1`, `Properties`.`address_line_2` AS `Properties__address_line_2`, `Properties`.`city` AS `Properties__city`, `Properties`.`state_province` AS `Properties__state_province`, `Properties`.`zip` AS `Properties__zip`, `Properties`.`country_id` AS `Properties__country_id`, `Properties`.`region` AS `Properties__region`, `Properties`.`property_offer_type_id` AS `Properties__property_offer_type_id`, `Properties`.`description` AS `Properties__description`, `Properties`.`lot_size` AS `Properties__lot_size`, `Properties`.`lot_size_unit` AS `Properties__lot_size_unit`, `Properties`.`property_size` AS `Properties__property_size`, `Properties`.`year_built` AS `Properties__year_built`, `Properties`.`property_style_id` AS `Properties__property_style_id`, `Properties`.`client_id` AS `Properties__client_id`, `Properties`.`availability_date` AS `Properties__availability_date`, `Properties`.`created` AS `Properties__created`, `Properties`.`modified` AS `Properties__modified`, `PropertyTypes`.`id` AS `PropertyTypes__id`, `PropertyTypes`.`title` AS `PropertyTypes__title`, `PropertyTypes`.`description` AS `PropertyTypes__description`, `PropertyPriceTypes`.`id` AS `PropertyPriceTypes__id`, `PropertyPriceTypes`.`title` AS `PropertyPriceTypes__title`, `PropertyPriceTypes`.`description` AS `PropertyPriceTypes__description`, `PropertyStatuses`.`id` AS `PropertyStatuses__id`, `PropertyStatuses`.`title` AS `PropertyStatuses__title`, `PropertyStatuses`.`description` AS `PropertyStatuses__description`, `PropertyStatuses`.`icon_path` AS `PropertyStatuses__icon_path`, `PropertyStatuses`.`created` AS `PropertyStatuses__created`, `PropertyStatuses`.`modified` AS `PropertyStatuses__modified`, `GeneralLocations`.`id` AS `GeneralLocations__id`, `GeneralLocations`.`title` AS `GeneralLocations__title`, `GeneralLocations`.`description` AS `GeneralLocations__description`, `Districts`.`id` AS `Districts__id`, `Districts`.`title` AS `Districts__title`, `Districts`.`description` AS `Districts__description`, `Countries`.`id` AS `Countries__id`, `Countries`.`common_name` AS `Countries__common_name`, `Countries`.`formal_name` AS `Countries__formal_name`, `Countries`.`type` AS `Countries__type`, `Countries`.`sub_type` AS `Countries__sub_type`, `Countries`.`sovereignty` AS `Countries__sovereignty`, `Countries`.`capital` AS `Countries__capital`, `Countries`.`ISO_4217_currency_code` AS `Countries__ISO_4217_currency_code`, `Countries`.`ISO_4217_currency_name` AS `Countries__ISO_4217_currency_name`, `Countries`.`ITU-T_telephone_code` AS `Countries__ITU-T_telephone_code`, `Countries`.`ISO_3166-1_2_letter_code` AS `Countries__ISO_3166-1_2_letter_code`, `Countries`.`ISO_3166-1_3_letter_code` AS `Countries__ISO_3166-1_3_letter_code`, `Countries`.`ISO_3166-1_number` AS `Countries__ISO_3166-1_number`, `Countries`.`IANA_country_code_TLD` AS `Countries__IANA_country_code_TLD`, `PropertyOfferTypes`.`id` AS `PropertyOfferTypes__id`, `PropertyOfferTypes`.`title` AS `PropertyOfferTypes__title`, `PropertyOfferTypes`.`description` AS `PropertyOfferTypes__description`, `PropertyStyles`.`id` AS `PropertyStyles__id`, `PropertyStyles`.`title` AS `PropertyStyles__title`, `PropertyStyles`.`description` AS `PropertyStyles__description`, `Clients`.`id` AS `Clients__id`, `Clients`.`first_name` AS `Clients__first_name`, `Clients`.`last_name` AS `Clients__last_name`, `Clients`.`full_name` AS `Clients__full_name`, `Clients`.`address_line_1` AS `Clients__address_line_1`, `Clients`.`address_line_2` AS `Clients__address_line_2`, `Clients`.`city` AS `Clients__city`, `Clients`.`state_province` AS `Clients__state_province`, `Clients`.`zip` AS `Clients__zip`, `Clients`.`country_id` AS `Clients__country_id`, `Clients`.`region` AS `Clients__region`, `Clients`.`phone` AS `Clients__phone`, `Clients`.`alt_phone` AS `Clients__alt_phone`, `Clients`.`fax` AS `Clients__fax`, `Clients`.`mobile` AS `Clients__mobile` FROM `re_properties` `Properties` LEFT JOIN `re_property_types` `PropertyTypes` ON `PropertyTypes`.`id` = (`Properties`.`property_type_id`) LEFT JOIN `re_property_price_types` `PropertyPriceTypes` ON `PropertyPriceTypes`.`id` = (`Properties`.`property_price_type_id`) LEFT JOIN `re_property_statuses` `PropertyStatuses` ON `PropertyStatuses`.`id` = (`Properties`.`property_status_id`) LEFT JOIN `re_general_locations` `GeneralLocations` ON `GeneralLocations`.`id` = (`Properties`.`general_location_id`) LEFT JOIN `re_districts` `Districts` ON `Districts`.`id` = (`Properties`.`district_id`) LEFT JOIN `re_countries` `Countries` ON `Countries`.`id` = (`Properties`.`country_id`) LEFT JOIN `re_property_offer_types` `PropertyOfferTypes` ON `PropertyOfferTypes`.`id` = (`Properties`.`property_offer_type_id`) LEFT JOIN `re_property_styles` `PropertyStyles` ON `PropertyStyles`.`id` = (`Properties`.`property_style_id`) LEFT JOIN `re_clients` `Clients` ON `Clients`.`id` = (`Properties`.`client_id`) WHERE `Properties`.`id` = :c0 LIMIT 1' $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' => [ 'Properties__id' => 'integer', 'Properties.id' => 'integer', 'id' => 'integer', 'Properties__enabled' => 'boolean', 'Properties.enabled' => 'boolean', 'enabled' => 'boolean', 'Properties__title' => 'string', 'Properties.title' => 'string', 'title' => 'string', 'Properties__main_image_path' => 'string', 'Properties.main_image_path' => 'string', 'main_image_path' => 'string', 'Properties__header_image_path' => 'string', 'Properties.header_image_path' => 'string', 'header_image_path' => 'string', 'Properties__reference' => 'string', 'Properties.reference' => 'string', 'reference' => 'string', 'Properties__property_type_id' => 'integer', 'Properties.property_type_id' => 'integer', 'property_type_id' => 'integer', 'Properties__longitude' => 'string', 'Properties.longitude' => 'string', 'longitude' => 'string', 'Properties__latitude' => 'string', 'Properties.latitude' => 'string', 'latitude' => 'string', 'Properties__zoom' => 'integer', 'Properties.zoom' => 'integer', 'zoom' => 'integer', 'Properties__display_map' => 'boolean', 'Properties.display_map' => 'boolean', 'display_map' => 'boolean', 'Properties__property_pic_id' => 'integer', 'Properties.property_pic_id' => 'integer', 'property_pic_id' => 'integer', 'Properties__price' => 'decimal', 'Properties.price' => 'decimal', 'price' => 'decimal', 'Properties__price_xcd' => 'decimal', 'Properties.price_xcd' => 'decimal', 'price_xcd' => 'decimal', 'Properties__property_price_type_id' => 'integer', 'Properties.property_price_type_id' => 'integer', 'property_price_type_id' => 'integer', 'Properties__duration' => 'string', 'Properties.duration' => 'string', 'duration' => 'string', 'Properties__bedrooms' => 'integer', 'Properties.bedrooms' => 'integer', 'bedrooms' => 'integer', 'Properties__bathrooms' => 'float', 'Properties.bathrooms' => 'float', 'bathrooms' => 'float', 'Properties__floors' => 'integer', 'Properties.floors' => 'integer', 'floors' => 'integer', 'Properties__rooms' => 'integer', 'Properties.rooms' => 'integer', 'rooms' => 'integer', 'Properties__furnished' => 'integer', 'Properties.furnished' => 'integer', 'furnished' => 'integer', 'Properties__property_status_id' => 'integer', 'Properties.property_status_id' => 'integer', 'property_status_id' => 'integer', 'Properties__general_location_id' => 'integer', 'Properties.general_location_id' => 'integer', 'general_location_id' => 'integer', 'Properties__district_id' => 'integer', 'Properties.district_id' => 'integer', 'district_id' => 'integer', 'Properties__address_line_1' => 'string', 'Properties.address_line_1' => 'string', 'address_line_1' => 'string', 'Properties__address_line_2' => 'string', 'Properties.address_line_2' => 'string', 'address_line_2' => 'string', 'Properties__city' => 'string', 'Properties.city' => 'string', 'city' => 'string', 'Properties__state_province' => 'string', 'Properties.state_province' => 'string', 'state_province' => 'string', 'Properties__zip' => 'string', 'Properties.zip' => 'string', 'zip' => 'string', 'Properties__country_id' => 'integer', 'Properties.country_id' => 'integer', 'country_id' => 'integer', 'Properties__region' => 'string', 'Properties.region' => 'string', 'region' => 'string', 'Properties__property_offer_type_id' => 'integer', 'Properties.property_offer_type_id' => 'integer', 'property_offer_type_id' => 'integer', 'Properties__description' => 'text', 'Properties.description' => 'text', 'description' => 'text', 'Properties__lot_size' => 'float', 'Properties.lot_size' => 'float', 'lot_size' => 'float', 'Properties__lot_size_unit' => 'string', 'Properties.lot_size_unit' => 'string', 'lot_size_unit' => 'string', 'Properties__property_size' => 'integer', 'Properties.property_size' => 'integer', 'property_size' => 'integer', 'Properties__year_built' => 'text', 'Properties.year_built' => 'text', 'year_built' => 'text', 'Properties__property_style_id' => 'integer', 'Properties.property_style_id' => 'integer', 'property_style_id' => 'integer', 'Properties__client_id' => 'integer', 'Properties.client_id' => 'integer', 'client_id' => 'integer', 'Properties__availability_date' => 'date', 'Properties.availability_date' => 'date', 'availability_date' => 'date', 'Properties__created' => 'date', 'Properties.created' => 'date', 'created' => 'date', 'Properties__modified' => 'date', 'Properties.modified' => 'date', 'modified' => 'date', 'PropertyTypes__id' => 'integer', 'PropertyTypes.id' => 'integer', 'PropertyTypes__title' => 'string', 'PropertyTypes.title' => 'string', 'PropertyTypes__description' => 'text', 'PropertyTypes.description' => 'text', 'PropertyPriceTypes__id' => 'integer', 'PropertyPriceTypes.id' => 'integer', 'PropertyPriceTypes__title' => 'string', 'PropertyPriceTypes.title' => 'string', 'PropertyPriceTypes__description' => 'text', 'PropertyPriceTypes.description' => 'text', 'PropertyStatuses__id' => 'integer', 'PropertyStatuses.id' => 'integer', 'PropertyStatuses__title' => 'string', 'PropertyStatuses.title' => 'string', 'PropertyStatuses__description' => 'text', 'PropertyStatuses.description' => 'text', 'PropertyStatuses__icon_path' => 'string', 'PropertyStatuses.icon_path' => 'string', 'icon_path' => 'string', 'PropertyStatuses__created' => 'datetime', 'PropertyStatuses.created' => 'datetime', 'PropertyStatuses__modified' => 'datetime', 'PropertyStatuses.modified' => 'datetime', 'GeneralLocations__id' => 'integer', 'GeneralLocations.id' => 'integer', 'GeneralLocations__title' => 'string', 'GeneralLocations.title' => 'string', 'GeneralLocations__description' => 'text', 'GeneralLocations.description' => 'text', 'Districts__id' => 'integer', 'Districts.id' => 'integer', 'Districts__title' => 'string', 'Districts.title' => 'string', 'Districts__description' => 'text', 'Districts.description' => 'text', 'Countries__id' => 'integer', 'Countries.id' => 'integer', 'Countries__common_name' => 'string', 'Countries.common_name' => 'string', 'common_name' => 'string', 'Countries__formal_name' => 'string', 'Countries.formal_name' => 'string', 'formal_name' => 'string', 'Countries__type' => 'string', 'Countries.type' => 'string', 'type' => 'string', 'Countries__sub_type' => 'string', 'Countries.sub_type' => 'string', 'sub_type' => 'string', 'Countries__sovereignty' => 'string', 'Countries.sovereignty' => 'string', 'sovereignty' => 'string', 'Countries__capital' => 'string', 'Countries.capital' => 'string', 'capital' => 'string', 'Countries__ISO_4217_currency_code' => 'string', 'Countries.ISO_4217_currency_code' => 'string', 'ISO_4217_currency_code' => 'string', 'Countries__ISO_4217_currency_name' => 'string', 'Countries.ISO_4217_currency_name' => 'string', 'ISO_4217_currency_name' => 'string', 'Countries__ITU-T_telephone_code' => 'string', 'Countries.ITU-T_telephone_code' => 'string', 'ITU-T_telephone_code' => 'string', 'Countries__ISO_3166-1_2_letter_code' => 'string', 'Countries.ISO_3166-1_2_letter_code' => 'string', 'ISO_3166-1_2_letter_code' => 'string', 'Countries__ISO_3166-1_3_letter_code' => 'string', 'Countries.ISO_3166-1_3_letter_code' => 'string', 'ISO_3166-1_3_letter_code' => 'string', 'Countries__ISO_3166-1_number' => 'string', 'Countries.ISO_3166-1_number' => 'string', 'ISO_3166-1_number' => 'string', 'Countries__IANA_country_code_TLD' => 'string', 'Countries.IANA_country_code_TLD' => 'string', 'IANA_country_code_TLD' => 'string', 'PropertyOfferTypes__id' => 'integer', 'PropertyOfferTypes.id' => 'integer', 'PropertyOfferTypes__title' => 'string', 'PropertyOfferTypes.title' => 'string', 'PropertyOfferTypes__description' => 'text', 'PropertyOfferTypes.description' => 'text', 'PropertyStyles__id' => 'integer', 'PropertyStyles.id' => 'integer', 'PropertyStyles__title' => 'string', 'PropertyStyles.title' => 'string', 'PropertyStyles__description' => 'text', 'PropertyStyles.description' => 'text', 'Clients__id' => 'integer', 'Clients.id' => 'integer', 'Clients__first_name' => 'string', 'Clients.first_name' => 'string', 'first_name' => 'string', 'Clients__last_name' => 'string', 'Clients.last_name' => 'string', 'last_name' => 'string', 'Clients__full_name' => 'string', 'Clients.full_name' => 'string', 'full_name' => 'string', 'Clients__address_line_1' => 'string', 'Clients.address_line_1' => 'string', 'Clients__address_line_2' => 'string', 'Clients.address_line_2' => 'string', 'Clients__city' => 'string', 'Clients.city' => 'string', 'Clients__state_province' => 'string', 'Clients.state_province' => 'string', 'Clients__zip' => 'string', 'Clients.zip' => 'string', 'Clients__country_id' => 'integer', 'Clients.country_id' => 'integer', 'Clients__region' => 'string', 'Clients.region' => 'string', 'Clients__phone' => 'string', 'Clients.phone' => 'string', 'phone' => 'string', 'Clients__alt_phone' => 'string', 'Clients.alt_phone' => 'string', 'alt_phone' => 'string', 'Clients__fax' => 'string', 'Clients.fax' => 'string', 'fax' => 'string', 'Clients__mobile' => 'string', 'Clients.mobile' => 'string', 'mobile' => 'string', 'PropertyFeatures__id' => 'integer', 'PropertyFeatures.id' => 'integer', 'PropertyFeatures__title' => 'string', 'PropertyFeatures.title' => 'string', 'PropertyFeatures__description' => 'text', 'PropertyFeatures.description' => 'text', 'PropertyPics__id' => 'integer', 'PropertyPics.id' => 'integer', 'PropertyPics__title' => 'string', 'PropertyPics.title' => 'string', 'PropertyPics__sub_title' => 'string', 'PropertyPics.sub_title' => 'string', 'sub_title' => 'string', 'PropertyPics__description' => 'text', 'PropertyPics.description' => 'text', 'PropertyPics__order' => 'integer', 'PropertyPics.order' => 'integer', 'order' => 'integer', 'PropertyPics__url' => 'string', 'PropertyPics.url' => 'string', 'url' => 'string', 'PropertyPics__url_title' => 'string', 'PropertyPics.url_title' => 'string', 'url_title' => 'string', 'PropertyPics__path' => 'text', 'PropertyPics.path' => 'text', 'path' => 'text', 'PropertyPics__property_id' => 'integer', 'PropertyPics.property_id' => 'integer', 'property_id' => 'integer', 'PropertyPics__filename' => 'string', 'PropertyPics.filename' => 'string', 'filename' => 'string', 'PropertyPics__webpath' => 'string', 'PropertyPics.webpath' => 'string', 'webpath' => 'string', 'PropertyPics__size' => 'integer', 'PropertyPics.size' => 'integer', 'size' => 'integer', 'PropertyPics__small' => 'string', 'PropertyPics.small' => 'string', 'small' => 'string', 'PropertyPics__large' => 'string', 'PropertyPics.large' => 'string', 'large' => 'string', 'PropertyPics__original' => 'string', 'PropertyPics.original' => 'string', 'original' => 'string', 'PropertyPics__created' => 'datetime', 'PropertyPics.created' => 'datetime', 'PropertyPics__modified' => 'datetime', 'PropertyPics.modified' => 'datetime' ], 'decorators' => (int) 0, 'executed' => false, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [ 'PropertyTypes' => [[maximum depth reached]], 'PropertyPriceTypes' => [[maximum depth reached]], 'PropertyStatuses' => [[maximum depth reached]], 'GeneralLocations' => [[maximum depth reached]], 'Districts' => [[maximum depth reached]], 'Countries' => [[maximum depth reached]], 'PropertyOfferTypes' => [[maximum depth reached]], 'PropertyStyles' => [[maximum depth reached]], 'Clients' => [[maximum depth reached]], 'PropertyFeatures' => [[maximum depth reached]], 'PropertyPics' => [[maximum depth reached]] ], 'matching' => [], 'extraOptions' => [], 'repository' => object(RealEstate\Model\Table\PropertiesTable) {} } $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 256 Cake\Database\QueryCompiler::compile() - CORE/src/Database/QueryCompiler.php, line 99 Cake\Database\Driver::compileQuery() - CORE/src/Database/Driver.php, line 333 Cake\Database\Connection::compileQuery() - CORE/src/Database/Connection.php, line 262 Cake\Database\Query::sql() - CORE/src/Database/Query.php, line 227 Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 937 Cake\Database\Driver\Mysql::prepare() - CORE/src/Database/Driver/Mysql.php, line 136 Cake\Database\Connection::prepare() - CORE/src/Database/Connection.php, line 221 Cake\Database\Connection::run() - CORE/src/Database/Connection.php, line 274 Cake\Database\Query::execute() - CORE/src/Database/Query.php, line 189 Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 958 Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276 Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 906 Cake\ORM\Query::first() - CORE/src/Datasource/QueryTrait.php, line 404 Cake\ORM\Query::firstOrFail() - CORE/src/Datasource/QueryTrait.php, line 415
Warning (2): count() [function.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 = 'epilog' $sql = 'SELECT `Properties`.`id` AS `Properties__id`, `Properties`.`enabled` AS `Properties__enabled`, `Properties`.`title` AS `Properties__title`, `Properties`.`main_image_path` AS `Properties__main_image_path`, `Properties`.`header_image_path` AS `Properties__header_image_path`, `Properties`.`reference` AS `Properties__reference`, `Properties`.`property_type_id` AS `Properties__property_type_id`, `Properties`.`longitude` AS `Properties__longitude`, `Properties`.`latitude` AS `Properties__latitude`, `Properties`.`zoom` AS `Properties__zoom`, `Properties`.`display_map` AS `Properties__display_map`, `Properties`.`property_pic_id` AS `Properties__property_pic_id`, `Properties`.`price` AS `Properties__price`, `Properties`.`price_xcd` AS `Properties__price_xcd`, `Properties`.`property_price_type_id` AS `Properties__property_price_type_id`, `Properties`.`duration` AS `Properties__duration`, `Properties`.`bedrooms` AS `Properties__bedrooms`, `Properties`.`bathrooms` AS `Properties__bathrooms`, `Properties`.`floors` AS `Properties__floors`, `Properties`.`rooms` AS `Properties__rooms`, `Properties`.`furnished` AS `Properties__furnished`, `Properties`.`property_status_id` AS `Properties__property_status_id`, `Properties`.`general_location_id` AS `Properties__general_location_id`, `Properties`.`district_id` AS `Properties__district_id`, `Properties`.`address_line_1` AS `Properties__address_line_1`, `Properties`.`address_line_2` AS `Properties__address_line_2`, `Properties`.`city` AS `Properties__city`, `Properties`.`state_province` AS `Properties__state_province`, `Properties`.`zip` AS `Properties__zip`, `Properties`.`country_id` AS `Properties__country_id`, `Properties`.`region` AS `Properties__region`, `Properties`.`property_offer_type_id` AS `Properties__property_offer_type_id`, `Properties`.`description` AS `Properties__description`, `Properties`.`lot_size` AS `Properties__lot_size`, `Properties`.`lot_size_unit` AS `Properties__lot_size_unit`, `Properties`.`property_size` AS `Properties__property_size`, `Properties`.`year_built` AS `Properties__year_built`, `Properties`.`property_style_id` AS `Properties__property_style_id`, `Properties`.`client_id` AS `Properties__client_id`, `Properties`.`availability_date` AS `Properties__availability_date`, `Properties`.`created` AS `Properties__created`, `Properties`.`modified` AS `Properties__modified`, `PropertyTypes`.`id` AS `PropertyTypes__id`, `PropertyTypes`.`title` AS `PropertyTypes__title`, `PropertyTypes`.`description` AS `PropertyTypes__description`, `PropertyPriceTypes`.`id` AS `PropertyPriceTypes__id`, `PropertyPriceTypes`.`title` AS `PropertyPriceTypes__title`, `PropertyPriceTypes`.`description` AS `PropertyPriceTypes__description`, `PropertyStatuses`.`id` AS `PropertyStatuses__id`, `PropertyStatuses`.`title` AS `PropertyStatuses__title`, `PropertyStatuses`.`description` AS `PropertyStatuses__description`, `PropertyStatuses`.`icon_path` AS `PropertyStatuses__icon_path`, `PropertyStatuses`.`created` AS `PropertyStatuses__created`, `PropertyStatuses`.`modified` AS `PropertyStatuses__modified`, `GeneralLocations`.`id` AS `GeneralLocations__id`, `GeneralLocations`.`title` AS `GeneralLocations__title`, `GeneralLocations`.`description` AS `GeneralLocations__description`, `Districts`.`id` AS `Districts__id`, `Districts`.`title` AS `Districts__title`, `Districts`.`description` AS `Districts__description`, `Countries`.`id` AS `Countries__id`, `Countries`.`common_name` AS `Countries__common_name`, `Countries`.`formal_name` AS `Countries__formal_name`, `Countries`.`type` AS `Countries__type`, `Countries`.`sub_type` AS `Countries__sub_type`, `Countries`.`sovereignty` AS `Countries__sovereignty`, `Countries`.`capital` AS `Countries__capital`, `Countries`.`ISO_4217_currency_code` AS `Countries__ISO_4217_currency_code`, `Countries`.`ISO_4217_currency_name` AS `Countries__ISO_4217_currency_name`, `Countries`.`ITU-T_telephone_code` AS `Countries__ITU-T_telephone_code`, `Countries`.`ISO_3166-1_2_letter_code` AS `Countries__ISO_3166-1_2_letter_code`, `Countries`.`ISO_3166-1_3_letter_code` AS `Countries__ISO_3166-1_3_letter_code`, `Countries`.`ISO_3166-1_number` AS `Countries__ISO_3166-1_number`, `Countries`.`IANA_country_code_TLD` AS `Countries__IANA_country_code_TLD`, `PropertyOfferTypes`.`id` AS `PropertyOfferTypes__id`, `PropertyOfferTypes`.`title` AS `PropertyOfferTypes__title`, `PropertyOfferTypes`.`description` AS `PropertyOfferTypes__description`, `PropertyStyles`.`id` AS `PropertyStyles__id`, `PropertyStyles`.`title` AS `PropertyStyles__title`, `PropertyStyles`.`description` AS `PropertyStyles__description`, `Clients`.`id` AS `Clients__id`, `Clients`.`first_name` AS `Clients__first_name`, `Clients`.`last_name` AS `Clients__last_name`, `Clients`.`full_name` AS `Clients__full_name`, `Clients`.`address_line_1` AS `Clients__address_line_1`, `Clients`.`address_line_2` AS `Clients__address_line_2`, `Clients`.`city` AS `Clients__city`, `Clients`.`state_province` AS `Clients__state_province`, `Clients`.`zip` AS `Clients__zip`, `Clients`.`country_id` AS `Clients__country_id`, `Clients`.`region` AS `Clients__region`, `Clients`.`phone` AS `Clients__phone`, `Clients`.`alt_phone` AS `Clients__alt_phone`, `Clients`.`fax` AS `Clients__fax`, `Clients`.`mobile` AS `Clients__mobile` FROM `re_properties` `Properties` LEFT JOIN `re_property_types` `PropertyTypes` ON `PropertyTypes`.`id` = (`Properties`.`property_type_id`) LEFT JOIN `re_property_price_types` `PropertyPriceTypes` ON `PropertyPriceTypes`.`id` = (`Properties`.`property_price_type_id`) LEFT JOIN `re_property_statuses` `PropertyStatuses` ON `PropertyStatuses`.`id` = (`Properties`.`property_status_id`) LEFT JOIN `re_general_locations` `GeneralLocations` ON `GeneralLocations`.`id` = (`Properties`.`general_location_id`) LEFT JOIN `re_districts` `Districts` ON `Districts`.`id` = (`Properties`.`district_id`) LEFT JOIN `re_countries` `Countries` ON `Countries`.`id` = (`Properties`.`country_id`) LEFT JOIN `re_property_offer_types` `PropertyOfferTypes` ON `PropertyOfferTypes`.`id` = (`Properties`.`property_offer_type_id`) LEFT JOIN `re_property_styles` `PropertyStyles` ON `PropertyStyles`.`id` = (`Properties`.`property_style_id`) LEFT JOIN `re_clients` `Clients` ON `Clients`.`id` = (`Properties`.`client_id`) WHERE `Properties`.`id` = :c0 LIMIT 1' $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' => [ 'Properties__id' => 'integer', 'Properties.id' => 'integer', 'id' => 'integer', 'Properties__enabled' => 'boolean', 'Properties.enabled' => 'boolean', 'enabled' => 'boolean', 'Properties__title' => 'string', 'Properties.title' => 'string', 'title' => 'string', 'Properties__main_image_path' => 'string', 'Properties.main_image_path' => 'string', 'main_image_path' => 'string', 'Properties__header_image_path' => 'string', 'Properties.header_image_path' => 'string', 'header_image_path' => 'string', 'Properties__reference' => 'string', 'Properties.reference' => 'string', 'reference' => 'string', 'Properties__property_type_id' => 'integer', 'Properties.property_type_id' => 'integer', 'property_type_id' => 'integer', 'Properties__longitude' => 'string', 'Properties.longitude' => 'string', 'longitude' => 'string', 'Properties__latitude' => 'string', 'Properties.latitude' => 'string', 'latitude' => 'string', 'Properties__zoom' => 'integer', 'Properties.zoom' => 'integer', 'zoom' => 'integer', 'Properties__display_map' => 'boolean', 'Properties.display_map' => 'boolean', 'display_map' => 'boolean', 'Properties__property_pic_id' => 'integer', 'Properties.property_pic_id' => 'integer', 'property_pic_id' => 'integer', 'Properties__price' => 'decimal', 'Properties.price' => 'decimal', 'price' => 'decimal', 'Properties__price_xcd' => 'decimal', 'Properties.price_xcd' => 'decimal', 'price_xcd' => 'decimal', 'Properties__property_price_type_id' => 'integer', 'Properties.property_price_type_id' => 'integer', 'property_price_type_id' => 'integer', 'Properties__duration' => 'string', 'Properties.duration' => 'string', 'duration' => 'string', 'Properties__bedrooms' => 'integer', 'Properties.bedrooms' => 'integer', 'bedrooms' => 'integer', 'Properties__bathrooms' => 'float', 'Properties.bathrooms' => 'float', 'bathrooms' => 'float', 'Properties__floors' => 'integer', 'Properties.floors' => 'integer', 'floors' => 'integer', 'Properties__rooms' => 'integer', 'Properties.rooms' => 'integer', 'rooms' => 'integer', 'Properties__furnished' => 'integer', 'Properties.furnished' => 'integer', 'furnished' => 'integer', 'Properties__property_status_id' => 'integer', 'Properties.property_status_id' => 'integer', 'property_status_id' => 'integer', 'Properties__general_location_id' => 'integer', 'Properties.general_location_id' => 'integer', 'general_location_id' => 'integer', 'Properties__district_id' => 'integer', 'Properties.district_id' => 'integer', 'district_id' => 'integer', 'Properties__address_line_1' => 'string', 'Properties.address_line_1' => 'string', 'address_line_1' => 'string', 'Properties__address_line_2' => 'string', 'Properties.address_line_2' => 'string', 'address_line_2' => 'string', 'Properties__city' => 'string', 'Properties.city' => 'string', 'city' => 'string', 'Properties__state_province' => 'string', 'Properties.state_province' => 'string', 'state_province' => 'string', 'Properties__zip' => 'string', 'Properties.zip' => 'string', 'zip' => 'string', 'Properties__country_id' => 'integer', 'Properties.country_id' => 'integer', 'country_id' => 'integer', 'Properties__region' => 'string', 'Properties.region' => 'string', 'region' => 'string', 'Properties__property_offer_type_id' => 'integer', 'Properties.property_offer_type_id' => 'integer', 'property_offer_type_id' => 'integer', 'Properties__description' => 'text', 'Properties.description' => 'text', 'description' => 'text', 'Properties__lot_size' => 'float', 'Properties.lot_size' => 'float', 'lot_size' => 'float', 'Properties__lot_size_unit' => 'string', 'Properties.lot_size_unit' => 'string', 'lot_size_unit' => 'string', 'Properties__property_size' => 'integer', 'Properties.property_size' => 'integer', 'property_size' => 'integer', 'Properties__year_built' => 'text', 'Properties.year_built' => 'text', 'year_built' => 'text', 'Properties__property_style_id' => 'integer', 'Properties.property_style_id' => 'integer', 'property_style_id' => 'integer', 'Properties__client_id' => 'integer', 'Properties.client_id' => 'integer', 'client_id' => 'integer', 'Properties__availability_date' => 'date', 'Properties.availability_date' => 'date', 'availability_date' => 'date', 'Properties__created' => 'date', 'Properties.created' => 'date', 'created' => 'date', 'Properties__modified' => 'date', 'Properties.modified' => 'date', 'modified' => 'date', 'PropertyTypes__id' => 'integer', 'PropertyTypes.id' => 'integer', 'PropertyTypes__title' => 'string', 'PropertyTypes.title' => 'string', 'PropertyTypes__description' => 'text', 'PropertyTypes.description' => 'text', 'PropertyPriceTypes__id' => 'integer', 'PropertyPriceTypes.id' => 'integer', 'PropertyPriceTypes__title' => 'string', 'PropertyPriceTypes.title' => 'string', 'PropertyPriceTypes__description' => 'text', 'PropertyPriceTypes.description' => 'text', 'PropertyStatuses__id' => 'integer', 'PropertyStatuses.id' => 'integer', 'PropertyStatuses__title' => 'string', 'PropertyStatuses.title' => 'string', 'PropertyStatuses__description' => 'text', 'PropertyStatuses.description' => 'text', 'PropertyStatuses__icon_path' => 'string', 'PropertyStatuses.icon_path' => 'string', 'icon_path' => 'string', 'PropertyStatuses__created' => 'datetime', 'PropertyStatuses.created' => 'datetime', 'PropertyStatuses__modified' => 'datetime', 'PropertyStatuses.modified' => 'datetime', 'GeneralLocations__id' => 'integer', 'GeneralLocations.id' => 'integer', 'GeneralLocations__title' => 'string', 'GeneralLocations.title' => 'string', 'GeneralLocations__description' => 'text', 'GeneralLocations.description' => 'text', 'Districts__id' => 'integer', 'Districts.id' => 'integer', 'Districts__title' => 'string', 'Districts.title' => 'string', 'Districts__description' => 'text', 'Districts.description' => 'text', 'Countries__id' => 'integer', 'Countries.id' => 'integer', 'Countries__common_name' => 'string', 'Countries.common_name' => 'string', 'common_name' => 'string', 'Countries__formal_name' => 'string', 'Countries.formal_name' => 'string', 'formal_name' => 'string', 'Countries__type' => 'string', 'Countries.type' => 'string', 'type' => 'string', 'Countries__sub_type' => 'string', 'Countries.sub_type' => 'string', 'sub_type' => 'string', 'Countries__sovereignty' => 'string', 'Countries.sovereignty' => 'string', 'sovereignty' => 'string', 'Countries__capital' => 'string', 'Countries.capital' => 'string', 'capital' => 'string', 'Countries__ISO_4217_currency_code' => 'string', 'Countries.ISO_4217_currency_code' => 'string', 'ISO_4217_currency_code' => 'string', 'Countries__ISO_4217_currency_name' => 'string', 'Countries.ISO_4217_currency_name' => 'string', 'ISO_4217_currency_name' => 'string', 'Countries__ITU-T_telephone_code' => 'string', 'Countries.ITU-T_telephone_code' => 'string', 'ITU-T_telephone_code' => 'string', 'Countries__ISO_3166-1_2_letter_code' => 'string', 'Countries.ISO_3166-1_2_letter_code' => 'string', 'ISO_3166-1_2_letter_code' => 'string', 'Countries__ISO_3166-1_3_letter_code' => 'string', 'Countries.ISO_3166-1_3_letter_code' => 'string', 'ISO_3166-1_3_letter_code' => 'string', 'Countries__ISO_3166-1_number' => 'string', 'Countries.ISO_3166-1_number' => 'string', 'ISO_3166-1_number' => 'string', 'Countries__IANA_country_code_TLD' => 'string', 'Countries.IANA_country_code_TLD' => 'string', 'IANA_country_code_TLD' => 'string', 'PropertyOfferTypes__id' => 'integer', 'PropertyOfferTypes.id' => 'integer', 'PropertyOfferTypes__title' => 'string', 'PropertyOfferTypes.title' => 'string', 'PropertyOfferTypes__description' => 'text', 'PropertyOfferTypes.description' => 'text', 'PropertyStyles__id' => 'integer', 'PropertyStyles.id' => 'integer', 'PropertyStyles__title' => 'string', 'PropertyStyles.title' => 'string', 'PropertyStyles__description' => 'text', 'PropertyStyles.description' => 'text', 'Clients__id' => 'integer', 'Clients.id' => 'integer', 'Clients__first_name' => 'string', 'Clients.first_name' => 'string', 'first_name' => 'string', 'Clients__last_name' => 'string', 'Clients.last_name' => 'string', 'last_name' => 'string', 'Clients__full_name' => 'string', 'Clients.full_name' => 'string', 'full_name' => 'string', 'Clients__address_line_1' => 'string', 'Clients.address_line_1' => 'string', 'Clients__address_line_2' => 'string', 'Clients.address_line_2' => 'string', 'Clients__city' => 'string', 'Clients.city' => 'string', 'Clients__state_province' => 'string', 'Clients.state_province' => 'string', 'Clients__zip' => 'string', 'Clients.zip' => 'string', 'Clients__country_id' => 'integer', 'Clients.country_id' => 'integer', 'Clients__region' => 'string', 'Clients.region' => 'string', 'Clients__phone' => 'string', 'Clients.phone' => 'string', 'phone' => 'string', 'Clients__alt_phone' => 'string', 'Clients.alt_phone' => 'string', 'alt_phone' => 'string', 'Clients__fax' => 'string', 'Clients.fax' => 'string', 'fax' => 'string', 'Clients__mobile' => 'string', 'Clients.mobile' => 'string', 'mobile' => 'string', 'PropertyFeatures__id' => 'integer', 'PropertyFeatures.id' => 'integer', 'PropertyFeatures__title' => 'string', 'PropertyFeatures.title' => 'string', 'PropertyFeatures__description' => 'text', 'PropertyFeatures.description' => 'text', 'PropertyPics__id' => 'integer', 'PropertyPics.id' => 'integer', 'PropertyPics__title' => 'string', 'PropertyPics.title' => 'string', 'PropertyPics__sub_title' => 'string', 'PropertyPics.sub_title' => 'string', 'sub_title' => 'string', 'PropertyPics__description' => 'text', 'PropertyPics.description' => 'text', 'PropertyPics__order' => 'integer', 'PropertyPics.order' => 'integer', 'order' => 'integer', 'PropertyPics__url' => 'string', 'PropertyPics.url' => 'string', 'url' => 'string', 'PropertyPics__url_title' => 'string', 'PropertyPics.url_title' => 'string', 'url_title' => 'string', 'PropertyPics__path' => 'text', 'PropertyPics.path' => 'text', 'path' => 'text', 'PropertyPics__property_id' => 'integer', 'PropertyPics.property_id' => 'integer', 'property_id' => 'integer', 'PropertyPics__filename' => 'string', 'PropertyPics.filename' => 'string', 'filename' => 'string', 'PropertyPics__webpath' => 'string', 'PropertyPics.webpath' => 'string', 'webpath' => 'string', 'PropertyPics__size' => 'integer', 'PropertyPics.size' => 'integer', 'size' => 'integer', 'PropertyPics__small' => 'string', 'PropertyPics.small' => 'string', 'small' => 'string', 'PropertyPics__large' => 'string', 'PropertyPics.large' => 'string', 'large' => 'string', 'PropertyPics__original' => 'string', 'PropertyPics.original' => 'string', 'original' => 'string', 'PropertyPics__created' => 'datetime', 'PropertyPics.created' => 'datetime', 'PropertyPics__modified' => 'datetime', 'PropertyPics.modified' => 'datetime' ], 'decorators' => (int) 0, 'executed' => false, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [ 'PropertyTypes' => [[maximum depth reached]], 'PropertyPriceTypes' => [[maximum depth reached]], 'PropertyStatuses' => [[maximum depth reached]], 'GeneralLocations' => [[maximum depth reached]], 'Districts' => [[maximum depth reached]], 'Countries' => [[maximum depth reached]], 'PropertyOfferTypes' => [[maximum depth reached]], 'PropertyStyles' => [[maximum depth reached]], 'Clients' => [[maximum depth reached]], 'PropertyFeatures' => [[maximum depth reached]], 'PropertyPics' => [[maximum depth reached]] ], 'matching' => [], 'extraOptions' => [], 'repository' => object(RealEstate\Model\Table\PropertiesTable) {} } $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 256 Cake\Database\QueryCompiler::compile() - CORE/src/Database/QueryCompiler.php, line 99 Cake\Database\Driver::compileQuery() - CORE/src/Database/Driver.php, line 333 Cake\Database\Connection::compileQuery() - CORE/src/Database/Connection.php, line 262 Cake\Database\Query::sql() - CORE/src/Database/Query.php, line 227 Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 937 Cake\Database\Driver\Mysql::prepare() - CORE/src/Database/Driver/Mysql.php, line 136 Cake\Database\Connection::prepare() - CORE/src/Database/Connection.php, line 221 Cake\Database\Connection::run() - CORE/src/Database/Connection.php, line 274 Cake\Database\Query::execute() - CORE/src/Database/Query.php, line 189 Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 958 Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276 Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 906 Cake\ORM\Query::first() - CORE/src/Datasource/QueryTrait.php, line 404 Cake\ORM\Query::firstOrFail() - CORE/src/Datasource/QueryTrait.php, line 415
Warning (2): count() [function.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 `RePropertiesPropertyFeatures`.`id` AS `PropertyFeatures_CJoin__id`, `RePropertiesPropertyFeatures`.`property_id` AS `PropertyFeatures_CJoin__property_id`, `RePropertiesPropertyFeatures`.`property_feature_id` AS `PropertyFeatures_CJoin__property_feature_id`, `PropertyFeatures`.`id` AS `PropertyFeatures__id`, `PropertyFeatures`.`title` AS `PropertyFeatures__title`, `PropertyFeatures`.`description` AS `PropertyFeatures__description` FROM `re_property_features` `PropertyFeatures` INNER JOIN `re_properties_property_features` `RePropertiesPropertyFeatures` ON `PropertyFeatures`.`id` = (`RePropertiesPropertyFeatures`.`property_feature_id`) WHERE `RePropertiesPropertyFeatures`.`property_id` in (:c0)' $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' => [ 'PropertyFeatures_CJoin__id' => 'integer', 'PropertyFeatures_CJoin__property_id' => 'integer', 'PropertyFeatures_CJoin__property_feature_id' => 'integer', 'PropertyFeatures__id' => 'integer', 'PropertyFeatures.id' => 'integer', 'id' => 'integer', 'PropertyFeatures__title' => 'string', 'PropertyFeatures.title' => 'string', 'title' => 'string', 'PropertyFeatures__description' => 'text', 'PropertyFeatures.description' => 'text', 'description' => 'text', 'RePropertiesPropertyFeatures__id' => 'integer', 'RePropertiesPropertyFeatures.id' => 'integer', 'RePropertiesPropertyFeatures__property_id' => 'integer', 'RePropertiesPropertyFeatures.property_id' => 'integer', 'property_id' => 'integer', 'RePropertiesPropertyFeatures__property_feature_id' => 'integer', 'RePropertiesPropertyFeatures.property_feature_id' => 'integer', 'property_feature_id' => 'integer' ], 'decorators' => (int) 0, 'executed' => false, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [], 'matching' => [], 'extraOptions' => [], 'repository' => object(RealEstate\Model\Table\PropertyFeaturesTable) {} } $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 256 Cake\Database\QueryCompiler::compile() - CORE/src/Database/QueryCompiler.php, line 99 Cake\Database\Driver::compileQuery() - CORE/src/Database/Driver.php, line 333 Cake\Database\Connection::compileQuery() - CORE/src/Database/Connection.php, line 262 Cake\Database\Query::sql() - CORE/src/Database/Query.php, line 227 Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 937 Cake\Database\Driver\Mysql::prepare() - CORE/src/Database/Driver/Mysql.php, line 136 Cake\Database\Connection::prepare() - CORE/src/Database/Connection.php, line 221 Cake\Database\Connection::run() - CORE/src/Database/Connection.php, line 274 Cake\Database\Query::execute() - CORE/src/Database/Query.php, line 189 Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 958 Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276 Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 906 Cake\ORM\Association\BelongsToMany::_buildResultMap() - CORE/src/ORM/Association/BelongsToMany.php, line 456 Cake\ORM\Association\BelongsToMany::eagerLoader() - CORE/src/ORM/Association/SelectableAssociationTrait.php, line 49
Warning (2): count() [function.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 = 'order' $sql = 'SELECT `RePropertiesPropertyFeatures`.`id` AS `PropertyFeatures_CJoin__id`, `RePropertiesPropertyFeatures`.`property_id` AS `PropertyFeatures_CJoin__property_id`, `RePropertiesPropertyFeatures`.`property_feature_id` AS `PropertyFeatures_CJoin__property_feature_id`, `PropertyFeatures`.`id` AS `PropertyFeatures__id`, `PropertyFeatures`.`title` AS `PropertyFeatures__title`, `PropertyFeatures`.`description` AS `PropertyFeatures__description` FROM `re_property_features` `PropertyFeatures` INNER JOIN `re_properties_property_features` `RePropertiesPropertyFeatures` ON `PropertyFeatures`.`id` = (`RePropertiesPropertyFeatures`.`property_feature_id`) WHERE `RePropertiesPropertyFeatures`.`property_id` in (:c0)' $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' => [ 'PropertyFeatures_CJoin__id' => 'integer', 'PropertyFeatures_CJoin__property_id' => 'integer', 'PropertyFeatures_CJoin__property_feature_id' => 'integer', 'PropertyFeatures__id' => 'integer', 'PropertyFeatures.id' => 'integer', 'id' => 'integer', 'PropertyFeatures__title' => 'string', 'PropertyFeatures.title' => 'string', 'title' => 'string', 'PropertyFeatures__description' => 'text', 'PropertyFeatures.description' => 'text', 'description' => 'text', 'RePropertiesPropertyFeatures__id' => 'integer', 'RePropertiesPropertyFeatures.id' => 'integer', 'RePropertiesPropertyFeatures__property_id' => 'integer', 'RePropertiesPropertyFeatures.property_id' => 'integer', 'property_id' => 'integer', 'RePropertiesPropertyFeatures__property_feature_id' => 'integer', 'RePropertiesPropertyFeatures.property_feature_id' => 'integer', 'property_feature_id' => 'integer' ], 'decorators' => (int) 0, 'executed' => false, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [], 'matching' => [], 'extraOptions' => [], 'repository' => object(RealEstate\Model\Table\PropertyFeaturesTable) {} } $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 256 Cake\Database\QueryCompiler::compile() - CORE/src/Database/QueryCompiler.php, line 99 Cake\Database\Driver::compileQuery() - CORE/src/Database/Driver.php, line 333 Cake\Database\Connection::compileQuery() - CORE/src/Database/Connection.php, line 262 Cake\Database\Query::sql() - CORE/src/Database/Query.php, line 227 Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 937 Cake\Database\Driver\Mysql::prepare() - CORE/src/Database/Driver/Mysql.php, line 136 Cake\Database\Connection::prepare() - CORE/src/Database/Connection.php, line 221 Cake\Database\Connection::run() - CORE/src/Database/Connection.php, line 274 Cake\Database\Query::execute() - CORE/src/Database/Query.php, line 189 Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 958 Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276 Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 906 Cake\ORM\Association\BelongsToMany::_buildResultMap() - CORE/src/ORM/Association/BelongsToMany.php, line 456 Cake\ORM\Association\BelongsToMany::eagerLoader() - CORE/src/ORM/Association/SelectableAssociationTrait.php, line 49
Warning (2): count() [function.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 = 'limit' $sql = 'SELECT `RePropertiesPropertyFeatures`.`id` AS `PropertyFeatures_CJoin__id`, `RePropertiesPropertyFeatures`.`property_id` AS `PropertyFeatures_CJoin__property_id`, `RePropertiesPropertyFeatures`.`property_feature_id` AS `PropertyFeatures_CJoin__property_feature_id`, `PropertyFeatures`.`id` AS `PropertyFeatures__id`, `PropertyFeatures`.`title` AS `PropertyFeatures__title`, `PropertyFeatures`.`description` AS `PropertyFeatures__description` FROM `re_property_features` `PropertyFeatures` INNER JOIN `re_properties_property_features` `RePropertiesPropertyFeatures` ON `PropertyFeatures`.`id` = (`RePropertiesPropertyFeatures`.`property_feature_id`) WHERE `RePropertiesPropertyFeatures`.`property_id` in (:c0)' $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' => [ 'PropertyFeatures_CJoin__id' => 'integer', 'PropertyFeatures_CJoin__property_id' => 'integer', 'PropertyFeatures_CJoin__property_feature_id' => 'integer', 'PropertyFeatures__id' => 'integer', 'PropertyFeatures.id' => 'integer', 'id' => 'integer', 'PropertyFeatures__title' => 'string', 'PropertyFeatures.title' => 'string', 'title' => 'string', 'PropertyFeatures__description' => 'text', 'PropertyFeatures.description' => 'text', 'description' => 'text', 'RePropertiesPropertyFeatures__id' => 'integer', 'RePropertiesPropertyFeatures.id' => 'integer', 'RePropertiesPropertyFeatures__property_id' => 'integer', 'RePropertiesPropertyFeatures.property_id' => 'integer', 'property_id' => 'integer', 'RePropertiesPropertyFeatures__property_feature_id' => 'integer', 'RePropertiesPropertyFeatures.property_feature_id' => 'integer', 'property_feature_id' => 'integer' ], 'decorators' => (int) 0, 'executed' => false, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [], 'matching' => [], 'extraOptions' => [], 'repository' => object(RealEstate\Model\Table\PropertyFeaturesTable) {} } $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 256 Cake\Database\QueryCompiler::compile() - CORE/src/Database/QueryCompiler.php, line 99 Cake\Database\Driver::compileQuery() - CORE/src/Database/Driver.php, line 333 Cake\Database\Connection::compileQuery() - CORE/src/Database/Connection.php, line 262 Cake\Database\Query::sql() - CORE/src/Database/Query.php, line 227 Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 937 Cake\Database\Driver\Mysql::prepare() - CORE/src/Database/Driver/Mysql.php, line 136 Cake\Database\Connection::prepare() - CORE/src/Database/Connection.php, line 221 Cake\Database\Connection::run() - CORE/src/Database/Connection.php, line 274 Cake\Database\Query::execute() - CORE/src/Database/Query.php, line 189 Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 958 Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276 Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 906 Cake\ORM\Association\BelongsToMany::_buildResultMap() - CORE/src/ORM/Association/BelongsToMany.php, line 456 Cake\ORM\Association\BelongsToMany::eagerLoader() - CORE/src/ORM/Association/SelectableAssociationTrait.php, line 49
Warning (2): count() [function.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 = 'offset' $sql = 'SELECT `RePropertiesPropertyFeatures`.`id` AS `PropertyFeatures_CJoin__id`, `RePropertiesPropertyFeatures`.`property_id` AS `PropertyFeatures_CJoin__property_id`, `RePropertiesPropertyFeatures`.`property_feature_id` AS `PropertyFeatures_CJoin__property_feature_id`, `PropertyFeatures`.`id` AS `PropertyFeatures__id`, `PropertyFeatures`.`title` AS `PropertyFeatures__title`, `PropertyFeatures`.`description` AS `PropertyFeatures__description` FROM `re_property_features` `PropertyFeatures` INNER JOIN `re_properties_property_features` `RePropertiesPropertyFeatures` ON `PropertyFeatures`.`id` = (`RePropertiesPropertyFeatures`.`property_feature_id`) WHERE `RePropertiesPropertyFeatures`.`property_id` in (:c0)' $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' => [ 'PropertyFeatures_CJoin__id' => 'integer', 'PropertyFeatures_CJoin__property_id' => 'integer', 'PropertyFeatures_CJoin__property_feature_id' => 'integer', 'PropertyFeatures__id' => 'integer', 'PropertyFeatures.id' => 'integer', 'id' => 'integer', 'PropertyFeatures__title' => 'string', 'PropertyFeatures.title' => 'string', 'title' => 'string', 'PropertyFeatures__description' => 'text', 'PropertyFeatures.description' => 'text', 'description' => 'text', 'RePropertiesPropertyFeatures__id' => 'integer', 'RePropertiesPropertyFeatures.id' => 'integer', 'RePropertiesPropertyFeatures__property_id' => 'integer', 'RePropertiesPropertyFeatures.property_id' => 'integer', 'property_id' => 'integer', 'RePropertiesPropertyFeatures__property_feature_id' => 'integer', 'RePropertiesPropertyFeatures.property_feature_id' => 'integer', 'property_feature_id' => 'integer' ], 'decorators' => (int) 0, 'executed' => false, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [], 'matching' => [], 'extraOptions' => [], 'repository' => object(RealEstate\Model\Table\PropertyFeaturesTable) {} } $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 256 Cake\Database\QueryCompiler::compile() - CORE/src/Database/QueryCompiler.php, line 99 Cake\Database\Driver::compileQuery() - CORE/src/Database/Driver.php, line 333 Cake\Database\Connection::compileQuery() - CORE/src/Database/Connection.php, line 262 Cake\Database\Query::sql() - CORE/src/Database/Query.php, line 227 Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 937 Cake\Database\Driver\Mysql::prepare() - CORE/src/Database/Driver/Mysql.php, line 136 Cake\Database\Connection::prepare() - CORE/src/Database/Connection.php, line 221 Cake\Database\Connection::run() - CORE/src/Database/Connection.php, line 274 Cake\Database\Query::execute() - CORE/src/Database/Query.php, line 189 Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 958 Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276 Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 906 Cake\ORM\Association\BelongsToMany::_buildResultMap() - CORE/src/ORM/Association/BelongsToMany.php, line 456 Cake\ORM\Association\BelongsToMany::eagerLoader() - CORE/src/ORM/Association/SelectableAssociationTrait.php, line 49
Warning (2): count() [function.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 = 'epilog' $sql = 'SELECT `RePropertiesPropertyFeatures`.`id` AS `PropertyFeatures_CJoin__id`, `RePropertiesPropertyFeatures`.`property_id` AS `PropertyFeatures_CJoin__property_id`, `RePropertiesPropertyFeatures`.`property_feature_id` AS `PropertyFeatures_CJoin__property_feature_id`, `PropertyFeatures`.`id` AS `PropertyFeatures__id`, `PropertyFeatures`.`title` AS `PropertyFeatures__title`, `PropertyFeatures`.`description` AS `PropertyFeatures__description` FROM `re_property_features` `PropertyFeatures` INNER JOIN `re_properties_property_features` `RePropertiesPropertyFeatures` ON `PropertyFeatures`.`id` = (`RePropertiesPropertyFeatures`.`property_feature_id`) WHERE `RePropertiesPropertyFeatures`.`property_id` in (:c0)' $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' => [ 'PropertyFeatures_CJoin__id' => 'integer', 'PropertyFeatures_CJoin__property_id' => 'integer', 'PropertyFeatures_CJoin__property_feature_id' => 'integer', 'PropertyFeatures__id' => 'integer', 'PropertyFeatures.id' => 'integer', 'id' => 'integer', 'PropertyFeatures__title' => 'string', 'PropertyFeatures.title' => 'string', 'title' => 'string', 'PropertyFeatures__description' => 'text', 'PropertyFeatures.description' => 'text', 'description' => 'text', 'RePropertiesPropertyFeatures__id' => 'integer', 'RePropertiesPropertyFeatures.id' => 'integer', 'RePropertiesPropertyFeatures__property_id' => 'integer', 'RePropertiesPropertyFeatures.property_id' => 'integer', 'property_id' => 'integer', 'RePropertiesPropertyFeatures__property_feature_id' => 'integer', 'RePropertiesPropertyFeatures.property_feature_id' => 'integer', 'property_feature_id' => 'integer' ], 'decorators' => (int) 0, 'executed' => false, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [], 'matching' => [], 'extraOptions' => [], 'repository' => object(RealEstate\Model\Table\PropertyFeaturesTable) {} } $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 256 Cake\Database\QueryCompiler::compile() - CORE/src/Database/QueryCompiler.php, line 99 Cake\Database\Driver::compileQuery() - CORE/src/Database/Driver.php, line 333 Cake\Database\Connection::compileQuery() - CORE/src/Database/Connection.php, line 262 Cake\Database\Query::sql() - CORE/src/Database/Query.php, line 227 Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 937 Cake\Database\Driver\Mysql::prepare() - CORE/src/Database/Driver/Mysql.php, line 136 Cake\Database\Connection::prepare() - CORE/src/Database/Connection.php, line 221 Cake\Database\Connection::run() - CORE/src/Database/Connection.php, line 274 Cake\Database\Query::execute() - CORE/src/Database/Query.php, line 189 Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 958 Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276 Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 906 Cake\ORM\Association\BelongsToMany::_buildResultMap() - CORE/src/ORM/Association/BelongsToMany.php, line 456 Cake\ORM\Association\BelongsToMany::eagerLoader() - CORE/src/ORM/Association/SelectableAssociationTrait.php, line 49
Warning (2): count() [function.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 `PropertyPics`.`id` AS `PropertyPics__id`, `PropertyPics`.`title` AS `PropertyPics__title`, `PropertyPics`.`sub_title` AS `PropertyPics__sub_title`, `PropertyPics`.`description` AS `PropertyPics__description`, `PropertyPics`.`order` AS `PropertyPics__order`, `PropertyPics`.`url` AS `PropertyPics__url`, `PropertyPics`.`url_title` AS `PropertyPics__url_title`, `PropertyPics`.`path` AS `PropertyPics__path`, `PropertyPics`.`property_id` AS `PropertyPics__property_id`, `PropertyPics`.`filename` AS `PropertyPics__filename`, `PropertyPics`.`webpath` AS `PropertyPics__webpath`, `PropertyPics`.`size` AS `PropertyPics__size`, `PropertyPics`.`small` AS `PropertyPics__small`, `PropertyPics`.`large` AS `PropertyPics__large`, `PropertyPics`.`original` AS `PropertyPics__original`, `PropertyPics`.`created` AS `PropertyPics__created`, `PropertyPics`.`modified` AS `PropertyPics__modified` FROM `re_property_pics` `PropertyPics` WHERE `PropertyPics`.`property_id` in (:c0)' $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' => [ 'PropertyPics__id' => 'integer', 'PropertyPics.id' => 'integer', 'id' => 'integer', 'PropertyPics__title' => 'string', 'PropertyPics.title' => 'string', 'title' => 'string', 'PropertyPics__sub_title' => 'string', 'PropertyPics.sub_title' => 'string', 'sub_title' => 'string', 'PropertyPics__description' => 'text', 'PropertyPics.description' => 'text', 'description' => 'text', 'PropertyPics__order' => 'integer', 'PropertyPics.order' => 'integer', 'order' => 'integer', 'PropertyPics__url' => 'string', 'PropertyPics.url' => 'string', 'url' => 'string', 'PropertyPics__url_title' => 'string', 'PropertyPics.url_title' => 'string', 'url_title' => 'string', 'PropertyPics__path' => 'text', 'PropertyPics.path' => 'text', 'path' => 'text', 'PropertyPics__property_id' => 'integer', 'PropertyPics.property_id' => 'integer', 'property_id' => 'integer', 'PropertyPics__filename' => 'string', 'PropertyPics.filename' => 'string', 'filename' => 'string', 'PropertyPics__webpath' => 'string', 'PropertyPics.webpath' => 'string', 'webpath' => 'string', 'PropertyPics__size' => 'integer', 'PropertyPics.size' => 'integer', 'size' => 'integer', 'PropertyPics__small' => 'string', 'PropertyPics.small' => 'string', 'small' => 'string', 'PropertyPics__large' => 'string', 'PropertyPics.large' => 'string', 'large' => 'string', 'PropertyPics__original' => 'string', 'PropertyPics.original' => 'string', 'original' => 'string', 'PropertyPics__created' => 'datetime', 'PropertyPics.created' => 'datetime', 'created' => 'datetime', 'PropertyPics__modified' => 'datetime', 'PropertyPics.modified' => 'datetime', 'modified' => 'datetime' ], 'decorators' => (int) 0, 'executed' => false, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [], 'matching' => [], 'extraOptions' => [], 'repository' => object(RealEstate\Model\Table\PropertyPicsTable) {} } $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 256 Cake\Database\QueryCompiler::compile() - CORE/src/Database/QueryCompiler.php, line 99 Cake\Database\Driver::compileQuery() - CORE/src/Database/Driver.php, line 333 Cake\Database\Connection::compileQuery() - CORE/src/Database/Connection.php, line 262 Cake\Database\Query::sql() - CORE/src/Database/Query.php, line 227 Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 937 Cake\Database\Driver\Mysql::prepare() - CORE/src/Database/Driver/Mysql.php, line 136 Cake\Database\Connection::prepare() - CORE/src/Database/Connection.php, line 221 Cake\Database\Connection::run() - CORE/src/Database/Connection.php, line 274 Cake\Database\Query::execute() - CORE/src/Database/Query.php, line 189 Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 958 Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276 Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 906 Cake\ORM\Association\HasMany::_buildResultMap() - CORE/src/ORM/Association/ExternalAssociationTrait.php, line 116 Cake\ORM\Association\HasMany::eagerLoader() - CORE/src/ORM/Association/SelectableAssociationTrait.php, line 49
Warning (2): count() [function.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 = 'order' $sql = 'SELECT `PropertyPics`.`id` AS `PropertyPics__id`, `PropertyPics`.`title` AS `PropertyPics__title`, `PropertyPics`.`sub_title` AS `PropertyPics__sub_title`, `PropertyPics`.`description` AS `PropertyPics__description`, `PropertyPics`.`order` AS `PropertyPics__order`, `PropertyPics`.`url` AS `PropertyPics__url`, `PropertyPics`.`url_title` AS `PropertyPics__url_title`, `PropertyPics`.`path` AS `PropertyPics__path`, `PropertyPics`.`property_id` AS `PropertyPics__property_id`, `PropertyPics`.`filename` AS `PropertyPics__filename`, `PropertyPics`.`webpath` AS `PropertyPics__webpath`, `PropertyPics`.`size` AS `PropertyPics__size`, `PropertyPics`.`small` AS `PropertyPics__small`, `PropertyPics`.`large` AS `PropertyPics__large`, `PropertyPics`.`original` AS `PropertyPics__original`, `PropertyPics`.`created` AS `PropertyPics__created`, `PropertyPics`.`modified` AS `PropertyPics__modified` FROM `re_property_pics` `PropertyPics` WHERE `PropertyPics`.`property_id` in (:c0)' $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' => [ 'PropertyPics__id' => 'integer', 'PropertyPics.id' => 'integer', 'id' => 'integer', 'PropertyPics__title' => 'string', 'PropertyPics.title' => 'string', 'title' => 'string', 'PropertyPics__sub_title' => 'string', 'PropertyPics.sub_title' => 'string', 'sub_title' => 'string', 'PropertyPics__description' => 'text', 'PropertyPics.description' => 'text', 'description' => 'text', 'PropertyPics__order' => 'integer', 'PropertyPics.order' => 'integer', 'order' => 'integer', 'PropertyPics__url' => 'string', 'PropertyPics.url' => 'string', 'url' => 'string', 'PropertyPics__url_title' => 'string', 'PropertyPics.url_title' => 'string', 'url_title' => 'string', 'PropertyPics__path' => 'text', 'PropertyPics.path' => 'text', 'path' => 'text', 'PropertyPics__property_id' => 'integer', 'PropertyPics.property_id' => 'integer', 'property_id' => 'integer', 'PropertyPics__filename' => 'string', 'PropertyPics.filename' => 'string', 'filename' => 'string', 'PropertyPics__webpath' => 'string', 'PropertyPics.webpath' => 'string', 'webpath' => 'string', 'PropertyPics__size' => 'integer', 'PropertyPics.size' => 'integer', 'size' => 'integer', 'PropertyPics__small' => 'string', 'PropertyPics.small' => 'string', 'small' => 'string', 'PropertyPics__large' => 'string', 'PropertyPics.large' => 'string', 'large' => 'string', 'PropertyPics__original' => 'string', 'PropertyPics.original' => 'string', 'original' => 'string', 'PropertyPics__created' => 'datetime', 'PropertyPics.created' => 'datetime', 'created' => 'datetime', 'PropertyPics__modified' => 'datetime', 'PropertyPics.modified' => 'datetime', 'modified' => 'datetime' ], 'decorators' => (int) 0, 'executed' => false, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [], 'matching' => [], 'extraOptions' => [], 'repository' => object(RealEstate\Model\Table\PropertyPicsTable) {} } $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 256 Cake\Database\QueryCompiler::compile() - CORE/src/Database/QueryCompiler.php, line 99 Cake\Database\Driver::compileQuery() - CORE/src/Database/Driver.php, line 333 Cake\Database\Connection::compileQuery() - CORE/src/Database/Connection.php, line 262 Cake\Database\Query::sql() - CORE/src/Database/Query.php, line 227 Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 937 Cake\Database\Driver\Mysql::prepare() - CORE/src/Database/Driver/Mysql.php, line 136 Cake\Database\Connection::prepare() - CORE/src/Database/Connection.php, line 221 Cake\Database\Connection::run() - CORE/src/Database/Connection.php, line 274 Cake\Database\Query::execute() - CORE/src/Database/Query.php, line 189 Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 958 Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276 Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 906 Cake\ORM\Association\HasMany::_buildResultMap() - CORE/src/ORM/Association/ExternalAssociationTrait.php, line 116 Cake\ORM\Association\HasMany::eagerLoader() - CORE/src/ORM/Association/SelectableAssociationTrait.php, line 49
Warning (2): count() [function.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 = 'limit' $sql = 'SELECT `PropertyPics`.`id` AS `PropertyPics__id`, `PropertyPics`.`title` AS `PropertyPics__title`, `PropertyPics`.`sub_title` AS `PropertyPics__sub_title`, `PropertyPics`.`description` AS `PropertyPics__description`, `PropertyPics`.`order` AS `PropertyPics__order`, `PropertyPics`.`url` AS `PropertyPics__url`, `PropertyPics`.`url_title` AS `PropertyPics__url_title`, `PropertyPics`.`path` AS `PropertyPics__path`, `PropertyPics`.`property_id` AS `PropertyPics__property_id`, `PropertyPics`.`filename` AS `PropertyPics__filename`, `PropertyPics`.`webpath` AS `PropertyPics__webpath`, `PropertyPics`.`size` AS `PropertyPics__size`, `PropertyPics`.`small` AS `PropertyPics__small`, `PropertyPics`.`large` AS `PropertyPics__large`, `PropertyPics`.`original` AS `PropertyPics__original`, `PropertyPics`.`created` AS `PropertyPics__created`, `PropertyPics`.`modified` AS `PropertyPics__modified` FROM `re_property_pics` `PropertyPics` WHERE `PropertyPics`.`property_id` in (:c0)' $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' => [ 'PropertyPics__id' => 'integer', 'PropertyPics.id' => 'integer', 'id' => 'integer', 'PropertyPics__title' => 'string', 'PropertyPics.title' => 'string', 'title' => 'string', 'PropertyPics__sub_title' => 'string', 'PropertyPics.sub_title' => 'string', 'sub_title' => 'string', 'PropertyPics__description' => 'text', 'PropertyPics.description' => 'text', 'description' => 'text', 'PropertyPics__order' => 'integer', 'PropertyPics.order' => 'integer', 'order' => 'integer', 'PropertyPics__url' => 'string', 'PropertyPics.url' => 'string', 'url' => 'string', 'PropertyPics__url_title' => 'string', 'PropertyPics.url_title' => 'string', 'url_title' => 'string', 'PropertyPics__path' => 'text', 'PropertyPics.path' => 'text', 'path' => 'text', 'PropertyPics__property_id' => 'integer', 'PropertyPics.property_id' => 'integer', 'property_id' => 'integer', 'PropertyPics__filename' => 'string', 'PropertyPics.filename' => 'string', 'filename' => 'string', 'PropertyPics__webpath' => 'string', 'PropertyPics.webpath' => 'string', 'webpath' => 'string', 'PropertyPics__size' => 'integer', 'PropertyPics.size' => 'integer', 'size' => 'integer', 'PropertyPics__small' => 'string', 'PropertyPics.small' => 'string', 'small' => 'string', 'PropertyPics__large' => 'string', 'PropertyPics.large' => 'string', 'large' => 'string', 'PropertyPics__original' => 'string', 'PropertyPics.original' => 'string', 'original' => 'string', 'PropertyPics__created' => 'datetime', 'PropertyPics.created' => 'datetime', 'created' => 'datetime', 'PropertyPics__modified' => 'datetime', 'PropertyPics.modified' => 'datetime', 'modified' => 'datetime' ], 'decorators' => (int) 0, 'executed' => false, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [], 'matching' => [], 'extraOptions' => [], 'repository' => object(RealEstate\Model\Table\PropertyPicsTable) {} } $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 256 Cake\Database\QueryCompiler::compile() - CORE/src/Database/QueryCompiler.php, line 99 Cake\Database\Driver::compileQuery() - CORE/src/Database/Driver.php, line 333 Cake\Database\Connection::compileQuery() - CORE/src/Database/Connection.php, line 262 Cake\Database\Query::sql() - CORE/src/Database/Query.php, line 227 Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 937 Cake\Database\Driver\Mysql::prepare() - CORE/src/Database/Driver/Mysql.php, line 136 Cake\Database\Connection::prepare() - CORE/src/Database/Connection.php, line 221 Cake\Database\Connection::run() - CORE/src/Database/Connection.php, line 274 Cake\Database\Query::execute() - CORE/src/Database/Query.php, line 189 Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 958 Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276 Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 906 Cake\ORM\Association\HasMany::_buildResultMap() - CORE/src/ORM/Association/ExternalAssociationTrait.php, line 116 Cake\ORM\Association\HasMany::eagerLoader() - CORE/src/ORM/Association/SelectableAssociationTrait.php, line 49
Warning (2): count() [function.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 = 'offset' $sql = 'SELECT `PropertyPics`.`id` AS `PropertyPics__id`, `PropertyPics`.`title` AS `PropertyPics__title`, `PropertyPics`.`sub_title` AS `PropertyPics__sub_title`, `PropertyPics`.`description` AS `PropertyPics__description`, `PropertyPics`.`order` AS `PropertyPics__order`, `PropertyPics`.`url` AS `PropertyPics__url`, `PropertyPics`.`url_title` AS `PropertyPics__url_title`, `PropertyPics`.`path` AS `PropertyPics__path`, `PropertyPics`.`property_id` AS `PropertyPics__property_id`, `PropertyPics`.`filename` AS `PropertyPics__filename`, `PropertyPics`.`webpath` AS `PropertyPics__webpath`, `PropertyPics`.`size` AS `PropertyPics__size`, `PropertyPics`.`small` AS `PropertyPics__small`, `PropertyPics`.`large` AS `PropertyPics__large`, `PropertyPics`.`original` AS `PropertyPics__original`, `PropertyPics`.`created` AS `PropertyPics__created`, `PropertyPics`.`modified` AS `PropertyPics__modified` FROM `re_property_pics` `PropertyPics` WHERE `PropertyPics`.`property_id` in (:c0)' $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' => [ 'PropertyPics__id' => 'integer', 'PropertyPics.id' => 'integer', 'id' => 'integer', 'PropertyPics__title' => 'string', 'PropertyPics.title' => 'string', 'title' => 'string', 'PropertyPics__sub_title' => 'string', 'PropertyPics.sub_title' => 'string', 'sub_title' => 'string', 'PropertyPics__description' => 'text', 'PropertyPics.description' => 'text', 'description' => 'text', 'PropertyPics__order' => 'integer', 'PropertyPics.order' => 'integer', 'order' => 'integer', 'PropertyPics__url' => 'string', 'PropertyPics.url' => 'string', 'url' => 'string', 'PropertyPics__url_title' => 'string', 'PropertyPics.url_title' => 'string', 'url_title' => 'string', 'PropertyPics__path' => 'text', 'PropertyPics.path' => 'text', 'path' => 'text', 'PropertyPics__property_id' => 'integer', 'PropertyPics.property_id' => 'integer', 'property_id' => 'integer', 'PropertyPics__filename' => 'string', 'PropertyPics.filename' => 'string', 'filename' => 'string', 'PropertyPics__webpath' => 'string', 'PropertyPics.webpath' => 'string', 'webpath' => 'string', 'PropertyPics__size' => 'integer', 'PropertyPics.size' => 'integer', 'size' => 'integer', 'PropertyPics__small' => 'string', 'PropertyPics.small' => 'string', 'small' => 'string', 'PropertyPics__large' => 'string', 'PropertyPics.large' => 'string', 'large' => 'string', 'PropertyPics__original' => 'string', 'PropertyPics.original' => 'string', 'original' => 'string', 'PropertyPics__created' => 'datetime', 'PropertyPics.created' => 'datetime', 'created' => 'datetime', 'PropertyPics__modified' => 'datetime', 'PropertyPics.modified' => 'datetime', 'modified' => 'datetime' ], 'decorators' => (int) 0, 'executed' => false, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [], 'matching' => [], 'extraOptions' => [], 'repository' => object(RealEstate\Model\Table\PropertyPicsTable) {} } $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 256 Cake\Database\QueryCompiler::compile() - CORE/src/Database/QueryCompiler.php, line 99 Cake\Database\Driver::compileQuery() - CORE/src/Database/Driver.php, line 333 Cake\Database\Connection::compileQuery() - CORE/src/Database/Connection.php, line 262 Cake\Database\Query::sql() - CORE/src/Database/Query.php, line 227 Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 937 Cake\Database\Driver\Mysql::prepare() - CORE/src/Database/Driver/Mysql.php, line 136 Cake\Database\Connection::prepare() - CORE/src/Database/Connection.php, line 221 Cake\Database\Connection::run() - CORE/src/Database/Connection.php, line 274 Cake\Database\Query::execute() - CORE/src/Database/Query.php, line 189 Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 958 Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276 Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 906 Cake\ORM\Association\HasMany::_buildResultMap() - CORE/src/ORM/Association/ExternalAssociationTrait.php, line 116 Cake\ORM\Association\HasMany::eagerLoader() - CORE/src/ORM/Association/SelectableAssociationTrait.php, line 49
Warning (2): count() [function.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 = 'epilog' $sql = 'SELECT `PropertyPics`.`id` AS `PropertyPics__id`, `PropertyPics`.`title` AS `PropertyPics__title`, `PropertyPics`.`sub_title` AS `PropertyPics__sub_title`, `PropertyPics`.`description` AS `PropertyPics__description`, `PropertyPics`.`order` AS `PropertyPics__order`, `PropertyPics`.`url` AS `PropertyPics__url`, `PropertyPics`.`url_title` AS `PropertyPics__url_title`, `PropertyPics`.`path` AS `PropertyPics__path`, `PropertyPics`.`property_id` AS `PropertyPics__property_id`, `PropertyPics`.`filename` AS `PropertyPics__filename`, `PropertyPics`.`webpath` AS `PropertyPics__webpath`, `PropertyPics`.`size` AS `PropertyPics__size`, `PropertyPics`.`small` AS `PropertyPics__small`, `PropertyPics`.`large` AS `PropertyPics__large`, `PropertyPics`.`original` AS `PropertyPics__original`, `PropertyPics`.`created` AS `PropertyPics__created`, `PropertyPics`.`modified` AS `PropertyPics__modified` FROM `re_property_pics` `PropertyPics` WHERE `PropertyPics`.`property_id` in (:c0)' $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' => [ 'PropertyPics__id' => 'integer', 'PropertyPics.id' => 'integer', 'id' => 'integer', 'PropertyPics__title' => 'string', 'PropertyPics.title' => 'string', 'title' => 'string', 'PropertyPics__sub_title' => 'string', 'PropertyPics.sub_title' => 'string', 'sub_title' => 'string', 'PropertyPics__description' => 'text', 'PropertyPics.description' => 'text', 'description' => 'text', 'PropertyPics__order' => 'integer', 'PropertyPics.order' => 'integer', 'order' => 'integer', 'PropertyPics__url' => 'string', 'PropertyPics.url' => 'string', 'url' => 'string', 'PropertyPics__url_title' => 'string', 'PropertyPics.url_title' => 'string', 'url_title' => 'string', 'PropertyPics__path' => 'text', 'PropertyPics.path' => 'text', 'path' => 'text', 'PropertyPics__property_id' => 'integer', 'PropertyPics.property_id' => 'integer', 'property_id' => 'integer', 'PropertyPics__filename' => 'string', 'PropertyPics.filename' => 'string', 'filename' => 'string', 'PropertyPics__webpath' => 'string', 'PropertyPics.webpath' => 'string', 'webpath' => 'string', 'PropertyPics__size' => 'integer', 'PropertyPics.size' => 'integer', 'size' => 'integer', 'PropertyPics__small' => 'string', 'PropertyPics.small' => 'string', 'small' => 'string', 'PropertyPics__large' => 'string', 'PropertyPics.large' => 'string', 'large' => 'string', 'PropertyPics__original' => 'string', 'PropertyPics.original' => 'string', 'original' => 'string', 'PropertyPics__created' => 'datetime', 'PropertyPics.created' => 'datetime', 'created' => 'datetime', 'PropertyPics__modified' => 'datetime', 'PropertyPics.modified' => 'datetime', 'modified' => 'datetime' ], 'decorators' => (int) 0, 'executed' => false, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [], 'matching' => [], 'extraOptions' => [], 'repository' => object(RealEstate\Model\Table\PropertyPicsTable) {} } $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 256 Cake\Database\QueryCompiler::compile() - CORE/src/Database/QueryCompiler.php, line 99 Cake\Database\Driver::compileQuery() - CORE/src/Database/Driver.php, line 333 Cake\Database\Connection::compileQuery() - CORE/src/Database/Connection.php, line 262 Cake\Database\Query::sql() - CORE/src/Database/Query.php, line 227 Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 937 Cake\Database\Driver\Mysql::prepare() - CORE/src/Database/Driver/Mysql.php, line 136 Cake\Database\Connection::prepare() - CORE/src/Database/Connection.php, line 221 Cake\Database\Connection::run() - CORE/src/Database/Connection.php, line 274 Cake\Database\Query::execute() - CORE/src/Database/Query.php, line 189 Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 958 Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276 Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 906 Cake\ORM\Association\HasMany::_buildResultMap() - CORE/src/ORM/Association/ExternalAssociationTrait.php, line 116 Cake\ORM\Association\HasMany::eagerLoader() - CORE/src/ORM/Association/SelectableAssociationTrait.php, line 49
Warning (2): count() [function.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 `Details`.`id` AS `Details__id`, `Details`.`title` AS `Details__title`, `Details`.`sub_title` AS `Details__sub_title`, `Details`.`body` AS `Details__body`, `Details`.`header_image_path` AS `Details__header_image_path`, `Details`.`meta_description` AS `Details__meta_description`, `Details`.`meta_keywords` AS `Details__meta_keywords`, `Details`.`model_table` AS `Details__model_table`, `Details`.`model_entity` AS `Details__model_entity`, `Details`.`plugin` AS `Details__plugin`, `Details`.`created` AS `Details__created`, `Details`.`modified` AS `Details__modified` FROM `plugin_intro_details` `Details` WHERE (`Details`.`plugin` = :c0 AND `Details`.`model_table` = :c1 AND `Details`.`model_entity` = :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' => [ 'Details__id' => 'integer', 'Details.id' => 'integer', 'id' => 'integer', 'Details__title' => 'string', 'Details.title' => 'string', 'title' => 'string', 'Details__sub_title' => 'string', 'Details.sub_title' => 'string', 'sub_title' => 'string', 'Details__body' => 'text', 'Details.body' => 'text', 'body' => 'text', 'Details__header_image_path' => 'string', 'Details.header_image_path' => 'string', 'header_image_path' => 'string', 'Details__meta_description' => 'text', 'Details.meta_description' => 'text', 'meta_description' => 'text', 'Details__meta_keywords' => 'text', 'Details.meta_keywords' => 'text', 'meta_keywords' => 'text', 'Details__model_table' => 'string', 'Details.model_table' => 'string', 'model_table' => 'string', 'Details__model_entity' => 'string', 'Details.model_entity' => 'string', 'model_entity' => 'string', 'Details__plugin' => 'string', 'Details.plugin' => 'string', 'plugin' => 'string', 'Details__created' => 'datetime', 'Details.created' => 'datetime', 'created' => 'datetime', 'Details__modified' => 'datetime', 'Details.modified' => 'datetime', 'modified' => 'datetime' ], 'decorators' => (int) 0, 'executed' => false, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [], 'matching' => [], 'extraOptions' => [], 'repository' => object(PluginIntro\Model\Table\DetailsTable) {} } $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 256 Cake\Database\QueryCompiler::compile() - CORE/src/Database/QueryCompiler.php, line 99 Cake\Database\Driver::compileQuery() - CORE/src/Database/Driver.php, line 333 Cake\Database\Connection::compileQuery() - CORE/src/Database/Connection.php, line 262 Cake\Database\Query::sql() - CORE/src/Database/Query.php, line 227 Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 937 Cake\Database\Driver\Mysql::prepare() - CORE/src/Database/Driver/Mysql.php, line 136 Cake\Database\Connection::prepare() - CORE/src/Database/Connection.php, line 221 Cake\Database\Connection::run() - CORE/src/Database/Connection.php, line 274 Cake\Database\Query::execute() - CORE/src/Database/Query.php, line 189 Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 958 Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276 Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 906 Cake\ORM\Query::first() - CORE/src/Datasource/QueryTrait.php, line 404 RealEstate\Controller\PropertiesController::view() - ROOT/plugins/RealEstate/src/Controller/PropertiesController.php, line 347
Warning (2): count() [function.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 = 'order' $sql = 'SELECT `Details`.`id` AS `Details__id`, `Details`.`title` AS `Details__title`, `Details`.`sub_title` AS `Details__sub_title`, `Details`.`body` AS `Details__body`, `Details`.`header_image_path` AS `Details__header_image_path`, `Details`.`meta_description` AS `Details__meta_description`, `Details`.`meta_keywords` AS `Details__meta_keywords`, `Details`.`model_table` AS `Details__model_table`, `Details`.`model_entity` AS `Details__model_entity`, `Details`.`plugin` AS `Details__plugin`, `Details`.`created` AS `Details__created`, `Details`.`modified` AS `Details__modified` FROM `plugin_intro_details` `Details` WHERE (`Details`.`plugin` = :c0 AND `Details`.`model_table` = :c1 AND `Details`.`model_entity` = :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' => [ 'Details__id' => 'integer', 'Details.id' => 'integer', 'id' => 'integer', 'Details__title' => 'string', 'Details.title' => 'string', 'title' => 'string', 'Details__sub_title' => 'string', 'Details.sub_title' => 'string', 'sub_title' => 'string', 'Details__body' => 'text', 'Details.body' => 'text', 'body' => 'text', 'Details__header_image_path' => 'string', 'Details.header_image_path' => 'string', 'header_image_path' => 'string', 'Details__meta_description' => 'text', 'Details.meta_description' => 'text', 'meta_description' => 'text', 'Details__meta_keywords' => 'text', 'Details.meta_keywords' => 'text', 'meta_keywords' => 'text', 'Details__model_table' => 'string', 'Details.model_table' => 'string', 'model_table' => 'string', 'Details__model_entity' => 'string', 'Details.model_entity' => 'string', 'model_entity' => 'string', 'Details__plugin' => 'string', 'Details.plugin' => 'string', 'plugin' => 'string', 'Details__created' => 'datetime', 'Details.created' => 'datetime', 'created' => 'datetime', 'Details__modified' => 'datetime', 'Details.modified' => 'datetime', 'modified' => 'datetime' ], 'decorators' => (int) 0, 'executed' => false, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [], 'matching' => [], 'extraOptions' => [], 'repository' => object(PluginIntro\Model\Table\DetailsTable) {} } $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 256 Cake\Database\QueryCompiler::compile() - CORE/src/Database/QueryCompiler.php, line 99 Cake\Database\Driver::compileQuery() - CORE/src/Database/Driver.php, line 333 Cake\Database\Connection::compileQuery() - CORE/src/Database/Connection.php, line 262 Cake\Database\Query::sql() - CORE/src/Database/Query.php, line 227 Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 937 Cake\Database\Driver\Mysql::prepare() - CORE/src/Database/Driver/Mysql.php, line 136 Cake\Database\Connection::prepare() - CORE/src/Database/Connection.php, line 221 Cake\Database\Connection::run() - CORE/src/Database/Connection.php, line 274 Cake\Database\Query::execute() - CORE/src/Database/Query.php, line 189 Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 958 Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276 Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 906 Cake\ORM\Query::first() - CORE/src/Datasource/QueryTrait.php, line 404 RealEstate\Controller\PropertiesController::view() - ROOT/plugins/RealEstate/src/Controller/PropertiesController.php, line 347
Warning (2): count() [function.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 = (int) 1 $name = 'limit' $sql = 'SELECT `Details`.`id` AS `Details__id`, `Details`.`title` AS `Details__title`, `Details`.`sub_title` AS `Details__sub_title`, `Details`.`body` AS `Details__body`, `Details`.`header_image_path` AS `Details__header_image_path`, `Details`.`meta_description` AS `Details__meta_description`, `Details`.`meta_keywords` AS `Details__meta_keywords`, `Details`.`model_table` AS `Details__model_table`, `Details`.`model_entity` AS `Details__model_entity`, `Details`.`plugin` AS `Details__plugin`, `Details`.`created` AS `Details__created`, `Details`.`modified` AS `Details__modified` FROM `plugin_intro_details` `Details` WHERE (`Details`.`plugin` = :c0 AND `Details`.`model_table` = :c1 AND `Details`.`model_entity` = :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' => [ 'Details__id' => 'integer', 'Details.id' => 'integer', 'id' => 'integer', 'Details__title' => 'string', 'Details.title' => 'string', 'title' => 'string', 'Details__sub_title' => 'string', 'Details.sub_title' => 'string', 'sub_title' => 'string', 'Details__body' => 'text', 'Details.body' => 'text', 'body' => 'text', 'Details__header_image_path' => 'string', 'Details.header_image_path' => 'string', 'header_image_path' => 'string', 'Details__meta_description' => 'text', 'Details.meta_description' => 'text', 'meta_description' => 'text', 'Details__meta_keywords' => 'text', 'Details.meta_keywords' => 'text', 'meta_keywords' => 'text', 'Details__model_table' => 'string', 'Details.model_table' => 'string', 'model_table' => 'string', 'Details__model_entity' => 'string', 'Details.model_entity' => 'string', 'model_entity' => 'string', 'Details__plugin' => 'string', 'Details.plugin' => 'string', 'plugin' => 'string', 'Details__created' => 'datetime', 'Details.created' => 'datetime', 'created' => 'datetime', 'Details__modified' => 'datetime', 'Details.modified' => 'datetime', 'modified' => 'datetime' ], 'decorators' => (int) 0, 'executed' => false, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [], 'matching' => [], 'extraOptions' => [], 'repository' => object(PluginIntro\Model\Table\DetailsTable) {} } $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 256 Cake\Database\QueryCompiler::compile() - CORE/src/Database/QueryCompiler.php, line 99 Cake\Database\Driver::compileQuery() - CORE/src/Database/Driver.php, line 333 Cake\Database\Connection::compileQuery() - CORE/src/Database/Connection.php, line 262 Cake\Database\Query::sql() - CORE/src/Database/Query.php, line 227 Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 937 Cake\Database\Driver\Mysql::prepare() - CORE/src/Database/Driver/Mysql.php, line 136 Cake\Database\Connection::prepare() - CORE/src/Database/Connection.php, line 221 Cake\Database\Connection::run() - CORE/src/Database/Connection.php, line 274 Cake\Database\Query::execute() - CORE/src/Database/Query.php, line 189 Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 958 Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276 Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 906 Cake\ORM\Query::first() - CORE/src/Datasource/QueryTrait.php, line 404 RealEstate\Controller\PropertiesController::view() - ROOT/plugins/RealEstate/src/Controller/PropertiesController.php, line 347
Warning (2): count() [function.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 = 'offset' $sql = 'SELECT `Details`.`id` AS `Details__id`, `Details`.`title` AS `Details__title`, `Details`.`sub_title` AS `Details__sub_title`, `Details`.`body` AS `Details__body`, `Details`.`header_image_path` AS `Details__header_image_path`, `Details`.`meta_description` AS `Details__meta_description`, `Details`.`meta_keywords` AS `Details__meta_keywords`, `Details`.`model_table` AS `Details__model_table`, `Details`.`model_entity` AS `Details__model_entity`, `Details`.`plugin` AS `Details__plugin`, `Details`.`created` AS `Details__created`, `Details`.`modified` AS `Details__modified` FROM `plugin_intro_details` `Details` WHERE (`Details`.`plugin` = :c0 AND `Details`.`model_table` = :c1 AND `Details`.`model_entity` = :c2) LIMIT 1' $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' => [ 'Details__id' => 'integer', 'Details.id' => 'integer', 'id' => 'integer', 'Details__title' => 'string', 'Details.title' => 'string', 'title' => 'string', 'Details__sub_title' => 'string', 'Details.sub_title' => 'string', 'sub_title' => 'string', 'Details__body' => 'text', 'Details.body' => 'text', 'body' => 'text', 'Details__header_image_path' => 'string', 'Details.header_image_path' => 'string', 'header_image_path' => 'string', 'Details__meta_description' => 'text', 'Details.meta_description' => 'text', 'meta_description' => 'text', 'Details__meta_keywords' => 'text', 'Details.meta_keywords' => 'text', 'meta_keywords' => 'text', 'Details__model_table' => 'string', 'Details.model_table' => 'string', 'model_table' => 'string', 'Details__model_entity' => 'string', 'Details.model_entity' => 'string', 'model_entity' => 'string', 'Details__plugin' => 'string', 'Details.plugin' => 'string', 'plugin' => 'string', 'Details__created' => 'datetime', 'Details.created' => 'datetime', 'created' => 'datetime', 'Details__modified' => 'datetime', 'Details.modified' => 'datetime', 'modified' => 'datetime' ], 'decorators' => (int) 0, 'executed' => false, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [], 'matching' => [], 'extraOptions' => [], 'repository' => object(PluginIntro\Model\Table\DetailsTable) {} } $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 256 Cake\Database\QueryCompiler::compile() - CORE/src/Database/QueryCompiler.php, line 99 Cake\Database\Driver::compileQuery() - CORE/src/Database/Driver.php, line 333 Cake\Database\Connection::compileQuery() - CORE/src/Database/Connection.php, line 262 Cake\Database\Query::sql() - CORE/src/Database/Query.php, line 227 Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 937 Cake\Database\Driver\Mysql::prepare() - CORE/src/Database/Driver/Mysql.php, line 136 Cake\Database\Connection::prepare() - CORE/src/Database/Connection.php, line 221 Cake\Database\Connection::run() - CORE/src/Database/Connection.php, line 274 Cake\Database\Query::execute() - CORE/src/Database/Query.php, line 189 Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 958 Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276 Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 906 Cake\ORM\Query::first() - CORE/src/Datasource/QueryTrait.php, line 404 RealEstate\Controller\PropertiesController::view() - ROOT/plugins/RealEstate/src/Controller/PropertiesController.php, line 347
Warning (2): count() [function.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 = 'epilog' $sql = 'SELECT `Details`.`id` AS `Details__id`, `Details`.`title` AS `Details__title`, `Details`.`sub_title` AS `Details__sub_title`, `Details`.`body` AS `Details__body`, `Details`.`header_image_path` AS `Details__header_image_path`, `Details`.`meta_description` AS `Details__meta_description`, `Details`.`meta_keywords` AS `Details__meta_keywords`, `Details`.`model_table` AS `Details__model_table`, `Details`.`model_entity` AS `Details__model_entity`, `Details`.`plugin` AS `Details__plugin`, `Details`.`created` AS `Details__created`, `Details`.`modified` AS `Details__modified` FROM `plugin_intro_details` `Details` WHERE (`Details`.`plugin` = :c0 AND `Details`.`model_table` = :c1 AND `Details`.`model_entity` = :c2) LIMIT 1' $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' => [ 'Details__id' => 'integer', 'Details.id' => 'integer', 'id' => 'integer', 'Details__title' => 'string', 'Details.title' => 'string', 'title' => 'string', 'Details__sub_title' => 'string', 'Details.sub_title' => 'string', 'sub_title' => 'string', 'Details__body' => 'text', 'Details.body' => 'text', 'body' => 'text', 'Details__header_image_path' => 'string', 'Details.header_image_path' => 'string', 'header_image_path' => 'string', 'Details__meta_description' => 'text', 'Details.meta_description' => 'text', 'meta_description' => 'text', 'Details__meta_keywords' => 'text', 'Details.meta_keywords' => 'text', 'meta_keywords' => 'text', 'Details__model_table' => 'string', 'Details.model_table' => 'string', 'model_table' => 'string', 'Details__model_entity' => 'string', 'Details.model_entity' => 'string', 'model_entity' => 'string', 'Details__plugin' => 'string', 'Details.plugin' => 'string', 'plugin' => 'string', 'Details__created' => 'datetime', 'Details.created' => 'datetime', 'created' => 'datetime', 'Details__modified' => 'datetime', 'Details.modified' => 'datetime', 'modified' => 'datetime' ], 'decorators' => (int) 0, 'executed' => false, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [], 'matching' => [], 'extraOptions' => [], 'repository' => object(PluginIntro\Model\Table\DetailsTable) {} } $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 256 Cake\Database\QueryCompiler::compile() - CORE/src/Database/QueryCompiler.php, line 99 Cake\Database\Driver::compileQuery() - CORE/src/Database/Driver.php, line 333 Cake\Database\Connection::compileQuery() - CORE/src/Database/Connection.php, line 262 Cake\Database\Query::sql() - CORE/src/Database/Query.php, line 227 Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 937 Cake\Database\Driver\Mysql::prepare() - CORE/src/Database/Driver/Mysql.php, line 136 Cake\Database\Connection::prepare() - CORE/src/Database/Connection.php, line 221 Cake\Database\Connection::run() - CORE/src/Database/Connection.php, line 274 Cake\Database\Query::execute() - CORE/src/Database/Query.php, line 189 Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 958 Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276 Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 906 Cake\ORM\Query::first() - CORE/src/Datasource/QueryTrait.php, line 404 RealEstate\Controller\PropertiesController::view() - ROOT/plugins/RealEstate/src/Controller/PropertiesController.php, line 347
Warning (512): Unable to emit headers. Headers sent in file=/home/hippoagency/public_html/vendor/cakephp/cakephp/src/Error/Debugger.php line=753 [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(Zend\Diactoros\Response) { [protected] headers => [ 'Content-Type' => [ [maximum depth reached] ] ] [protected] headerNames => [ 'content-type' => 'Content-Type' ] [private] phrases => [ (int) 100 => 'Continue', (int) 101 => 'Switching Protocols', (int) 102 => 'Processing', (int) 200 => 'OK', (int) 201 => 'Created', (int) 202 => 'Accepted', (int) 203 => 'Non-Authoritative Information', (int) 204 => 'No Content', (int) 205 => 'Reset Content', (int) 206 => 'Partial Content', (int) 207 => 'Multi-status', (int) 208 => 'Already Reported', (int) 226 => 'IM used', (int) 300 => 'Multiple Choices', (int) 301 => 'Moved Permanently', (int) 302 => 'Found', (int) 303 => 'See Other', (int) 304 => 'Not Modified', (int) 305 => 'Use Proxy', (int) 306 => 'Switch Proxy', (int) 307 => 'Temporary Redirect', (int) 308 => 'Permanent Redirect', (int) 400 => 'Bad Request', (int) 401 => 'Unauthorized', (int) 402 => 'Payment Required', (int) 403 => 'Forbidden', (int) 404 => 'Not Found', (int) 405 => 'Method Not Allowed', (int) 406 => 'Not Acceptable', (int) 407 => 'Proxy Authentication Required', (int) 408 => 'Request Time-out', (int) 409 => 'Conflict', (int) 410 => 'Gone', (int) 411 => 'Length Required', (int) 412 => 'Precondition Failed', (int) 413 => 'Request Entity Too Large', (int) 414 => 'Request-URI Too Large', (int) 415 => 'Unsupported Media Type', (int) 416 => 'Requested range not satisfiable', (int) 417 => 'Expectation Failed', (int) 418 => 'I'm a teapot', (int) 421 => 'Misdirected Request', (int) 422 => 'Unprocessable Entity', (int) 423 => 'Locked', (int) 424 => 'Failed Dependency', (int) 425 => 'Unordered Collection', (int) 426 => 'Upgrade Required', (int) 428 => 'Precondition Required', (int) 429 => 'Too Many Requests', (int) 431 => 'Request Header Fields Too Large', (int) 444 => 'Connection Closed Without Response', (int) 451 => 'Unavailable For Legal Reasons', (int) 499 => 'Client Closed Request', (int) 500 => 'Internal Server Error', (int) 501 => 'Not Implemented', (int) 502 => 'Bad Gateway', (int) 503 => 'Service Unavailable', (int) 504 => 'Gateway Time-out', (int) 505 => 'HTTP Version not supported', (int) 506 => 'Variant Also Negotiates', (int) 507 => 'Insufficient Storage', (int) 508 => 'Loop Detected', (int) 510 => 'Not Extended', (int) 511 => 'Network Authentication Required', (int) 599 => 'Network Connect Timeout Error' ] [private] reasonPhrase => '' [private] statusCode => (int) 200 [private] protocol => '1.1' [private] stream => object(Zend\Diactoros\Stream) {} } $maxBufferLength = (int) 8192 $file = '/home/hippoagency/public_html/vendor/cakephp/cakephp/src/Error/Debugger.php' $line = (int) 753 $message = 'Unable to emit headers. Headers sent in file=/home/hippoagency/public_html/vendor/cakephp/cakephp/src/Error/Debugger.php line=753'Cake\Http\ResponseEmitter::emit() - CORE/src/Http/ResponseEmitter.php, line 48 Cake\Http\Server::emit() - CORE/src/Http/Server.php, line 118 [main] - ROOT/webroot/index.php, line 37
Warning (2): Cannot modify header information - headers already sent by (output started at /home/hippoagency/public_html/vendor/cakephp/cakephp/src/Error/Debugger.php:753) [CORE/src/Http/ResponseEmitter.php, line 145]Code Context$response->getProtocolVersion(),$response->getStatusCode(),($reasonPhrase ? ' ' . $reasonPhrase : '')$response = object(Zend\Diactoros\Response) { [protected] headers => [ 'Content-Type' => [ [maximum depth reached] ] ] [protected] headerNames => [ 'content-type' => 'Content-Type' ] [private] phrases => [ (int) 100 => 'Continue', (int) 101 => 'Switching Protocols', (int) 102 => 'Processing', (int) 200 => 'OK', (int) 201 => 'Created', (int) 202 => 'Accepted', (int) 203 => 'Non-Authoritative Information', (int) 204 => 'No Content', (int) 205 => 'Reset Content', (int) 206 => 'Partial Content', (int) 207 => 'Multi-status', (int) 208 => 'Already Reported', (int) 226 => 'IM used', (int) 300 => 'Multiple Choices', (int) 301 => 'Moved Permanently', (int) 302 => 'Found', (int) 303 => 'See Other', (int) 304 => 'Not Modified', (int) 305 => 'Use Proxy', (int) 306 => 'Switch Proxy', (int) 307 => 'Temporary Redirect', (int) 308 => 'Permanent Redirect', (int) 400 => 'Bad Request', (int) 401 => 'Unauthorized', (int) 402 => 'Payment Required', (int) 403 => 'Forbidden', (int) 404 => 'Not Found', (int) 405 => 'Method Not Allowed', (int) 406 => 'Not Acceptable', (int) 407 => 'Proxy Authentication Required', (int) 408 => 'Request Time-out', (int) 409 => 'Conflict', (int) 410 => 'Gone', (int) 411 => 'Length Required', (int) 412 => 'Precondition Failed', (int) 413 => 'Request Entity Too Large', (int) 414 => 'Request-URI Too Large', (int) 415 => 'Unsupported Media Type', (int) 416 => 'Requested range not satisfiable', (int) 417 => 'Expectation Failed', (int) 418 => 'I'm a teapot', (int) 421 => 'Misdirected Request', (int) 422 => 'Unprocessable Entity', (int) 423 => 'Locked', (int) 424 => 'Failed Dependency', (int) 425 => 'Unordered Collection', (int) 426 => 'Upgrade Required', (int) 428 => 'Precondition Required', (int) 429 => 'Too Many Requests', (int) 431 => 'Request Header Fields Too Large', (int) 444 => 'Connection Closed Without Response', (int) 451 => 'Unavailable For Legal Reasons', (int) 499 => 'Client Closed Request', (int) 500 => 'Internal Server Error', (int) 501 => 'Not Implemented', (int) 502 => 'Bad Gateway', (int) 503 => 'Service Unavailable', (int) 504 => 'Gateway Time-out', (int) 505 => 'HTTP Version not supported', (int) 506 => 'Variant Also Negotiates', (int) 507 => 'Insufficient Storage', (int) 508 => 'Loop Detected', (int) 510 => 'Not Extended', (int) 511 => 'Network Authentication Required', (int) 599 => 'Network Connect Timeout Error' ] [private] reasonPhrase => 'OK' [private] statusCode => (int) 200 [private] protocol => '1.1' [private] stream => object(Zend\Diactoros\Stream) {} } $reasonPhrase = 'OK'header - [internal], line ?? Cake\Http\ResponseEmitter::emitStatusLine() - CORE/src/Http/ResponseEmitter.php, line 145 Cake\Http\ResponseEmitter::emit() - CORE/src/Http/ResponseEmitter.php, line 54 Cake\Http\Server::emit() - CORE/src/Http/Server.php, line 118 [main] - ROOT/webroot/index.php, line 37
Warning (2): Cannot modify header information - headers already sent by (output started at /home/hippoagency/public_html/vendor/cakephp/cakephp/src/Error/Debugger.php:753) [CORE/src/Http/ResponseEmitter.php, line 173]Code Context$name,$value), $first);$response = object(Zend\Diactoros\Response) { [protected] headers => [ 'Content-Type' => [ [maximum depth reached] ] ] [protected] headerNames => [ 'content-type' => 'Content-Type' ] [private] phrases => [ (int) 100 => 'Continue', (int) 101 => 'Switching Protocols', (int) 102 => 'Processing', (int) 200 => 'OK', (int) 201 => 'Created', (int) 202 => 'Accepted', (int) 203 => 'Non-Authoritative Information', (int) 204 => 'No Content', (int) 205 => 'Reset Content', (int) 206 => 'Partial Content', (int) 207 => 'Multi-status', (int) 208 => 'Already Reported', (int) 226 => 'IM used', (int) 300 => 'Multiple Choices', (int) 301 => 'Moved Permanently', (int) 302 => 'Found', (int) 303 => 'See Other', (int) 304 => 'Not Modified', (int) 305 => 'Use Proxy', (int) 306 => 'Switch Proxy', (int) 307 => 'Temporary Redirect', (int) 308 => 'Permanent Redirect', (int) 400 => 'Bad Request', (int) 401 => 'Unauthorized', (int) 402 => 'Payment Required', (int) 403 => 'Forbidden', (int) 404 => 'Not Found', (int) 405 => 'Method Not Allowed', (int) 406 => 'Not Acceptable', (int) 407 => 'Proxy Authentication Required', (int) 408 => 'Request Time-out', (int) 409 => 'Conflict', (int) 410 => 'Gone', (int) 411 => 'Length Required', (int) 412 => 'Precondition Failed', (int) 413 => 'Request Entity Too Large', (int) 414 => 'Request-URI Too Large', (int) 415 => 'Unsupported Media Type', (int) 416 => 'Requested range not satisfiable', (int) 417 => 'Expectation Failed', (int) 418 => 'I'm a teapot', (int) 421 => 'Misdirected Request', (int) 422 => 'Unprocessable Entity', (int) 423 => 'Locked', (int) 424 => 'Failed Dependency', (int) 425 => 'Unordered Collection', (int) 426 => 'Upgrade Required', (int) 428 => 'Precondition Required', (int) 429 => 'Too Many Requests', (int) 431 => 'Request Header Fields Too Large', (int) 444 => 'Connection Closed Without Response', (int) 451 => 'Unavailable For Legal Reasons', (int) 499 => 'Client Closed Request', (int) 500 => 'Internal Server Error', (int) 501 => 'Not Implemented', (int) 502 => 'Bad Gateway', (int) 503 => 'Service Unavailable', (int) 504 => 'Gateway Time-out', (int) 505 => 'HTTP Version not supported', (int) 506 => 'Variant Also Negotiates', (int) 507 => 'Insufficient Storage', (int) 508 => 'Loop Detected', (int) 510 => 'Not Extended', (int) 511 => 'Network Authentication Required', (int) 599 => 'Network Connect Timeout Error' ] [private] reasonPhrase => 'OK' [private] statusCode => (int) 200 [private] protocol => '1.1' [private] stream => object(Zend\Diactoros\Stream) {} } $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 173 Cake\Http\ResponseEmitter::emit() - CORE/src/Http/ResponseEmitter.php, line 55 Cake\Http\Server::emit() - CORE/src/Http/Server.php, line 118 [main] - ROOT/webroot/index.php, line 37
Two story, three apartments.
