[10501] PDOException in Connection.php line 399

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'pid' in 'where clause'

            $this->PDOStatement->execute();
            // 调试结束
            $this->debug(false);
            // 返回结果集
            return $this->getResult($pdo, $procedure);
        } catch (\PDOException $e) {
            if ($this->config['break_reconnect'] && $this->isBreak($e)) {
                return $this->close()->query($sql, $bind, $master, $pdo);
            }
            throw new PDOException($e, $this->config, $this->getLastsql());
        }
    }

    /**
     * 执行语句
     * @access public
     * @param string        $sql sql指令
     * @param array         $bind 参数绑定
     * @return int

Call Stack

in Connection.php line 399
at Connection->query('SELECT * FROM `nav` ...', [], false, false) in Query.php line 225
at Query->query('SELECT * FROM `nav` ...', [], false, false) in Query.php line 2297
at Query->select() in Common.php line 19
at Common->__construct()
at ReflectionClass->newInstanceArgs([]) in App.php line 243
at App::invokeClass('app\index\controller...') in Loader.php line 420
at Loader::controller('index', 'controller', false, 'Error') in App.php line 368
at App::module(['index', null, null], ['app_namespace' => 'app', 'app_debug' => true, 'app_trace' => false, ...], true) in App.php line 130
at App::run() in start.php line 18
at require('/www/wwwroot/www.khl...') in index.php line 17

Exception Datas

PDO Error Info
SQLSTATE	42S22
Driver Error Code	1054
Driver Error Message	Unknown column 'pid' in 'where clause'

Database Status
Error Code	10501
Error Message	SQLSTATE[42S22]: Column not found: 1054 Unknown column 'pid' in 'where clause'
Error SQL	SELECT * FROM `nav` WHERE `pid` = 0 ORDER BY `sort`

Database Config
type	mysql
hostname	127.0.0.1
database	game735
username	root
password	FmMLPpAJJ77zDkpS
hostport	3306
dsn
params	[]
charset	utf8mb4
prefix
debug	true
deploy	0
rw_separate	false
master_num	1
slave_no
fields_strict	true
result_type	2
resultset_type	array
auto_timestamp	false
datetime_format	Y-m-d H:i:s
sql_explain	false
builder
query	\think\db\Query
break_reconnect	false

Environment Variables

GET Data

empty

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

Mozilla/4.0 (compatible; MSIE 9.0; Windows NT 6.1)

HTTP_REFERER

http://www.khl5.com/index.php

HTTP_ACCEPT_LANGUAGE

zh-cn

HTTP_ACCEPT

*/*

HTTP_CONNECTION

Keep-Alive

PATH_INFO

REDIRECT_STATUS

200

SERVER_NAME

www.khl5.com

SERVER_PORT

SERVER_ADDR

172.31.32.181

REMOTE_PORT

49888

REMOTE_ADDR

134.122.134.12

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

/index.php

SCRIPT_NAME

/index.php

CONTENT_LENGTH

CONTENT_TYPE

REQUEST_METHOD

GET

QUERY_STRING

SCRIPT_FILENAME

/www/wwwroot/www.khl5.com/index.php

FCGI_ROLE

RESPONDER

PHP_SELF

/index.php

REQUEST_TIME_FLOAT

1744569298.5316

REQUEST_TIME

1744569298

Environment Variables

empty

ThinkPHP Constants

APP_PATH

/www/wwwroot/www.khl5.com/application/

BIND_MODULE

index

GehPk

/index.php

nsyE8

http://www.khl5.com/index.php

kqeis

134.122.134.12

E5fp2

www.khl5.com

bkBBS

Mozilla/4.0 (compatible; MSIE 9.0; Windows NT 6.1)

U2VNy

http://zb1559.cc

z47Zb

THINK_VERSION

5.0.7

THINK_START_TIME

1744569298.532

THINK_START_MEM

396200

EXT

.php

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