Mason County Research: Errors

Database Error

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

SQL Query: SELECT `Location`.`id`, `Location`.`name` FROM `masoncountyresearch`.`locations` AS `Location` WHERE 1 = 1

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 458 → 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 424 → DboSource->_execute(string, array)

        $options += array('log' => $this->fullDebug);



        $t = microtime(true);

        $this->_result = $this->_execute($sql, $params);

'SELECT `Location`.`id`, `Location`.`name` FROM `masoncountyresearch`.`locations` AS `Location`   WHERE 1 = 1'
array()

CORE/Cake/Model/Datasource/DboSource.php line 666 → DboSource->execute(string, array, array)

        if ($cache && ($cached = $this->getQueryCache($sql, $params)) !== false) {

            return $cached;

        }

        $result = $this->execute($sql, array(), $params);

        if ($result) {

'SELECT `Location`.`id`, `Location`.`name` FROM `masoncountyresearch`.`locations` AS `Location`   WHERE 1 = 1'
array()
array()

CORE/Cake/Model/Datasource/DboSource.php line 1106 → DboSource->fetchAll(string, boolean)

        // Build SQL statement with the primary model, plus hasOne and belongsTo associations

        $query = $this->buildAssociationQuery($Model, $queryData);



        $resultSet = $this->fetchAll($query, $Model->cacheQueries);

        unset($query);

'SELECT `Location`.`id`, `Location`.`name` FROM `masoncountyresearch`.`locations` AS `Location`   WHERE 1 = 1'
false

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

 * @return array

 */

    protected function _readDataSource($type, $query) {

        $results = $this->getDataSource()->read($this, $query);

        $this->resetAssociations();

object(Location) {
	belongsTo => array(
		[maximum depth reached]
	)
	hasMany => array(
		[maximum depth reached]
	)
	actsAs => array(
		[maximum depth reached]
	)
	useDbConfig => 'default'
	useTable => 'locations'
	displayField => 'name'
	id => false
	data => array([maximum depth reached])
	schemaName => 'masoncountyresearch'
	table => 'locations'
	primaryKey => 'id'
	validate => array([maximum depth reached])
	validationErrors => array([maximum depth reached])
	validationDomain => null
	tablePrefix => ''
	plugin => null
	name => 'Location'
	alias => 'Location'
	tableToModel => array(
		[maximum depth reached]
	)
	cacheQueries => false
	hasOne => array([maximum depth reached])
	hasAndBelongsToMany => array([maximum depth reached])
	Behaviors => object(BehaviorCollection) {}
	whitelist => array([maximum depth reached])
	cacheSources => true
	findQueryType => 'list'
	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' => null,
	'fields' => array(
		(int) 0 => 'Location.id',
		(int) 1 => 'Location.name'
	),
	'joins' => array(),
	'limit' => null,
	'offset' => null,
	'order' => array(
		(int) 0 => null
	),
	'page' => (int) 1,
	'group' => null,
	'callbacks' => true,
	'recursive' => (int) -1,
	'list' => array(
		'groupPath' => null,
		'valuePath' => '{n}.Location.name',
		'keyPath' => '{n}.Location.id'
	)
)

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

            return null;

        }



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

    }

'list'
array(
	'conditions' => null,
	'fields' => array(
		(int) 0 => 'Location.id',
		(int) 1 => 'Location.name'
	),
	'joins' => array(),
	'limit' => null,
	'offset' => null,
	'order' => array(
		(int) 0 => null
	),
	'page' => (int) 1,
	'group' => null,
	'callbacks' => true,
	'recursive' => (int) -1,
	'list' => array(
		'groupPath' => null,
		'valuePath' => '{n}.Location.name',
		'keyPath' => '{n}.Location.id'
	)
)

APP/Controller/StatusesController.php line 50 → Model->find(string)

        $this->set('items', $this->paginate($this->Status->Item, array('Status.id'=> $id))); 

        $categories = $this->Status->Item->Category->find('list');

        $donors = $this->Status->Item->Donor->find('list');

        $locations = $this->Status->Item->Location->find('list');

        $this->set(compact('categories','locations', 'donors'));

