Warning (2): count() [function.count]: Parameter must be an array or an object that implements Countable [CORE/src/Database/QueryCompiler.php, line 128]
{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`.`enabled` = :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'
],
'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]]
],
'matching' => [],
'extraOptions' => [
'scope' => null,
'whitelist' => [
[maximum depth reached]
]
],
'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\Controller\Component\PaginatorComponent::paginate() - CORE/src/Controller/Component/PaginatorComponent.php, line 189
Cake\Controller\Controller::paginate() - CORE/src/Controller/Controller.php, line 713
Warning (2): count() [function.count]: Parameter must be an array or an object that implements Countable [CORE/src/Database/QueryCompiler.php, line 128]
{return function ($parts, $name) use (&$sql, $query, $generator) {if (!count($parts)) {
$parts = (int) 20
$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`.`enabled` = :c0 ORDER BY `Properties`.`title` ASC'
$query = object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SQL could not be generated for this query as it is incomplete.',
'params' => [],
'defaultTypes' => [
'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'
],
'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]]
],
'matching' => [],
'extraOptions' => [
'scope' => null,
'whitelist' => [
[maximum depth reached]
]
],
'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\Controller\Component\PaginatorComponent::paginate() - CORE/src/Controller/Component/PaginatorComponent.php, line 189
Cake\Controller\Controller::paginate() - CORE/src/Controller/Controller.php, line 713
Warning (2): count() [function.count]: Parameter must be an array or an object that implements Countable [CORE/src/Database/QueryCompiler.php, line 128]
{return function ($parts, $name) use (&$sql, $query, $generator) {if (!count($parts)) {
$parts = (int) 0
$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`.`enabled` = :c0 ORDER BY `Properties`.`title` ASC LIMIT 20'
$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'
],
'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]]
],
'matching' => [],
'extraOptions' => [
'scope' => null,
'whitelist' => [
[maximum depth reached]
]
],
'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\Controller\Component\PaginatorComponent::paginate() - CORE/src/Controller/Component/PaginatorComponent.php, line 189
Cake\Controller\Controller::paginate() - CORE/src/Controller/Controller.php, line 713
Warning (2): count() [function.count]: Parameter must be an array or an object that implements Countable [CORE/src/Database/QueryCompiler.php, line 128]
{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`.`enabled` = :c0 ORDER BY `Properties`.`title` ASC LIMIT 20 OFFSET 0'
$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'
],
'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]]
],
'matching' => [],
'extraOptions' => [
'scope' => null,
'whitelist' => [
[maximum depth reached]
]
],
'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\Controller\Component\PaginatorComponent::paginate() - CORE/src/Controller/Component/PaginatorComponent.php, line 189
Cake\Controller\Controller::paginate() - CORE/src/Controller/Controller.php, line 713
Warning (2): count() [function.count]: Parameter must be an array or an object that implements Countable [CORE/src/Database/QueryCompiler.php, line 128]
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::_performCount() - CORE/src/ORM/Query.php, line 818
Cake\ORM\Query::count() - CORE/src/ORM/Query.php, line 768
Cake\Controller\Component\PaginatorComponent::paginate() - CORE/src/Controller/Component/PaginatorComponent.php, line 191
Cake\Controller\Controller::paginate() - CORE/src/Controller/Controller.php, line 713
RealEstate\Controller\PropertiesController::index() - ROOT/plugins/RealEstate/src/Controller/PropertiesController.php, line 258
Warning (2): count() [function.count]: Parameter must be an array or an object that implements Countable [CORE/src/Database/QueryCompiler.php, line 128]
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::_performCount() - CORE/src/ORM/Query.php, line 818
Cake\ORM\Query::count() - CORE/src/ORM/Query.php, line 768
Cake\Controller\Component\PaginatorComponent::paginate() - CORE/src/Controller/Component/PaginatorComponent.php, line 191
Cake\Controller\Controller::paginate() - CORE/src/Controller/Controller.php, line 713
RealEstate\Controller\PropertiesController::index() - ROOT/plugins/RealEstate/src/Controller/PropertiesController.php, line 258
Warning (2): count() [function.count]: Parameter must be an array or an object that implements Countable [CORE/src/Database/QueryCompiler.php, line 128]
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::_performCount() - CORE/src/ORM/Query.php, line 818
Cake\ORM\Query::count() - CORE/src/ORM/Query.php, line 768
Cake\Controller\Component\PaginatorComponent::paginate() - CORE/src/Controller/Component/PaginatorComponent.php, line 191
Cake\Controller\Controller::paginate() - CORE/src/Controller/Controller.php, line 713
RealEstate\Controller\PropertiesController::index() - ROOT/plugins/RealEstate/src/Controller/PropertiesController.php, line 258
Warning (2): count() [function.count]: Parameter must be an array or an object that implements Countable [CORE/src/Database/QueryCompiler.php, line 128]
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::_performCount() - CORE/src/ORM/Query.php, line 818
Cake\ORM\Query::count() - CORE/src/ORM/Query.php, line 768
Cake\Controller\Component\PaginatorComponent::paginate() - CORE/src/Controller/Component/PaginatorComponent.php, line 191
Cake\Controller\Controller::paginate() - CORE/src/Controller/Controller.php, line 713
RealEstate\Controller\PropertiesController::index() - ROOT/plugins/RealEstate/src/Controller/PropertiesController.php, line 258
Warning (2): count() [function.count]: Parameter must be an array or an object that implements Countable [CORE/src/Database/QueryCompiler.php, line 128]
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::_performCount() - CORE/src/ORM/Query.php, line 818
Cake\ORM\Query::count() - CORE/src/ORM/Query.php, line 768
Cake\Controller\Component\PaginatorComponent::paginate() - CORE/src/Controller/Component/PaginatorComponent.php, line 191
Cake\Controller\Controller::paginate() - CORE/src/Controller/Controller.php, line 713
RealEstate\Controller\PropertiesController::index() - ROOT/plugins/RealEstate/src/Controller/PropertiesController.php, line 258
Notice (8): Undefined index: `count` [CORE/src/Database/FieldTypeConverter.php, line 78]
Cake\Database\FieldTypeConverter::__invoke() - CORE/src/Database/FieldTypeConverter.php, line 78
Cake\Database\Statement\CallbackStatement::fetch() - CORE/src/Database/Statement/CallbackStatement.php, line 59
Cake\ORM\Query::_performCount() - CORE/src/ORM/Query.php, line 826
Cake\ORM\Query::count() - CORE/src/ORM/Query.php, line 768
Cake\Controller\Component\PaginatorComponent::paginate() - CORE/src/Controller/Component/PaginatorComponent.php, line 191
Cake\Controller\Controller::paginate() - CORE/src/Controller/Controller.php, line 713
RealEstate\Controller\PropertiesController::index() - ROOT/plugins/RealEstate/src/Controller/PropertiesController.php, line 258
Cake\Controller\Controller::invokeAction() - CORE/src/Controller/Controller.php, line 435
Cake\Http\ActionDispatcher::_invoke() - CORE/src/Http/ActionDispatcher.php, line 122
Cake\Http\ActionDispatcher::dispatch() - CORE/src/Http/ActionDispatcher.php, line 96
Cake\Http\BaseApplication::__invoke() - CORE/src/Http/BaseApplication.php, line 83
Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65
Cake\Routing\Middleware\RoutingMiddleware::__invoke() - CORE/src/Routing/Middleware/RoutingMiddleware.php, line 62
Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65
Cake\Routing\Middleware\AssetMiddleware::__invoke() - CORE/src/Routing/Middleware/AssetMiddleware.php, line 88
Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65
Warning (2): count() [function.count]: Parameter must be an array or an object that implements Countable [CORE/src/Database/QueryCompiler.php, line 128]
{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::index() - ROOT/plugins/RealEstate/src/Controller/PropertiesController.php, line 294
Warning (2): count() [function.count]: Parameter must be an array or an object that implements Countable [CORE/src/Database/QueryCompiler.php, line 128]
{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::index() - ROOT/plugins/RealEstate/src/Controller/PropertiesController.php, line 294
Warning (2): count() [function.count]: Parameter must be an array or an object that implements Countable [CORE/src/Database/QueryCompiler.php, line 128]
{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::index() - ROOT/plugins/RealEstate/src/Controller/PropertiesController.php, line 294
Warning (2): count() [function.count]: Parameter must be an array or an object that implements Countable [CORE/src/Database/QueryCompiler.php, line 128]
{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::index() - ROOT/plugins/RealEstate/src/Controller/PropertiesController.php, line 294
Warning (2): count() [function.count]: Parameter must be an array or an object that implements Countable [CORE/src/Database/QueryCompiler.php, line 128]
{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::index() - ROOT/plugins/RealEstate/src/Controller/PropertiesController.php, line 294
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]
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]
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]
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
Properties | Hippolytes Agencies & Services Ltd.:
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form
Real Estate Agent
Real Estate Services are provided under Zenith Investments. Emma Hippolyte has over thirty years’ experience in: Construction of homes and Commercial buildings, property rentals and management.; having overseen the building and repairs of many homes in Soufriere and Castries. We can be reached at www.zenithinvestmentproperties.com or 1 (758) 584-7826 or emmahippolyte@yahoo.com for property sales, property management and/or rentals.
