Giving Animals

Database Error

Error: SQLSTATE[HY000]: General error: 1030 Got error 122 from storage engine

SQL Query: SHOW FULL COLUMNS FROM `test_petrescue`.`animals`

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 459 → 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/Database/Mysql.php line 309 → DboSource->_execute(string)

          $table = $this->fullTableName($model);
  
          $fields = false;
          $cols = $this->_execute('SHOW FULL COLUMNS FROM ' . $table);
          if (!$cols) {

  'SHOW FULL COLUMNS FROM `test_petrescue`.`animals`'

• CORE/Cake/Model/Model.php line 1321 → Mysql->describe(Animal)

              $db = $this->getDataSource();
              $db->cacheSources = ($this->cacheSources && $db->cacheSources);
              if (method_exists($db, 'describe')) {
                  $this->_schema = $db->describe($this);
              }

  object(Animal) {
  	actsAs => array(
  		[maximum depth reached]
  	)
  	validate => array(
  		[maximum depth reached]
  	)
  	belongsTo => array(
  		[maximum depth reached]
  	)
  	hasMany => array(
  		[maximum depth reached]
  	)
  	useDbConfig => 'default'
  	useTable => 'animals'
  	id => false
  	data => array([maximum depth reached])
  	schemaName => 'test_petrescue'
  	table => 'animals'
  	primaryKey => 'id'
  	validationErrors => array([maximum depth reached])
  	validationDomain => null
  	plugin => null
  	name => 'Animal'
  	alias => 'Animal'
  	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 => '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]
  	)
  	tablePrefix => ''
  	[protected] _schema => null
  	[protected] _associationKeys => array(
  		[maximum depth reached]
  	)
  	[protected] _associations => array(
  		[maximum depth reached]
  	)
  	[protected] _insertID => null
  	[protected] _sourceConfigured => true
  	[protected] _eventManager => null
  	[protected] _validator => null
  }

• CORE/Cake/Model/Model.php line 1358 → Model->schema()

   */
      public function getColumnType($column) {
          $db = $this->getDataSource();
          $cols = $this->schema();
          $model = null;

• CORE/Cake/Model/Datasource/DboSource.php line 2565 → Model->getColumnType(string)

              $virtual = true;
          }
  
          $type = is_object($model) ? $model->getColumnType($key) : null;
          $null = $value === null || (is_array($value) && empty($value));

  'Animal.id'

• CORE/Cake/Model/Datasource/DboSource.php line 2520 → DboSource->_parseKey(Animal, string, string)

                  } elseif (is_numeric($key) && !empty($value)) {
                      $data = $this->_quoteFields($value);
                  } else {
                      $data = $this->_parseKey($model, trim($key), $value);
                  }

  object(Animal) {
  	actsAs => array(
  		[maximum depth reached]
  	)
  	validate => array(
  		[maximum depth reached]
  	)
  	belongsTo => array(
  		[maximum depth reached]
  	)
  	hasMany => array(
  		[maximum depth reached]
  	)
  	useDbConfig => 'default'
  	useTable => 'animals'
  	id => false
  	data => array([maximum depth reached])
  	schemaName => 'test_petrescue'
  	table => 'animals'
  	primaryKey => 'id'
  	validationErrors => array([maximum depth reached])
  	validationDomain => null
  	plugin => null
  	name => 'Animal'
  	alias => 'Animal'
  	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 => '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]
  	)
  	tablePrefix => ''
  	[protected] _schema => null
  	[protected] _associationKeys => array(
  		[maximum depth reached]
  	)
  	[protected] _associations => array(
  		[maximum depth reached]
  	)
  	[protected] _insertID => null
  	[protected] _sourceConfigured => true
  	[protected] _eventManager => null
  	[protected] _validator => null
  }
  'Animal.id'
  '3607'

• CORE/Cake/Model/Datasource/DboSource.php line 2403 → DboSource->conditionKeysToString(array, boolean, Animal)

          }
  
          if (is_array($conditions) && !empty($conditions)) {
              $out = $this->conditionKeysToString($conditions, $quoteValues, $model);
  

  array(
  	'Animal.id' => '3607'
  )
  true
  object(Animal) {
  	actsAs => array(
  		[maximum depth reached]
  	)
  	validate => array(
  		[maximum depth reached]
  	)
  	belongsTo => array(
  		[maximum depth reached]
  	)
  	hasMany => array(
  		[maximum depth reached]
  	)
  	useDbConfig => 'default'
  	useTable => 'animals'
  	id => false
  	data => array([maximum depth reached])
  	schemaName => 'test_petrescue'
  	table => 'animals'
  	primaryKey => 'id'
  	validationErrors => array([maximum depth reached])
  	validationDomain => null
  	plugin => null
  	name => 'Animal'
  	alias => 'Animal'
  	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 => '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]
  	)
  	tablePrefix => ''
  	[protected] _schema => null
  	[protected] _associationKeys => array(
  		[maximum depth reached]
  	)
  	[protected] _associations => array(
  		[maximum depth reached]
  	)
  	[protected] _insertID => null
  	[protected] _sourceConfigured => true
  	[protected] _eventManager => null
  	[protected] _validator => null
  }

