[HY000] PDOException in Mysql.php line 60

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

  1. {
  2. $this->initConnect(true);
  3. list($tableName) = explode(' ', $tableName);
  4. if (strpos($tableName, '.')) {
  5. $tableName = str_replace('.', '`.`', $tableName);
  6. }
  7. $sql = 'SHOW COLUMNS FROM `' . $tableName . '`';
  8. // 调试开始
  9. $this->debug(true);
  10. $pdo = $this->linkID->query($sql);
  11. // 调试结束
  12. $this->debug(false, $sql);
  13. $result = $pdo->fetchAll(PDO::FETCH_ASSOC);
  14. $info = [];
  15. if ($result) {
  16. foreach ($result as $key => $val) {
  17. $val = array_change_key_case($val);
  18. $info[$val['field']] = [
  19. 'name' => $val['field'],

Call Stack

  1. in Mysql.php line 60
  2. at PDO->query('SHOW COLUMNS FROM `a...') in Mysql.php line 60
  3. at Mysql->getFields('als_article') in Query.php line 1397
  4. at Query->getTableInfo('als_article', 'type') in Query.php line 1445
  5. at Query->getFieldsType(['where' => ['AND' => ['cat_id' => ['in', ['17']], 'is_open' => ['eq', 1]]], 'order' => ['add_time' => 'desc'], 'field' => ['COUNT(*) AS tp_count'], ...]) in Query.php line 1451
  6. at Query->getFieldsBind(['where' => ['AND' => ['cat_id' => ['in', ['17']], 'is_open' => ['eq', 1]]], 'order' => ['add_time' => 'desc'], 'field' => ['COUNT(*) AS tp_count'], ...]) in Builder.php line 230
  7. at Builder->buildWhere(['AND' => ['cat_id' => ['in', ['17']], 'is_open' => ['eq', 1]]], ['where' => ['AND' => ['cat_id' => ['in', ['17']], 'is_open' => ['eq', 1]]], 'order' => ['add_time' => 'desc'], 'field' => ['COUNT(*) AS tp_count'], ...]) in Builder.php line 208
  8. at Builder->parseWhere(['AND' => ['cat_id' => ['in', ['17']], 'is_open' => ['eq', 1]]], ['where' => ['AND' => ['cat_id' => ['in', ['17']], 'is_open' => ['eq', 1]]], 'order' => ['add_time' => 'desc'], 'field' => ['COUNT(*) AS tp_count'], ...]) in Builder.php line 600
  9. at Builder->select(['where' => ['AND' => ['cat_id' => ['in', ['17']], 'is_open' => ['eq', 1]]], 'order' => ['add_time' => 'desc'], 'field' => ['COUNT(*) AS tp_count'], ...]) in Query.php line 1993
  10. at Query->find() in Query.php line 394
  11. at Query->value('COUNT(*) AS tp_count', 0) in Query.php line 492
  12. at Query->count() in Query.php line 1006
  13. at Query->paginate(8, false, ['query' => ['cate' => '17']]) in NewsController.php line 40
  14. at NewsController->newsList()
  15. at ReflectionMethod->invokeArgs(object(NewsController), []) in App.php line 230
  16. at App::invokeMethod([object(NewsController), 'newslist']) in App.php line 399
  17. at App::module(['news', 'news', 'newsList'], ['app_namespace' => 'application', 'app_debug' => true, 'app_trace' => false, ...], null) in App.php line 138
  18. at App::run() in start.php line 18
  19. at require('/var/www/alsweb/thin...') in index.php line 21

Environment Variables

GET Data
cate 17
page 2
POST Dataempty
Filesempty
Cookiesempty
Sessionempty
Server/Request Data
REDIRECT_STATUS 200
HTTP_ACCEPT */*
HTTP_USER_AGENT claudebot
HTTP_HOST www.alsrobot.com
PATH /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
SERVER_SIGNATURE
SERVER_SOFTWARE Apache
SERVER_NAME www.alsrobot.com
SERVER_ADDR 10.45.24.120
SERVER_PORT 80
REMOTE_ADDR 18.209.63.120
DOCUMENT_ROOT /var/www/alsweb/public
REQUEST_SCHEME http
CONTEXT_PREFIX
CONTEXT_DOCUMENT_ROOT /var/www/alsweb/public
SERVER_ADMIN zy2016@foxmail.com
SCRIPT_FILENAME /var/www/alsweb/public/index.php
REMOTE_PORT 52158
REDIRECT_QUERY_STRING cate=17&page=2
REDIRECT_URL /news/news/newsList
GATEWAY_INTERFACE CGI/1.1
SERVER_PROTOCOL HTTP/1.1
REQUEST_METHOD GET
QUERY_STRING cate=17&page=2
REQUEST_URI /news/news/newsList?cate=17&page=2
SCRIPT_NAME /index.php
PATH_INFO /news/news/newsList
PATH_TRANSLATED redirect:/index.php/news/news/newsList/news/newsList
PHP_SELF /index.php/news/news/newsList
REQUEST_TIME_FLOAT 1711670943.366
REQUEST_TIME 1711670943
Environment Variablesempty
ThinkPHP Constantsempty