[HY000] PDOException in Mysql.php line 65

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

  1. if (false === strpos($tableName, '`')) {
  2. if (strpos($tableName, '.')) {
  3. $tableName = str_replace('.', '`.`', $tableName);
  4. }
  5. $tableName = '`' . $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 65
  2. at PDO->query('SHOW COLUMNS FROM `t...') in Mysql.php line 65
  3. at Mysql->getFields('tp_ad_position') in Query.php line 1722
  4. at Query->getTableInfo('tp_ad_position', 'type') in Query.php line 1770
  5. at Query->getFieldsType(['cache' => ['key' => true, 'expire' => 86400, 'tag' => null], 'table' => 'tp_ad_position', 'field' => ['position_id', 'position_name', 'ad_width', ...], ...]) in Query.php line 1776
  6. at Query->getFieldsBind(['cache' => ['key' => true, 'expire' => 86400, 'tag' => null], 'table' => 'tp_ad_position', 'field' => ['position_id', 'position_name', 'ad_width', ...], ...]) in Builder.php line 245
  7. at Builder->buildWhere([], ['cache' => ['key' => true, 'expire' => 86400, 'tag' => null], 'table' => 'tp_ad_position', 'field' => ['position_id', 'position_name', 'ad_width', ...], ...]) in Builder.php line 223
  8. at Builder->parseWhere([], ['cache' => ['key' => true, 'expire' => 86400, 'tag' => null], 'table' => 'tp_ad_position', 'field' => ['position_id', 'position_name', 'ad_width', ...], ...]) in Builder.php line 658
  9. at Builder->select(['cache' => ['key' => true, 'expire' => 86400, 'tag' => null], 'table' => 'tp_ad_position', 'field' => ['position_id', 'position_name', 'ad_width', ...], ...]) in Query.php line 2238
  10. at Query->getPdo() in Query.php line 457
  11. at Query->column('position_id,position...', 'position_id') in 4d211d6c10e983bcc646672bdfad1382.php line 42
  12. at include('C:\WWW\meihao\runtim...') in File.php line 50
  13. at File->read('C:\WWW\meihao\runtim...', ['action' => 'login', 'template_now_time' => 1569014348, 'goods_category_tree' => [['id' => 1, 'name' => '空调', 'mobile_name' => '空调', ...], ['id' => 2, 'name' => '新风系统', 'mobile_name' => '新风系统', ...], ['id' => 3, 'name' => '中央净水', 'mobile_name' => '中央净水', ...], ...], ...]) in Template.php line 196
  14. at Template->fetch('./template/pc/rainbo...', ['action' => 'login', 'template_now_time' => 1569014348, 'goods_category_tree' => [['id' => 1, 'name' => '空调', 'mobile_name' => '空调', ...], ['id' => 2, 'name' => '新风系统', 'mobile_name' => '新风系统', ...], ['id' => 3, 'name' => '中央净水', 'mobile_name' => '中央净水', ...], ...], ...], []) in Think.php line 89
  15. at Think->fetch('', ['action' => 'login', 'template_now_time' => 1569014348, 'goods_category_tree' => [['id' => 1, 'name' => '空调', 'mobile_name' => '空调', ...], ['id' => 2, 'name' => '新风系统', 'mobile_name' => '新风系统', ...], ['id' => 3, 'name' => '中央净水', 'mobile_name' => '中央净水', ...], ...], ...], []) in View.php line 159
  16. at View->fetch('', [], [], []) in Controller.php line 129
  17. at Controller->fetch() in User.php line 121
  18. at User->login()
  19. at ReflectionMethod->invokeArgs(object(User), []) in App.php line 227
  20. at App::invokeMethod([object(User), 'login'], []) in App.php line 409
  21. at App::module(['Home', 'User', 'login'], ['app_namespace' => 'app', 'app_debug' => true, 'app_trace' => false, ...], null) in App.php line 133
  22. at App::run() in start.php line 18
  23. at require('C:\WWW\meihao\thinkp...') in index.php line 48

Environment Variables

GET Data
empty
POST Data
empty
Files
empty

Cookies

is_mobile
0
Session
empty

Server/Request Data

_FCGI_X_PIPE_
\\.\pipe\IISFCGI-8a54b1bb-8673-48df-bc2d-8af5383ae7b4
PHP_FCGI_MAX_REQUESTS
10000
ALLUSERSPROFILE
C:\ProgramData
APPDATA
C:\Windows\system32\config\systemprofile\AppData\Roaming
APP_POOL_CONFIG
APP_POOL_ID
CommonProgramFiles
C:\Program Files\Common Files
CommonProgramFiles(x86)
C:\Program Files (x86)\Common Files
CommonProgramW6432
C:\Program Files\Common Files
COMPUTERNAME
iZulw6f5kpd750Z
ComSpec
C:\Windows\system32\cmd.exe
FP_NO_HOST_CHECK
NO
LOCALAPPDATA
C:\Windows\system32\config\systemprofile\AppData\Local
NUMBER_OF_PROCESSORS
2
OS
Windows_NT
Path
C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Windows\System32\WindowsPowerShell\v1.0\;
PATHEXT
.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
PROCESSOR_ARCHITECTURE
AMD64
PROCESSOR_IDENTIFIER
Intel64 Family 6 Model 79 Stepping 1, GenuineIntel
PROCESSOR_LEVEL
6
PROCESSOR_REVISION
4f01
ProgramData
C:\ProgramData
ProgramFiles
C:\Program Files
ProgramFiles(x86)
C:\Program Files (x86)
ProgramW6432
C:\Program Files
PSModulePath
C:\Program Files\WindowsPowerShell\Modules;C:\Windows\system32\WindowsPowerShell\v1.0\Modules
PUBLIC
C:\Users\Public
SystemDrive
C:
SystemRoot
C:\Windows
TEMP
C:\Windows\TEMP
TMP
C:\Windows\TEMP
USERDOMAIN
WORKGROUP
USERNAME
iZulw6f5kpd750Z$
USERPROFILE
C:\Windows\system32\config\systemprofile
windir
C:\Windows
windows_tracing_flags
3
windows_tracing_logfile
C:\BVTBin\Tests\installpackage\csilogfile.log
ORIG_PATH_INFO
/index.php/Home/User/login.html
URL
/index.php
SERVER_SOFTWARE
Microsoft-IIS/7.5
SERVER_PROTOCOL
HTTP/1.1
SERVER_PORT_SECURE
0
SERVER_PORT
80
SERVER_NAME
www.meihaoshangcheng.cn
SCRIPT_NAME
/index.php
SCRIPT_FILENAME
C:\WWW\meihao\index.php
REQUEST_URI
/Home/User/login.html
REQUEST_METHOD
GET
REMOTE_USER
REMOTE_PORT
20001
REMOTE_HOST
154.197.222.92
REMOTE_ADDR
154.197.222.92
QUERY_STRING
PATH_TRANSLATED
C:\WWW\meihao\index.php\Home\User\login.html
PATH_INFO
/Home/User/login.html
LOGON_USER
LOCAL_ADDR
172.31.215.54
INSTANCE_META_PATH
/LM/W3SVC/2
INSTANCE_NAME
INSTANCE_ID
2
HTTPS_SERVER_SUBJECT
HTTPS_SERVER_ISSUER
HTTPS_SECRETKEYSIZE
HTTPS_KEYSIZE
HTTPS
off
GATEWAY_INTERFACE
CGI/1.1
DOCUMENT_ROOT
C:\WWW\meihao
CONTENT_TYPE
CONTENT_LENGTH
0
CERT_SUBJECT
CERT_SERIALNUMBER
CERT_ISSUER
CERT_FLAGS
CERT_COOKIE
AUTH_USER
AUTH_PASSWORD
AUTH_TYPE
APPL_PHYSICAL_PATH
C:\WWW\meihao\
APPL_MD_PATH
/LM/W3SVC/2/ROOT
IIS_UrlRewriteModule
7.1.0871.0
UNENCODED_URL
/Home/User/login.html
IIS_WasUrlRewritten
1
HTTP_X_ORIGINAL_URL
/Home/User/login.html
HTTP_USER_AGENT
Mozilla/5.0+(compatible;+Baiduspider/2.0;++http://www.baidu.com/search/spider.html)
HTTP_HOST
www.meihaoshangcheng.cn
HTTP_ACCEPT_ENCODING
deflate, gzip
HTTP_ACCEPT
*/*
HTTP_CONTENT_LENGTH
0
FCGI_ROLE
RESPONDER
PHP_SELF
/index.php/Home/User/login.html
REQUEST_TIME_FLOAT
1569014348.2931
REQUEST_TIME
1569014348
Environment Variables
empty

ThinkPHP Constants

PLUGIN_PATH
C:\WWW\meihao/plugins/
UPLOAD_PATH
public/upload/
TPSHOP_CACHE_TIME
86400
SITE_URL
http://www.meihaoshangcheng.cn
INSTALL_DATE
1463741583
SERIALNUMBER
20160520065303oCWIoa
APP_PATH
C:\WWW\meihao/application/
NOW_TIME
1569014348
THINK_VERSION
5.0.7
THINK_START_TIME
1569014348.2931
THINK_START_MEM
298840
EXT
.php
DS
\
THINK_PATH
C:\WWW\meihao\thinkphp\
LIB_PATH
C:\WWW\meihao\thinkphp\library\
CORE_PATH
C:\WWW\meihao\thinkphp\library\think\
TRAIT_PATH
C:\WWW\meihao\thinkphp\library\traits\
ROOT_PATH
C:\WWW\meihao\
EXTEND_PATH
C:\WWW\meihao\extend\
VENDOR_PATH
C:\WWW\meihao\vendor\
RUNTIME_PATH
C:\WWW\meihao\runtime\
LOG_PATH
C:\WWW\meihao\runtime\log\
CACHE_PATH
C:\WWW\meihao\runtime\cache\
TEMP_PATH
C:\WWW\meihao\runtime\temp\
CONF_PATH
C:\WWW\meihao/application/
CONF_EXT
.php
ENV_PREFIX
PHP_
IS_CLI
false
IS_WIN
true
IS_AJAX
false
IS_GET
true
IS_POST
false
MODULE_NAME
home
CONTROLLER_NAME
User
ACTION_NAME
login
PREFIX
tp_
SESSION_ID
5vtkndao47ltmvcma65dr8q140