Toko Ani | Errors

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 `tokoan39_web2`.`carts` AS `Cart`   WHERE `session_id` = 'deacbcc77096912efc352195ef2b838d''
$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) 37
	numRows => (int) 37
	took => (float) 0
	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]
		)
	)
	[protected] _baseConfig => array(
		'password' => '*****',
		'login' => '*****',
		'host' => '*****',
		'database' => '*****',
		'port' => '*****',
		'persistent' => true
	)
	[protected] _connection => object(PDO) {}
	[protected] _useAlias => true
	[protected] _charsets => array()
	[protected] _result => object(PDOStatement) {}
	[protected] _queriesCnt => (int) 2
	[protected] _queriesTime => (float) 0
	[protected] _queriesLog => array(
		(int) 0 => array(
			[maximum depth reached]
		),
		(int) 1 => 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 => false
	[protected] _descriptions => array(
		'tokoan39_web2.carts' => array(
			[maximum depth reached]
		)
	)
	[protected] _sources => array(
		(int) 0 => 'brands',
		(int) 1 => 'carts',
		(int) 2 => 'categories',
		(int) 3 => 'category_types',
		(int) 4 => 'configurations',
		(int) 5 => 'course_galleries',
		(int) 6 => 'course_schedules',
		(int) 7 => 'courses',
		(int) 8 => 'order_details',
		(int) 9 => 'orders',
		(int) 10 => 'pages',
		(int) 11 => 'product',
		(int) 12 => 'product_attributes',
		(int) 13 => 'products',
		(int) 14 => 'productss',
		(int) 15 => 'slideshows',
		(int) 16 => 'users'
	)
	[protected] _transactionStarted => false
}
$query = object(PDOStatement) {
	queryString => 'SELECT COUNT(*) AS `count` FROM `tokoan39_web2`.`carts` AS `Cart`   WHERE `session_id` = 'deacbcc77096912efc352195ef2b838d''
}

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 666
DboSource::read() - CORE/Cake/Model/Datasource/DboSource.php, line 1077
Model::_readDataSource() - CORE/Cake/Model/Model.php, line 2750
Model::find() - CORE/Cake/Model/Model.php, line 2722
AppController::beforeFilter() - APP/Controller/AppController.php, line 43
call_user_func - [internal], line ??
CakeEventManager::dispatch() - CORE/Cake/Event/CakeEventManager.php, line 248
Controller::startupProcess() - CORE/Cake/Controller/Controller.php, line 674
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 184
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 162
[main] - APP/webroot/index.php, line 108

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 `tokoan39_web2`.`carts` AS `Cart`   WHERE `session_id` = 'deacbcc77096912efc352195ef2b838d''
$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) 37
	numRows => (int) 37
	took => (float) 0
	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]
		)
	)
	[protected] _baseConfig => array(
		'password' => '*****',
		'login' => '*****',
		'host' => '*****',
		'database' => '*****',
		'port' => '*****',
		'persistent' => true
	)
	[protected] _connection => object(PDO) {}
	[protected] _useAlias => true
	[protected] _charsets => array()
	[protected] _result => object(PDOStatement) {}
	[protected] _queriesCnt => (int) 2
	[protected] _queriesTime => (float) 0
	[protected] _queriesLog => array(
		(int) 0 => array(
			[maximum depth reached]
		),
		(int) 1 => 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 => false
	[protected] _descriptions => array(
		'tokoan39_web2.carts' => array(
			[maximum depth reached]
		)
	)
	[protected] _sources => array(
		(int) 0 => 'brands',
		(int) 1 => 'carts',
		(int) 2 => 'categories',
		(int) 3 => 'category_types',
		(int) 4 => 'configurations',
		(int) 5 => 'course_galleries',
		(int) 6 => 'course_schedules',
		(int) 7 => 'courses',
		(int) 8 => 'order_details',
		(int) 9 => 'orders',
		(int) 10 => 'pages',
		(int) 11 => 'product',
		(int) 12 => 'product_attributes',
		(int) 13 => 'products',
		(int) 14 => 'productss',
		(int) 15 => 'slideshows',
		(int) 16 => 'users'
	)
	[protected] _transactionStarted => false
}
$query = object(PDOStatement) {
	queryString => 'SELECT COUNT(*) AS `count` FROM `tokoan39_web2`.`carts` AS `Cart`   WHERE `session_id` = 'deacbcc77096912efc352195ef2b838d''
}

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 666
DboSource::read() - CORE/Cake/Model/Datasource/DboSource.php, line 1077
Model::_readDataSource() - CORE/Cake/Model/Model.php, line 2750
Model::find() - CORE/Cake/Model/Model.php, line 2722
AppController::beforeFilter() - APP/Controller/AppController.php, line 43
call_user_func - [internal], line ??
CakeEventManager::dispatch() - CORE/Cake/Event/CakeEventManager.php, line 248
Controller::startupProcess() - CORE/Cake/Controller/Controller.php, line 674
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 184
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 162
[main] - APP/webroot/index.php, line 108

