[10501] PDOException in Connection.php line 687

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'c.zi' in 'on clause'

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

Call Stack

  1. in Connection.php line 687
  2. at Connection->query() in Connection.php line 923
  3. at Connection->select() in Query.php line 3039
  4. at Query->select() in ChaxunZuci.php line 694
  5. at ChaxunZuci->bihua()
  6. at ReflectionMethod->invokeArgs() in Container.php line 395
  7. at Container->invokeReflectMethod() in Module.php line 131
  8. at Module->think\route\dispatch\{closure}()
  9. at call_user_func_array() in Middleware.php line 185
  10. at Middleware->think\{closure}()
  11. at call_user_func() in Middleware.php line 130
  12. at Middleware->dispatch() in Module.php line 136
  13. at Module->exec() in Dispatch.php line 168
  14. at Dispatch->run() in App.php line 432
  15. at App->think\{closure}()
  16. at call_user_func_array() in Middleware.php line 185
  17. at Middleware->think\{closure}()
  18. at call_user_func() in Middleware.php line 130
  19. at Middleware->dispatch() in App.php line 435
  20. at App->run() in index.php line 27

Exception Datas

PDO Error Info
SQLSTATE 42S22
Driver Error Code 1054
Driver Error Message Unknown column 'c.zi' in 'on clause'
Database Status
Error Code 10501
Error Message SQLSTATE[42S22]: Column not found: 1054 Unknown column 'c.zi' in 'on clause'
Error SQL SELECT `x`.`hanzi` FROM `ho_chaxun_xinhuazidian` `x` INNER JOIN `ho_chaxun_ciyu` `c` ON `c`.`zi`=`x`.`hanzi` WHERE `bihua_num` = 1 GROUP BY `c`.`zi` LIMIT 100
Database Config
type mysql
hostname 172.17.48.4
database study163
hostport 3306
dsn
params []
charset utf8mb4
prefix ho_
debug 1
deploy 0
rw_separate false
master_num 1
slave_no
read_master false
fields_strict true
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
break_match_str []
db_config1 { "type": "mysql", "hostname": "172.17.0.6,172.17.0.11", "database": "dongshi", "username": "root", "password": "HMFLrCYiZwbYtSDE7980@!_+#", "charset": "utf8mb4", "debug": false, "prefix": "ho_", "deploy": 1, "rw_separate": true, "master_num": 1 }
db_config2 { "type": "mysql", "hostname": "sh-cdb-5ru3tkz2.sql.tencentcdb.com", "database": "chongsodata", "username": "root", "password": "3b5dEd5ru3tkz2!@#123%okhjk!", "charset": "utf8mb4", "debug": false, "prefix": "ho_", "hostport": 58958 }
db_config3 { "type": "mysql", "hostname": "172.17.0.11", "database": "ds_ask", "username": "root", "password": "HMFLrCYiZwbYtSDE7980@!_+#", "charset": "utf8mb4", "debug": false, "prefix": "dsask_" }
db_config4 { "type": "mysql", "hostname": "172.17.0.17", "database": "study163_gaokao", "username": "root", "password": "c16ab#@58606A3013bd16ef27b92Bdc08a", "charset": "utf8mb4", "debug": false, "prefix": "ho_", "hostport": 3306 }
db_config5 { "type": "mysql", "hostname": "172.17.0.11", "database": "how_234", "username": "root", "password": "HMFLrCYiZwbYtSDE7980@!_+#", "charset": "utf8mb4", "debug": false, "prefix": "ho_", "hostport": 3306 }
db_config6 { "type": "mysql", "hostname": "172.17.48.4", "database": "cnzhacai", "username": "root", "password": "ih7EGb2RNdaLczRm@#_+frkeji!", "charset": "utf8mb4", "debug": false, "prefix": "ho_", "hostport": 3306 }
db_config7 { "type": "mysql", "hostname": "124.222.251.101", "database": "ds_ask", "username": "root", "password": "HMFLrCYiZwbYtSDE7980@!_+#", "charset": "utf8mb4", "debug": false, "prefix": "dsask_", "hostport": 63508 }
db_config8 { "type": "mysql", "hostname": "124.222.251.105", "database": "study163_gaokao", "username": "root", "password": "c16ab#@58606A3013bd16ef27b92Bdc08a", "charset": "utf8mb4", "debug": false, "prefix": "ho_", "hostport": 63469 }
db_config9 { "type": "mysql", "hostname": "172.17.0.17", "database": "wenda", "username": "root", "password": "c16ab#@58606A3013bd16ef27b92Bdc08a", "charset": "utf8mb4", "debug": false, "prefix": "dsask_", "hostport": 3306 }
db_config10 { "type": "mysql", "hostname": "172.17.0.17", "database": "pwbook", "username": "root", "password": "c16ab#@58606A3013bd16ef27b92Bdc08a", "charset": "utf8mb4", "debug": false, "prefix": "wz_", "hostport": 3306 }
db_config11 { "type": "mysql", "hostname": "124.222.251.101", "database": "dongshi", "username": "root", "password": "HMFLrCYiZwbYtSDE7980@!_+#", "charset": "utf8mb4", "debug": false, "prefix": "ho_", "hostport": 63508 }
db_config12 { "type": "mysql", "hostname": "172.17.0.17", "database": "mt_quna", "username": "root", "password": "c16ab#@58606A3013bd16ef27b92Bdc08a", "charset": "utf8mb4", "debug": false, "prefix": "ho_", "hostport": 3306 }

