Database Error
Error: SQLSTATE[HY000]: General error: 1030 Got error 28 from storage engine
SQL Query: SHOW FULL COLUMNS FROM `fashion195_db`.`categories`
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/Database/Mysql.php line 333 → DboSource->_execute(string)
$table = $this->fullTableName($model);
$fields = false;
$cols = $this->_execute('SHOW FULL COLUMNS FROM ' . $table);
if (!$cols) {
'SHOW FULL COLUMNS FROM `fashion195_db`.`categories`'
- CORE/Cake/Model/Model.php line 1353 → Mysql->describe(AppModel)
$db = $this->getDataSource();
$db->cacheSources = ($this->cacheSources && $db->cacheSources);
if (method_exists($db, 'describe')) {
$this->_schema = $db->describe($this);
}
object(AppModel) { useDbConfig => 'default' useTable => 'categories' id => false data => array([maximum depth reached]) schemaName => 'fashion195_db' table => 'categories' primaryKey => 'id' validate => array([maximum depth reached]) validationErrors => array([maximum depth reached]) validationDomain => null tablePrefix => '' plugin => null name => 'Category' alias => 'Category' 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 => 'threaded' 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 => null [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 }
- CORE/Cake/Model/Model.php line 1395 → Model->schema()
*/
public function getColumnType($column) {
$db = $this->getDataSource();
$cols = $this->schema();
$model = null;
- CORE/Cake/Model/Datasource/DboSource.php line 2563 → Model->getColumnType(string)
$virtual = true;
}
$type = is_object($model) ? $model->getColumnType($key) : null;
$null = $value === null || (is_array($value) && empty($value));
'Node.status'
- CORE/Cake/Model/Datasource/DboSource.php line 2518 → DboSource->_parseKey(AppModel, string, integer)
} elseif (is_numeric($key) && !empty($value)) {
$data = $this->_quoteFields($value);
} else {
$data = $this->_parseKey($model, trim($key), $value);
}
object(AppModel) { useDbConfig => 'default' useTable => 'categories' id => false data => array([maximum depth reached]) schemaName => 'fashion195_db' table => 'categories' primaryKey => 'id' validate => array([maximum depth reached]) validationErrors => array([maximum depth reached]) validationDomain => null tablePrefix => '' plugin => null name => 'Category' alias => 'Category' 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 => 'threaded' 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 => null [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 } 'Node.status' (int) 1
- CORE/Cake/Model/Datasource/DboSource.php line 2401 → DboSource->conditionKeysToString(array, boolean, AppModel)
}
if (is_array($conditions) && !empty($conditions)) {
$out = $this->conditionKeysToString($conditions, $quoteValues, $model);
array( 'Node.status' => (int) 1, 'Category.menu' => (int) 1 ) true object(AppModel) { useDbConfig => 'default' useTable => 'categories' id => false data => array([maximum depth reached]) schemaName => 'fashion195_db' table => 'categories' primaryKey => 'id' validate => array([maximum depth reached]) validationErrors => array([maximum depth reached]) validationDomain => null tablePrefix => '' plugin => null name => 'Category' alias => 'Category' 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 => 'threaded' 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 => null [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 }
- CORE/Cake/Model/Datasource/DboSource.php line 1715 → DboSource->conditions(array, boolean, boolean, AppModel)
}
}
return $this->renderStatement('select', array(
'conditions' => $this->conditions($query['conditions'], true, true, $model),
'fields' => implode(', ', $query['fields']),
array( 'Node.status' => (int) 1, 'Category.menu' => (int) 1 ) true true object(AppModel) { useDbConfig => 'default' useTable => 'categories' id => false data => array([maximum depth reached]) schemaName => 'fashion195_db' table => 'categories' primaryKey => 'id' validate => array([maximum depth reached]) validationErrors => array([maximum depth reached]) validationDomain => null tablePrefix => '' plugin => null name => 'Category' alias => 'Category' 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 => 'threaded' 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 => null [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 }
- CORE/Cake/Model/Datasource/DboSource.php line 1512 → DboSource->buildStatement(array, AppModel)
'group' => $queryData['group']
),
$model
);
}
array( 'fields' => array( (int) 0 => '`Node`.*', (int) 1 => '`Category`.*' ), 'table' => '`fashion195_db`.`categories`', 'alias' => 'Category', 'limit' => null, 'offset' => null, 'joins' => array( (int) 0 => array( [maximum depth reached] ) ), 'conditions' => array( 'Node.status' => (int) 1, 'Category.menu' => (int) 1 ), 'order' => array( (int) 0 => array( [maximum depth reached] ) ), 'group' => null ) object(AppModel) { useDbConfig => 'default' useTable => 'categories' id => false data => array([maximum depth reached]) schemaName => 'fashion195_db' table => 'categories' primaryKey => 'id' validate => array([maximum depth reached]) validationErrors => array([maximum depth reached]) validationDomain => null tablePrefix => '' plugin => null name => 'Category' alias => 'Category' 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 => 'threaded' 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 => null [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 }
- CORE/Cake/Model/Datasource/DboSource.php line 1075 → DboSource->generateAssociationQuery(AppModel, null, null, null, null, array, boolean, null)
}
}
$query = $this->generateAssociationQuery($model, null, null, null, null, $queryData, false, $null);
object(AppModel) { useDbConfig => 'default' useTable => 'categories' id => false data => array([maximum depth reached]) schemaName => 'fashion195_db' table => 'categories' primaryKey => 'id' validate => array([maximum depth reached]) validationErrors => array([maximum depth reached]) validationDomain => null tablePrefix => '' plugin => null name => 'Category' alias => 'Category' 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 => 'threaded' 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 => null [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 } null null null null array( 'conditions' => array( 'Node.status' => (int) 1, 'Category.menu' => (int) 1 ), 'fields' => array( (int) 0 => '`Node`.*', (int) 1 => '`Category`.*' ), 'joins' => array( (int) 0 => array( [maximum depth reached] ) ), 'limit' => null, 'offset' => null, 'order' => array( (int) 0 => array( [maximum depth reached] ) ), 'page' => (int) 1, 'group' => null, 'callbacks' => true ) false null
- CORE/Cake/Model/Model.php line 2880 → DboSource->read(AppModel, array)
* @return array
*/
protected function _readDataSource($type, $query) {
$results = $this->getDataSource()->read($this, $query);
$this->resetAssociations();
object(AppModel) { useDbConfig => 'default' useTable => 'categories' id => false data => array([maximum depth reached]) schemaName => 'fashion195_db' table => 'categories' primaryKey => 'id' validate => array([maximum depth reached]) validationErrors => array([maximum depth reached]) validationDomain => null tablePrefix => '' plugin => null name => 'Category' alias => 'Category' 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 => 'threaded' 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 => null [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( 'Node.status' => (int) 1, 'Category.menu' => (int) 1 ), 'fields' => array( (int) 0 => 'Node.*', (int) 1 => 'Category.*' ), 'joins' => array( (int) 0 => array( [maximum depth reached] ) ), 'limit' => null, 'offset' => null, 'order' => array( (int) 0 => array( [maximum depth reached] ) ), 'page' => (int) 1, 'group' => null, 'callbacks' => true )
- CORE/Cake/Model/Model.php line 2852 → Model->_readDataSource(string, array)
return null;
}
return $this->_readDataSource($type, $query);
}
'threaded' array( 'conditions' => array( 'Node.status' => (int) 1, 'Category.menu' => (int) 1 ), 'fields' => array( (int) 0 => 'Node.*', (int) 1 => 'Category.*' ), 'joins' => array( (int) 0 => array( [maximum depth reached] ) ), 'limit' => null, 'offset' => null, 'order' => array( (int) 0 => array( [maximum depth reached] ) ), 'page' => (int) 1, 'group' => null, 'callbacks' => true )
- APP/Plugin/Default/Controller/DefaultAppController.php line 288 → Model->find(string, array)
),
'order' => array('Node.pos'=>'desc', 'Node.id'=> 'asc'),
'fields' => array('Node.*', 'Category.*')
)));
'threaded' array( 'joins' => array( (int) 0 => array( [maximum depth reached] ) ), 'conditions' => array( 'Node.status' => (int) 1, 'Category.menu' => (int) 1 ), 'order' => array( 'Node.pos' => 'desc', 'Node.id' => 'asc' ), 'fields' => array( (int) 0 => 'Node.*', (int) 1 => 'Category.*' ) )
- APP/Plugin/Default/Controller/DefaultAppController.php line 94 → DefaultAppController->categories()
$this->get_lang();
$this->settings();
$this->categories();
$this->latest_news();
- [internal function] → DefaultAppController->beforeFilter(CakeEvent)
object(CakeEvent) { data => null result => null [protected] _name => 'Controller.initialize' [protected] _subject => object(NodeController) {} [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(NodeController) {}, (int) 1 => 'beforeFilter' ) object(CakeEvent) { data => null result => null [protected] _name => 'Controller.initialize' [protected] _subject => object(NodeController) {} [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(NodeController) {} [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(NodeController, CakeRequest, CakeResponse)
));
}
$response = $this->_invoke($controller, $request, $response);
if (isset($request->params['return'])) {
object(NodeController) { theme => 'Default' product_pagination_limit => (int) 16 news_pagination_limit => (int) 10 document_pagination_limit => (int) 12 hook => array( [maximum depth reached] ) components => array( [maximum depth reached] ) uses => array( [maximum depth reached] ) Controller => null lang => 'vi' lang_array => null settings => array( [maximum depth reached] ) nodeData => null cModalName => null cActionName => null cFlagPage => false currentCategory => null action_array => array( [maximum depth reached] ) cBuff => array([maximum depth reached]) name => 'Node' helpers => array([maximum depth reached]) request => object(CakeRequest) {} response => object(CakeResponse) {} viewPath => 'Node' layoutPath => null viewVars => array( [maximum depth reached] ) view => 'index' layout => 'default' autoRender => true autoLayout => true Components => object(ComponentCollection) {} viewClass => 'View' View => null ext => '.ctp' plugin => 'Default' cacheAction => false passedArgs => array( [maximum depth reached] ) scaffold => false methods => array( [maximum depth reached] ) modelClass => 'Category' modelKey => 'node' validationErrors => null Session => object(SessionComponent) {} Cookie => object(CookieComponent) {} Ccontent => object(CcontentComponent) {} Cmodal => object(CmodalComponent) {} Cmeta => object(CmetaComponent) {} Capp => object(CappComponent) {} Clayout => object(ClayoutComponent) {} RequestHandler => object(RequestHandlerComponent) {} Lang => object(AppModel) {} Setting => object(AppModel) {} title_for_layout => 'Công ty 19-5, Bộ Công an' keyword_for_layout => 'Quần áo thời trang, trang phục chuyên dùng, đặc chủng, phù cấp hiệu, số hiệu, mũ, sản phẩm cơ khí, sản phẩm nhựa' description_for_layout => 'Quần áo thời trang, trang phục chuyên dùng, đặc chủng, phù cấp hiệu, số hiệu, mũ, sản phẩm cơ khí, sản phẩm nhựa, Công ty 19-5, Bộ Công an, giày da, dây lưng' Category => 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 => 'default/node/index/van-ban-tai-lieu/.html/thong-bao-ve-viec-ban-tai-san-thanh-ly-nam-2022.html/cong-bo-thong-tin-hoat-dong-cua-cong-ty-19-5-bo-cong-an-nam-2023.html/cong-bo-thong-tin-bat-thuong-pho-tong-giam-doc.html/cong-bo-thong-tin-bat-thuong-nguoi-phu-trach-ke-toan.html/luat-dau-thau-so-43.html/luat-cand-so-73-2014.html/thong-bao-ve-viec-thanh-ly-hang-hoa-vat-tu-ton-dong-1483429081.html/cong-bo-thong-tin-hoat-dong-cua-cong-ty-19-5-bo-cong-an-nam-2022.html' base => '' webroot => '/' here => '/default/node/index/van-ban-tai-lieu/.html/thong-bao-ve-viec-ban-tai-san-thanh-ly-nam-2022.html/cong-bo-thong-tin-hoat-dong-cua-cong-ty-19-5-bo-cong-an-nam-2023.html/cong-bo-thong-tin-bat-thuong-pho-tong-giam-doc.html/cong-bo-thong-tin-bat-thuong-nguoi-phu-trach-ke-toan.html/luat-dau-thau-so-43.html/luat-cand-so-73-2014.html/thong-bao-ve-viec-thanh-ly-hang-hoa-vat-tu-ton-dong-1483429081.html/cong-bo-thong-tin-hoat-dong-cua-cong-ty-19-5-bo-cong-an-nam-2022.html' [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 111 → 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 => 'default/node/index/van-ban-tai-lieu/.html/thong-bao-ve-viec-ban-tai-san-thanh-ly-nam-2022.html/cong-bo-thong-tin-hoat-dong-cua-cong-ty-19-5-bo-cong-an-nam-2023.html/cong-bo-thong-tin-bat-thuong-pho-tong-giam-doc.html/cong-bo-thong-tin-bat-thuong-nguoi-phu-trach-ke-toan.html/luat-dau-thau-so-43.html/luat-cand-so-73-2014.html/thong-bao-ve-viec-thanh-ly-hang-hoa-vat-tu-ton-dong-1483429081.html/cong-bo-thong-tin-hoat-dong-cua-cong-ty-19-5-bo-cong-an-nam-2022.html' base => '' webroot => '/' here => '/default/node/index/van-ban-tai-lieu/.html/thong-bao-ve-viec-ban-tai-san-thanh-ly-nam-2022.html/cong-bo-thong-tin-hoat-dong-cua-cong-ty-19-5-bo-cong-an-nam-2023.html/cong-bo-thong-tin-bat-thuong-pho-tong-giam-doc.html/cong-bo-thong-tin-bat-thuong-nguoi-phu-trach-ke-toan.html/luat-dau-thau-so-43.html/luat-cand-so-73-2014.html/thong-bao-ve-viec-thanh-ly-hang-hoa-vat-tu-ton-dong-1483429081.html/cong-bo-thong-tin-hoat-dong-cua-cong-ty-19-5-bo-cong-an-nam-2022.html' [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]) }