Database Error

Error: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away

SQL Query: SELECT COUNT(*) AS `count` FROM `tokoan39_web2`.`carts` AS `Cart` WHERE `session_id` = 'deacbcc77096912efc352195ef2b838d'

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;

array()

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 `tokoan39_web2`.`carts` AS `Cart`   WHERE `session_id` = 'deacbcc77096912efc352195ef2b838d''
array()

CORE/Cake/Model/Datasource/DboSource.php line 666 → 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 `tokoan39_web2`.`carts` AS `Cart`   WHERE `session_id` = 'deacbcc77096912efc352195ef2b838d''
array()
array()

CORE/Cake/Model/Datasource/DboSource.php line 1077 → 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 `tokoan39_web2`.`carts` AS `Cart`   WHERE `session_id` = 'deacbcc77096912efc352195ef2b838d''
false

CORE/Cake/Model/Model.php line 2750 → DboSource->read(AppModel, array)

 * @return array
 */
    protected function _readDataSource($type, $query) {
        $results = $this->getDataSource()->read($this, $query);
        $this->resetAssociations();

object(AppModel) {
	useDbConfig => 'default'
	useTable => 'carts'
	id => false
	data => array([maximum depth reached])
	schemaName => 'tokoan39_web2'
	table => 'carts'
	primaryKey => 'id'
	validate => array([maximum depth reached])
	validationErrors => array([maximum depth reached])
	validationDomain => null
	tablePrefix => ''
	plugin => null
	name => 'Cart'
	alias => 'Cart'
	tableToModel => array(
		[maximum depth reached]
	)
	cacheQueries => false
	belongsTo => array([maximum depth reached])
	hasOne => array([maximum depth reached])
	hasMany => array([maximum depth reached])
	hasAndBelongsToMany => array([maximum depth reached])
	actsAs => null
	Behaviors => object(BehaviorCollection) {}
	whitelist => array([maximum depth reached])
	cacheSources => true
	findQueryType => 'count'
	recursive => (int) 1
	order => null
	virtualFields => array([maximum depth reached])
	__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]
	)
	[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(
		'session_id' => 'deacbcc77096912efc352195ef2b838d'
	),
	'fields' => 'COUNT(*) AS `count`',
	'joins' => array(),
	'limit' => null,
	'offset' => null,
	'order' => array(
		(int) 0 => false
	),
	'page' => (int) 1,
	'group' => null,
	'callbacks' => true
)

CORE/Cake/Model/Model.php line 2722 → Model->_readDataSource(string, array)

            return null;
        }

        return $this->_readDataSource($type, $query);
    }

'count'
array(
	'conditions' => array(
		'session_id' => 'deacbcc77096912efc352195ef2b838d'
	),
	'fields' => 'COUNT(*) AS `count`',
	'joins' => array(),
	'limit' => null,
	'offset' => null,
	'order' => array(
		(int) 0 => false
	),
	'page' => (int) 1,
	'group' => null,
	'callbacks' => true
)