Environment Variables

GET Dataempty
POST Dataempty
Filesempty
Cookiesempty
Sessionempty
Server/Request Data
USER www
HOME /home/www
HTTP_OHC_UPSTREAM_ID 8243e17ce38dba4c,58cf5dd1ee1d0d6d
HTTP_BAIDU_CDN_TTL 2
HTTP_X_FORWARDED_HOST chaxun.study163.com
HTTP_X_FORWARDED_PROTO https
HTTP_X_FORWARDED_FOR 44.200.175.46,113.219.142.54
HTTP_USER_AGENT claudebot
HTTP_ACCEPT */*
HTTP_BAIDU_CDN_REQUEST_ID 1711704596652-464177197-113.219.142.55-2
HTTP_VIA Baidu-CDN-Node1,Baidu-CDN-Node3
HTTP_X_VIA Baidu-CDN-Node1,Baidu-CDN-Node3
HTTP_CONNECTION keep-alive
HTTP_RANGE bytes=0-1048575
HTTP_HOST chaxun.study163.com
PATH_INFO
REDIRECT_STATUS 200
SERVER_NAME chaxun.study163.com
SERVER_PORT 80
SERVER_ADDR 172.17.0.34
REMOTE_PORT 47007
REMOTE_ADDR 124.237.212.91
SERVER_SOFTWARE nginx/1.22.0
GATEWAY_INTERFACE CGI/1.1
REQUEST_SCHEME http
SERVER_PROTOCOL HTTP/1.1
DOCUMENT_ROOT /www/wwwroot/chaxun.study163.com/public
DOCUMENT_URI /index.php
REQUEST_URI /zuci_bihua/
SCRIPT_NAME /index.php
CONTENT_LENGTH
CONTENT_TYPE
REQUEST_METHOD GET
QUERY_STRING s=/zuci_bihua/
SCRIPT_FILENAME /www/wwwroot/chaxun.study163.com/public/index.php
FCGI_ROLE RESPONDER
PHP_SELF /index.php
REQUEST_TIME_FLOAT 1711704596.7226
REQUEST_TIME 1711704596
Environment Variablesempty
ThinkPHP Constants
ROOT_PATH /www/wwwroot/chaxun.study163.com/public/../
APP_PATH /www/wwwroot/chaxun.study163.com/public/../application/
PUBLIC_PATH /www/wwwroot/chaxun.study163.com/public/../public/
EXTEND_PATH /www/wwwroot/chaxun.study163.com/public/../extend/
DS /
FILTER_VALIDATE_BOOL 258