• CORE/Cake/Model/Datasource/DboSource.php line 1720 → DboSource->conditions(array, boolean, boolean, Animal)

              }
          }
          return $this->renderStatement('select', array(
              'conditions' => $this->conditions($query['conditions'], true, true, $model),
              'fields' => implode(', ', $query['fields']),

  array(
  	'Animal.id' => '3607'
  )
  true
  true
  object(Animal) {
  	actsAs => array(
  		[maximum depth reached]
  	)
  	validate => array(
  		[maximum depth reached]
  	)
  	belongsTo => array(
  		[maximum depth reached]
  	)
  	hasMany => array(
  		[maximum depth reached]
  	)
  	useDbConfig => 'default'
  	useTable => 'animals'
  	id => false
  	data => array([maximum depth reached])
  	schemaName => 'test_petrescue'
  	table => 'animals'
  	primaryKey => 'id'
  	validationErrors => array([maximum depth reached])
  	validationDomain => null
  	plugin => null
  	name => 'Animal'
  	alias => 'Animal'
  	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 => '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]
  	)
  	tablePrefix => ''
  	[protected] _schema => null
  	[protected] _associationKeys => array(
  		[maximum depth reached]
  	)
  	[protected] _associations => array(
  		[maximum depth reached]
  	)
  	[protected] _insertID => null
  	[protected] _sourceConfigured => true
  	[protected] _eventManager => null
  	[protected] _validator => null
  }

• CORE/Cake/Model/Datasource/DboSource.php line 1516 → DboSource->buildStatement(array, Animal)

                      'group' => $queryData['group']
                  ),
                  $model
              );
          }

  array(
  	'fields' => array(
  		(int) 0 => 'COUNT(*) AS `count`'
  	),
  	'table' => '`test_petrescue`.`animals`',
  	'alias' => 'Animal',
  	'limit' => null,
  	'offset' => null,
  	'joins' => array(),
  	'conditions' => array(
  		'Animal.id' => '3607'
  	),
  	'order' => array(
  		(int) 0 => false
  	),
  	'group' => null
  )
  object(Animal) {
  	actsAs => array(
  		[maximum depth reached]
  	)
  	validate => array(
  		[maximum depth reached]
  	)
  	belongsTo => array(
  		[maximum depth reached]
  	)
  	hasMany => array(
  		[maximum depth reached]
  	)
  	useDbConfig => 'default'
  	useTable => 'animals'
  	id => false
  	data => array([maximum depth reached])
  	schemaName => 'test_petrescue'
  	table => 'animals'
  	primaryKey => 'id'
  	validationErrors => array([maximum depth reached])
  	validationDomain => null
  	plugin => null
  	name => 'Animal'
  	alias => 'Animal'
  	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 => '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]
  	)
  	tablePrefix => ''
  	[protected] _schema => null
  	[protected] _associationKeys => array(
  		[maximum depth reached]
  	)
  	[protected] _associations => array(
  		[maximum depth reached]
  	)
  	[protected] _insertID => null
  	[protected] _sourceConfigured => true
  	[protected] _eventManager => null
  	[protected] _validator => null
  }

• CORE/Cake/Model/Datasource/DboSource.php line 1078 → DboSource->generateAssociationQuery(Animal, null, null, null, null, array, boolean, null)

              }
          }
  
          $query = trim($this->generateAssociationQuery($model, null, null, null, null, $queryData, false, $null));
  

  object(Animal) {
  	actsAs => array(
  		[maximum depth reached]
  	)
  	validate => array(
  		[maximum depth reached]
  	)
  	belongsTo => array(
  		[maximum depth reached]
  	)
  	hasMany => array(
  		[maximum depth reached]
  	)
  	useDbConfig => 'default'
  	useTable => 'animals'
  	id => false
  	data => array([maximum depth reached])
  	schemaName => 'test_petrescue'
  	table => 'animals'
  	primaryKey => 'id'
  	validationErrors => array([maximum depth reached])
  	validationDomain => null
  	plugin => null
  	name => 'Animal'
  	alias => 'Animal'
  	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 => '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]
  	)
  	tablePrefix => ''
  	[protected] _schema => null
  	[protected] _associationKeys => array(
  		[maximum depth reached]
  	)
  	[protected] _associations => array(
  		[maximum depth reached]
  	)
  	[protected] _insertID => null
  	[protected] _sourceConfigured => true
  	[protected] _eventManager => null
  	[protected] _validator => null
  }
  null
  null
  null
  null
  array(
  	'conditions' => array(
  		'Animal.id' => '3607'
  	),
  	'fields' => array(
  		(int) 0 => 'COUNT(*) AS `count`'
  	),
  	'joins' => array(),
  	'limit' => null,
  	'offset' => null,
  	'order' => array(
  		(int) 0 => false
  	),
  	'page' => (int) 1,
  	'group' => null,
  	'callbacks' => false,
  	'recursive' => (int) -1
  )
  false
  null

