[42S02] PDOException in Mysql.php line 65

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

  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 `n...') in Mysql.php line 65
  3. at Mysql->getFields('`nav`') in Query.php line 1722
  4. at Query->getTableInfo('nav', 'type') in Query.php line 1770
  5. at Query->getFieldsType(['multi' => ['AND' => ['pid' => [0]]], 'where' => ['AND' => ['pid' => 0]], 'order' => ['sort'], ...]) in Query.php line 1776
  6. at Query->getFieldsBind(['multi' => ['AND' => ['pid' => [0]]], 'where' => ['AND' => ['pid' => 0]], 'order' => ['sort'], ...]) in Builder.php line 245
  7. at Builder->buildWhere(['AND' => ['pid' => 0]], ['multi' => ['AND' => ['pid' => [0]]], 'where' => ['AND' => ['pid' => 0]], 'order' => ['sort'], ...]) in Builder.php line 223
  8. at Builder->parseWhere(['AND' => ['pid' => 0]], ['multi' => ['AND' => ['pid' => [0]]], 'where' => ['AND' => ['pid' => 0]], 'order' => ['sort'], ...]) in Builder.php line 658
  9. at Builder->select(['multi' => ['AND' => ['pid' => [0]]], 'where' => ['AND' => ['pid' => 0]], 'order' => ['sort'], ...]) in Query.php line 2285
  10. at Query->select() in Common.php line 19
  11. at Common->__construct()
  12. at ReflectionClass->newInstanceArgs([]) in App.php line 243
  13. at App::invokeClass('app\index\controller...') in Loader.php line 420
  14. at Loader::controller('index', 'controller', false, 'Error') in App.php line 368
  15. at App::module(['index', null, null], ['app_namespace' => 'app', 'app_debug' => true, 'app_trace' => false, ...], true) in App.php line 130
  16. at App::run() in start.php line 18
  17. at require('/www/wwwroot/www.khl...') in index.php line 17

Environment Variables

GET Data

classid
4
page
1
POST Data
empty
Files
empty
Cookies
empty
Session
empty

Server/Request Data

USER
www
HOME
/home/www
ORACLE_HOME
/www/server/oci8-lib/instantclient_21_13
HTTP_HOST
www.khl5.com
HTTP_USER_AGENT
claudebot
HTTP_ACCEPT
*/*
PATH_INFO
REDIRECT_STATUS
200
SERVER_NAME
www.khl5.com
SERVER_PORT
80
SERVER_ADDR
172.31.32.181
REMOTE_PORT
35738
REMOTE_ADDR
3.82.232.31
SERVER_SOFTWARE
nginx/1.22.1
GATEWAY_INTERFACE
CGI/1.1
REQUEST_SCHEME
http
SERVER_PROTOCOL
HTTP/1.1
DOCUMENT_ROOT
/www/wwwroot/www.khl5.com
DOCUMENT_URI
/index.php
REQUEST_URI
/?classid=4&page=1
SCRIPT_NAME
/index.php
CONTENT_LENGTH
CONTENT_TYPE
REQUEST_METHOD
GET
QUERY_STRING
classid=4&page=1
SCRIPT_FILENAME
/www/wwwroot/www.khl5.com/index.php
FCGI_ROLE
RESPONDER
PHP_SELF
/index.php
REQUEST_TIME_FLOAT
1711726910.1222
REQUEST_TIME
1711726910
Environment Variables
empty

ThinkPHP Constants

APP_PATH
/www/wwwroot/www.khl5.com/application/
BIND_MODULE
index
THINK_VERSION
5.0.7
THINK_START_TIME
1711726910.1224
THINK_START_MEM
394824
EXT
.php
DS
/
THINK_PATH
/www/wwwroot/www.khl5.com/thinkphp/
LIB_PATH
/www/wwwroot/www.khl5.com/thinkphp/library/
CORE_PATH
/www/wwwroot/www.khl5.com/thinkphp/library/think/
TRAIT_PATH
/www/wwwroot/www.khl5.com/thinkphp/library/traits/
ROOT_PATH
/www/wwwroot/www.khl5.com/
EXTEND_PATH
/www/wwwroot/www.khl5.com/extend/
VENDOR_PATH
/www/wwwroot/www.khl5.com/vendor/
RUNTIME_PATH
/www/wwwroot/www.khl5.com/runtime/
LOG_PATH
/www/wwwroot/www.khl5.com/runtime/log/
CACHE_PATH
/www/wwwroot/www.khl5.com/runtime/cache/
TEMP_PATH
/www/wwwroot/www.khl5.com/runtime/temp/
CONF_PATH
/www/wwwroot/www.khl5.com/application/
CONF_EXT
.php
ENV_PREFIX
PHP_
IS_CLI
false
IS_WIN
false