Warning (2)CORE/src/Database/QueryCompiler.php , line 128 ]Code Context { return function ( $parts , $name ) use (& $sql , $query , $generator ) { if (! count ( $parts )) { $parts = null
$name = 'having'
$sql = 'SELECT Products.category_id AS `Products__category_id` FROM products Products WHERE (Products.unpublished = :c0 AND Products.visibility <> :c1 AND Products.clearance = :c2) GROUP BY category_id '
$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' => [
'Products__id' => 'integer',
'Products.id' => 'integer',
'id' => 'integer',
'Products__eid' => 'integer',
'Products.eid' => 'integer',
'eid' => 'integer',
'Products__product_sku' => 'string',
'Products.product_sku' => 'string',
'product_sku' => 'string',
'Products__product_mpn' => 'string',
'Products.product_mpn' => 'string',
'product_mpn' => 'string',
'Products__product_upc' => 'string',
'Products.product_upc' => 'string',
'product_upc' => 'string',
'Products__product_title' => 'string',
'Products.product_title' => 'string',
'product_title' => 'string',
'Products__adword_title' => 'string',
'Products.adword_title' => 'string',
'adword_title' => 'string',
'Products__search_suggestion' => 'text',
'Products.search_suggestion' => 'text',
'search_suggestion' => 'text',
'Products__surl' => 'string',
'Products.surl' => 'string',
'surl' => 'string',
'Products__serial_id' => 'integer',
'Products.serial_id' => 'integer',
'serial_id' => 'integer',
'Products__color_id' => 'integer',
'Products.color_id' => 'integer',
'color_id' => 'integer',
'Products__manufacturer_id' => 'integer',
'Products.manufacturer_id' => 'integer',
'manufacturer_id' => 'integer',
'Products__category_id' => 'integer',
'Products.category_id' => 'integer',
'category_id' => 'integer',
'Products__short_description' => 'string',
'Products.short_description' => 'string',
'short_description' => 'string',
'Products__long_description' => 'text',
'Products.long_description' => 'text',
'long_description' => 'text',
'Products__product_length' => 'string',
'Products.product_length' => 'string',
'product_length' => 'string',
'Products__product_width' => 'string',
'Products.product_width' => 'string',
'product_width' => 'string',
'Products__product_height' => 'string',
'Products.product_height' => 'string',
'product_height' => 'string',
'Products__product_weight' => 'float',
'Products.product_weight' => 'float',
'product_weight' => 'float',
'Products__size' => 'string',
'Products.size' => 'string',
'size' => 'string',
'Products__product_stock' => 'integer',
'Products.product_stock' => 'integer',
'product_stock' => 'integer',
'Products__save_tax' => 'boolean',
'Products.save_tax' => 'boolean',
'save_tax' => 'boolean',
'Products__msrp' => 'float',
'Products.msrp' => 'float',
'msrp' => 'float',
'Products__map' => 'float',
'Products.map' => 'float',
'map' => 'float',
'Products__future_price1' => 'float',
'Products.future_price1' => 'float',
'future_price1' => 'float',
'Products__future_price2' => 'float',
'Products.future_price2' => 'float',
'future_price2' => 'float',
'Products__active_price' => 'float',
'Products.active_price' => 'float',
'active_price' => 'float',
'Products__future_price1_start' => 'string',
'Products.future_price1_start' => 'string',
'future_price1_start' => 'string',
'Products__future_price1_end' => 'string',
'Products.future_price1_end' => 'string',
'future_price1_end' => 'string',
'Products__future_price2_start' => 'string',
'Products.future_price2_start' => 'string',
'future_price2_start' => 'string',
'Products__future_price2_end' => 'string',
'Products.future_price2_end' => 'string',
'future_price2_end' => 'string',
'Products__msrp2' => 'float',
'Products.msrp2' => 'float',
'msrp2' => 'float',
'Products__msrp2_start' => 'string',
'Products.msrp2_start' => 'string',
'msrp2_start' => 'string',
'Products__msrp2_end' => 'string',
'Products.msrp2_end' => 'string',
'msrp2_end' => 'string',
'Products__price_display' => 'boolean',
'Products.price_display' => 'boolean',
'price_display' => 'boolean',
'Products__tax_id' => 'integer',
'Products.tax_id' => 'integer',
'tax_id' => 'integer',
'Products__ehf_id' => 'integer',
'Products.ehf_id' => 'integer',
'ehf_id' => 'integer',
'Products__unpublished' => 'boolean',
'Products.unpublished' => 'boolean',
'unpublished' => 'boolean',
'Products__get_a_quote_or_add_to_cart' => 'integer',
'Products.get_a_quote_or_add_to_cart' => 'integer',
'get_a_quote_or_add_to_cart' => 'integer',
'Products__discontinued' => 'boolean',
'Products.discontinued' => 'boolean',
'discontinued' => 'boolean',
'Products__new_model' => 'string',
'Products.new_model' => 'string',
'new_model' => 'string',
'Products__meta_description' => 'text',
'Products.meta_description' => 'text',
'meta_description' => 'text',
'Products__meta_title' => 'string',
'Products.meta_title' => 'string',
'meta_title' => 'string',
'Products__meta_keywords' => 'string',
'Products.meta_keywords' => 'string',
'meta_keywords' => 'string',
'Products__created' => 'datetime',
'Products.created' => 'datetime',
'created' => 'datetime',
'Products__modified' => 'datetime',
'Products.modified' => 'datetime',
'modified' => 'datetime',
'Products__shipping_id' => 'integer',
'Products.shipping_id' => 'integer',
'shipping_id' => 'integer',
'Products__productwarranty_id' => 'integer',
'Products.productwarranty_id' => 'integer',
'productwarranty_id' => 'integer',
'Products__no_of_clicks' => 'integer',
'Products.no_of_clicks' => 'integer',
'no_of_clicks' => 'integer',
'Products__temp_var' => 'integer',
'Products.temp_var' => 'integer',
'temp_var' => 'integer',
'Products__not_update_by_script' => 'boolean',
'Products.not_update_by_script' => 'boolean',
'not_update_by_script' => 'boolean',
'Products__visibility' => 'integer',
'Products.visibility' => 'integer',
'visibility' => 'integer',
'Products__cnet_code' => 'text',
'Products.cnet_code' => 'text',
'cnet_code' => 'text',
'Products__free_shipping' => 'boolean',
'Products.free_shipping' => 'boolean',
'free_shipping' => 'boolean',
'Products__clearance' => 'boolean',
'Products.clearance' => 'boolean',
'clearance' => 'boolean',
'Products__in_store_special' => 'boolean',
'Products.in_store_special' => 'boolean',
'in_store_special' => 'boolean',
'Products__staff_pick' => 'boolean',
'Products.staff_pick' => 'boolean',
'staff_pick' => 'boolean',
'Products__limited_stock' => 'boolean',
'Products.limited_stock' => 'boolean',
'limited_stock' => 'boolean',
'Products__in_flyer' => 'boolean',
'Products.in_flyer' => 'boolean',
'in_flyer' => 'boolean',
'Products__ehfcategory_id' => 'integer',
'Products.ehfcategory_id' => 'integer',
'ehfcategory_id' => 'integer',
'Products__display_model' => 'boolean',
'Products.display_model' => 'boolean',
'display_model' => 'boolean',
'Products__vimeo_videoid' => 'string',
'Products.vimeo_videoid' => 'string',
'vimeo_videoid' => 'string',
'Products__youtube_video' => 'text',
'Products.youtube_video' => 'text',
'youtube_video' => 'text',
'Products__top_on_category' => 'boolean',
'Products.top_on_category' => 'boolean',
'top_on_category' => 'boolean',
'Products__new' => 'boolean',
'Products.new' => 'boolean',
'new' => 'boolean',
'Products__active_current_promo' => 'boolean',
'Products.active_current_promo' => 'boolean',
'active_current_promo' => 'boolean',
'Products__open_box' => 'boolean',
'Products.open_box' => 'boolean',
'open_box' => 'boolean',
'Products__pair' => 'boolean',
'Products.pair' => 'boolean',
'pair' => 'boolean',
'Products__used' => 'boolean',
'Products.used' => 'boolean',
'used' => 'boolean',
'Products__no_stand' => 'boolean',
'Products.no_stand' => 'boolean',
'no_stand' => 'boolean',
'Products__box_damage' => 'boolean',
'Products.box_damage' => 'boolean',
'box_damage' => 'boolean',
'Products__price_updated_date' => 'string',
'Products.price_updated_date' => 'string',
'price_updated_date' => 'string',
'Products__home_top_picks' => 'boolean',
'Products.home_top_picks' => 'boolean',
'home_top_picks' => 'boolean',
'Products__feature_1' => 'string',
'Products.feature_1' => 'string',
'feature_1' => 'string',
'Products__feature_2' => 'string',
'Products.feature_2' => 'string',
'feature_2' => 'string',
'Products__feature_3' => 'string',
'Products.feature_3' => 'string',
'feature_3' => 'string',
'Products__feature_4' => 'string',
'Products.feature_4' => 'string',
'feature_4' => 'string',
'Products__product_info_incomplete' => 'boolean',
'Products.product_info_incomplete' => 'boolean',
'product_info_incomplete' => 'boolean',
'Products__product_info_incomplete_details' => 'text',
'Products.product_info_incomplete_details' => 'text',
'product_info_incomplete_details' => 'text',
'Products__show_bundle_savings' => 'boolean',
'Products.show_bundle_savings' => 'boolean',
'show_bundle_savings' => 'boolean',
'Products__clearance_price' => 'float',
'Products.clearance_price' => 'float',
'clearance_price' => 'float',
'Products__warranty_label' => 'integer',
'Products.warranty_label' => 'integer',
'warranty_label' => 'integer',
'Products__clearance_message' => 'string',
'Products.clearance_message' => 'string',
'clearance_message' => 'string',
'Products__size_category' => 'string',
'Products.size_category' => 'string',
'size_category' => 'string',
'Products__atc_flag' => 'boolean',
'Products.atc_flag' => 'boolean',
'atc_flag' => 'boolean',
'Products__pdf_available' => 'boolean',
'Products.pdf_available' => 'boolean',
'pdf_available' => 'boolean',
'Products__free_warranty' => 'boolean',
'Products.free_warranty' => 'boolean',
'free_warranty' => 'boolean',
'Products__online_only' => 'boolean',
'Products.online_only' => 'boolean',
'online_only' => 'boolean',
'Products__coming_soon' => 'boolean',
'Products.coming_soon' => 'boolean',
'coming_soon' => 'boolean',
'Products__ontario_energy_savings_rebate' => 'boolean',
'Products.ontario_energy_savings_rebate' => 'boolean',
'ontario_energy_savings_rebate' => 'boolean',
'Products__special' => 'boolean',
'Products.special' => 'boolean',
'special' => 'boolean',
'Products__do_not_apply_warranty' => 'boolean',
'Products.do_not_apply_warranty' => 'boolean',
'do_not_apply_warranty' => 'boolean',
'Products__style_type' => 'string',
'Products.style_type' => 'string',
'style_type' => 'string',
'Products__temporarily_unavailable' => 'boolean',
'Products.temporarily_unavailable' => 'boolean',
'temporarily_unavailable' => 'boolean'
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 1,
'mapReducers' => (int) 0,
'contain' => [],
'matching' => [],
'extraOptions' => [
'keyField' => 'category_id',
'valueField' => 'category_id'
],
'repository' => object(App\Model\Table\ProductsTable) {}
}
$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 257
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 228
Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 936
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 190
Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 957
Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276
Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 905
Cake\ORM\Query::toArray() - CORE/src/Datasource/QueryTrait.php, line 293
App\Controller\AppController::beforeFilter() - APP/Controller/AppController.php, line 417 Warning (2)CORE/src/Database/QueryCompiler.php , line 128 ]Code Context { return function ( $parts , $name ) use (& $sql , $query , $generator ) { if (! count ( $parts )) { $parts = null
$name = 'order'
$sql = 'SELECT Products.category_id AS `Products__category_id` FROM products Products WHERE (Products.unpublished = :c0 AND Products.visibility <> :c1 AND Products.clearance = :c2) GROUP BY category_id '
$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' => [
'Products__id' => 'integer',
'Products.id' => 'integer',
'id' => 'integer',
'Products__eid' => 'integer',
'Products.eid' => 'integer',
'eid' => 'integer',
'Products__product_sku' => 'string',
'Products.product_sku' => 'string',
'product_sku' => 'string',
'Products__product_mpn' => 'string',
'Products.product_mpn' => 'string',
'product_mpn' => 'string',
'Products__product_upc' => 'string',
'Products.product_upc' => 'string',
'product_upc' => 'string',
'Products__product_title' => 'string',
'Products.product_title' => 'string',
'product_title' => 'string',
'Products__adword_title' => 'string',
'Products.adword_title' => 'string',
'adword_title' => 'string',
'Products__search_suggestion' => 'text',
'Products.search_suggestion' => 'text',
'search_suggestion' => 'text',
'Products__surl' => 'string',
'Products.surl' => 'string',
'surl' => 'string',
'Products__serial_id' => 'integer',
'Products.serial_id' => 'integer',
'serial_id' => 'integer',
'Products__color_id' => 'integer',
'Products.color_id' => 'integer',
'color_id' => 'integer',
'Products__manufacturer_id' => 'integer',
'Products.manufacturer_id' => 'integer',
'manufacturer_id' => 'integer',
'Products__category_id' => 'integer',
'Products.category_id' => 'integer',
'category_id' => 'integer',
'Products__short_description' => 'string',
'Products.short_description' => 'string',
'short_description' => 'string',
'Products__long_description' => 'text',
'Products.long_description' => 'text',
'long_description' => 'text',
'Products__product_length' => 'string',
'Products.product_length' => 'string',
'product_length' => 'string',
'Products__product_width' => 'string',
'Products.product_width' => 'string',
'product_width' => 'string',
'Products__product_height' => 'string',
'Products.product_height' => 'string',
'product_height' => 'string',
'Products__product_weight' => 'float',
'Products.product_weight' => 'float',
'product_weight' => 'float',
'Products__size' => 'string',
'Products.size' => 'string',
'size' => 'string',
'Products__product_stock' => 'integer',
'Products.product_stock' => 'integer',
'product_stock' => 'integer',
'Products__save_tax' => 'boolean',
'Products.save_tax' => 'boolean',
'save_tax' => 'boolean',
'Products__msrp' => 'float',
'Products.msrp' => 'float',
'msrp' => 'float',
'Products__map' => 'float',
'Products.map' => 'float',
'map' => 'float',
'Products__future_price1' => 'float',
'Products.future_price1' => 'float',
'future_price1' => 'float',
'Products__future_price2' => 'float',
'Products.future_price2' => 'float',
'future_price2' => 'float',
'Products__active_price' => 'float',
'Products.active_price' => 'float',
'active_price' => 'float',
'Products__future_price1_start' => 'string',
'Products.future_price1_start' => 'string',
'future_price1_start' => 'string',
'Products__future_price1_end' => 'string',
'Products.future_price1_end' => 'string',
'future_price1_end' => 'string',
'Products__future_price2_start' => 'string',
'Products.future_price2_start' => 'string',
'future_price2_start' => 'string',
'Products__future_price2_end' => 'string',
'Products.future_price2_end' => 'string',
'future_price2_end' => 'string',
'Products__msrp2' => 'float',
'Products.msrp2' => 'float',
'msrp2' => 'float',
'Products__msrp2_start' => 'string',
'Products.msrp2_start' => 'string',
'msrp2_start' => 'string',
'Products__msrp2_end' => 'string',
'Products.msrp2_end' => 'string',
'msrp2_end' => 'string',
'Products__price_display' => 'boolean',
'Products.price_display' => 'boolean',
'price_display' => 'boolean',
'Products__tax_id' => 'integer',
'Products.tax_id' => 'integer',
'tax_id' => 'integer',
'Products__ehf_id' => 'integer',
'Products.ehf_id' => 'integer',
'ehf_id' => 'integer',
'Products__unpublished' => 'boolean',
'Products.unpublished' => 'boolean',
'unpublished' => 'boolean',
'Products__get_a_quote_or_add_to_cart' => 'integer',
'Products.get_a_quote_or_add_to_cart' => 'integer',
'get_a_quote_or_add_to_cart' => 'integer',
'Products__discontinued' => 'boolean',
'Products.discontinued' => 'boolean',
'discontinued' => 'boolean',
'Products__new_model' => 'string',
'Products.new_model' => 'string',
'new_model' => 'string',
'Products__meta_description' => 'text',
'Products.meta_description' => 'text',
'meta_description' => 'text',
'Products__meta_title' => 'string',
'Products.meta_title' => 'string',
'meta_title' => 'string',
'Products__meta_keywords' => 'string',
'Products.meta_keywords' => 'string',
'meta_keywords' => 'string',
'Products__created' => 'datetime',
'Products.created' => 'datetime',
'created' => 'datetime',
'Products__modified' => 'datetime',
'Products.modified' => 'datetime',
'modified' => 'datetime',
'Products__shipping_id' => 'integer',
'Products.shipping_id' => 'integer',
'shipping_id' => 'integer',
'Products__productwarranty_id' => 'integer',
'Products.productwarranty_id' => 'integer',
'productwarranty_id' => 'integer',
'Products__no_of_clicks' => 'integer',
'Products.no_of_clicks' => 'integer',
'no_of_clicks' => 'integer',
'Products__temp_var' => 'integer',
'Products.temp_var' => 'integer',
'temp_var' => 'integer',
'Products__not_update_by_script' => 'boolean',
'Products.not_update_by_script' => 'boolean',
'not_update_by_script' => 'boolean',
'Products__visibility' => 'integer',
'Products.visibility' => 'integer',
'visibility' => 'integer',
'Products__cnet_code' => 'text',
'Products.cnet_code' => 'text',
'cnet_code' => 'text',
'Products__free_shipping' => 'boolean',
'Products.free_shipping' => 'boolean',
'free_shipping' => 'boolean',
'Products__clearance' => 'boolean',
'Products.clearance' => 'boolean',
'clearance' => 'boolean',
'Products__in_store_special' => 'boolean',
'Products.in_store_special' => 'boolean',
'in_store_special' => 'boolean',
'Products__staff_pick' => 'boolean',
'Products.staff_pick' => 'boolean',
'staff_pick' => 'boolean',
'Products__limited_stock' => 'boolean',
'Products.limited_stock' => 'boolean',
'limited_stock' => 'boolean',
'Products__in_flyer' => 'boolean',
'Products.in_flyer' => 'boolean',
'in_flyer' => 'boolean',
'Products__ehfcategory_id' => 'integer',
'Products.ehfcategory_id' => 'integer',
'ehfcategory_id' => 'integer',
'Products__display_model' => 'boolean',
'Products.display_model' => 'boolean',
'display_model' => 'boolean',
'Products__vimeo_videoid' => 'string',
'Products.vimeo_videoid' => 'string',
'vimeo_videoid' => 'string',
'Products__youtube_video' => 'text',
'Products.youtube_video' => 'text',
'youtube_video' => 'text',
'Products__top_on_category' => 'boolean',
'Products.top_on_category' => 'boolean',
'top_on_category' => 'boolean',
'Products__new' => 'boolean',
'Products.new' => 'boolean',
'new' => 'boolean',
'Products__active_current_promo' => 'boolean',
'Products.active_current_promo' => 'boolean',
'active_current_promo' => 'boolean',
'Products__open_box' => 'boolean',
'Products.open_box' => 'boolean',
'open_box' => 'boolean',
'Products__pair' => 'boolean',
'Products.pair' => 'boolean',
'pair' => 'boolean',
'Products__used' => 'boolean',
'Products.used' => 'boolean',
'used' => 'boolean',
'Products__no_stand' => 'boolean',
'Products.no_stand' => 'boolean',
'no_stand' => 'boolean',
'Products__box_damage' => 'boolean',
'Products.box_damage' => 'boolean',
'box_damage' => 'boolean',
'Products__price_updated_date' => 'string',
'Products.price_updated_date' => 'string',
'price_updated_date' => 'string',
'Products__home_top_picks' => 'boolean',
'Products.home_top_picks' => 'boolean',
'home_top_picks' => 'boolean',
'Products__feature_1' => 'string',
'Products.feature_1' => 'string',
'feature_1' => 'string',
'Products__feature_2' => 'string',
'Products.feature_2' => 'string',
'feature_2' => 'string',
'Products__feature_3' => 'string',
'Products.feature_3' => 'string',
'feature_3' => 'string',
'Products__feature_4' => 'string',
'Products.feature_4' => 'string',
'feature_4' => 'string',
'Products__product_info_incomplete' => 'boolean',
'Products.product_info_incomplete' => 'boolean',
'product_info_incomplete' => 'boolean',
'Products__product_info_incomplete_details' => 'text',
'Products.product_info_incomplete_details' => 'text',
'product_info_incomplete_details' => 'text',
'Products__show_bundle_savings' => 'boolean',
'Products.show_bundle_savings' => 'boolean',
'show_bundle_savings' => 'boolean',
'Products__clearance_price' => 'float',
'Products.clearance_price' => 'float',
'clearance_price' => 'float',
'Products__warranty_label' => 'integer',
'Products.warranty_label' => 'integer',
'warranty_label' => 'integer',
'Products__clearance_message' => 'string',
'Products.clearance_message' => 'string',
'clearance_message' => 'string',
'Products__size_category' => 'string',
'Products.size_category' => 'string',
'size_category' => 'string',
'Products__atc_flag' => 'boolean',
'Products.atc_flag' => 'boolean',
'atc_flag' => 'boolean',
'Products__pdf_available' => 'boolean',
'Products.pdf_available' => 'boolean',
'pdf_available' => 'boolean',
'Products__free_warranty' => 'boolean',
'Products.free_warranty' => 'boolean',
'free_warranty' => 'boolean',
'Products__online_only' => 'boolean',
'Products.online_only' => 'boolean',
'online_only' => 'boolean',
'Products__coming_soon' => 'boolean',
'Products.coming_soon' => 'boolean',
'coming_soon' => 'boolean',
'Products__ontario_energy_savings_rebate' => 'boolean',
'Products.ontario_energy_savings_rebate' => 'boolean',
'ontario_energy_savings_rebate' => 'boolean',
'Products__special' => 'boolean',
'Products.special' => 'boolean',
'special' => 'boolean',
'Products__do_not_apply_warranty' => 'boolean',
'Products.do_not_apply_warranty' => 'boolean',
'do_not_apply_warranty' => 'boolean',
'Products__style_type' => 'string',
'Products.style_type' => 'string',
'style_type' => 'string',
'Products__temporarily_unavailable' => 'boolean',
'Products.temporarily_unavailable' => 'boolean',
'temporarily_unavailable' => 'boolean'
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 1,
'mapReducers' => (int) 0,
'contain' => [],
'matching' => [],
'extraOptions' => [
'keyField' => 'category_id',
'valueField' => 'category_id'
],
'repository' => object(App\Model\Table\ProductsTable) {}
}
$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 257
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 228
Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 936
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 190
Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 957
Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276
Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 905
Cake\ORM\Query::toArray() - CORE/src/Datasource/QueryTrait.php, line 293
App\Controller\AppController::beforeFilter() - APP/Controller/AppController.php, line 417 Warning (2)CORE/src/Database/QueryCompiler.php , line 128 ]Code Context { return function ( $parts , $name ) use (& $sql , $query , $generator ) { if (! count ( $parts )) { $parts = null
$name = 'limit'
$sql = 'SELECT Products.category_id AS `Products__category_id` FROM products Products WHERE (Products.unpublished = :c0 AND Products.visibility <> :c1 AND Products.clearance = :c2) GROUP BY category_id '
$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' => [
'Products__id' => 'integer',
'Products.id' => 'integer',
'id' => 'integer',
'Products__eid' => 'integer',
'Products.eid' => 'integer',
'eid' => 'integer',
'Products__product_sku' => 'string',
'Products.product_sku' => 'string',
'product_sku' => 'string',
'Products__product_mpn' => 'string',
'Products.product_mpn' => 'string',
'product_mpn' => 'string',
'Products__product_upc' => 'string',
'Products.product_upc' => 'string',
'product_upc' => 'string',
'Products__product_title' => 'string',
'Products.product_title' => 'string',
'product_title' => 'string',
'Products__adword_title' => 'string',
'Products.adword_title' => 'string',
'adword_title' => 'string',
'Products__search_suggestion' => 'text',
'Products.search_suggestion' => 'text',
'search_suggestion' => 'text',
'Products__surl' => 'string',
'Products.surl' => 'string',
'surl' => 'string',
'Products__serial_id' => 'integer',
'Products.serial_id' => 'integer',
'serial_id' => 'integer',
'Products__color_id' => 'integer',
'Products.color_id' => 'integer',
'color_id' => 'integer',
'Products__manufacturer_id' => 'integer',
'Products.manufacturer_id' => 'integer',
'manufacturer_id' => 'integer',
'Products__category_id' => 'integer',
'Products.category_id' => 'integer',
'category_id' => 'integer',
'Products__short_description' => 'string',
'Products.short_description' => 'string',
'short_description' => 'string',
'Products__long_description' => 'text',
'Products.long_description' => 'text',
'long_description' => 'text',
'Products__product_length' => 'string',
'Products.product_length' => 'string',
'product_length' => 'string',
'Products__product_width' => 'string',
'Products.product_width' => 'string',
'product_width' => 'string',
'Products__product_height' => 'string',
'Products.product_height' => 'string',
'product_height' => 'string',
'Products__product_weight' => 'float',
'Products.product_weight' => 'float',
'product_weight' => 'float',
'Products__size' => 'string',
'Products.size' => 'string',
'size' => 'string',
'Products__product_stock' => 'integer',
'Products.product_stock' => 'integer',
'product_stock' => 'integer',
'Products__save_tax' => 'boolean',
'Products.save_tax' => 'boolean',
'save_tax' => 'boolean',
'Products__msrp' => 'float',
'Products.msrp' => 'float',
'msrp' => 'float',
'Products__map' => 'float',
'Products.map' => 'float',
'map' => 'float',
'Products__future_price1' => 'float',
'Products.future_price1' => 'float',
'future_price1' => 'float',
'Products__future_price2' => 'float',
'Products.future_price2' => 'float',
'future_price2' => 'float',
'Products__active_price' => 'float',
'Products.active_price' => 'float',
'active_price' => 'float',
'Products__future_price1_start' => 'string',
'Products.future_price1_start' => 'string',
'future_price1_start' => 'string',
'Products__future_price1_end' => 'string',
'Products.future_price1_end' => 'string',
'future_price1_end' => 'string',
'Products__future_price2_start' => 'string',
'Products.future_price2_start' => 'string',
'future_price2_start' => 'string',
'Products__future_price2_end' => 'string',
'Products.future_price2_end' => 'string',
'future_price2_end' => 'string',
'Products__msrp2' => 'float',
'Products.msrp2' => 'float',
'msrp2' => 'float',
'Products__msrp2_start' => 'string',
'Products.msrp2_start' => 'string',
'msrp2_start' => 'string',
'Products__msrp2_end' => 'string',
'Products.msrp2_end' => 'string',
'msrp2_end' => 'string',
'Products__price_display' => 'boolean',
'Products.price_display' => 'boolean',
'price_display' => 'boolean',
'Products__tax_id' => 'integer',
'Products.tax_id' => 'integer',
'tax_id' => 'integer',
'Products__ehf_id' => 'integer',
'Products.ehf_id' => 'integer',
'ehf_id' => 'integer',
'Products__unpublished' => 'boolean',
'Products.unpublished' => 'boolean',
'unpublished' => 'boolean',
'Products__get_a_quote_or_add_to_cart' => 'integer',
'Products.get_a_quote_or_add_to_cart' => 'integer',
'get_a_quote_or_add_to_cart' => 'integer',
'Products__discontinued' => 'boolean',
'Products.discontinued' => 'boolean',
'discontinued' => 'boolean',
'Products__new_model' => 'string',
'Products.new_model' => 'string',
'new_model' => 'string',
'Products__meta_description' => 'text',
'Products.meta_description' => 'text',
'meta_description' => 'text',
'Products__meta_title' => 'string',
'Products.meta_title' => 'string',
'meta_title' => 'string',
'Products__meta_keywords' => 'string',
'Products.meta_keywords' => 'string',
'meta_keywords' => 'string',
'Products__created' => 'datetime',
'Products.created' => 'datetime',
'created' => 'datetime',
'Products__modified' => 'datetime',
'Products.modified' => 'datetime',
'modified' => 'datetime',
'Products__shipping_id' => 'integer',
'Products.shipping_id' => 'integer',
'shipping_id' => 'integer',
'Products__productwarranty_id' => 'integer',
'Products.productwarranty_id' => 'integer',
'productwarranty_id' => 'integer',
'Products__no_of_clicks' => 'integer',
'Products.no_of_clicks' => 'integer',
'no_of_clicks' => 'integer',
'Products__temp_var' => 'integer',
'Products.temp_var' => 'integer',
'temp_var' => 'integer',
'Products__not_update_by_script' => 'boolean',
'Products.not_update_by_script' => 'boolean',
'not_update_by_script' => 'boolean',
'Products__visibility' => 'integer',
'Products.visibility' => 'integer',
'visibility' => 'integer',
'Products__cnet_code' => 'text',
'Products.cnet_code' => 'text',
'cnet_code' => 'text',
'Products__free_shipping' => 'boolean',
'Products.free_shipping' => 'boolean',
'free_shipping' => 'boolean',
'Products__clearance' => 'boolean',
'Products.clearance' => 'boolean',
'clearance' => 'boolean',
'Products__in_store_special' => 'boolean',
'Products.in_store_special' => 'boolean',
'in_store_special' => 'boolean',
'Products__staff_pick' => 'boolean',
'Products.staff_pick' => 'boolean',
'staff_pick' => 'boolean',
'Products__limited_stock' => 'boolean',
'Products.limited_stock' => 'boolean',
'limited_stock' => 'boolean',
'Products__in_flyer' => 'boolean',
'Products.in_flyer' => 'boolean',
'in_flyer' => 'boolean',
'Products__ehfcategory_id' => 'integer',
'Products.ehfcategory_id' => 'integer',
'ehfcategory_id' => 'integer',
'Products__display_model' => 'boolean',
'Products.display_model' => 'boolean',
'display_model' => 'boolean',
'Products__vimeo_videoid' => 'string',
'Products.vimeo_videoid' => 'string',
'vimeo_videoid' => 'string',
'Products__youtube_video' => 'text',
'Products.youtube_video' => 'text',
'youtube_video' => 'text',
'Products__top_on_category' => 'boolean',
'Products.top_on_category' => 'boolean',
'top_on_category' => 'boolean',
'Products__new' => 'boolean',
'Products.new' => 'boolean',
'new' => 'boolean',
'Products__active_current_promo' => 'boolean',
'Products.active_current_promo' => 'boolean',
'active_current_promo' => 'boolean',
'Products__open_box' => 'boolean',
'Products.open_box' => 'boolean',
'open_box' => 'boolean',
'Products__pair' => 'boolean',
'Products.pair' => 'boolean',
'pair' => 'boolean',
'Products__used' => 'boolean',
'Products.used' => 'boolean',
'used' => 'boolean',
'Products__no_stand' => 'boolean',
'Products.no_stand' => 'boolean',
'no_stand' => 'boolean',
'Products__box_damage' => 'boolean',
'Products.box_damage' => 'boolean',
'box_damage' => 'boolean',
'Products__price_updated_date' => 'string',
'Products.price_updated_date' => 'string',
'price_updated_date' => 'string',
'Products__home_top_picks' => 'boolean',
'Products.home_top_picks' => 'boolean',
'home_top_picks' => 'boolean',
'Products__feature_1' => 'string',
'Products.feature_1' => 'string',
'feature_1' => 'string',
'Products__feature_2' => 'string',
'Products.feature_2' => 'string',
'feature_2' => 'string',
'Products__feature_3' => 'string',
'Products.feature_3' => 'string',
'feature_3' => 'string',
'Products__feature_4' => 'string',
'Products.feature_4' => 'string',
'feature_4' => 'string',
'Products__product_info_incomplete' => 'boolean',
'Products.product_info_incomplete' => 'boolean',
'product_info_incomplete' => 'boolean',
'Products__product_info_incomplete_details' => 'text',
'Products.product_info_incomplete_details' => 'text',
'product_info_incomplete_details' => 'text',
'Products__show_bundle_savings' => 'boolean',
'Products.show_bundle_savings' => 'boolean',
'show_bundle_savings' => 'boolean',
'Products__clearance_price' => 'float',
'Products.clearance_price' => 'float',
'clearance_price' => 'float',
'Products__warranty_label' => 'integer',
'Products.warranty_label' => 'integer',
'warranty_label' => 'integer',
'Products__clearance_message' => 'string',
'Products.clearance_message' => 'string',
'clearance_message' => 'string',
'Products__size_category' => 'string',
'Products.size_category' => 'string',
'size_category' => 'string',
'Products__atc_flag' => 'boolean',
'Products.atc_flag' => 'boolean',
'atc_flag' => 'boolean',
'Products__pdf_available' => 'boolean',
'Products.pdf_available' => 'boolean',
'pdf_available' => 'boolean',
'Products__free_warranty' => 'boolean',
'Products.free_warranty' => 'boolean',
'free_warranty' => 'boolean',
'Products__online_only' => 'boolean',
'Products.online_only' => 'boolean',
'online_only' => 'boolean',
'Products__coming_soon' => 'boolean',
'Products.coming_soon' => 'boolean',
'coming_soon' => 'boolean',
'Products__ontario_energy_savings_rebate' => 'boolean',
'Products.ontario_energy_savings_rebate' => 'boolean',
'ontario_energy_savings_rebate' => 'boolean',
'Products__special' => 'boolean',
'Products.special' => 'boolean',
'special' => 'boolean',
'Products__do_not_apply_warranty' => 'boolean',
'Products.do_not_apply_warranty' => 'boolean',
'do_not_apply_warranty' => 'boolean',
'Products__style_type' => 'string',
'Products.style_type' => 'string',
'style_type' => 'string',
'Products__temporarily_unavailable' => 'boolean',
'Products.temporarily_unavailable' => 'boolean',
'temporarily_unavailable' => 'boolean'
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 1,
'mapReducers' => (int) 0,
'contain' => [],
'matching' => [],
'extraOptions' => [
'keyField' => 'category_id',
'valueField' => 'category_id'
],
'repository' => object(App\Model\Table\ProductsTable) {}
}
$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 257
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 228
Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 936
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 190
Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 957
Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276
Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 905
Cake\ORM\Query::toArray() - CORE/src/Datasource/QueryTrait.php, line 293
App\Controller\AppController::beforeFilter() - APP/Controller/AppController.php, line 417 Warning (2)CORE/src/Database/QueryCompiler.php , line 128 ]Code Context { return function ( $parts , $name ) use (& $sql , $query , $generator ) { if (! count ( $parts )) { $parts = null
$name = 'offset'
$sql = 'SELECT Products.category_id AS `Products__category_id` FROM products Products WHERE (Products.unpublished = :c0 AND Products.visibility <> :c1 AND Products.clearance = :c2) GROUP BY category_id '
$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' => [
'Products__id' => 'integer',
'Products.id' => 'integer',
'id' => 'integer',
'Products__eid' => 'integer',
'Products.eid' => 'integer',
'eid' => 'integer',
'Products__product_sku' => 'string',
'Products.product_sku' => 'string',
'product_sku' => 'string',
'Products__product_mpn' => 'string',
'Products.product_mpn' => 'string',
'product_mpn' => 'string',
'Products__product_upc' => 'string',
'Products.product_upc' => 'string',
'product_upc' => 'string',
'Products__product_title' => 'string',
'Products.product_title' => 'string',
'product_title' => 'string',
'Products__adword_title' => 'string',
'Products.adword_title' => 'string',
'adword_title' => 'string',
'Products__search_suggestion' => 'text',
'Products.search_suggestion' => 'text',
'search_suggestion' => 'text',
'Products__surl' => 'string',
'Products.surl' => 'string',
'surl' => 'string',
'Products__serial_id' => 'integer',
'Products.serial_id' => 'integer',
'serial_id' => 'integer',
'Products__color_id' => 'integer',
'Products.color_id' => 'integer',
'color_id' => 'integer',
'Products__manufacturer_id' => 'integer',
'Products.manufacturer_id' => 'integer',
'manufacturer_id' => 'integer',
'Products__category_id' => 'integer',
'Products.category_id' => 'integer',
'category_id' => 'integer',
'Products__short_description' => 'string',
'Products.short_description' => 'string',
'short_description' => 'string',
'Products__long_description' => 'text',
'Products.long_description' => 'text',
'long_description' => 'text',
'Products__product_length' => 'string',
'Products.product_length' => 'string',
'product_length' => 'string',
'Products__product_width' => 'string',
'Products.product_width' => 'string',
'product_width' => 'string',
'Products__product_height' => 'string',
'Products.product_height' => 'string',
'product_height' => 'string',
'Products__product_weight' => 'float',
'Products.product_weight' => 'float',
'product_weight' => 'float',
'Products__size' => 'string',
'Products.size' => 'string',
'size' => 'string',
'Products__product_stock' => 'integer',
'Products.product_stock' => 'integer',
'product_stock' => 'integer',
'Products__save_tax' => 'boolean',
'Products.save_tax' => 'boolean',
'save_tax' => 'boolean',
'Products__msrp' => 'float',
'Products.msrp' => 'float',
'msrp' => 'float',
'Products__map' => 'float',
'Products.map' => 'float',
'map' => 'float',
'Products__future_price1' => 'float',
'Products.future_price1' => 'float',
'future_price1' => 'float',
'Products__future_price2' => 'float',
'Products.future_price2' => 'float',
'future_price2' => 'float',
'Products__active_price' => 'float',
'Products.active_price' => 'float',
'active_price' => 'float',
'Products__future_price1_start' => 'string',
'Products.future_price1_start' => 'string',
'future_price1_start' => 'string',
'Products__future_price1_end' => 'string',
'Products.future_price1_end' => 'string',
'future_price1_end' => 'string',
'Products__future_price2_start' => 'string',
'Products.future_price2_start' => 'string',
'future_price2_start' => 'string',
'Products__future_price2_end' => 'string',
'Products.future_price2_end' => 'string',
'future_price2_end' => 'string',
'Products__msrp2' => 'float',
'Products.msrp2' => 'float',
'msrp2' => 'float',
'Products__msrp2_start' => 'string',
'Products.msrp2_start' => 'string',
'msrp2_start' => 'string',
'Products__msrp2_end' => 'string',
'Products.msrp2_end' => 'string',
'msrp2_end' => 'string',
'Products__price_display' => 'boolean',
'Products.price_display' => 'boolean',
'price_display' => 'boolean',
'Products__tax_id' => 'integer',
'Products.tax_id' => 'integer',
'tax_id' => 'integer',
'Products__ehf_id' => 'integer',
'Products.ehf_id' => 'integer',
'ehf_id' => 'integer',
'Products__unpublished' => 'boolean',
'Products.unpublished' => 'boolean',
'unpublished' => 'boolean',
'Products__get_a_quote_or_add_to_cart' => 'integer',
'Products.get_a_quote_or_add_to_cart' => 'integer',
'get_a_quote_or_add_to_cart' => 'integer',
'Products__discontinued' => 'boolean',
'Products.discontinued' => 'boolean',
'discontinued' => 'boolean',
'Products__new_model' => 'string',
'Products.new_model' => 'string',
'new_model' => 'string',
'Products__meta_description' => 'text',
'Products.meta_description' => 'text',
'meta_description' => 'text',
'Products__meta_title' => 'string',
'Products.meta_title' => 'string',
'meta_title' => 'string',
'Products__meta_keywords' => 'string',
'Products.meta_keywords' => 'string',
'meta_keywords' => 'string',
'Products__created' => 'datetime',
'Products.created' => 'datetime',
'created' => 'datetime',
'Products__modified' => 'datetime',
'Products.modified' => 'datetime',
'modified' => 'datetime',
'Products__shipping_id' => 'integer',
'Products.shipping_id' => 'integer',
'shipping_id' => 'integer',
'Products__productwarranty_id' => 'integer',
'Products.productwarranty_id' => 'integer',
'productwarranty_id' => 'integer',
'Products__no_of_clicks' => 'integer',
'Products.no_of_clicks' => 'integer',
'no_of_clicks' => 'integer',
'Products__temp_var' => 'integer',
'Products.temp_var' => 'integer',
'temp_var' => 'integer',
'Products__not_update_by_script' => 'boolean',
'Products.not_update_by_script' => 'boolean',
'not_update_by_script' => 'boolean',
'Products__visibility' => 'integer',
'Products.visibility' => 'integer',
'visibility' => 'integer',
'Products__cnet_code' => 'text',
'Products.cnet_code' => 'text',
'cnet_code' => 'text',
'Products__free_shipping' => 'boolean',
'Products.free_shipping' => 'boolean',
'free_shipping' => 'boolean',
'Products__clearance' => 'boolean',
'Products.clearance' => 'boolean',
'clearance' => 'boolean',
'Products__in_store_special' => 'boolean',
'Products.in_store_special' => 'boolean',
'in_store_special' => 'boolean',
'Products__staff_pick' => 'boolean',
'Products.staff_pick' => 'boolean',
'staff_pick' => 'boolean',
'Products__limited_stock' => 'boolean',
'Products.limited_stock' => 'boolean',
'limited_stock' => 'boolean',
'Products__in_flyer' => 'boolean',
'Products.in_flyer' => 'boolean',
'in_flyer' => 'boolean',
'Products__ehfcategory_id' => 'integer',
'Products.ehfcategory_id' => 'integer',
'ehfcategory_id' => 'integer',
'Products__display_model' => 'boolean',
'Products.display_model' => 'boolean',
'display_model' => 'boolean',
'Products__vimeo_videoid' => 'string',
'Products.vimeo_videoid' => 'string',
'vimeo_videoid' => 'string',
'Products__youtube_video' => 'text',
'Products.youtube_video' => 'text',
'youtube_video' => 'text',
'Products__top_on_category' => 'boolean',
'Products.top_on_category' => 'boolean',
'top_on_category' => 'boolean',
'Products__new' => 'boolean',
'Products.new' => 'boolean',
'new' => 'boolean',
'Products__active_current_promo' => 'boolean',
'Products.active_current_promo' => 'boolean',
'active_current_promo' => 'boolean',
'Products__open_box' => 'boolean',
'Products.open_box' => 'boolean',
'open_box' => 'boolean',
'Products__pair' => 'boolean',
'Products.pair' => 'boolean',
'pair' => 'boolean',
'Products__used' => 'boolean',
'Products.used' => 'boolean',
'used' => 'boolean',
'Products__no_stand' => 'boolean',
'Products.no_stand' => 'boolean',
'no_stand' => 'boolean',
'Products__box_damage' => 'boolean',
'Products.box_damage' => 'boolean',
'box_damage' => 'boolean',
'Products__price_updated_date' => 'string',
'Products.price_updated_date' => 'string',
'price_updated_date' => 'string',
'Products__home_top_picks' => 'boolean',
'Products.home_top_picks' => 'boolean',
'home_top_picks' => 'boolean',
'Products__feature_1' => 'string',
'Products.feature_1' => 'string',
'feature_1' => 'string',
'Products__feature_2' => 'string',
'Products.feature_2' => 'string',
'feature_2' => 'string',
'Products__feature_3' => 'string',
'Products.feature_3' => 'string',
'feature_3' => 'string',
'Products__feature_4' => 'string',
'Products.feature_4' => 'string',
'feature_4' => 'string',
'Products__product_info_incomplete' => 'boolean',
'Products.product_info_incomplete' => 'boolean',
'product_info_incomplete' => 'boolean',
'Products__product_info_incomplete_details' => 'text',
'Products.product_info_incomplete_details' => 'text',
'product_info_incomplete_details' => 'text',
'Products__show_bundle_savings' => 'boolean',
'Products.show_bundle_savings' => 'boolean',
'show_bundle_savings' => 'boolean',
'Products__clearance_price' => 'float',
'Products.clearance_price' => 'float',
'clearance_price' => 'float',
'Products__warranty_label' => 'integer',
'Products.warranty_label' => 'integer',
'warranty_label' => 'integer',
'Products__clearance_message' => 'string',
'Products.clearance_message' => 'string',
'clearance_message' => 'string',
'Products__size_category' => 'string',
'Products.size_category' => 'string',
'size_category' => 'string',
'Products__atc_flag' => 'boolean',
'Products.atc_flag' => 'boolean',
'atc_flag' => 'boolean',
'Products__pdf_available' => 'boolean',
'Products.pdf_available' => 'boolean',
'pdf_available' => 'boolean',
'Products__free_warranty' => 'boolean',
'Products.free_warranty' => 'boolean',
'free_warranty' => 'boolean',
'Products__online_only' => 'boolean',
'Products.online_only' => 'boolean',
'online_only' => 'boolean',
'Products__coming_soon' => 'boolean',
'Products.coming_soon' => 'boolean',
'coming_soon' => 'boolean',
'Products__ontario_energy_savings_rebate' => 'boolean',
'Products.ontario_energy_savings_rebate' => 'boolean',
'ontario_energy_savings_rebate' => 'boolean',
'Products__special' => 'boolean',
'Products.special' => 'boolean',
'special' => 'boolean',
'Products__do_not_apply_warranty' => 'boolean',
'Products.do_not_apply_warranty' => 'boolean',
'do_not_apply_warranty' => 'boolean',
'Products__style_type' => 'string',
'Products.style_type' => 'string',
'style_type' => 'string',
'Products__temporarily_unavailable' => 'boolean',
'Products.temporarily_unavailable' => 'boolean',
'temporarily_unavailable' => 'boolean'
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 1,
'mapReducers' => (int) 0,
'contain' => [],
'matching' => [],
'extraOptions' => [
'keyField' => 'category_id',
'valueField' => 'category_id'
],
'repository' => object(App\Model\Table\ProductsTable) {}
}
$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 257
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 228
Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 936
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 190
Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 957
Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276
Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 905
Cake\ORM\Query::toArray() - CORE/src/Datasource/QueryTrait.php, line 293
App\Controller\AppController::beforeFilter() - APP/Controller/AppController.php, line 417 Warning (2)CORE/src/Database/QueryCompiler.php , line 128 ]Code Context { return function ( $parts , $name ) use (& $sql , $query , $generator ) { if (! count ( $parts )) { $parts = null
$name = 'epilog'
$sql = 'SELECT Products.category_id AS `Products__category_id` FROM products Products WHERE (Products.unpublished = :c0 AND Products.visibility <> :c1 AND Products.clearance = :c2) GROUP BY category_id '
$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' => [
'Products__id' => 'integer',
'Products.id' => 'integer',
'id' => 'integer',
'Products__eid' => 'integer',
'Products.eid' => 'integer',
'eid' => 'integer',
'Products__product_sku' => 'string',
'Products.product_sku' => 'string',
'product_sku' => 'string',
'Products__product_mpn' => 'string',
'Products.product_mpn' => 'string',
'product_mpn' => 'string',
'Products__product_upc' => 'string',
'Products.product_upc' => 'string',
'product_upc' => 'string',
'Products__product_title' => 'string',
'Products.product_title' => 'string',
'product_title' => 'string',
'Products__adword_title' => 'string',
'Products.adword_title' => 'string',
'adword_title' => 'string',
'Products__search_suggestion' => 'text',
'Products.search_suggestion' => 'text',
'search_suggestion' => 'text',
'Products__surl' => 'string',
'Products.surl' => 'string',
'surl' => 'string',
'Products__serial_id' => 'integer',
'Products.serial_id' => 'integer',
'serial_id' => 'integer',
'Products__color_id' => 'integer',
'Products.color_id' => 'integer',
'color_id' => 'integer',
'Products__manufacturer_id' => 'integer',
'Products.manufacturer_id' => 'integer',
'manufacturer_id' => 'integer',
'Products__category_id' => 'integer',
'Products.category_id' => 'integer',
'category_id' => 'integer',
'Products__short_description' => 'string',
'Products.short_description' => 'string',
'short_description' => 'string',
'Products__long_description' => 'text',
'Products.long_description' => 'text',
'long_description' => 'text',
'Products__product_length' => 'string',
'Products.product_length' => 'string',
'product_length' => 'string',
'Products__product_width' => 'string',
'Products.product_width' => 'string',
'product_width' => 'string',
'Products__product_height' => 'string',
'Products.product_height' => 'string',
'product_height' => 'string',
'Products__product_weight' => 'float',
'Products.product_weight' => 'float',
'product_weight' => 'float',
'Products__size' => 'string',
'Products.size' => 'string',
'size' => 'string',
'Products__product_stock' => 'integer',
'Products.product_stock' => 'integer',
'product_stock' => 'integer',
'Products__save_tax' => 'boolean',
'Products.save_tax' => 'boolean',
'save_tax' => 'boolean',
'Products__msrp' => 'float',
'Products.msrp' => 'float',
'msrp' => 'float',
'Products__map' => 'float',
'Products.map' => 'float',
'map' => 'float',
'Products__future_price1' => 'float',
'Products.future_price1' => 'float',
'future_price1' => 'float',
'Products__future_price2' => 'float',
'Products.future_price2' => 'float',
'future_price2' => 'float',
'Products__active_price' => 'float',
'Products.active_price' => 'float',
'active_price' => 'float',
'Products__future_price1_start' => 'string',
'Products.future_price1_start' => 'string',
'future_price1_start' => 'string',
'Products__future_price1_end' => 'string',
'Products.future_price1_end' => 'string',
'future_price1_end' => 'string',
'Products__future_price2_start' => 'string',
'Products.future_price2_start' => 'string',
'future_price2_start' => 'string',
'Products__future_price2_end' => 'string',
'Products.future_price2_end' => 'string',
'future_price2_end' => 'string',
'Products__msrp2' => 'float',
'Products.msrp2' => 'float',
'msrp2' => 'float',
'Products__msrp2_start' => 'string',
'Products.msrp2_start' => 'string',
'msrp2_start' => 'string',
'Products__msrp2_end' => 'string',
'Products.msrp2_end' => 'string',
'msrp2_end' => 'string',
'Products__price_display' => 'boolean',
'Products.price_display' => 'boolean',
'price_display' => 'boolean',
'Products__tax_id' => 'integer',
'Products.tax_id' => 'integer',
'tax_id' => 'integer',
'Products__ehf_id' => 'integer',
'Products.ehf_id' => 'integer',
'ehf_id' => 'integer',
'Products__unpublished' => 'boolean',
'Products.unpublished' => 'boolean',
'unpublished' => 'boolean',
'Products__get_a_quote_or_add_to_cart' => 'integer',
'Products.get_a_quote_or_add_to_cart' => 'integer',
'get_a_quote_or_add_to_cart' => 'integer',
'Products__discontinued' => 'boolean',
'Products.discontinued' => 'boolean',
'discontinued' => 'boolean',
'Products__new_model' => 'string',
'Products.new_model' => 'string',
'new_model' => 'string',
'Products__meta_description' => 'text',
'Products.meta_description' => 'text',
'meta_description' => 'text',
'Products__meta_title' => 'string',
'Products.meta_title' => 'string',
'meta_title' => 'string',
'Products__meta_keywords' => 'string',
'Products.meta_keywords' => 'string',
'meta_keywords' => 'string',
'Products__created' => 'datetime',
'Products.created' => 'datetime',
'created' => 'datetime',
'Products__modified' => 'datetime',
'Products.modified' => 'datetime',
'modified' => 'datetime',
'Products__shipping_id' => 'integer',
'Products.shipping_id' => 'integer',
'shipping_id' => 'integer',
'Products__productwarranty_id' => 'integer',
'Products.productwarranty_id' => 'integer',
'productwarranty_id' => 'integer',
'Products__no_of_clicks' => 'integer',
'Products.no_of_clicks' => 'integer',
'no_of_clicks' => 'integer',
'Products__temp_var' => 'integer',
'Products.temp_var' => 'integer',
'temp_var' => 'integer',
'Products__not_update_by_script' => 'boolean',
'Products.not_update_by_script' => 'boolean',
'not_update_by_script' => 'boolean',
'Products__visibility' => 'integer',
'Products.visibility' => 'integer',
'visibility' => 'integer',
'Products__cnet_code' => 'text',
'Products.cnet_code' => 'text',
'cnet_code' => 'text',
'Products__free_shipping' => 'boolean',
'Products.free_shipping' => 'boolean',
'free_shipping' => 'boolean',
'Products__clearance' => 'boolean',
'Products.clearance' => 'boolean',
'clearance' => 'boolean',
'Products__in_store_special' => 'boolean',
'Products.in_store_special' => 'boolean',
'in_store_special' => 'boolean',
'Products__staff_pick' => 'boolean',
'Products.staff_pick' => 'boolean',
'staff_pick' => 'boolean',
'Products__limited_stock' => 'boolean',
'Products.limited_stock' => 'boolean',
'limited_stock' => 'boolean',
'Products__in_flyer' => 'boolean',
'Products.in_flyer' => 'boolean',
'in_flyer' => 'boolean',
'Products__ehfcategory_id' => 'integer',
'Products.ehfcategory_id' => 'integer',
'ehfcategory_id' => 'integer',
'Products__display_model' => 'boolean',
'Products.display_model' => 'boolean',
'display_model' => 'boolean',
'Products__vimeo_videoid' => 'string',
'Products.vimeo_videoid' => 'string',
'vimeo_videoid' => 'string',
'Products__youtube_video' => 'text',
'Products.youtube_video' => 'text',
'youtube_video' => 'text',
'Products__top_on_category' => 'boolean',
'Products.top_on_category' => 'boolean',
'top_on_category' => 'boolean',
'Products__new' => 'boolean',
'Products.new' => 'boolean',
'new' => 'boolean',
'Products__active_current_promo' => 'boolean',
'Products.active_current_promo' => 'boolean',
'active_current_promo' => 'boolean',
'Products__open_box' => 'boolean',
'Products.open_box' => 'boolean',
'open_box' => 'boolean',
'Products__pair' => 'boolean',
'Products.pair' => 'boolean',
'pair' => 'boolean',
'Products__used' => 'boolean',
'Products.used' => 'boolean',
'used' => 'boolean',
'Products__no_stand' => 'boolean',
'Products.no_stand' => 'boolean',
'no_stand' => 'boolean',
'Products__box_damage' => 'boolean',
'Products.box_damage' => 'boolean',
'box_damage' => 'boolean',
'Products__price_updated_date' => 'string',
'Products.price_updated_date' => 'string',
'price_updated_date' => 'string',
'Products__home_top_picks' => 'boolean',
'Products.home_top_picks' => 'boolean',
'home_top_picks' => 'boolean',
'Products__feature_1' => 'string',
'Products.feature_1' => 'string',
'feature_1' => 'string',
'Products__feature_2' => 'string',
'Products.feature_2' => 'string',
'feature_2' => 'string',
'Products__feature_3' => 'string',
'Products.feature_3' => 'string',
'feature_3' => 'string',
'Products__feature_4' => 'string',
'Products.feature_4' => 'string',
'feature_4' => 'string',
'Products__product_info_incomplete' => 'boolean',
'Products.product_info_incomplete' => 'boolean',
'product_info_incomplete' => 'boolean',
'Products__product_info_incomplete_details' => 'text',
'Products.product_info_incomplete_details' => 'text',
'product_info_incomplete_details' => 'text',
'Products__show_bundle_savings' => 'boolean',
'Products.show_bundle_savings' => 'boolean',
'show_bundle_savings' => 'boolean',
'Products__clearance_price' => 'float',
'Products.clearance_price' => 'float',
'clearance_price' => 'float',
'Products__warranty_label' => 'integer',
'Products.warranty_label' => 'integer',
'warranty_label' => 'integer',
'Products__clearance_message' => 'string',
'Products.clearance_message' => 'string',
'clearance_message' => 'string',
'Products__size_category' => 'string',
'Products.size_category' => 'string',
'size_category' => 'string',
'Products__atc_flag' => 'boolean',
'Products.atc_flag' => 'boolean',
'atc_flag' => 'boolean',
'Products__pdf_available' => 'boolean',
'Products.pdf_available' => 'boolean',
'pdf_available' => 'boolean',
'Products__free_warranty' => 'boolean',
'Products.free_warranty' => 'boolean',
'free_warranty' => 'boolean',
'Products__online_only' => 'boolean',
'Products.online_only' => 'boolean',
'online_only' => 'boolean',
'Products__coming_soon' => 'boolean',
'Products.coming_soon' => 'boolean',
'coming_soon' => 'boolean',
'Products__ontario_energy_savings_rebate' => 'boolean',
'Products.ontario_energy_savings_rebate' => 'boolean',
'ontario_energy_savings_rebate' => 'boolean',
'Products__special' => 'boolean',
'Products.special' => 'boolean',
'special' => 'boolean',
'Products__do_not_apply_warranty' => 'boolean',
'Products.do_not_apply_warranty' => 'boolean',
'do_not_apply_warranty' => 'boolean',
'Products__style_type' => 'string',
'Products.style_type' => 'string',
'style_type' => 'string',
'Products__temporarily_unavailable' => 'boolean',
'Products.temporarily_unavailable' => 'boolean',
'temporarily_unavailable' => 'boolean'
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 1,
'mapReducers' => (int) 0,
'contain' => [],
'matching' => [],
'extraOptions' => [
'keyField' => 'category_id',
'valueField' => 'category_id'
],
'repository' => object(App\Model\Table\ProductsTable) {}
}
$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 257
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 228
Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 936
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 190
Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 957
Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276
Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 905
Cake\ORM\Query::toArray() - CORE/src/Datasource/QueryTrait.php, line 293
App\Controller\AppController::beforeFilter() - APP/Controller/AppController.php, line 417 Warning (2)CORE/src/Database/QueryCompiler.php , line 128 ]Code Context { return function ( $parts , $name ) use (& $sql , $query , $generator ) { if (! count ( $parts )) { $parts = null
$name = 'having'
$sql = 'SELECT Categories.name AS `Categories__name`, Categories.id AS `Categories__id`, Categories.category_image AS `Categories__category_image` FROM categories Categories WHERE (Categories.unpublished = :c0 AND Categories.id in (:c1,:c2,:c3,:c4,:c5,:c6,:c7,:c8,:c9,:c10,:c11,:c12,:c13))'
$query = object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SQL could not be generated for this query as it is incomplete.',
'params' => [],
'defaultTypes' => [
'Categories__id' => 'integer',
'Categories.id' => 'integer',
'id' => 'integer',
'Categories__parent_id' => 'integer',
'Categories.parent_id' => 'integer',
'parent_id' => 'integer',
'Categories__lft' => 'integer',
'Categories.lft' => 'integer',
'lft' => 'integer',
'Categories__rght' => 'integer',
'Categories.rght' => 'integer',
'rght' => 'integer',
'Categories__name' => 'string',
'Categories.name' => 'string',
'name' => 'string',
'Categories__surl' => 'string',
'Categories.surl' => 'string',
'surl' => 'string',
'Categories__description' => 'text',
'Categories.description' => 'text',
'description' => 'text',
'Categories__google_category' => 'string',
'Categories.google_category' => 'string',
'google_category' => 'string',
'Categories__category_image' => 'string',
'Categories.category_image' => 'string',
'category_image' => 'string',
'Categories__banner_1' => 'string',
'Categories.banner_1' => 'string',
'banner_1' => 'string',
'Categories__banner_1_start_date' => 'string',
'Categories.banner_1_start_date' => 'string',
'banner_1_start_date' => 'string',
'Categories__banner_1_end_date' => 'string',
'Categories.banner_1_end_date' => 'string',
'banner_1_end_date' => 'string',
'Categories__banner_2' => 'string',
'Categories.banner_2' => 'string',
'banner_2' => 'string',
'Categories__banner_2_start_date' => 'string',
'Categories.banner_2_start_date' => 'string',
'banner_2_start_date' => 'string',
'Categories__banner_2_end_date' => 'string',
'Categories.banner_2_end_date' => 'string',
'banner_2_end_date' => 'string',
'Categories__status' => 'boolean',
'Categories.status' => 'boolean',
'status' => 'boolean',
'Categories__ordering' => 'integer',
'Categories.ordering' => 'integer',
'ordering' => 'integer',
'Categories__unpublished' => 'boolean',
'Categories.unpublished' => 'boolean',
'unpublished' => 'boolean',
'Categories__meta_title' => 'string',
'Categories.meta_title' => 'string',
'meta_title' => 'string',
'Categories__meta_description' => 'text',
'Categories.meta_description' => 'text',
'meta_description' => 'text',
'Categories__display_in_dropdown' => 'boolean',
'Categories.display_in_dropdown' => 'boolean',
'display_in_dropdown' => 'boolean',
'Categories__created' => 'datetime',
'Categories.created' => 'datetime',
'created' => 'datetime',
'Categories__modified' => 'datetime',
'Categories.modified' => 'datetime',
'modified' => 'datetime',
'Categories__flyer_image' => 'string',
'Categories.flyer_image' => 'string',
'flyer_image' => 'string',
'Categories__cartoptioncategory_id' => 'integer',
'Categories.cartoptioncategory_id' => 'integer',
'cartoptioncategory_id' => 'integer',
'Categories__shipping_value' => 'float',
'Categories.shipping_value' => 'float',
'shipping_value' => 'float',
'Categories__productwarranty_id' => 'integer',
'Categories.productwarranty_id' => 'integer',
'productwarranty_id' => 'integer'
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => false,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [],
'matching' => [],
'extraOptions' => [],
'repository' => object(App\Model\Table\CategoriesTable) {}
}
$generator = object(Cake\Database\ValueBinder) {
[protected] _bindings => [
':c0' => [
[maximum depth reached]
],
':c1' => [
[maximum depth reached]
],
':c2' => [
[maximum depth reached]
],
':c3' => [
[maximum depth reached]
],
':c4' => [
[maximum depth reached]
],
':c5' => [
[maximum depth reached]
],
':c6' => [
[maximum depth reached]
],
':c7' => [
[maximum depth reached]
],
':c8' => [
[maximum depth reached]
],
':c9' => [
[maximum depth reached]
],
':c10' => [
[maximum depth reached]
],
':c11' => [
[maximum depth reached]
],
':c12' => [
[maximum depth reached]
],
':c13' => [
[maximum depth reached]
]
]
[protected] _bindingsCount => (int) 14
} 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 257
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 228
Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 936
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 190
Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 957
Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276
Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 905
Cake\ORM\Query::toArray() - CORE/src/Datasource/QueryTrait.php, line 293
App\Controller\AppController::beforeFilter() - APP/Controller/AppController.php, line 421 Warning (2)CORE/src/Database/QueryCompiler.php , line 128 ]Code Context { return function ( $parts , $name ) use (& $sql , $query , $generator ) { if (! count ( $parts )) { $parts = null
$name = 'order'
$sql = 'SELECT Categories.name AS `Categories__name`, Categories.id AS `Categories__id`, Categories.category_image AS `Categories__category_image` FROM categories Categories WHERE (Categories.unpublished = :c0 AND Categories.id in (:c1,:c2,:c3,:c4,:c5,:c6,:c7,:c8,:c9,:c10,:c11,:c12,:c13))'
$query = object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SQL could not be generated for this query as it is incomplete.',
'params' => [],
'defaultTypes' => [
'Categories__id' => 'integer',
'Categories.id' => 'integer',
'id' => 'integer',
'Categories__parent_id' => 'integer',
'Categories.parent_id' => 'integer',
'parent_id' => 'integer',
'Categories__lft' => 'integer',
'Categories.lft' => 'integer',
'lft' => 'integer',
'Categories__rght' => 'integer',
'Categories.rght' => 'integer',
'rght' => 'integer',
'Categories__name' => 'string',
'Categories.name' => 'string',
'name' => 'string',
'Categories__surl' => 'string',
'Categories.surl' => 'string',
'surl' => 'string',
'Categories__description' => 'text',
'Categories.description' => 'text',
'description' => 'text',
'Categories__google_category' => 'string',
'Categories.google_category' => 'string',
'google_category' => 'string',
'Categories__category_image' => 'string',
'Categories.category_image' => 'string',
'category_image' => 'string',
'Categories__banner_1' => 'string',
'Categories.banner_1' => 'string',
'banner_1' => 'string',
'Categories__banner_1_start_date' => 'string',
'Categories.banner_1_start_date' => 'string',
'banner_1_start_date' => 'string',
'Categories__banner_1_end_date' => 'string',
'Categories.banner_1_end_date' => 'string',
'banner_1_end_date' => 'string',
'Categories__banner_2' => 'string',
'Categories.banner_2' => 'string',
'banner_2' => 'string',
'Categories__banner_2_start_date' => 'string',
'Categories.banner_2_start_date' => 'string',
'banner_2_start_date' => 'string',
'Categories__banner_2_end_date' => 'string',
'Categories.banner_2_end_date' => 'string',
'banner_2_end_date' => 'string',
'Categories__status' => 'boolean',
'Categories.status' => 'boolean',
'status' => 'boolean',
'Categories__ordering' => 'integer',
'Categories.ordering' => 'integer',
'ordering' => 'integer',
'Categories__unpublished' => 'boolean',
'Categories.unpublished' => 'boolean',
'unpublished' => 'boolean',
'Categories__meta_title' => 'string',
'Categories.meta_title' => 'string',
'meta_title' => 'string',
'Categories__meta_description' => 'text',
'Categories.meta_description' => 'text',
'meta_description' => 'text',
'Categories__display_in_dropdown' => 'boolean',
'Categories.display_in_dropdown' => 'boolean',
'display_in_dropdown' => 'boolean',
'Categories__created' => 'datetime',
'Categories.created' => 'datetime',
'created' => 'datetime',
'Categories__modified' => 'datetime',
'Categories.modified' => 'datetime',
'modified' => 'datetime',
'Categories__flyer_image' => 'string',
'Categories.flyer_image' => 'string',
'flyer_image' => 'string',
'Categories__cartoptioncategory_id' => 'integer',
'Categories.cartoptioncategory_id' => 'integer',
'cartoptioncategory_id' => 'integer',
'Categories__shipping_value' => 'float',
'Categories.shipping_value' => 'float',
'shipping_value' => 'float',
'Categories__productwarranty_id' => 'integer',
'Categories.productwarranty_id' => 'integer',
'productwarranty_id' => 'integer'
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => false,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [],
'matching' => [],
'extraOptions' => [],
'repository' => object(App\Model\Table\CategoriesTable) {}
}
$generator = object(Cake\Database\ValueBinder) {
[protected] _bindings => [
':c0' => [
[maximum depth reached]
],
':c1' => [
[maximum depth reached]
],
':c2' => [
[maximum depth reached]
],
':c3' => [
[maximum depth reached]
],
':c4' => [
[maximum depth reached]
],
':c5' => [
[maximum depth reached]
],
':c6' => [
[maximum depth reached]
],
':c7' => [
[maximum depth reached]
],
':c8' => [
[maximum depth reached]
],
':c9' => [
[maximum depth reached]
],
':c10' => [
[maximum depth reached]
],
':c11' => [
[maximum depth reached]
],
':c12' => [
[maximum depth reached]
],
':c13' => [
[maximum depth reached]
]
]
[protected] _bindingsCount => (int) 14
} 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 257
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 228
Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 936
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 190
Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 957
Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276
Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 905
Cake\ORM\Query::toArray() - CORE/src/Datasource/QueryTrait.php, line 293
App\Controller\AppController::beforeFilter() - APP/Controller/AppController.php, line 421 Warning (2)CORE/src/Database/QueryCompiler.php , line 128 ]Code Context { return function ( $parts , $name ) use (& $sql , $query , $generator ) { if (! count ( $parts )) { $parts = null
$name = 'limit'
$sql = 'SELECT Categories.name AS `Categories__name`, Categories.id AS `Categories__id`, Categories.category_image AS `Categories__category_image` FROM categories Categories WHERE (Categories.unpublished = :c0 AND Categories.id in (:c1,:c2,:c3,:c4,:c5,:c6,:c7,:c8,:c9,:c10,:c11,:c12,:c13))'
$query = object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SQL could not be generated for this query as it is incomplete.',
'params' => [],
'defaultTypes' => [
'Categories__id' => 'integer',
'Categories.id' => 'integer',
'id' => 'integer',
'Categories__parent_id' => 'integer',
'Categories.parent_id' => 'integer',
'parent_id' => 'integer',
'Categories__lft' => 'integer',
'Categories.lft' => 'integer',
'lft' => 'integer',
'Categories__rght' => 'integer',
'Categories.rght' => 'integer',
'rght' => 'integer',
'Categories__name' => 'string',
'Categories.name' => 'string',
'name' => 'string',
'Categories__surl' => 'string',
'Categories.surl' => 'string',
'surl' => 'string',
'Categories__description' => 'text',
'Categories.description' => 'text',
'description' => 'text',
'Categories__google_category' => 'string',
'Categories.google_category' => 'string',
'google_category' => 'string',
'Categories__category_image' => 'string',
'Categories.category_image' => 'string',
'category_image' => 'string',
'Categories__banner_1' => 'string',
'Categories.banner_1' => 'string',
'banner_1' => 'string',
'Categories__banner_1_start_date' => 'string',
'Categories.banner_1_start_date' => 'string',
'banner_1_start_date' => 'string',
'Categories__banner_1_end_date' => 'string',
'Categories.banner_1_end_date' => 'string',
'banner_1_end_date' => 'string',
'Categories__banner_2' => 'string',
'Categories.banner_2' => 'string',
'banner_2' => 'string',
'Categories__banner_2_start_date' => 'string',
'Categories.banner_2_start_date' => 'string',
'banner_2_start_date' => 'string',
'Categories__banner_2_end_date' => 'string',
'Categories.banner_2_end_date' => 'string',
'banner_2_end_date' => 'string',
'Categories__status' => 'boolean',
'Categories.status' => 'boolean',
'status' => 'boolean',
'Categories__ordering' => 'integer',
'Categories.ordering' => 'integer',
'ordering' => 'integer',
'Categories__unpublished' => 'boolean',
'Categories.unpublished' => 'boolean',
'unpublished' => 'boolean',
'Categories__meta_title' => 'string',
'Categories.meta_title' => 'string',
'meta_title' => 'string',
'Categories__meta_description' => 'text',
'Categories.meta_description' => 'text',
'meta_description' => 'text',
'Categories__display_in_dropdown' => 'boolean',
'Categories.display_in_dropdown' => 'boolean',
'display_in_dropdown' => 'boolean',
'Categories__created' => 'datetime',
'Categories.created' => 'datetime',
'created' => 'datetime',
'Categories__modified' => 'datetime',
'Categories.modified' => 'datetime',
'modified' => 'datetime',
'Categories__flyer_image' => 'string',
'Categories.flyer_image' => 'string',
'flyer_image' => 'string',
'Categories__cartoptioncategory_id' => 'integer',
'Categories.cartoptioncategory_id' => 'integer',
'cartoptioncategory_id' => 'integer',
'Categories__shipping_value' => 'float',
'Categories.shipping_value' => 'float',
'shipping_value' => 'float',
'Categories__productwarranty_id' => 'integer',
'Categories.productwarranty_id' => 'integer',
'productwarranty_id' => 'integer'
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => false,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [],
'matching' => [],
'extraOptions' => [],
'repository' => object(App\Model\Table\CategoriesTable) {}
}
$generator = object(Cake\Database\ValueBinder) {
[protected] _bindings => [
':c0' => [
[maximum depth reached]
],
':c1' => [
[maximum depth reached]
],
':c2' => [
[maximum depth reached]
],
':c3' => [
[maximum depth reached]
],
':c4' => [
[maximum depth reached]
],
':c5' => [
[maximum depth reached]
],
':c6' => [
[maximum depth reached]
],
':c7' => [
[maximum depth reached]
],
':c8' => [
[maximum depth reached]
],
':c9' => [
[maximum depth reached]
],
':c10' => [
[maximum depth reached]
],
':c11' => [
[maximum depth reached]
],
':c12' => [
[maximum depth reached]
],
':c13' => [
[maximum depth reached]
]
]
[protected] _bindingsCount => (int) 14
} 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 257
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 228
Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 936
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 190
Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 957
Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276
Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 905
Cake\ORM\Query::toArray() - CORE/src/Datasource/QueryTrait.php, line 293
App\Controller\AppController::beforeFilter() - APP/Controller/AppController.php, line 421 Warning (2)CORE/src/Database/QueryCompiler.php , line 128 ]Code Context { return function ( $parts , $name ) use (& $sql , $query , $generator ) { if (! count ( $parts )) { $parts = null
$name = 'offset'
$sql = 'SELECT Categories.name AS `Categories__name`, Categories.id AS `Categories__id`, Categories.category_image AS `Categories__category_image` FROM categories Categories WHERE (Categories.unpublished = :c0 AND Categories.id in (:c1,:c2,:c3,:c4,:c5,:c6,:c7,:c8,:c9,:c10,:c11,:c12,:c13))'
$query = object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SQL could not be generated for this query as it is incomplete.',
'params' => [],
'defaultTypes' => [
'Categories__id' => 'integer',
'Categories.id' => 'integer',
'id' => 'integer',
'Categories__parent_id' => 'integer',
'Categories.parent_id' => 'integer',
'parent_id' => 'integer',
'Categories__lft' => 'integer',
'Categories.lft' => 'integer',
'lft' => 'integer',
'Categories__rght' => 'integer',
'Categories.rght' => 'integer',
'rght' => 'integer',
'Categories__name' => 'string',
'Categories.name' => 'string',
'name' => 'string',
'Categories__surl' => 'string',
'Categories.surl' => 'string',
'surl' => 'string',
'Categories__description' => 'text',
'Categories.description' => 'text',
'description' => 'text',
'Categories__google_category' => 'string',
'Categories.google_category' => 'string',
'google_category' => 'string',
'Categories__category_image' => 'string',
'Categories.category_image' => 'string',
'category_image' => 'string',
'Categories__banner_1' => 'string',
'Categories.banner_1' => 'string',
'banner_1' => 'string',
'Categories__banner_1_start_date' => 'string',
'Categories.banner_1_start_date' => 'string',
'banner_1_start_date' => 'string',
'Categories__banner_1_end_date' => 'string',
'Categories.banner_1_end_date' => 'string',
'banner_1_end_date' => 'string',
'Categories__banner_2' => 'string',
'Categories.banner_2' => 'string',
'banner_2' => 'string',
'Categories__banner_2_start_date' => 'string',
'Categories.banner_2_start_date' => 'string',
'banner_2_start_date' => 'string',
'Categories__banner_2_end_date' => 'string',
'Categories.banner_2_end_date' => 'string',
'banner_2_end_date' => 'string',
'Categories__status' => 'boolean',
'Categories.status' => 'boolean',
'status' => 'boolean',
'Categories__ordering' => 'integer',
'Categories.ordering' => 'integer',
'ordering' => 'integer',
'Categories__unpublished' => 'boolean',
'Categories.unpublished' => 'boolean',
'unpublished' => 'boolean',
'Categories__meta_title' => 'string',
'Categories.meta_title' => 'string',
'meta_title' => 'string',
'Categories__meta_description' => 'text',
'Categories.meta_description' => 'text',
'meta_description' => 'text',
'Categories__display_in_dropdown' => 'boolean',
'Categories.display_in_dropdown' => 'boolean',
'display_in_dropdown' => 'boolean',
'Categories__created' => 'datetime',
'Categories.created' => 'datetime',
'created' => 'datetime',
'Categories__modified' => 'datetime',
'Categories.modified' => 'datetime',
'modified' => 'datetime',
'Categories__flyer_image' => 'string',
'Categories.flyer_image' => 'string',
'flyer_image' => 'string',
'Categories__cartoptioncategory_id' => 'integer',
'Categories.cartoptioncategory_id' => 'integer',
'cartoptioncategory_id' => 'integer',
'Categories__shipping_value' => 'float',
'Categories.shipping_value' => 'float',
'shipping_value' => 'float',
'Categories__productwarranty_id' => 'integer',
'Categories.productwarranty_id' => 'integer',
'productwarranty_id' => 'integer'
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => false,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [],
'matching' => [],
'extraOptions' => [],
'repository' => object(App\Model\Table\CategoriesTable) {}
}
$generator = object(Cake\Database\ValueBinder) {
[protected] _bindings => [
':c0' => [
[maximum depth reached]
],
':c1' => [
[maximum depth reached]
],
':c2' => [
[maximum depth reached]
],
':c3' => [
[maximum depth reached]
],
':c4' => [
[maximum depth reached]
],
':c5' => [
[maximum depth reached]
],
':c6' => [
[maximum depth reached]
],
':c7' => [
[maximum depth reached]
],
':c8' => [
[maximum depth reached]
],
':c9' => [
[maximum depth reached]
],
':c10' => [
[maximum depth reached]
],
':c11' => [
[maximum depth reached]
],
':c12' => [
[maximum depth reached]
],
':c13' => [
[maximum depth reached]
]
]
[protected] _bindingsCount => (int) 14
} 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 257
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 228
Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 936
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 190
Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 957
Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276
Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 905
Cake\ORM\Query::toArray() - CORE/src/Datasource/QueryTrait.php, line 293
App\Controller\AppController::beforeFilter() - APP/Controller/AppController.php, line 421 Warning (2)CORE/src/Database/QueryCompiler.php , line 128 ]Code Context { return function ( $parts , $name ) use (& $sql , $query , $generator ) { if (! count ( $parts )) { $parts = null
$name = 'epilog'
$sql = 'SELECT Categories.name AS `Categories__name`, Categories.id AS `Categories__id`, Categories.category_image AS `Categories__category_image` FROM categories Categories WHERE (Categories.unpublished = :c0 AND Categories.id in (:c1,:c2,:c3,:c4,:c5,:c6,:c7,:c8,:c9,:c10,:c11,:c12,:c13))'
$query = object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SQL could not be generated for this query as it is incomplete.',
'params' => [],
'defaultTypes' => [
'Categories__id' => 'integer',
'Categories.id' => 'integer',
'id' => 'integer',
'Categories__parent_id' => 'integer',
'Categories.parent_id' => 'integer',
'parent_id' => 'integer',
'Categories__lft' => 'integer',
'Categories.lft' => 'integer',
'lft' => 'integer',
'Categories__rght' => 'integer',
'Categories.rght' => 'integer',
'rght' => 'integer',
'Categories__name' => 'string',
'Categories.name' => 'string',
'name' => 'string',
'Categories__surl' => 'string',
'Categories.surl' => 'string',
'surl' => 'string',
'Categories__description' => 'text',
'Categories.description' => 'text',
'description' => 'text',
'Categories__google_category' => 'string',
'Categories.google_category' => 'string',
'google_category' => 'string',
'Categories__category_image' => 'string',
'Categories.category_image' => 'string',
'category_image' => 'string',
'Categories__banner_1' => 'string',
'Categories.banner_1' => 'string',
'banner_1' => 'string',
'Categories__banner_1_start_date' => 'string',
'Categories.banner_1_start_date' => 'string',
'banner_1_start_date' => 'string',
'Categories__banner_1_end_date' => 'string',
'Categories.banner_1_end_date' => 'string',
'banner_1_end_date' => 'string',
'Categories__banner_2' => 'string',
'Categories.banner_2' => 'string',
'banner_2' => 'string',
'Categories__banner_2_start_date' => 'string',
'Categories.banner_2_start_date' => 'string',
'banner_2_start_date' => 'string',
'Categories__banner_2_end_date' => 'string',
'Categories.banner_2_end_date' => 'string',
'banner_2_end_date' => 'string',
'Categories__status' => 'boolean',
'Categories.status' => 'boolean',
'status' => 'boolean',
'Categories__ordering' => 'integer',
'Categories.ordering' => 'integer',
'ordering' => 'integer',
'Categories__unpublished' => 'boolean',
'Categories.unpublished' => 'boolean',
'unpublished' => 'boolean',
'Categories__meta_title' => 'string',
'Categories.meta_title' => 'string',
'meta_title' => 'string',
'Categories__meta_description' => 'text',
'Categories.meta_description' => 'text',
'meta_description' => 'text',
'Categories__display_in_dropdown' => 'boolean',
'Categories.display_in_dropdown' => 'boolean',
'display_in_dropdown' => 'boolean',
'Categories__created' => 'datetime',
'Categories.created' => 'datetime',
'created' => 'datetime',
'Categories__modified' => 'datetime',
'Categories.modified' => 'datetime',
'modified' => 'datetime',
'Categories__flyer_image' => 'string',
'Categories.flyer_image' => 'string',
'flyer_image' => 'string',
'Categories__cartoptioncategory_id' => 'integer',
'Categories.cartoptioncategory_id' => 'integer',
'cartoptioncategory_id' => 'integer',
'Categories__shipping_value' => 'float',
'Categories.shipping_value' => 'float',
'shipping_value' => 'float',
'Categories__productwarranty_id' => 'integer',
'Categories.productwarranty_id' => 'integer',
'productwarranty_id' => 'integer'
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => false,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [],
'matching' => [],
'extraOptions' => [],
'repository' => object(App\Model\Table\CategoriesTable) {}
}
$generator = object(Cake\Database\ValueBinder) {
[protected] _bindings => [
':c0' => [
[maximum depth reached]
],
':c1' => [
[maximum depth reached]
],
':c2' => [
[maximum depth reached]
],
':c3' => [
[maximum depth reached]
],
':c4' => [
[maximum depth reached]
],
':c5' => [
[maximum depth reached]
],
':c6' => [
[maximum depth reached]
],
':c7' => [
[maximum depth reached]
],
':c8' => [
[maximum depth reached]
],
':c9' => [
[maximum depth reached]
],
':c10' => [
[maximum depth reached]
],
':c11' => [
[maximum depth reached]
],
':c12' => [
[maximum depth reached]
],
':c13' => [
[maximum depth reached]
]
]
[protected] _bindingsCount => (int) 14
} 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 257
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 228
Cake\ORM\Query::sql() - CORE/src/ORM/Query.php, line 936
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 190
Cake\ORM\Query::_execute() - CORE/src/ORM/Query.php, line 957
Cake\ORM\Query::_all() - CORE/src/Datasource/QueryTrait.php, line 276
Cake\ORM\Query::all() - CORE/src/ORM/Query.php, line 905
Cake\ORM\Query::toArray() - CORE/src/Datasource/QueryTrait.php, line 293
App\Controller\AppController::beforeFilter() - APP/Controller/AppController.php, line 421 Warning (512)CORE/src/Http/ResponseEmitter.php , line 48 ]Code Context $message = "Unable to emit headers. Headers sent in file= $file line= $line " ; if ( Configure :: read ( 'debug' )) { trigger_error ( $message , E_USER_WARNING ); $response = object(Zend\Diactoros\Response) {
[protected] headers => [
'Content-Type' => [
[maximum depth reached]
]
]
[protected] headerNames => [
'content-type' => 'Content-Type'
]
[private] phrases => [
(int) 100 => 'Continue',
(int) 101 => 'Switching Protocols',
(int) 102 => 'Processing',
(int) 200 => 'OK',
(int) 201 => 'Created',
(int) 202 => 'Accepted',
(int) 203 => 'Non-Authoritative Information',
(int) 204 => 'No Content',
(int) 205 => 'Reset Content',
(int) 206 => 'Partial Content',
(int) 207 => 'Multi-status',
(int) 208 => 'Already Reported',
(int) 226 => 'IM used',
(int) 300 => 'Multiple Choices',
(int) 301 => 'Moved Permanently',
(int) 302 => 'Found',
(int) 303 => 'See Other',
(int) 304 => 'Not Modified',
(int) 305 => 'Use Proxy',
(int) 306 => 'Switch Proxy',
(int) 307 => 'Temporary Redirect',
(int) 308 => 'Permanent Redirect',
(int) 400 => 'Bad Request',
(int) 401 => 'Unauthorized',
(int) 402 => 'Payment Required',
(int) 403 => 'Forbidden',
(int) 404 => 'Not Found',
(int) 405 => 'Method Not Allowed',
(int) 406 => 'Not Acceptable',
(int) 407 => 'Proxy Authentication Required',
(int) 408 => 'Request Time-out',
(int) 409 => 'Conflict',
(int) 410 => 'Gone',
(int) 411 => 'Length Required',
(int) 412 => 'Precondition Failed',
(int) 413 => 'Request Entity Too Large',
(int) 414 => 'Request-URI Too Large',
(int) 415 => 'Unsupported Media Type',
(int) 416 => 'Requested range not satisfiable',
(int) 417 => 'Expectation Failed',
(int) 418 => 'I'm a teapot',
(int) 421 => 'Misdirected Request',
(int) 422 => 'Unprocessable Entity',
(int) 423 => 'Locked',
(int) 424 => 'Failed Dependency',
(int) 425 => 'Unordered Collection',
(int) 426 => 'Upgrade Required',
(int) 428 => 'Precondition Required',
(int) 429 => 'Too Many Requests',
(int) 431 => 'Request Header Fields Too Large',
(int) 444 => 'Connection Closed Without Response',
(int) 451 => 'Unavailable For Legal Reasons',
(int) 499 => 'Client Closed Request',
(int) 500 => 'Internal Server Error',
(int) 501 => 'Not Implemented',
(int) 502 => 'Bad Gateway',
(int) 503 => 'Service Unavailable',
(int) 504 => 'Gateway Time-out',
(int) 505 => 'HTTP Version not supported',
(int) 506 => 'Variant Also Negotiates',
(int) 507 => 'Insufficient Storage',
(int) 508 => 'Loop Detected',
(int) 510 => 'Not Extended',
(int) 511 => 'Network Authentication Required',
(int) 599 => 'Network Connect Timeout Error'
]
[private] reasonPhrase => ''
[private] statusCode => (int) 200
[private] protocol => '1.1'
[private] stream => object(Zend\Diactoros\Stream) {}
}
$maxBufferLength = (int) 8192
$file = '/home/bestbrandapp/public_html/vendor/cakephp/cakephp/src/Error/Debugger.php'
$line = (int) 754
$message = 'Unable to emit headers. Headers sent in file=/home/bestbrandapp/public_html/vendor/cakephp/cakephp/src/Error/Debugger.php line=754' Cake\Http\ResponseEmitter::emit() - CORE/src/Http/ResponseEmitter.php, line 48
Cake\Http\Server::emit() - CORE/src/Http/Server.php, line 116
[main] - ROOT/webroot/index.php, line 37 Warning (2)CORE/src/Http/ResponseEmitter.php , line 145 ]Code Context $response -> getProtocolVersion (), $response -> getStatusCode (), ( $reasonPhrase ? ' ' . $reasonPhrase : '' ) $response = object(Zend\Diactoros\Response) {
[protected] headers => [
'Content-Type' => [
[maximum depth reached]
]
]
[protected] headerNames => [
'content-type' => 'Content-Type'
]
[private] phrases => [
(int) 100 => 'Continue',
(int) 101 => 'Switching Protocols',
(int) 102 => 'Processing',
(int) 200 => 'OK',
(int) 201 => 'Created',
(int) 202 => 'Accepted',
(int) 203 => 'Non-Authoritative Information',
(int) 204 => 'No Content',
(int) 205 => 'Reset Content',
(int) 206 => 'Partial Content',
(int) 207 => 'Multi-status',
(int) 208 => 'Already Reported',
(int) 226 => 'IM used',
(int) 300 => 'Multiple Choices',
(int) 301 => 'Moved Permanently',
(int) 302 => 'Found',
(int) 303 => 'See Other',
(int) 304 => 'Not Modified',
(int) 305 => 'Use Proxy',
(int) 306 => 'Switch Proxy',
(int) 307 => 'Temporary Redirect',
(int) 308 => 'Permanent Redirect',
(int) 400 => 'Bad Request',
(int) 401 => 'Unauthorized',
(int) 402 => 'Payment Required',
(int) 403 => 'Forbidden',
(int) 404 => 'Not Found',
(int) 405 => 'Method Not Allowed',
(int) 406 => 'Not Acceptable',
(int) 407 => 'Proxy Authentication Required',
(int) 408 => 'Request Time-out',
(int) 409 => 'Conflict',
(int) 410 => 'Gone',
(int) 411 => 'Length Required',
(int) 412 => 'Precondition Failed',
(int) 413 => 'Request Entity Too Large',
(int) 414 => 'Request-URI Too Large',
(int) 415 => 'Unsupported Media Type',
(int) 416 => 'Requested range not satisfiable',
(int) 417 => 'Expectation Failed',
(int) 418 => 'I'm a teapot',
(int) 421 => 'Misdirected Request',
(int) 422 => 'Unprocessable Entity',
(int) 423 => 'Locked',
(int) 424 => 'Failed Dependency',
(int) 425 => 'Unordered Collection',
(int) 426 => 'Upgrade Required',
(int) 428 => 'Precondition Required',
(int) 429 => 'Too Many Requests',
(int) 431 => 'Request Header Fields Too Large',
(int) 444 => 'Connection Closed Without Response',
(int) 451 => 'Unavailable For Legal Reasons',
(int) 499 => 'Client Closed Request',
(int) 500 => 'Internal Server Error',
(int) 501 => 'Not Implemented',
(int) 502 => 'Bad Gateway',
(int) 503 => 'Service Unavailable',
(int) 504 => 'Gateway Time-out',
(int) 505 => 'HTTP Version not supported',
(int) 506 => 'Variant Also Negotiates',
(int) 507 => 'Insufficient Storage',
(int) 508 => 'Loop Detected',
(int) 510 => 'Not Extended',
(int) 511 => 'Network Authentication Required',
(int) 599 => 'Network Connect Timeout Error'
]
[private] reasonPhrase => 'OK'
[private] statusCode => (int) 200
[private] protocol => '1.1'
[private] stream => object(Zend\Diactoros\Stream) {}
}
$reasonPhrase = 'OK' header - [internal], line ??
Cake\Http\ResponseEmitter::emitStatusLine() - CORE/src/Http/ResponseEmitter.php, line 145
Cake\Http\ResponseEmitter::emit() - CORE/src/Http/ResponseEmitter.php, line 54
Cake\Http\Server::emit() - CORE/src/Http/Server.php, line 116
[main] - ROOT/webroot/index.php, line 37 Warning (2)CORE/src/Http/ResponseEmitter.php , line 169 ]Code Context $first = true ; foreach ( $values as $value ) { header ( sprintf ( $response = object(Zend\Diactoros\Response) {
[protected] headers => [
'Content-Type' => [
[maximum depth reached]
]
]
[protected] headerNames => [
'content-type' => 'Content-Type'
]
[private] phrases => [
(int) 100 => 'Continue',
(int) 101 => 'Switching Protocols',
(int) 102 => 'Processing',
(int) 200 => 'OK',
(int) 201 => 'Created',
(int) 202 => 'Accepted',
(int) 203 => 'Non-Authoritative Information',
(int) 204 => 'No Content',
(int) 205 => 'Reset Content',
(int) 206 => 'Partial Content',
(int) 207 => 'Multi-status',
(int) 208 => 'Already Reported',
(int) 226 => 'IM used',
(int) 300 => 'Multiple Choices',
(int) 301 => 'Moved Permanently',
(int) 302 => 'Found',
(int) 303 => 'See Other',
(int) 304 => 'Not Modified',
(int) 305 => 'Use Proxy',
(int) 306 => 'Switch Proxy',
(int) 307 => 'Temporary Redirect',
(int) 308 => 'Permanent Redirect',
(int) 400 => 'Bad Request',
(int) 401 => 'Unauthorized',
(int) 402 => 'Payment Required',
(int) 403 => 'Forbidden',
(int) 404 => 'Not Found',
(int) 405 => 'Method Not Allowed',
(int) 406 => 'Not Acceptable',
(int) 407 => 'Proxy Authentication Required',
(int) 408 => 'Request Time-out',
(int) 409 => 'Conflict',
(int) 410 => 'Gone',
(int) 411 => 'Length Required',
(int) 412 => 'Precondition Failed',
(int) 413 => 'Request Entity Too Large',
(int) 414 => 'Request-URI Too Large',
(int) 415 => 'Unsupported Media Type',
(int) 416 => 'Requested range not satisfiable',
(int) 417 => 'Expectation Failed',
(int) 418 => 'I'm a teapot',
(int) 421 => 'Misdirected Request',
(int) 422 => 'Unprocessable Entity',
(int) 423 => 'Locked',
(int) 424 => 'Failed Dependency',
(int) 425 => 'Unordered Collection',
(int) 426 => 'Upgrade Required',
(int) 428 => 'Precondition Required',
(int) 429 => 'Too Many Requests',
(int) 431 => 'Request Header Fields Too Large',
(int) 444 => 'Connection Closed Without Response',
(int) 451 => 'Unavailable For Legal Reasons',
(int) 499 => 'Client Closed Request',
(int) 500 => 'Internal Server Error',
(int) 501 => 'Not Implemented',
(int) 502 => 'Bad Gateway',
(int) 503 => 'Service Unavailable',
(int) 504 => 'Gateway Time-out',
(int) 505 => 'HTTP Version not supported',
(int) 506 => 'Variant Also Negotiates',
(int) 507 => 'Insufficient Storage',
(int) 508 => 'Loop Detected',
(int) 510 => 'Not Extended',
(int) 511 => 'Network Authentication Required',
(int) 599 => 'Network Connect Timeout Error'
]
[private] reasonPhrase => 'OK'
[private] statusCode => (int) 200
[private] protocol => '1.1'
[private] stream => object(Zend\Diactoros\Stream) {}
}
$values = [
(int) 0 => 'text/html; charset=UTF-8'
]
$name = 'Content-Type'
$first = true
$value = 'text/html; charset=UTF-8' header - [internal], line ??
Cake\Http\ResponseEmitter::emitHeaders() - CORE/src/Http/ResponseEmitter.php, line 169
Cake\Http\ResponseEmitter::emit() - CORE/src/Http/ResponseEmitter.php, line 55
Cake\Http\Server::emit() - CORE/src/Http/Server.php, line 116
[main] - ROOT/webroot/index.php, line 37 Contact Us | Best Brand Appliance
Products added for enquiry
