CakePHP: the rapid development php framework

Database Error

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

SQL Query: SHOW FULL COLUMNS FROM `lucky_collection`.`tags`

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 461 → 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 340 → DboSource->_execute(string)

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

  'SHOW FULL COLUMNS FROM `lucky_collection`.`tags`'

• CORE/Cake/Model/Model.php line 1389 → Mysql->describe(Tag)

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

  object(Tag) {
  	hasAndBelongsToMany => array(
  		'Question' => array(
  			'className' => 'Question',
  			'joinTable' => 'tagged',
  			'foreignKey' => 'foreign_key',
  			'associationForeignKey' => 'tag_id',
  			'unique' => true,
  			'conditions' => array(
  				[maximum depth reached]
  			),
  			'with' => 'Tagged',
  			'dynamicWith' => true,
  			'fields' => '',
  			'order' => '',
  			'limit' => '',
  			'offset' => '',
  			'finderQuery' => ''
  		),
  		'Board' => array(
  			'className' => 'Board',
  			'joinTable' => 'tagged',
  			'foreignKey' => 'foreign_key',
  			'associationForeignKey' => 'tag_id',
  			'unique' => true,
  			'conditions' => array(
  				[maximum depth reached]
  			),
  			'with' => 'Tagged',
  			'dynamicWith' => true,
  			'fields' => '',
  			'order' => '',
  			'limit' => '',
  			'offset' => '',
  			'finderQuery' => ''
  		)
  	)
  	validate => array(
  		'name' => array(
  			'notblank' => array(
  				[maximum depth reached]
  			),
  			'max' => array(
  				[maximum depth reached]
  			)
  		),
  		'description' => array(
  			'rule' => array(
  				[maximum depth reached]
  			),
  			'message' => '説明は100文字以内で入力してください',
  			'required' => false,
  			'allowEmpty' => true
  		)
  	)
  	useDbConfig => 'default'
  	useTable => 'tags'
  	id => false
  	data => array()
  	schemaName => 'lucky_collection'
  	table => 'tags'
  	primaryKey => 'id'
  	validationErrors => array()
  	validationDomain => null
  	tablePrefix => ''
  	plugin => null
  	name => 'Tag'
  	alias => 'Tag'
  	tableToModel => array(
  		'tags' => 'Tag'
  	)
  	cacheQueries => false
  	belongsTo => array()
  	hasOne => array()
  	hasMany => array()
  	actsAs => null
  	Behaviors => object(BehaviorCollection) {
  		modelName => 'Tag'
  		defaultPriority => (int) 10
  		[protected] _methods => array([maximum depth reached])
  		[protected] _mappedMethods => array([maximum depth reached])
  		[protected] _enabled => array([maximum depth reached])
  		[protected] _loaded => array([maximum depth reached])
  	}
  	whitelist => array()
  	cacheSources => true
  	findQueryType => 'all'
  	recursive => (int) -1
  	order => null
  	virtualFields => array()
  	__backAssociation => array()
  	__backInnerAssociation => array()
  	__backOriginalAssociation => array()
  	__backContainableAssociation => array()
  	__safeUpdateMode => false
  	useConsistentAfterFind => true
  	findMethods => array(
  		'all' => true,
  		'first' => true,
  		'count' => true,
  		'neighbors' => true,
  		'list' => true,
  		'threaded' => true
  	)
  	[protected] _schema => null
  	[protected] _associationKeys => array(
  		'belongsTo' => array(
  			(int) 0 => 'className',
  			(int) 1 => 'foreignKey',
  			(int) 2 => 'conditions',
  			(int) 3 => 'fields',
  			(int) 4 => 'order',
  			(int) 5 => 'counterCache'
  		),
  		'hasOne' => array(
  			(int) 0 => 'className',
  			(int) 1 => 'foreignKey',
  			(int) 2 => 'conditions',
  			(int) 3 => 'fields',
  			(int) 4 => 'order',
  			(int) 5 => 'dependent'
  		),
  		'hasMany' => array(
  			(int) 0 => 'className',
  			(int) 1 => 'foreignKey',
  			(int) 2 => 'conditions',
  			(int) 3 => 'fields',
  			(int) 4 => 'order',
  			(int) 5 => 'limit',
  			(int) 6 => 'offset',
  			(int) 7 => 'dependent',
  			(int) 8 => 'exclusive',
  			(int) 9 => 'finderQuery',
  			(int) 10 => 'counterQuery'
  		),
  		'hasAndBelongsToMany' => array(
  			(int) 0 => 'className',
  			(int) 1 => 'joinTable',
  			(int) 2 => 'with',
  			(int) 3 => 'foreignKey',
  			(int) 4 => 'associationForeignKey',
  			(int) 5 => 'conditions',
  			(int) 6 => 'fields',
  			(int) 7 => 'order',
  			(int) 8 => 'limit',
  			(int) 9 => 'offset',
  			(int) 10 => 'unique',
  			(int) 11 => 'finderQuery'
  		)
  	)
  	[protected] _associations => array(
  		(int) 0 => 'belongsTo',
  		(int) 1 => 'hasOne',
  		(int) 2 => 'hasMany',
  		(int) 3 => 'hasAndBelongsToMany'
  	)
  	[protected] _insertID => null
  	[protected] _sourceConfigured => true
  	[protected] _eventManager => object(CakeEventManager) {
  		[protected] _generalManager => object(CakeEventManager) {}
  		[protected] _listeners => array(
  			[maximum depth reached]
  		)
  		[protected] _isGlobal => false
  	}
  	[protected] _validator => null
  }