'list'

[internal function] → StatusesController->view(string)
```
'5'
```

CORE/Cake/Controller/Controller.php line 490 → ReflectionMethod->invokeArgs(StatusesController, array)

                    'action' => $request->params['action']

                ));

            }

            return $method->invokeArgs($this, $request->params['pass']);

object(StatusesController) {
	components => array(
		[maximum depth reached]
	)
	helpers => array(
		[maximum depth reached]
	)
	name => 'Statuses'
	uses => array(
		[maximum depth reached]
	)
	request => object(CakeRequest) {}
	response => object(CakeResponse) {}
	viewPath => 'Statuses'
	layoutPath => null
	viewVars => array(
		[maximum depth reached]
	)
	view => 'view'
	layout => 'default'
	autoRender => true
	autoLayout => true
	Components => object(ComponentCollection) {}
	viewClass => 'View'
	View => null
	ext => '.ctp'
	plugin => null
	cacheAction => false
	passedArgs => array(
		[maximum depth reached]
	)
	scaffold => false
	methods => array(
		[maximum depth reached]
	)
	modelClass => 'Status'
	modelKey => 'status'
	validationErrors => null
	Acl => object(AclComponent) {}
	Auth => object(AuthComponent) {}
	Session => object(SessionComponent) {}
	Paginator => object(PaginatorComponent) {}
	Status => object(Status) {}
	[protected] _responseClass => 'CakeResponse'
	[protected] _mergeParent => 'AppController'
	[protected] _eventManager => object(CakeEventManager) {}
}
array(
	(int) 0 => '5'
)

CORE/Cake/Routing/Dispatcher.php line 191 → Controller->invokeAction(CakeRequest)



        $response = $controller->response;

        $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 => 'statuses/view/5/page:920/sort:Location.name/direction:desc'
	base => ''
	webroot => '/'
	here => '/statuses/view/5/page:920/sort:Location.name/direction:desc'
	[protected] _detectors => array(
		[maximum depth reached]
	)
	[protected] _input => ''
}

CORE/Cake/Routing/Dispatcher.php line 165 → Dispatcher->_invoke(StatusesController, CakeRequest)

            ));

        }



        $response = $this->_invoke($controller, $request);

        if (isset($request->params['return'])) {

object(StatusesController) {
	components => array(
		[maximum depth reached]
	)
	helpers => array(
		[maximum depth reached]
	)
	name => 'Statuses'
	uses => array(
		[maximum depth reached]
	)
	request => object(CakeRequest) {}
	response => object(CakeResponse) {}
	viewPath => 'Statuses'
	layoutPath => null
	viewVars => array(
		[maximum depth reached]
	)
	view => 'view'
	layout => 'default'
	autoRender => true
	autoLayout => true
	Components => object(ComponentCollection) {}
	viewClass => 'View'
	View => null
	ext => '.ctp'
	plugin => null
	cacheAction => false
	passedArgs => array(
		[maximum depth reached]
	)
	scaffold => false
	methods => array(
		[maximum depth reached]
	)
	modelClass => 'Status'
	modelKey => 'status'
	validationErrors => null
	Acl => object(AclComponent) {}
	Auth => object(AuthComponent) {}
	Session => object(SessionComponent) {}
	Paginator => object(PaginatorComponent) {}
	Status => object(Status) {}
	[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 => 'statuses/view/5/page:920/sort:Location.name/direction:desc'
	base => ''
	webroot => '/'
	here => '/statuses/view/5/page:920/sort:Location.name/direction:desc'
	[protected] _detectors => array(
		[maximum depth reached]
	)
	[protected] _input => ''
}

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 => 'statuses/view/5/page:920/sort:Location.name/direction:desc'
	base => ''
	webroot => '/'
	here => '/statuses/view/5/page:920/sort:Location.name/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] _fileRange => null
	[protected] _charset => 'UTF-8'
	[protected] _cacheDirectives => array([maximum depth reached])
	[protected] _cookies => array([maximum depth reached])
}