[10501] PDOException in Connection.php line 390

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

  1. $this->PDOStatement->execute();
  2. // 调试结束
  3. $this->debug(false, '', $master);
  4. // 返回结果集
  5. return $this->getResult($pdo, $procedure);
  6. } catch (\PDOException $e) {
  7. if ($this->isBreak($e)) {
  8. return $this->close()->query($sql, $bind, $master, $pdo);
  9. }
  10. throw new PDOException($e, $this->config, $this->getLastsql());
  11. } catch (\Throwable $e) {
  12. if ($this->isBreak($e)) {
  13. return $this->close()->query($sql, $bind, $master, $pdo);
  14. }
  15. throw $e;
  16. } catch (\Exception $e) {
  17. if ($this->isBreak($e)) {
  18. return $this->close()->query($sql, $bind, $master, $pdo);
  19. }

Call Stack

  1. in Connection.php line 390
  2. at Connection->query('SELECT * FROM `think...', [], false, false) in Query.php line 248
  3. at Query->query('SELECT * FROM `think...', [], false, false) in Query.php line 2476
  4. at Query->select() in Pro.php line 16
  5. at Pro->index(object(Request))
  6. at ReflectionMethod->invokeArgs(object(Pro), [object(Request)]) in App.php line 343
  7. at App::invokeMethod([object(Pro), 'index'], []) in App.php line 609
  8. at App::module(['Index', 'Pro', 'index'], ['app_host' => '', 'app_debug' => true, 'app_trace' => false, ...], false) in App.php line 457
  9. at App::exec(['type' => 'module', 'module' => ['Index', 'Pro', 'index'], 'convert' => false], ['app_host' => '', 'app_debug' => true, 'app_trace' => false, ...]) in App.php line 139
  10. at App::run() in start.php line 19
  11. at require('/usr/home/hyu7851150...') in index.php line 20

Exception Datas

PDO Error Info
SQLSTATE 42S22
Driver Error Code 1054
Driver Error Message Unknown column 'prolist' in 'where clause'
Database Status
Error Code 10501
Error Message SQLSTATE[42S22]: Column not found: 1054 Unknown column 'prolist' in 'where clause'
Error SQL SELECT * FROM `think_proclass` WHERE ( status = 1 and parentid = prolist ) ORDER BY `orderid` DESC
Database Config
type mysql
hostname hdm721909221.my3w.com
database hdm721909221_db
hostport
dsn
params []
charset utf8
prefix think_
debug true
deploy 0
rw_separate false
master_num 1
slave_no
read_master false
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

id
123
pid
118
POST Data
empty
Files
empty
Cookies
empty
Session
empty

Server/Request Data

DOCUMENT_ROOT
/usr/home/hyu7851150001/htdocs
GATEWAY_INTERFACE
CGI/1.1
HTTPS
on
HTTP_ACCEPT
*/*
HTTP_HOST
fast-jet.com
HTTP_USER_AGENT
claudebot
PATH
/bin
PHPRC
/var/www/php55/hichina_ini/hyu7851150001
QUERY_STRING
id=123&pid=118
REDIRECT_DOCUMENT_ROOT
/usr/home/hyu7851150001/htdocs
REDIRECT_GATEWAY_INTERFACE
CGI/1.1
REDIRECT_HTTPS
on
REDIRECT_HTTP_ACCEPT
*/*
REDIRECT_HTTP_HOST
fast-jet.com
REDIRECT_HTTP_USER_AGENT
claudebot
REDIRECT_PATH
/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
REDIRECT_PATH_INFO
/Pro/prolist/
REDIRECT_PATH_TRANSLATED
redirect:/index.php/Pro/prolist//prolist/
REDIRECT_QUERY_STRING
id=123&pid=118
REDIRECT_REMOTE_ADDR
35.175.174.36
REDIRECT_REMOTE_PORT
45856
REDIRECT_REQUEST_METHOD
GET
REDIRECT_REQUEST_URI
/Index/Pro/prolist/?id=123&pid=118
REDIRECT_SCRIPT_FILENAME
/usr/home/hyu7851150001/htdocs/Index
REDIRECT_SCRIPT_NAME
/Index
REDIRECT_SERVER_ADDR
10.21.100.107
REDIRECT_SERVER_ADMIN
webmaster@hyu7851150001.my3w.com
REDIRECT_SERVER_NAME
fast-jet.com
REDIRECT_SERVER_PORT
443
REDIRECT_SERVER_PROTOCOL
HTTP/1.1
REDIRECT_SERVER_SIGNATURE
REDIRECT_SERVER_SOFTWARE
Apache
REDIRECT_SSL_TLS_SNI
fast-jet.com
REDIRECT_STATUS
200
REDIRECT_TZ
Asia/Shanghai
REDIRECT_UNIQUE_ID
ZgXTRAoVZGsACLCnB4kAAAAB
REDIRECT_URL
/Index/Pro/prolist/
REMOTE_ADDR
35.175.174.36
REMOTE_PORT
45856
REQUEST_METHOD
GET
REQUEST_URI
/Index/Pro/prolist/?id=123&pid=118
SCRIPT_FILENAME
/usr/home/hyu7851150001/htdocs/index.php
SCRIPT_NAME
/index.php
SERVER_ADDR
10.21.100.107
SERVER_ADMIN
webmaster@hyu7851150001.my3w.com
SERVER_NAME
fast-jet.com
SERVER_PORT
443
SERVER_PROTOCOL
HTTP/1.1
SERVER_SIGNATURE
SERVER_SOFTWARE
Apache
SSL_TLS_SNI
fast-jet.com
TZ
Asia/Shanghai
UNIQUE_ID
ZgXTRAoVZGsACLCnB4kAAAAB
ORIG_PATH_INFO
/Index/Pro/prolist/
ORIG_PATH_TRANSLATED
/usr/home/hyu7851150001/htdocs/index.php
PHP_SELF
/index.php
REQUEST_TIME_FLOAT
1711657796.388
REQUEST_TIME
1711657796
PATH_INFO
/Index/Pro/prolist/
Environment Variables
empty

ThinkPHP Constants

APP_PATH
/usr/home/hyu7851150001/htdocs/application/
THINK_VERSION
5.0.20
THINK_START_TIME
1711657796.3886
THINK_START_MEM
265360
EXT
.php
DS
/
THINK_PATH
/usr/home/hyu7851150001/htdocs/thinkphp/
LIB_PATH
/usr/home/hyu7851150001/htdocs/thinkphp/library/
CORE_PATH
/usr/home/hyu7851150001/htdocs/thinkphp/library/think/
TRAIT_PATH
/usr/home/hyu7851150001/htdocs/thinkphp/library/traits/
ROOT_PATH
/usr/home/hyu7851150001/htdocs/
EXTEND_PATH
/usr/home/hyu7851150001/htdocs/extend/
VENDOR_PATH
/usr/home/hyu7851150001/htdocs/vendor/
RUNTIME_PATH
/usr/home/hyu7851150001/htdocs/runtime/
LOG_PATH
/usr/home/hyu7851150001/htdocs/runtime/log/
CACHE_PATH
/usr/home/hyu7851150001/htdocs/runtime/cache/
TEMP_PATH
/usr/home/hyu7851150001/htdocs/runtime/temp/
CONF_PATH
/usr/home/hyu7851150001/htdocs/application/
CONF_EXT
.php
ENV_PREFIX
PHP_
IS_CLI
false
IS_WIN
false
/
/
YMD
20240329
__PUBLIC__
/public