[42S02] PDOException in Mysql.php line 60

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bdm256727397_db.xdnet_' doesn't exist

  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 `x...') in Mysql.php line 60
  3. at Mysql->getFields('xdnet_') in Query.php line 1424
  4. at Query->getTableInfo('xdnet_', 'type') in Query.php line 1472
  5. at Query->getFieldsType(['where' => ['AND' => [['exp', 'catid= and id<']]], 'order' => 'id DESC', 'table' => 'xdnet_', ...]) in Query.php line 1478
  6. at Query->getFieldsBind(['where' => ['AND' => [['exp', 'catid= and id<']]], 'order' => 'id DESC', 'table' => 'xdnet_', ...]) in Builder.php line 230
  7. at Builder->buildWhere(['AND' => [['exp', 'catid= and id<']]], ['where' => ['AND' => [['exp', 'catid= and id<']]], 'order' => 'id DESC', 'table' => 'xdnet_', ...]) in Builder.php line 208
  8. at Builder->parseWhere(['AND' => [['exp', 'catid= and id<']]], ['where' => ['AND' => [['exp', 'catid= and id<']]], 'order' => 'id DESC', 'table' => 'xdnet_', ...]) in Builder.php line 600
  9. at Builder->select(['where' => ['AND' => [['exp', 'catid= and id<']]], 'order' => 'id DESC', 'table' => 'xdnet_', ...]) in Query.php line 2022
  10. at Query->find() in Cx.php line 695
  11. at Cx->tagPre(['catid' => 'catid'], '') in TagLib.php line 180
  12. at TagLib->think\template\{closure}(['{pre catid="catid"/}', 'pre'])
  13. at preg_replace_callback('/\{(elseif|else|defa...', object(Closure), '<!DOCTYPE html> <htm...') in TagLib.php line 181
  14. at TagLib->parseTag('<!DOCTYPE html> <htm...', '') in Template.php line 691
  15. at Template->parseTagLib('cx', '<!DOCTYPE html> <htm...', true) in Template.php line 410
  16. at Template->parse('<!DOCTYPE html> <htm...') in Template.php line 340
  17. at Template->compiler('<!DOCTYPE html> <htm...', '/data/home/bxu240447...') in Template.php line 189
  18. at Template->fetch('/data/home/bxu240447...', ['alisms' => ['appid' => '235145211', 'appkey' => '1fbb1052442b8a98c16e...', 'template_code' => 'SMS_25150360'], 'attachment' => ['maxsize' => '5200000', 'allowext' => 'jpg,jpeg,gif,png,doc...', 'watermark_enable' => '1', ...], 'contact' => ['tel' => '029-68297980', 'email' => 'admin@xdnet.cn', 'fax' => '029-68297793', ...], ...], []) in Think.php line 84
  19. at Think->fetch('article/show', ['alisms' => ['appid' => '235145211', 'appkey' => '1fbb1052442b8a98c16e...', 'template_code' => 'SMS_25150360'], 'attachment' => ['maxsize' => '5200000', 'allowext' => 'jpg,jpeg,gif,png,doc...', 'watermark_enable' => '1', ...], 'contact' => ['tel' => '029-68297980', 'email' => 'admin@xdnet.cn', 'fax' => '029-68297793', ...], ...], []) in View.php line 127
  20. at View->fetch('article/show', [], [], []) in Controller.php line 109
  21. at Controller->fetch('article/show') in Base.php line 250
  22. at Base->show()
  23. at ReflectionMethod->invokeArgs(object(Error), []) in App.php line 232
  24. at App::invokeMethod([object(Error), 'show'], []) in App.php line 400
  25. at App::module(['home', 'article', 'show'], ['app_namespace' => 'app', 'app_debug' => true, 'app_trace' => false, ...], null) in App.php line 140
  26. at App::run() in start.php line 27
  27. at require('/data/home/bxu240447...') in index.php line 4

Environment Variables

GET Dataempty
POST Dataempty
Filesempty
Cookies
$Version 1
PHPSESSID jjaj7rcaae3ov6srqstthmhs92
$Path /
Sessionempty
Server/Request Data
DOCUMENT_ROOT /usr/home/bxu2404470127/htdocs
GATEWAY_INTERFACE CGI/1.1
HTTP_ACCEPT text/html,image/png,image/jpeg,image/pjpeg,image/x-xbitmap,image/svg+xml,image/gif;q=0.9,*/*;q=0.1
HTTP_ACCEPT_ENCODING gzip, identity;q=0.9
HTTP_ACCEPT_LANGUAGE zh, en, *
HTTP_CONNECTION keep-alive
HTTP_COOKIE $Version=1; PHPSESSID=jjaj7rcaae3ov6srqstthmhs92; $Path=/
HTTP_HOST www.xamzgs.com
HTTP_REFERER http://www.xamzgs.com/home/article/show/id/28.html
HTTP_USER_AGENT Mozilla/4.5 (compatible; HTTrack 3.0x; Windows 98)
PATH /bin:/usr/bin
PHPRC /var/www/php55/hichina_ini/bxu2404470127
QUERY_STRING
REDIRECT_DOCUMENT_ROOT /usr/home/bxu2404470127/htdocs
REDIRECT_GATEWAY_INTERFACE CGI/1.1
REDIRECT_HTTP_ACCEPT text/html,image/png,image/jpeg,image/pjpeg,image/x-xbitmap,image/svg+xml,image/gif;q=0.9,*/*;q=0.1
REDIRECT_HTTP_ACCEPT_ENCODING gzip, identity;q=0.9
REDIRECT_HTTP_ACCEPT_LANGUAGE zh, en, *
REDIRECT_HTTP_CONNECTION keep-alive
REDIRECT_HTTP_COOKIE $Version=1; PHPSESSID=jjaj7rcaae3ov6srqstthmhs92; $Path=/
REDIRECT_HTTP_HOST www.xamzgs.com
REDIRECT_HTTP_REFERER http://www.xamzgs.com/home/article/show/id/28.html
REDIRECT_HTTP_USER_AGENT Mozilla/4.5 (compatible; HTTrack 3.0x; Windows 98)
REDIRECT_PATH /bin:/bin/sbin/:/usr/sbin/:/usr/bin/:/usr/local/bin/:/sbin
REDIRECT_PATH_INFO /article/show/id/home/page/index/id/43.html
REDIRECT_PATH_TRANSLATED redirect:/index.php/article/show/id/home/page/index/id/43.html/show/id/home/page/index/id/43.html
REDIRECT_QUERY_STRING
REDIRECT_REMOTE_ADDR 49.159.49.17
REDIRECT_REMOTE_PORT 62605
REDIRECT_REQUEST_METHOD GET
REDIRECT_REQUEST_URI /home/article/show/id/home/page/index/id/43.html
REDIRECT_SCRIPT_FILENAME /usr/home/bxu2404470127/htdocs/home
REDIRECT_SCRIPT_NAME /home
REDIRECT_SERVER_ADDR 60.205.34.24
REDIRECT_SERVER_ADMIN webmaster@bxu2404470127.my3w.com
REDIRECT_SERVER_NAME www.xamzgs.com
REDIRECT_SERVER_PORT 80
REDIRECT_SERVER_PROTOCOL HTTP/1.1
REDIRECT_SERVER_SIGNATURE
REDIRECT_SERVER_SOFTWARE Apache
REDIRECT_STATUS 200
REDIRECT_UNIQUE_ID XQxASAqq4m0AAArPOnkAAAAV
REDIRECT_URL /home/article/show/id/home/page/index/id/43.html
REDIRECT_gzip_only_text_html 1
REMOTE_ADDR 49.159.49.17
REMOTE_PORT 62605
REQUEST_METHOD GET
REQUEST_URI /home/article/show/id/home/page/index/id/43.html
SCRIPT_FILENAME /usr/home/bxu2404470127/htdocs/index.php
SCRIPT_NAME /index.php
SERVER_ADDR 60.205.34.24
SERVER_ADMIN webmaster@bxu2404470127.my3w.com
SERVER_NAME www.xamzgs.com
SERVER_PORT 80
SERVER_PROTOCOL HTTP/1.1
SERVER_SIGNATURE
SERVER_SOFTWARE Apache
UNIQUE_ID XQxASAqq4m0AAArPOnkAAAAV
gzip_only_text_html 1
ORIG_PATH_INFO /home/article/show/id/home/page/index/id/43.html
ORIG_PATH_TRANSLATED /usr/home/bxu2404470127/htdocs/index.php
PHP_SELF /index.php
REQUEST_TIME_FLOAT 1561083976.4479
REQUEST_TIME 1561083976
PATH_INFO /home/article/show/id/home/page/index/id/43.html
Environment Variablesempty
ThinkPHP Constants
APP_PATH /data/home/bxu2404470127/htdocs/xdnet/
TOP_DOMAIN .xamzgs.com
CMS_VERSION XDCMS 0.6.5
THINK_VERSION 5.0.3
THINK_START_TIME 1561083976.4488
THINK_START_MEM 256168
EXT .php
DS /
THINK_PATH /data/home/bxu2404470127/htdocs/thinkphp/
LIB_PATH /data/home/bxu2404470127/htdocs/thinkphp/library/
CORE_PATH /data/home/bxu2404470127/htdocs/thinkphp/library/think/
TRAIT_PATH /data/home/bxu2404470127/htdocs/thinkphp/library/traits/
ROOT_PATH /data/home/bxu2404470127/htdocs/
EXTEND_PATH /data/home/bxu2404470127/htdocs/extend/
VENDOR_PATH /data/home/bxu2404470127/htdocs/vendor/
RUNTIME_PATH /data/home/bxu2404470127/htdocs/xdnet/runtime/
LOG_PATH /data/home/bxu2404470127/htdocs/xdnet/runtime/log/
CACHE_PATH /data/home/bxu2404470127/htdocs/xdnet/runtime/cache/
TEMP_PATH /data/home/bxu2404470127/htdocs/xdnet/runtime/temp/
CONF_PATH /data/home/bxu2404470127/htdocs/xdnet/
CONF_EXT .php
ENV_PREFIX PHP_
IS_CLI false
IS_WIN false
GROUP_NAME home
MODULE_NAME Article
ACTION_NAME show
TIME_OUT_SHOW_INFO