Warning (2) : PDOStatement::execute(): MySQL server has gone away [CORE/Cake/Model/Datasource/DboSource.php , line 460 ]Code Context $query = $this -> _connection -> prepare ( $sql , $prepareOptions );
$query -> setFetchMode ( PDO :: FETCH_LAZY );
if (! $query -> execute ( $params )) {
$sql = 'SELECT COUNT(*) AS `count` FROM `shopgtsd_db`.`products` AS `Product` WHERE `category_id` = '60132' AND `Product`.`status` = '1' AND (location = '0' OR location = '2')'
$params = array()
$prepareOptions = array()
$this = object(Mysql) {
description => 'MySQL DBO Driver'
startQuote => '`'
endQuote => '`'
fieldParameters => array(
'charset' => array(
[maximum depth reached]
),
'collate' => array(
[maximum depth reached]
),
'comment' => array(
[maximum depth reached]
)
)
tableParameters => array(
'charset' => array(
[maximum depth reached]
),
'collate' => array(
[maximum depth reached]
),
'engine' => array(
[maximum depth reached]
)
)
columns => array(
'primary_key' => array(
[maximum depth reached]
),
'string' => array(
[maximum depth reached]
),
'text' => array(
[maximum depth reached]
),
'biginteger' => array(
[maximum depth reached]
),
'integer' => array(
[maximum depth reached]
),
'float' => array(
[maximum depth reached]
),
'datetime' => array(
[maximum depth reached]
),
'timestamp' => array(
[maximum depth reached]
),
'time' => array(
[maximum depth reached]
),
'date' => array(
[maximum depth reached]
),
'binary' => array(
[maximum depth reached]
),
'boolean' => array(
[maximum depth reached]
)
)
index => array(
'PRI' => 'primary',
'MUL' => 'index',
'UNI' => 'unique'
)
alias => 'AS '
cacheMethods => true
useNestedTransactions => false
fullDebug => true
affected => (int) 6
numRows => (int) 6
took => (float) 2219
configKeyName => 'default'
virtualFieldSeparator => '__'
connected => true
config => array(
'password' => '*****',
'login' => '*****',
'host' => '*****',
'database' => '*****',
'port' => '*****',
'prefix' => '*****',
'persistent' => false,
'datasource' => 'Database/Mysql'
)
cacheSources => true
map => array(
(int) 0 => array(
[maximum depth reached]
),
(int) 1 => array(
[maximum depth reached]
),
(int) 2 => array(
[maximum depth reached]
),
(int) 3 => array(
[maximum depth reached]
),
(int) 4 => array(
[maximum depth reached]
),
(int) 5 => array(
[maximum depth reached]
),
(int) 6 => array(
[maximum depth reached]
),
(int) 7 => array(
[maximum depth reached]
),
(int) 8 => array(
[maximum depth reached]
),
(int) 9 => array(
[maximum depth reached]
),
(int) 10 => array(
[maximum depth reached]
),
(int) 11 => array(
[maximum depth reached]
),
(int) 12 => array(
[maximum depth reached]
),
(int) 13 => array(
[maximum depth reached]
),
(int) 14 => array(
[maximum depth reached]
),
(int) 15 => array(
[maximum depth reached]
),
(int) 16 => array(
[maximum depth reached]
),
(int) 17 => array(
[maximum depth reached]
),
(int) 18 => array(
[maximum depth reached]
),
(int) 19 => array(
[maximum depth reached]
),
(int) 20 => array(
[maximum depth reached]
),
(int) 21 => array(
[maximum depth reached]
),
(int) 22 => array(
[maximum depth reached]
),
(int) 23 => array(
[maximum depth reached]
),
(int) 24 => array(
[maximum depth reached]
),
(int) 25 => array(
[maximum depth reached]
),
(int) 26 => array(
[maximum depth reached]
),
(int) 27 => array(
[maximum depth reached]
),
(int) 28 => array(
[maximum depth reached]
),
(int) 29 => array(
[maximum depth reached]
),
(int) 30 => array(
[maximum depth reached]
),
(int) 31 => array(
[maximum depth reached]
),
(int) 32 => array(
[maximum depth reached]
),
(int) 33 => array(
[maximum depth reached]
),
(int) 34 => array(
[maximum depth reached]
)
)
[protected] _baseConfig => array(
'password' => '*****',
'login' => '*****',
'host' => '*****',
'database' => '*****',
'port' => '*****',
'persistent' => true
)
[protected] _connection => object(PDO) {}
[protected] _useAlias => true
[protected] _charsets => array(
'utf8_general_ci' => 'utf8',
'utf8_bin' => 'utf8',
'utf8_unicode_ci' => 'utf8'
)
[protected] _result => object(PDOStatement) {}
[protected] _queriesCnt => (int) 15
[protected] _queriesTime => (float) 2294
[protected] _queriesLog => array(
(int) 0 => array(
[maximum depth reached]
),
(int) 1 => array(
[maximum depth reached]
),
(int) 2 => array(
[maximum depth reached]
),
(int) 3 => array(
[maximum depth reached]
),
(int) 4 => array(
[maximum depth reached]
),
(int) 5 => array(
[maximum depth reached]
),
(int) 6 => array(
[maximum depth reached]
),
(int) 7 => array(
[maximum depth reached]
),
(int) 8 => array(
[maximum depth reached]
),
(int) 9 => array(
[maximum depth reached]
),
(int) 10 => array(
[maximum depth reached]
),
(int) 11 => array(
[maximum depth reached]
),
(int) 12 => array(
[maximum depth reached]
),
(int) 13 => array(
[maximum depth reached]
),
(int) 14 => array(
[maximum depth reached]
)
)
[protected] _queriesLogMax => (int) 200
[protected] _queryCache => array()
[protected] _sqlOps => array(
(int) 0 => 'like',
(int) 1 => 'ilike',
(int) 2 => 'or',
(int) 3 => 'not',
(int) 4 => 'in',
(int) 5 => 'between',
(int) 6 => 'regexp',
(int) 7 => 'similar to'
)
[protected] _transactionNesting => (int) 0
[protected] _queryDefaults => array(
'conditions' => array([maximum depth reached]),
'fields' => null,
'table' => null,
'alias' => null,
'order' => null,
'limit' => null,
'joins' => array([maximum depth reached]),
'group' => null,
'offset' => null
)
[protected] _methodCacheChange => true
[protected] _descriptions => array(
'shopgtsd_db.margins' => array(
[maximum depth reached]
),
'shopgtsd_db.categories' => array(
[maximum depth reached]
),
'shopgtsd_db.categorymargins' => array(
[maximum depth reached]
),
'shopgtsd_db.products' => array(
[maximum depth reached]
)
)
[protected] _sources => array(
(int) 0 => 'accounts',
(int) 1 => 'accounts-20160622',
(int) 2 => 'accounts-20220630',
(int) 3 => 'categories',
(int) 4 => 'categorymargins',
(int) 5 => 'catmajor',
(int) 6 => 'catminor',
(int) 7 => 'contactformdetails',
(int) 8 => 'contactforms',
(int) 9 => 'contracts',
(int) 10 => 'contracts-20210506',
(int) 11 => 'contracts-20220627',
(int) 12 => 'contracts-20221003',
(int) 13 => 'contracts-20240703',
(int) 14 => 'contracts20250223',
(int) 15 => 'countries',
(int) 16 => 'custtemp',
(int) 17 => 'eplusmonthlies',
(int) 18 => 'eplusmonthlies-20191202',
(int) 19 => 'eplusmonthlies-20230106',
(int) 20 => 'eplusmonthlies-20230529',
(int) 21 => 'eplusmonthlies-20240522',
(int) 22 => 'favourites',
(int) 23 => 'hpprices',
(int) 24 => 'importecats',
(int) 25 => 'importispc',
(int) 26 => 'importquarters',
(int) 27 => 'importsales',
(int) 28 => 'importweeks',
(int) 29 => 'importweeksmalls',
(int) 30 => 'invoices',
(int) 31 => 'labels',
(int) 32 => 'locations',
(int) 33 => 'manufacturers',
(int) 34 => 'margins',
(int) 35 => 'newcattemp',
(int) 36 => 'orders',
(int) 37 => 'orders_products',
(int) 38 => 'orders_products20250609',
(int) 39 => 'productdetails',
(int) 40 => 'products',
(int) 41 => 'products20200609',
(int) 42 => 'products20250206-before-sff-prods',
(int) 43 => 'shoppriceupdates',
(int) 44 => 'shoppriceupdates20230831',
(int) 45 => 'shoppriceupdates20231108',
(int) 46 => 'systemsettings',
(int) 47 => 'tradeapps',
(int) 48 => 'users',
(int) 49 => 'webproducts',
(int) 50 => 'zones'
)
[protected] _transactionStarted => false
}
$query = object(PDOStatement) {
queryString => 'SELECT COUNT(*) AS `count` FROM `shopgtsd_db`.`products` AS `Product` WHERE `category_id` = '60132' AND `Product`.`status` = '1' AND (location = '0' OR location = '2')'
} PDOStatement::execute() - [internal], line ??
DboSource::_execute() - CORE/Cake/Model/Datasource/DboSource.php, line 460
DboSource::execute() - CORE/Cake/Model/Datasource/DboSource.php, line 426
DboSource::fetchAll() - CORE/Cake/Model/Datasource/DboSource.php, line 670
DboSource::read() - CORE/Cake/Model/Datasource/DboSource.php, line 1081
Model::find() - CORE/Cake/Model/Model.php, line 2688
PaginatorComponent::paginate() - CORE/Cake/Controller/Component/PaginatorComponent.php, line 210
Controller::paginate() - CORE/Cake/Controller/Controller.php, line 1074
CategoryController::view() - APP/Controller/CategoryController.php, line 286
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 486
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 187
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 162
[main] - APP/webroot/index.php, line 92 Warning (2) : PDOStatement::execute() [pdostatement.execute ]: Error reading result set's header [CORE/Cake/Model/Datasource/DboSource.php , line 460 ]Code Context $query = $this -> _connection -> prepare ( $sql , $prepareOptions );
$query -> setFetchMode ( PDO :: FETCH_LAZY );
if (! $query -> execute ( $params )) {
$sql = 'SELECT COUNT(*) AS `count` FROM `shopgtsd_db`.`products` AS `Product` WHERE `category_id` = '60132' AND `Product`.`status` = '1' AND (location = '0' OR location = '2')'
$params = array()
$prepareOptions = array()
$this = object(Mysql) {
description => 'MySQL DBO Driver'
startQuote => '`'
endQuote => '`'
fieldParameters => array(
'charset' => array(
[maximum depth reached]
),
'collate' => array(
[maximum depth reached]
),
'comment' => array(
[maximum depth reached]
)
)
tableParameters => array(
'charset' => array(
[maximum depth reached]
),
'collate' => array(
[maximum depth reached]
),
'engine' => array(
[maximum depth reached]
)
)
columns => array(
'primary_key' => array(
[maximum depth reached]
),
'string' => array(
[maximum depth reached]
),
'text' => array(
[maximum depth reached]
),
'biginteger' => array(
[maximum depth reached]
),
'integer' => array(
[maximum depth reached]
),
'float' => array(
[maximum depth reached]
),
'datetime' => array(
[maximum depth reached]
),
'timestamp' => array(
[maximum depth reached]
),
'time' => array(
[maximum depth reached]
),
'date' => array(
[maximum depth reached]
),
'binary' => array(
[maximum depth reached]
),
'boolean' => array(
[maximum depth reached]
)
)
index => array(
'PRI' => 'primary',
'MUL' => 'index',
'UNI' => 'unique'
)
alias => 'AS '
cacheMethods => true
useNestedTransactions => false
fullDebug => true
affected => (int) 6
numRows => (int) 6
took => (float) 2219
configKeyName => 'default'
virtualFieldSeparator => '__'
connected => true
config => array(
'password' => '*****',
'login' => '*****',
'host' => '*****',
'database' => '*****',
'port' => '*****',
'prefix' => '*****',
'persistent' => false,
'datasource' => 'Database/Mysql'
)
cacheSources => true
map => array(
(int) 0 => array(
[maximum depth reached]
),
(int) 1 => array(
[maximum depth reached]
),
(int) 2 => array(
[maximum depth reached]
),
(int) 3 => array(
[maximum depth reached]
),
(int) 4 => array(
[maximum depth reached]
),
(int) 5 => array(
[maximum depth reached]
),
(int) 6 => array(
[maximum depth reached]
),
(int) 7 => array(
[maximum depth reached]
),
(int) 8 => array(
[maximum depth reached]
),
(int) 9 => array(
[maximum depth reached]
),
(int) 10 => array(
[maximum depth reached]
),
(int) 11 => array(
[maximum depth reached]
),
(int) 12 => array(
[maximum depth reached]
),
(int) 13 => array(
[maximum depth reached]
),
(int) 14 => array(
[maximum depth reached]
),
(int) 15 => array(
[maximum depth reached]
),
(int) 16 => array(
[maximum depth reached]
),
(int) 17 => array(
[maximum depth reached]
),
(int) 18 => array(
[maximum depth reached]
),
(int) 19 => array(
[maximum depth reached]
),
(int) 20 => array(
[maximum depth reached]
),
(int) 21 => array(
[maximum depth reached]
),
(int) 22 => array(
[maximum depth reached]
),
(int) 23 => array(
[maximum depth reached]
),
(int) 24 => array(
[maximum depth reached]
),
(int) 25 => array(
[maximum depth reached]
),
(int) 26 => array(
[maximum depth reached]
),
(int) 27 => array(
[maximum depth reached]
),
(int) 28 => array(
[maximum depth reached]
),
(int) 29 => array(
[maximum depth reached]
),
(int) 30 => array(
[maximum depth reached]
),
(int) 31 => array(
[maximum depth reached]
),
(int) 32 => array(
[maximum depth reached]
),
(int) 33 => array(
[maximum depth reached]
),
(int) 34 => array(
[maximum depth reached]
)
)
[protected] _baseConfig => array(
'password' => '*****',
'login' => '*****',
'host' => '*****',
'database' => '*****',
'port' => '*****',
'persistent' => true
)
[protected] _connection => object(PDO) {}
[protected] _useAlias => true
[protected] _charsets => array(
'utf8_general_ci' => 'utf8',
'utf8_bin' => 'utf8',
'utf8_unicode_ci' => 'utf8'
)
[protected] _result => object(PDOStatement) {}
[protected] _queriesCnt => (int) 15
[protected] _queriesTime => (float) 2294
[protected] _queriesLog => array(
(int) 0 => array(
[maximum depth reached]
),
(int) 1 => array(
[maximum depth reached]
),
(int) 2 => array(
[maximum depth reached]
),
(int) 3 => array(
[maximum depth reached]
),
(int) 4 => array(
[maximum depth reached]
),
(int) 5 => array(
[maximum depth reached]
),
(int) 6 => array(
[maximum depth reached]
),
(int) 7 => array(
[maximum depth reached]
),
(int) 8 => array(
[maximum depth reached]
),
(int) 9 => array(
[maximum depth reached]
),
(int) 10 => array(
[maximum depth reached]
),
(int) 11 => array(
[maximum depth reached]
),
(int) 12 => array(
[maximum depth reached]
),
(int) 13 => array(
[maximum depth reached]
),
(int) 14 => array(
[maximum depth reached]
)
)
[protected] _queriesLogMax => (int) 200
[protected] _queryCache => array()
[protected] _sqlOps => array(
(int) 0 => 'like',
(int) 1 => 'ilike',
(int) 2 => 'or',
(int) 3 => 'not',
(int) 4 => 'in',
(int) 5 => 'between',
(int) 6 => 'regexp',
(int) 7 => 'similar to'
)
[protected] _transactionNesting => (int) 0
[protected] _queryDefaults => array(
'conditions' => array([maximum depth reached]),
'fields' => null,
'table' => null,
'alias' => null,
'order' => null,
'limit' => null,
'joins' => array([maximum depth reached]),
'group' => null,
'offset' => null
)
[protected] _methodCacheChange => true
[protected] _descriptions => array(
'shopgtsd_db.margins' => array(
[maximum depth reached]
),
'shopgtsd_db.categories' => array(
[maximum depth reached]
),
'shopgtsd_db.categorymargins' => array(
[maximum depth reached]
),
'shopgtsd_db.products' => array(
[maximum depth reached]
)
)
[protected] _sources => array(
(int) 0 => 'accounts',
(int) 1 => 'accounts-20160622',
(int) 2 => 'accounts-20220630',
(int) 3 => 'categories',
(int) 4 => 'categorymargins',
(int) 5 => 'catmajor',
(int) 6 => 'catminor',
(int) 7 => 'contactformdetails',
(int) 8 => 'contactforms',
(int) 9 => 'contracts',
(int) 10 => 'contracts-20210506',
(int) 11 => 'contracts-20220627',
(int) 12 => 'contracts-20221003',
(int) 13 => 'contracts-20240703',
(int) 14 => 'contracts20250223',
(int) 15 => 'countries',
(int) 16 => 'custtemp',
(int) 17 => 'eplusmonthlies',
(int) 18 => 'eplusmonthlies-20191202',
(int) 19 => 'eplusmonthlies-20230106',
(int) 20 => 'eplusmonthlies-20230529',
(int) 21 => 'eplusmonthlies-20240522',
(int) 22 => 'favourites',
(int) 23 => 'hpprices',
(int) 24 => 'importecats',
(int) 25 => 'importispc',
(int) 26 => 'importquarters',
(int) 27 => 'importsales',
(int) 28 => 'importweeks',
(int) 29 => 'importweeksmalls',
(int) 30 => 'invoices',
(int) 31 => 'labels',
(int) 32 => 'locations',
(int) 33 => 'manufacturers',
(int) 34 => 'margins',
(int) 35 => 'newcattemp',
(int) 36 => 'orders',
(int) 37 => 'orders_products',
(int) 38 => 'orders_products20250609',
(int) 39 => 'productdetails',
(int) 40 => 'products',
(int) 41 => 'products20200609',
(int) 42 => 'products20250206-before-sff-prods',
(int) 43 => 'shoppriceupdates',
(int) 44 => 'shoppriceupdates20230831',
(int) 45 => 'shoppriceupdates20231108',
(int) 46 => 'systemsettings',
(int) 47 => 'tradeapps',
(int) 48 => 'users',
(int) 49 => 'webproducts',
(int) 50 => 'zones'
)
[protected] _transactionStarted => false
}
$query = object(PDOStatement) {
queryString => 'SELECT COUNT(*) AS `count` FROM `shopgtsd_db`.`products` AS `Product` WHERE `category_id` = '60132' AND `Product`.`status` = '1' AND (location = '0' OR location = '2')'
} PDOStatement::execute() - [internal], line ??
DboSource::_execute() - CORE/Cake/Model/Datasource/DboSource.php, line 460
DboSource::execute() - CORE/Cake/Model/Datasource/DboSource.php, line 426
DboSource::fetchAll() - CORE/Cake/Model/Datasource/DboSource.php, line 670
DboSource::read() - CORE/Cake/Model/Datasource/DboSource.php, line 1081
Model::find() - CORE/Cake/Model/Model.php, line 2688
PaginatorComponent::paginate() - CORE/Cake/Controller/Component/PaginatorComponent.php, line 210
Controller::paginate() - CORE/Cake/Controller/Controller.php, line 1074
CategoryController::view() - APP/Controller/CategoryController.php, line 286
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 486
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 187
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 162
[main] - APP/webroot/index.php, line 92
GTS Direct
Database Error
Error:
SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
SQL Query:
SELECT COUNT(*) AS `count` FROM `shopgtsd_db`.`products` AS `Product` WHERE `category_id` = '60132' AND `Product`.`status` = '1' AND (location = '0' OR location = '2')
Notice:
If you want to customize this error message, create app/View/Errors/pdo_error.ctp
Stack Trace
CORE/Cake/Model/Datasource/DboSource.php line 460 → PDOStatement->execute(array) try {
$query = $this -> _connection -> prepare ( $sql , $prepareOptions );
$query -> setFetchMode ( PDO :: FETCH_LAZY );
if (! $query -> execute ( $params )) {
$this -> _results = $query ;
CORE/Cake/Model/Datasource/DboSource.php line 426 → DboSource->_execute(string, array) $options += array( 'log' => $this -> fullDebug );
$t = microtime ( true );
$this -> _result = $this -> _execute ( $sql , $params );
'SELECT COUNT(*) AS `count` FROM `shopgtsd_db`.`products` AS `Product` WHERE `category_id` = '60132' AND `Product`.`status` = '1' AND (location = '0' OR location = '2')'
array()
CORE/Cake/Model/Datasource/DboSource.php line 670 → DboSource->execute(string, array, array) if ( $cache && ( $cached = $this -> getQueryCache ( $sql , $params )) !== false ) {
return $cached ;
}
if ( $result = $this -> execute ( $sql , array(), $params )) {
$out = array();
'SELECT COUNT(*) AS `count` FROM `shopgtsd_db`.`products` AS `Product` WHERE `category_id` = '60132' AND `Product`.`status` = '1' AND (location = '0' OR location = '2')'
array()
array()
CORE/Cake/Model/Datasource/DboSource.php line 1081 → DboSource->fetchAll(string, boolean)
$query = trim ( $this -> generateAssociationQuery ( $model , null , null , null , null , $queryData , false , $null ));
$resultSet = $this -> fetchAll ( $query , $model -> cacheQueries );
'SELECT COUNT(*) AS `count` FROM `shopgtsd_db`.`products` AS `Product` WHERE `category_id` = '60132' AND `Product`.`status` = '1' AND (location = '0' OR location = '2')'
false
CORE/Cake/Model/Model.php line 2688 → DboSource->read(Product, array) return null ;
}
$results = $this -> getDataSource ()-> read ( $this , $query );
$this -> resetAssociations ();
object(Product) {
thispercentage => (float) 0.01
virtualFields => array(
[maximum depth reached]
)
belongsTo => array(
[maximum depth reached]
)
hasOne => array(
[maximum depth reached]
)
hasMany => array(
[maximum depth reached]
)
useDbConfig => 'default'
useTable => 'products'
id => false
data => array([maximum depth reached])
schemaName => 'shopgtsd_db'
table => 'products'
primaryKey => 'id'
validate => array([maximum depth reached])
validationErrors => array([maximum depth reached])
validationDomain => null
plugin => null
name => 'Product'
alias => 'Product'
tableToModel => array(
[maximum depth reached]
)
cacheQueries => false
hasAndBelongsToMany => array([maximum depth reached])
actsAs => null
Behaviors => object(BehaviorCollection) {}
whitelist => array([maximum depth reached])
cacheSources => true
findQueryType => 'count'
recursive => (int) -1
order => null
__backAssociation => array([maximum depth reached])
__backInnerAssociation => array([maximum depth reached])
__backOriginalAssociation => array([maximum depth reached])
__backContainableAssociation => array([maximum depth reached])
findMethods => array(
[maximum depth reached]
)
qpercent => (float) 0.01
tablePrefix => ''
[protected] _schema => array(
[maximum depth reached]
)
[protected] _associationKeys => array(
[maximum depth reached]
)
[protected] _associations => array(
[maximum depth reached]
)
[protected] _insertID => null
[protected] _sourceConfigured => true
[protected] _eventManager => object(CakeEventManager) {}
[protected] _validator => null
}
array(
'conditions' => array(
'category_id' => '60132',
'Product.status' => (int) 1,
(int) 0 => '(location = '0' OR location = '2')'
),
'fields' => 'COUNT(*) AS `count`',
'joins' => array(),
'limit' => null,
'offset' => null,
'order' => array(
(int) 0 => false
),
'page' => (int) 1,
'group' => null,
'callbacks' => true,
'recursive' => (int) -1,
'maxLimit' => (int) 10,
'paramType' => 'named',
'sort' => 'Product.nonvow',
'direction' => 'DESC'
)
CORE/Cake/Controller/Component/PaginatorComponent.php line 210 → Model->find(string, array) if ( $recursive != $object -> recursive ) {
$parameters [ 'recursive' ] = $recursive ;
}
$count = $object -> find ( 'count' , array_merge ( $parameters , $extra ));
}
'count'
array(
'conditions' => array(
'category_id' => '60132',
'Product.status' => (int) 1,
(int) 0 => '(location = '0' OR location = '2')'
),
'recursive' => (int) -1,
'maxLimit' => (int) 10,
'paramType' => 'named',
'sort' => 'Product.nonvow',
'direction' => 'DESC'
)
CORE/Cake/Controller/Controller.php line 1074 → PaginatorComponent->paginate(string, array, array) * @ deprecated Use PaginatorComponent instead
*/
public function paginate ( $object = null , $scope = array(), $whitelist = array()) {
return $this -> Components -> load ( 'Paginator' , $this -> paginate )-> paginate ( $object , $scope , $whitelist );
}
'Product'
array()
array()
APP/Controller/CategoryController.php line 286 → Controller->paginate(string) 'recursive' =>- 1
)
);
$products = $this -> paginate ( 'Product' );
[internal function] → CategoryController->view(string)
CORE/Cake/Controller/Controller.php line 486 → ReflectionMethod->invokeArgs(CategoryController, array) 'action' => $request -> params [ 'action' ]
));
}
return $method -> invokeArgs ( $this , $request -> params [ 'pass' ]);
object(CategoryController) {
paginate => array(
[maximum depth reached]
)
name => 'Category'
uses => array(
[maximum depth reached]
)
helpers => array([maximum depth reached])
request => object(CakeRequest) {}
response => object(CakeResponse) {}
viewPath => 'Category'
layoutPath => null
viewVars => array(
[maximum depth reached]
)
view => 'view'
layout => 'default'
autoRender => true
autoLayout => true
Components => object(ComponentCollection) {}
components => array(
[maximum depth reached]
)
viewClass => 'View'
View => null
ext => '.ctp'
plugin => null
cacheAction => false
passedArgs => array(
[maximum depth reached]
)
scaffold => false
methods => array(
[maximum depth reached]
)
modelClass => 'Category'
modelKey => 'category'
validationErrors => null
Session => object(SessionComponent) {}
Margin => object(Margin) {}
Category => object(Category) {}
Product => object(Product) {}
Categorymargin => object(Categorymargin) {}
[protected] _responseClass => 'CakeResponse'
[protected] _mergeParent => 'AppController'
[protected] _eventManager => object(CakeEventManager) {}
}
array(
(int) 0 => '60132'
)
CORE/Cake/Routing/Dispatcher.php line 187 → Controller->invokeAction(CakeRequest) $controller -> startupProcess ();
$render = true ;
$result = $controller -> invokeAction ( $request );
if ( $result instanceof CakeResponse ) {
object(CakeRequest) {
params => array(
[maximum depth reached]
)
data => array([maximum depth reached])
query => array([maximum depth reached])
url => 'category/view/60132/page:2/sort:Product.nonvow/direction:DESC'
base => ''
webroot => '/'
here => '/category/view/60132/page:2/sort:Product.nonvow/direction:DESC'
[protected] _detectors => array(
[maximum depth reached]
)
[protected] _input => ''
}
CORE/Cake/Routing/Dispatcher.php line 162 → Dispatcher->_invoke(CategoryController, CakeRequest, CakeResponse) ));
}
$response = $this -> _invoke ( $controller , $request , $response );
if (isset( $request -> params [ 'return' ])) {
object(CategoryController) {
paginate => array(
[maximum depth reached]
)
name => 'Category'
uses => array(
[maximum depth reached]
)
helpers => array([maximum depth reached])
request => object(CakeRequest) {}
response => object(CakeResponse) {}
viewPath => 'Category'
layoutPath => null
viewVars => array(
[maximum depth reached]
)
view => 'view'
layout => 'default'
autoRender => true
autoLayout => true
Components => object(ComponentCollection) {}
components => array(
[maximum depth reached]
)
viewClass => 'View'
View => null
ext => '.ctp'
plugin => null
cacheAction => false
passedArgs => array(
[maximum depth reached]
)
scaffold => false
methods => array(
[maximum depth reached]
)
modelClass => 'Category'
modelKey => 'category'
validationErrors => null
Session => object(SessionComponent) {}
Margin => object(Margin) {}
Category => object(Category) {}
Product => object(Product) {}
Categorymargin => object(Categorymargin) {}
[protected] _responseClass => 'CakeResponse'
[protected] _mergeParent => 'AppController'
[protected] _eventManager => object(CakeEventManager) {}
}
object(CakeRequest) {
params => array(
[maximum depth reached]
)
data => array([maximum depth reached])
query => array([maximum depth reached])
url => 'category/view/60132/page:2/sort:Product.nonvow/direction:DESC'
base => ''
webroot => '/'
here => '/category/view/60132/page:2/sort:Product.nonvow/direction:DESC'
[protected] _detectors => array(
[maximum depth reached]
)
[protected] _input => ''
}
object(CakeResponse) {
[protected] _statusCodes => array(
[maximum depth reached]
)
[protected] _mimeTypes => array(
[maximum depth reached]
)
[protected] _protocol => 'HTTP/1.1'
[protected] _status => (int) 200
[protected] _contentType => 'text/html'
[protected] _headers => array([maximum depth reached])
[protected] _body => null
[protected] _file => null
[protected] _charset => 'UTF-8'
[protected] _cacheDirectives => array([maximum depth reached])
[protected] _cookies => array([maximum depth reached])
}
APP/webroot/index.php line 92 → Dispatcher->dispatch(CakeRequest, CakeResponse) App :: uses ( 'Dispatcher' , 'Routing' );
$Dispatcher = new Dispatcher ();
$Dispatcher -> dispatch (new CakeRequest (), new CakeResponse (array( 'charset' => Configure :: read ( 'App.encoding' ))));
object(CakeRequest) {
params => array(
[maximum depth reached]
)
data => array([maximum depth reached])
query => array([maximum depth reached])
url => 'category/view/60132/page:2/sort:Product.nonvow/direction:DESC'
base => ''
webroot => '/'
here => '/category/view/60132/page:2/sort:Product.nonvow/direction:DESC'
[protected] _detectors => array(
[maximum depth reached]
)
[protected] _input => ''
}
object(CakeResponse) {
[protected] _statusCodes => array(
[maximum depth reached]
)
[protected] _mimeTypes => array(
[maximum depth reached]
)
[protected] _protocol => 'HTTP/1.1'
[protected] _status => (int) 200
[protected] _contentType => 'text/html'
[protected] _headers => array([maximum depth reached])
[protected] _body => null
[protected] _file => null
[protected] _charset => 'UTF-8'
[protected] _cacheDirectives => array([maximum depth reached])
[protected] _cookies => array([maximum depth reached])
}