• CORE/Cake/Model/Datasource/DboSource.php line 2529 → Model->schema()

          }
          $allFields = empty($fields);
          if ($allFields) {
              $fields = array_keys($Model->schema());
          } elseif (!is_array($fields)) {

• CORE/Cake/Model/Datasource/DboSource.php line 1061 → DboSource->fields(Tag)

              $queryData['fields'] = $this->fields($Model, null, $queryData['fields']);
          } else {
              $noAssocFields = false;
              $queryData['fields'] = $this->fields($Model);
          }

  object(Tag) {
  	hasAndBelongsToMany => array(
  		'Question' => array(
  			'className' => 'Question',
  			'joinTable' => 'tagged',
  			'foreignKey' => 'foreign_key',
  			'associationForeignKey' => 'tag_id',
  			'unique' => true,
  			'conditions' => array(
  				[maximum depth reached]
  			),
  			'with' => 'Tagged',
  			'dynamicWith' => true,
  			'fields' => '',
  			'order' => '',
  			'limit' => '',
  			'offset' => '',
  			'finderQuery' => ''
  		),
  		'Board' => array(
  			'className' => 'Board',
  			'joinTable' => 'tagged',
  			'foreignKey' => 'foreign_key',
  			'associationForeignKey' => 'tag_id',
  			'unique' => true,
  			'conditions' => array(
  				[maximum depth reached]
  			),
  			'with' => 'Tagged',
  			'dynamicWith' => true,
  			'fields' => '',
  			'order' => '',
  			'limit' => '',
  			'offset' => '',
  			'finderQuery' => ''
  		)
  	)
  	validate => array(
  		'name' => array(
  			'notblank' => array(
  				[maximum depth reached]
  			),
  			'max' => array(
  				[maximum depth reached]
  			)
  		),
  		'description' => array(
  			'rule' => array(
  				[maximum depth reached]
  			),
  			'message' => '説明は100文字以内で入力してください',
  			'required' => false,
  			'allowEmpty' => true
  		)
  	)
  	useDbConfig => 'default'
  	useTable => 'tags'
  	id => false
  	data => array()
  	schemaName => 'lucky_collection'
  	table => 'tags'
  	primaryKey => 'id'
  	validationErrors => array()
  	validationDomain => null
  	tablePrefix => ''
  	plugin => null
  	name => 'Tag'
  	alias => 'Tag'
  	tableToModel => array(
  		'tags' => 'Tag'
  	)
  	cacheQueries => false
  	belongsTo => array()
  	hasOne => array()
  	hasMany => array()
  	actsAs => null
  	Behaviors => object(BehaviorCollection) {
  		modelName => 'Tag'
  		defaultPriority => (int) 10
  		[protected] _methods => array([maximum depth reached])
  		[protected] _mappedMethods => array([maximum depth reached])
  		[protected] _enabled => array([maximum depth reached])
  		[protected] _loaded => array([maximum depth reached])
  	}
  	whitelist => array()
  	cacheSources => true
  	findQueryType => 'all'
  	recursive => (int) -1
  	order => null
  	virtualFields => array()
  	__backAssociation => array()
  	__backInnerAssociation => array()
  	__backOriginalAssociation => array()
  	__backContainableAssociation => array()
  	__safeUpdateMode => false
  	useConsistentAfterFind => true
  	findMethods => array(
  		'all' => true,
  		'first' => true,
  		'count' => true,
  		'neighbors' => true,
  		'list' => true,
  		'threaded' => true
  	)
  	[protected] _schema => null
  	[protected] _associationKeys => array(
  		'belongsTo' => array(
  			(int) 0 => 'className',
  			(int) 1 => 'foreignKey',
  			(int) 2 => 'conditions',
  			(int) 3 => 'fields',
  			(int) 4 => 'order',
  			(int) 5 => 'counterCache'
  		),
  		'hasOne' => array(
  			(int) 0 => 'className',
  			(int) 1 => 'foreignKey',
  			(int) 2 => 'conditions',
  			(int) 3 => 'fields',
  			(int) 4 => 'order',
  			(int) 5 => 'dependent'
  		),
  		'hasMany' => array(
  			(int) 0 => 'className',
  			(int) 1 => 'foreignKey',
  			(int) 2 => 'conditions',
  			(int) 3 => 'fields',
  			(int) 4 => 'order',
  			(int) 5 => 'limit',
  			(int) 6 => 'offset',
  			(int) 7 => 'dependent',
  			(int) 8 => 'exclusive',
  			(int) 9 => 'finderQuery',
  			(int) 10 => 'counterQuery'
  		),
  		'hasAndBelongsToMany' => array(
  			(int) 0 => 'className',
  			(int) 1 => 'joinTable',
  			(int) 2 => 'with',
  			(int) 3 => 'foreignKey',
  			(int) 4 => 'associationForeignKey',
  			(int) 5 => 'conditions',
  			(int) 6 => 'fields',
  			(int) 7 => 'order',
  			(int) 8 => 'limit',
  			(int) 9 => 'offset',
  			(int) 10 => 'unique',
  			(int) 11 => 'finderQuery'
  		)
  	)
  	[protected] _associations => array(
  		(int) 0 => 'belongsTo',
  		(int) 1 => 'hasOne',
  		(int) 2 => 'hasMany',
  		(int) 3 => 'hasAndBelongsToMany'
  	)
  	[protected] _insertID => null
  	[protected] _sourceConfigured => true
  	[protected] _eventManager => object(CakeEventManager) {
  		[protected] _generalManager => object(CakeEventManager) {}
  		[protected] _listeners => array(
  			[maximum depth reached]
  		)
  		[protected] _isGlobal => false
  	}
  	[protected] _validator => null
  }

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

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

  object(Tag) {
  	hasAndBelongsToMany => array(
  		'Question' => array(
  			'className' => 'Question',
  			'joinTable' => 'tagged',
  			'foreignKey' => 'foreign_key',
  			'associationForeignKey' => 'tag_id',
  			'unique' => true,
  			'conditions' => array(
  				[maximum depth reached]
  			),
  			'with' => 'Tagged',
  			'dynamicWith' => true,
  			'fields' => '',
  			'order' => '',
  			'limit' => '',
  			'offset' => '',
  			'finderQuery' => ''
  		),
  		'Board' => array(
  			'className' => 'Board',
  			'joinTable' => 'tagged',
  			'foreignKey' => 'foreign_key',
  			'associationForeignKey' => 'tag_id',
  			'unique' => true,
  			'conditions' => array(
  				[maximum depth reached]
  			),
  			'with' => 'Tagged',
  			'dynamicWith' => true,
  			'fields' => '',
  			'order' => '',
  			'limit' => '',
  			'offset' => '',
  			'finderQuery' => ''
  		)
  	)
  	validate => array(
  		'name' => array(
  			'notblank' => array(
  				[maximum depth reached]
  			),
  			'max' => array(
  				[maximum depth reached]
  			)
  		),
  		'description' => array(
  			'rule' => array(
  				[maximum depth reached]
  			),
  			'message' => '説明は100文字以内で入力してください',
  			'required' => false,
  			'allowEmpty' => true
  		)
  	)
  	useDbConfig => 'default'
  	useTable => 'tags'
  	id => false
  	data => array()
  	schemaName => 'lucky_collection'
  	table => 'tags'
  	primaryKey => 'id'
  	validationErrors => array()
  	validationDomain => null
  	tablePrefix => ''
  	plugin => null
  	name => 'Tag'
  	alias => 'Tag'
  	tableToModel => array(
  		'tags' => 'Tag'
  	)
  	cacheQueries => false
  	belongsTo => array()
  	hasOne => array()
  	hasMany => array()
  	actsAs => null
  	Behaviors => object(BehaviorCollection) {
  		modelName => 'Tag'
  		defaultPriority => (int) 10
  		[protected] _methods => array([maximum depth reached])
  		[protected] _mappedMethods => array([maximum depth reached])
  		[protected] _enabled => array([maximum depth reached])
  		[protected] _loaded => array([maximum depth reached])
  	}
  	whitelist => array()
  	cacheSources => true
  	findQueryType => 'all'
  	recursive => (int) -1
  	order => null
  	virtualFields => array()
  	__backAssociation => array()
  	__backInnerAssociation => array()
  	__backOriginalAssociation => array()
  	__backContainableAssociation => array()
  	__safeUpdateMode => false
  	useConsistentAfterFind => true
  	findMethods => array(
  		'all' => true,
  		'first' => true,
  		'count' => true,
  		'neighbors' => true,
  		'list' => true,
  		'threaded' => true
  	)
  	[protected] _schema => null
  	[protected] _associationKeys => array(
  		'belongsTo' => array(
  			(int) 0 => 'className',
  			(int) 1 => 'foreignKey',
  			(int) 2 => 'conditions',
  			(int) 3 => 'fields',
  			(int) 4 => 'order',
  			(int) 5 => 'counterCache'
  		),
  		'hasOne' => array(
  			(int) 0 => 'className',
  			(int) 1 => 'foreignKey',
  			(int) 2 => 'conditions',
  			(int) 3 => 'fields',
  			(int) 4 => 'order',
  			(int) 5 => 'dependent'
  		),
  		'hasMany' => array(
  			(int) 0 => 'className',
  			(int) 1 => 'foreignKey',
  			(int) 2 => 'conditions',
  			(int) 3 => 'fields',
  			(int) 4 => 'order',
  			(int) 5 => 'limit',
  			(int) 6 => 'offset',
  			(int) 7 => 'dependent',
  			(int) 8 => 'exclusive',
  			(int) 9 => 'finderQuery',
  			(int) 10 => 'counterQuery'
  		),
  		'hasAndBelongsToMany' => array(
  			(int) 0 => 'className',
  			(int) 1 => 'joinTable',
  			(int) 2 => 'with',
  			(int) 3 => 'foreignKey',
  			(int) 4 => 'associationForeignKey',
  			(int) 5 => 'conditions',
  			(int) 6 => 'fields',
  			(int) 7 => 'order',
  			(int) 8 => 'limit',
  			(int) 9 => 'offset',
  			(int) 10 => 'unique',
  			(int) 11 => 'finderQuery'
  		)
  	)
  	[protected] _associations => array(
  		(int) 0 => 'belongsTo',
  		(int) 1 => 'hasOne',
  		(int) 2 => 'hasMany',
  		(int) 3 => 'hasAndBelongsToMany'
  	)
  	[protected] _insertID => null
  	[protected] _sourceConfigured => true
  	[protected] _eventManager => object(CakeEventManager) {
  		[protected] _generalManager => object(CakeEventManager) {}
  		[protected] _listeners => array(
  			[maximum depth reached]
  		)
  		[protected] _isGlobal => false
  	}
  	[protected] _validator => null
  }
  array(
  	'conditions' => null,
  	'fields' => null,
  	'joins' => array(),
  	'limit' => null,
  	'offset' => null,
  	'order' => array(
  		'id' => 'desc'
  	),
  	'page' => (int) 1,
  	'group' => null,
  	'callbacks' => true
  )

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

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

  'all'
  array(
  	'conditions' => null,
  	'fields' => null,
  	'joins' => array(),
  	'limit' => null,
  	'offset' => null,
  	'order' => array(
  		'id' => 'desc'
  	),
  	'page' => (int) 1,
  	'group' => null,
  	'callbacks' => true
  )

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

  
      //Tag
      $this->Tag->recursive = -1;
      $tags = $this->Tag->find('all', ['order' => ['id' => 'desc']]);
      $all_tags = [];

  'all'
  array(
  	'order' => array(
  		'id' => 'desc'
  	)
  )

