[10501] PDOException in Connection.php line 388

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

  1. $this->PDOStatement->execute();
  2. // 调试结束
  3. $this->debug(false);
  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 (\Exception $e) {
  12. if ($this->isBreak($e)) {
  13. return $this->close()->query($sql, $bind, $master, $pdo);
  14. }
  15. throw $e;
  16. }
  17. }
  18. /**

Call Stack

  1. in Connection.php line 388
  2. at Connection->query('SELECT * FROM `my_te...', [], false, false) in Query.php line 227
  3. at Query->query('SELECT * FROM `my_te...', [], false, false) in Query.php line 2501
  4. at Query->find() in Pro.php line 22
  5. at Pro->index()
  6. at ReflectionMethod->invokeArgs(object(Pro), []) in App.php line 224
  7. at App::invokeMethod([object(Pro), 'index'], []) in App.php line 390
  8. at App::module(['home', 'Pro', 'index'], ['app_host' => '', 'app_debug' => true, 'app_trace' => false, ...], false) in App.php line 130
  9. at App::run() in start.php line 18
  10. at require('/www/wwwroot/zlkj/th...') in index.php line 18

Exception Datas

PDO Error Info
SQLSTATE 42S22
Driver Error Code 1054
Driver Error Message Unknown column 'rfid' in 'where clause'
Database Status
Error Code 10501
Error Message SQLSTATE[42S22]: Column not found: 1054 Unknown column 'rfid' in 'where clause'
Error SQL SELECT * FROM `my_tech` WHERE ( id= rfid ) ORDER BY id desc LIMIT 1
Database Config
type mysql
hostname 127.0.0.1
database index_zlink_grou
hostport
dsn
params []
charset utf8
prefix my_
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 false
sql_explain false
builder
query \think\db\Query
break_reconnect false
auto_datetime_format false

Environment Variables

GET Data
empty
POST Data
empty
Files
empty
Cookies
empty
Session
empty

Server/Request Data

USER
www
HOME
/home/www
HTTP_USER_AGENT
claudebot
HTTP_ACCEPT
*/*
HTTP_ALI_CDN_REAL_IP
35.171.22.220
HTTP_X_CLIENT_SCHEME
http
HTTP_X_FORWARDED_FOR
35.171.22.220
HTTP_ALI_SWIFT_STAT_HOST
level2.www.zlink-e.com
HTTP_ALI_SWIFT_LOG_HOST
www.zlink-e.com
HTTP_EAGLEEYE_TRACEID
3adad01b17116600117578862e
HTTP_VIA
cn192.l1, kunlun9.cn192, l2cn2647.l2, cache31.l2cn2647
HTTP_HOST
www.zlink-e.com
PATH_INFO
//product/rfid/
REDIRECT_STATUS
200
SERVER_NAME
index.zlink.group
SERVER_PORT
80
SERVER_ADDR
172.16.167.111
REMOTE_PORT
63356
REMOTE_ADDR
153.35.52.179
SERVER_SOFTWARE
nginx/1.20.0
GATEWAY_INTERFACE
CGI/1.1
REQUEST_SCHEME
http
SERVER_PROTOCOL
HTTP/1.1
DOCUMENT_ROOT
/www/wwwroot/zlkj
DOCUMENT_URI
/index.php
REQUEST_URI
/product/rfid/
SCRIPT_NAME
/index.php
CONTENT_LENGTH
CONTENT_TYPE
REQUEST_METHOD
GET
QUERY_STRING
s=//product/rfid/
SCRIPT_FILENAME
/www/wwwroot/zlkj/index.php
FCGI_ROLE
RESPONDER
PHP_SELF
/index.php
REQUEST_TIME_FLOAT
1711660011.8206
REQUEST_TIME
1711660011
Environment Variables
empty

ThinkPHP Constants

APP_PATH
/www/wwwroot/zlkj/application/
THINK_VERSION
5.0.12
THINK_START_TIME
1711660011.8211
THINK_START_MEM
403904
EXT
.php
DS
/
THINK_PATH
/www/wwwroot/zlkj/thinkphp/
LIB_PATH
/www/wwwroot/zlkj/thinkphp/library/
CORE_PATH
/www/wwwroot/zlkj/thinkphp/library/think/
TRAIT_PATH
/www/wwwroot/zlkj/thinkphp/library/traits/
ROOT_PATH
/www/wwwroot/zlkj/
EXTEND_PATH
/www/wwwroot/zlkj/extend/
VENDOR_PATH
/www/wwwroot/zlkj/vendor/
RUNTIME_PATH
/www/wwwroot/zlkj/runtime/
LOG_PATH
/www/wwwroot/zlkj/runtime/log/
CACHE_PATH
/www/wwwroot/zlkj/runtime/cache/
TEMP_PATH
/www/wwwroot/zlkj/runtime/temp/
CONF_PATH
/www/wwwroot/zlkj/application/
CONF_EXT
.php
ENV_PREFIX
PHP_
IS_CLI
false
IS_WIN
false
QINIU_FUNCTIONS_VERSION
7.2.2
DM
http://index.zlink.group