• CORE/Cake/Model/Model.php line 2674 → DboSource->read(Animal, array)

              return null;
          }
  
          $results = $this->getDataSource()->read($this, $query);
          $this->resetAssociations();

  object(Animal) {
  	actsAs => array(
  		[maximum depth reached]
  	)
  	validate => array(
  		[maximum depth reached]
  	)
  	belongsTo => array(
  		[maximum depth reached]
  	)
  	hasMany => array(
  		[maximum depth reached]
  	)
  	useDbConfig => 'default'
  	useTable => 'animals'
  	id => false
  	data => array([maximum depth reached])
  	schemaName => 'test_petrescue'
  	table => 'animals'
  	primaryKey => 'id'
  	validationErrors => array([maximum depth reached])
  	validationDomain => null
  	plugin => null
  	name => 'Animal'
  	alias => 'Animal'
  	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 => '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]
  	)
  	tablePrefix => ''
  	[protected] _schema => null
  	[protected] _associationKeys => array(
  		[maximum depth reached]
  	)
  	[protected] _associations => array(
  		[maximum depth reached]
  	)
  	[protected] _insertID => null
  	[protected] _sourceConfigured => true
  	[protected] _eventManager => null
  	[protected] _validator => null
  }
  array(
  	'conditions' => array(
  		'Animal.id' => '3607'
  	),
  	'fields' => 'COUNT(*) AS `count`',
  	'joins' => array(),
  	'limit' => null,
  	'offset' => null,
  	'order' => array(
  		(int) 0 => false
  	),
  	'page' => (int) 1,
  	'group' => null,
  	'callbacks' => false,
  	'recursive' => (int) -1
  )

• CORE/Cake/Model/Model.php line 2596 → Model->find(string, array)

              ),
              'recursive' => -1,
              'callbacks' => false
          ));
      }

  'count'
  array(
  	'conditions' => array(
  		'Animal.id' => '3607'
  	),
  	'recursive' => (int) -1,
  	'callbacks' => false
  )

• APP/Controller/AnimalsController.php line 265 → Model->exists(string)

   * @return void
   */
      public function view($id = null) {
          if (!$this->Animal->exists($id)) {
              throw new NotFoundException(__('Invalid animal'));

  '3607'

• [internal function] → AnimalsController->view(string)

  '3607'

• CORE/Cake/Controller/Controller.php line 485 → ReflectionMethod->invokeArgs(AnimalsController, array)

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

  object(AnimalsController) {
  	components => array(
  		[maximum depth reached]
  	)
  	filters => array(
  		[maximum depth reached]
  	)
  	uses => array(
  		[maximum depth reached]
  	)
  	theme => 'PetRescue'
  	name => 'Animals'
  	helpers => array([maximum depth reached])
  	request => object(CakeRequest) {}
  	response => object(CakeResponse) {}
  	viewPath => 'Animals'
  	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 => 'Animal'
  	modelKey => 'animal'
  	validationErrors => null
  	Session => object(SessionComponent) {}
  	Auth => object(AuthComponent) {}
  	Filter => object(FilterComponent) {}
  	Animal => object(Animal) {}
  	[protected] _responseClass => 'CakeResponse'
  	[protected] _mergeParent => 'AppController'
  	[protected] _eventManager => object(CakeEventManager) {}
  }
  array(
  	(int) 0 => '3607'
  )

• CORE/Cake/Routing/Dispatcher.php line 186 → 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 => 'animals/view/3607'
  	base => ''
  	webroot => '/'
  	here => '/animals/view/3607'
  	[protected] _detectors => array(
  		[maximum depth reached]
  	)
  	[protected] _input => ''
  }

• CORE/Cake/Routing/Dispatcher.php line 161 → Dispatcher->_invoke(AnimalsController, CakeRequest, CakeResponse)

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

  object(AnimalsController) {
  	components => array(
  		[maximum depth reached]
  	)
  	filters => array(
  		[maximum depth reached]
  	)
  	uses => array(
  		[maximum depth reached]
  	)
  	theme => 'PetRescue'
  	name => 'Animals'
  	helpers => array([maximum depth reached])
  	request => object(CakeRequest) {}
  	response => object(CakeResponse) {}
  	viewPath => 'Animals'
  	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 => 'Animal'
  	modelKey => 'animal'
  	validationErrors => null
  	Session => object(SessionComponent) {}
  	Auth => object(AuthComponent) {}
  	Filter => object(FilterComponent) {}
  	Animal => object(Animal) {}
  	[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 => 'animals/view/3607'
  	base => ''
  	webroot => '/'
  	here => '/animals/view/3607'
  	[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 97 → Dispatcher->dispatch(CakeRequest, CakeResponse)

  App::uses('Dispatcher', 'Routing');
  
  $Dispatcher = new Dispatcher();
  $Dispatcher->dispatch(new CakeRequest(), new CakeResponse());
  

  object(CakeRequest) {
  	params => array(
  		[maximum depth reached]
  	)
  	data => array([maximum depth reached])
  	query => array([maximum depth reached])
  	url => 'animals/view/3607'
  	base => ''
  	webroot => '/'
  	here => '/animals/view/3607'
  	[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])
  }