• APP/Controller/QuestionsController.php line 15 → AppController->beforeFilter()

      public $presetVars = true;
  
      public function beforeFilter(){
          parent::beforeFilter();
      }//end function beforeFilter

• [internal function] → QuestionsController->beforeFilter(CakeEvent)

  object(CakeEvent) {
  	data => null
  	result => null
  	[protected] _name => 'Controller.initialize'
  	[protected] _subject => object(QuestionsController) {
  		uses => array(
  			[maximum depth reached]
  		)
  		helpers => array(
  			[maximum depth reached]
  		)
  		components => array(
  			[maximum depth reached]
  		)
  		autoRender => true
  		layout => 'main'
  		presetVars => array(
  			[maximum depth reached]
  		)
  		helper => array(
  			[maximum depth reached]
  		)
  		general_setting => null
  		name => 'Questions'
  		request => object(CakeRequest) {}
  		response => object(CakeResponse) {}
  		viewPath => 'Questions'
  		layoutPath => null
  		viewVars => array([maximum depth reached])
  		view => 'index'
  		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 => 'Question'
  		modelKey => 'question'
  		validationErrors => null
  		Words => object(WordsComponent) {}
  		Session => object(SessionComponent) {}
  		Security => object(SecurityComponent) {}
  		Setting => object(SettingComponent) {}
  		ImageUrl => object(ImageUrlComponent) {}
  		Line => object(LineComponent) {}
  		Mail => object(MailComponent) {}
  		Paginator => object(PaginatorComponent) {}
  		Prg => object(PrgComponent) {}
  		Question => object(Question) {}
  		Tag => object(Tag) {}
  		[protected] _responseClass => 'CakeResponse'
  		[protected] _mergeParent => 'AppController'
  		[protected] _eventManager => object(CakeEventManager) {}
  	}
  	[protected] _stopped => false
  }

• CORE/Cake/Event/CakeEventManager.php line 243 → 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(QuestionsController) {
  		uses => array(
  			(int) 0 => 'Question',
  			(int) 1 => 'User',
  			(int) 2 => 'Profile',
  			(int) 3 => 'Answer',
  			(int) 4 => 'Comment',
  			(int) 5 => 'Image',
  			(int) 6 => 'Category',
  			(int) 7 => 'Favorite',
  			(int) 8 => 'Review',
  			(int) 9 => 'Notification',
  			(int) 10 => 'Search',
  			(int) 11 => 'Follow',
  			(int) 12 => 'Log',
  			(int) 13 => 'Changelog',
  			(int) 14 => 'Vote',
  			(int) 15 => 'Tagged',
  			(int) 16 => 'TicketShop',
  			(int) 17 => 'Tag',
  			(int) 18 => 'Board',
  			(int) 19 => 'ServiceCategory',
  			(int) 20 => 'GeneralSetting'
  		)
  		helpers => array(
  			(int) 0 => 'Question',
  			(int) 1 => 'Answer',
  			(int) 2 => 'Profile'
  		)
  		components => array(
  			'Words' => null,
  			'Session' => null,
  			'Security' => null,
  			'Setting' => null,