APP/Controller/AppController.php line 43 → Model->find(string, array)

        $brands = $this->Brand->find('list',array('fields'=>array('Brand.id','Brand.brand'),'order'=>'brand ASC'));
        $this->set(compact('brand','brands'));
        $this->loadModel('Cart');
        $count= $this->Cart->find('count',array('conditions'=>array('session_id'=>$this->Session->read('Config.userAgent'))));
        $this->set(compact('count'));

'count'
array(
	'conditions' => array(
		'session_id' => 'deacbcc77096912efc352195ef2b838d'
	)
)

[internal function] → AppController->beforeFilter(CakeEvent)

object(CakeEvent) {
	data => null
	result => null
	[protected] _name => 'Controller.initialize'
	[protected] _subject => object(ProductsController) {}
	[protected] _stopped => false
}

CORE/Cake/Event/CakeEventManager.php line 248 → call_user_func(array, CakeEvent)

            if ($listener['passParams'] === true) {
                $result = call_user_func_array($listener['callable'], $event->data);
            } else {
                $result = call_user_func($listener['callable'], $event);
            }

array(
	(int) 0 => object(ProductsController) {},
	(int) 1 => 'beforeFilter'
)
object(CakeEvent) {
	data => null
	result => null
	[protected] _name => 'Controller.initialize'
	[protected] _subject => object(ProductsController) {}
	[protected] _stopped => false
}

CORE/Cake/Controller/Controller.php line 674 → CakeEventManager->dispatch(CakeEvent)

 * @return void
 */
    public function startupProcess() {
        $this->getEventManager()->dispatch(new CakeEvent('Controller.initialize', $this));
        $this->getEventManager()->dispatch(new CakeEvent('Controller.startup', $this));

object(CakeEvent) {
	data => null
	result => null
	[protected] _name => 'Controller.initialize'
	[protected] _subject => object(ProductsController) {}
	[protected] _stopped => false
}

CORE/Cake/Routing/Dispatcher.php line 184 → Controller->startupProcess()

 */
    protected function _invoke(Controller $controller, CakeRequest $request, CakeResponse $response) {
        $controller->constructClasses();
        $controller->startupProcess();

CORE/Cake/Routing/Dispatcher.php line 162 → Dispatcher->_invoke(ProductsController, CakeRequest, CakeResponse)

            ));
        }

        $response = $this->_invoke($controller, $request, $response);
        if (isset($request->params['return'])) {

object(ProductsController) {
	uses => array(
		[maximum depth reached]
	)
	name => 'Products'
	helpers => array([maximum depth reached])
	request => object(CakeRequest) {}
	response => object(CakeResponse) {}
	viewPath => 'Products'
	layoutPath => null
	viewVars => array(
		[maximum depth reached]
	)
	view => 'category'
	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 => 'product'
	validationErrors => null
	Session => object(SessionComponent) {}
	theme => 'Metro'
	Brand => object(AppModel) {}
	Cart => object(AppModel) {}
	[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 => 'products/category/218'
	base => ''
	webroot => '/'
	here => '/products/category/218'
	[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] _fileRange => null
	[protected] _charset => 'UTF-8'
	[protected] _cacheDirectives => array([maximum depth reached])
	[protected] _cookies => array([maximum depth reached])
}

APP/webroot/index.php line 108 → Dispatcher->dispatch(CakeRequest, CakeResponse)

$Dispatcher->dispatch(
    new CakeRequest(),
    new CakeResponse()
);

object(CakeRequest) {
	params => array(
		[maximum depth reached]
	)
	data => array([maximum depth reached])
	query => array([maximum depth reached])
	url => 'products/category/218'
	base => ''
	webroot => '/'
	here => '/products/category/218'
	[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] _fileRange => null
	[protected] _charset => 'UTF-8'
	[protected] _cacheDirectives => array([maximum depth reached])
	[protected] _cookies => array([maximum depth reached])
}