#0 [10501]PDOException in PDOConnection.php line 796

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

  1. }
  2. } else {
  3. if ($this->reConnectTimes < 4 && $this->isBreak($e)) {
  4. ++$this->reConnectTimes;
  5. return $this->close()->getPDOStatement($sql, $bind, $master, $procedure);
  6. }
  7. }
  8. if ($e instanceof \PDOException) {
  9. throw new PDOException($e, $this->config, $this->getLastsql());
  10. } else {
  11. throw $e;
  12. }
  13. }
  14. }
  15. /**
  16. * 执行语句
  17. * @access protected

Call Stack

  1. in PDOConnection.php line 796
  2. at PDOConnection->getPDOStatement('SELECT COUNT(*) AS t...', ['ThinkBind_1_780882965_' => ['458', 1]], false) in PDOConnection.php line 1132
  3. at PDOConnection->value(object(Query), 'COUNT(*) AS think_co...', 0) in PDOConnection.php line 1162
  4. at PDOConnection->aggregate(object(Query), 'COUNT', 'COUNT(*) AS think_co...', false) in AggregateQuery.php line 32
  5. at BaseQuery->aggregate('COUNT', '*') in AggregateQuery.php line 55
  6. at BaseQuery->count() in Index.php line 18
  7. at Index->appoint_company()
  8. at ReflectionMethod->invokeArgs(object(Index), []) in Container.php line 343
  9. at Container->invokeReflectMethod(object(Index), object(ReflectionMethod), ['pxid' => '458']) in Controller.php line 110
  10. at Controller->think\route\dispatch\{closure}(object(Request)) in Pipeline.php line 59
  11. at Pipeline->think\{closure}(object(Request)) in Pipeline.php line 66
  12. at Pipeline->then(object(Closure)) in Controller.php line 113
  13. at Controller->exec() in Dispatch.php line 89
  14. at Dispatch->run() in Route.php line 772
  15. at Route->think\{closure}(object(Request)) in Pipeline.php line 59
  16. at Pipeline->think\{closure}(object(Request)) in Pipeline.php line 66
  17. at Pipeline->then(object(Closure)) in Route.php line 773
  18. at Route->dispatch(object(Request), object(Closure)) in Http.php line 216
  19. at Http->dispatchToRoute(object(Request)) in Http.php line 206
  20. at Http->think\{closure}(object(Request)) in Pipeline.php line 59
  21. at Pipeline->think\{closure}(object(Request)) in MultiApp.php line 71
  22. at MultiApp->think\app\{closure}(object(Request)) in Pipeline.php line 59
  23. at Pipeline->think\{closure}(object(Request)) in Pipeline.php line 66
  24. at Pipeline->then(object(Closure)) in MultiApp.php line 72
  25. at MultiApp->handle(object(Request), object(Closure))
  26. at call_user_func([object(MultiApp), 'handle'], object(Request), object(Closure)) in Middleware.php line 142
  27. at Middleware->think\{closure}(object(Request), object(Closure)) in Pipeline.php line 85
  28. at Pipeline->think\{closure}(object(Request)) in SessionInit.php line 67
  29. at SessionInit->handle(object(Request), object(Closure))
  30. at call_user_func([object(SessionInit), 'handle'], object(Request), object(Closure)) in Middleware.php line 142
  31. at Middleware->think\{closure}(object(Request), object(Closure)) in Pipeline.php line 85
  32. at Pipeline->think\{closure}(object(Request)) in TraceDebug.php line 71
  33. at TraceDebug->handle(object(Request), object(Closure))
  34. at call_user_func([object(TraceDebug), 'handle'], object(Request), object(Closure)) in Middleware.php line 142
  35. at Middleware->think\{closure}(object(Request), object(Closure)) in Pipeline.php line 85
  36. at Pipeline->think\{closure}(object(Request)) in Pipeline.php line 66
  37. at Pipeline->then(object(Closure)) in Http.php line 207
  38. at Http->runWithRequest(object(Request)) in Http.php line 170
  39. at Http->run() in index.php line 20

Exception Datas

PDO Error Info
SQLSTATE 42S22
Driver Error Code 1054
Driver Error Message Unknown column 'lyh_company_appoint.appoint_ent_id' in 'on clause'
Database Status
Error Code 10501
Error Message SQLSTATE[42S22]: Column not found: 1054 Unknown column 'lyh_company_appoint.appoint_ent_id' in 'on clause'
Error SQL SELECT COUNT(*) AS think_count FROM `lyh_company_appoint` LEFT JOIN `lyh_company` ON `lyh_company_appoint`.`appoint_ent_id`=`lyh_company`.`ent_id` WHERE `appoint_pxid` = 458 LIMIT 1
Database Config
type mysql
hostname 39.106.65.64
database kehu_zgqybxh
hostport 13306
dsn
params []
charset utf8
prefix lyh_
deploy 0
rw_separate false
master_num 1
slave_no
read_master false
fields_strict true
fields_cache false
trigger_sql true
builder
query
break_reconnect false
break_match_str []

Environment Variables

GET Dataempty
POST Dataempty
Filesempty
Cookiesempty
Sessionempty
Server/Request Data
USER www
HOME /home/www
HTTP_HOST p.ihwrm.com
HTTP_USER_AGENT claudebot
HTTP_ACCEPT */*
PATH_INFO
REDIRECT_STATUS 200
SERVER_NAME p.ihwrm.com
SERVER_PORT 80
SERVER_ADDR 220.248.165.25
REMOTE_PORT 52092
REMOTE_ADDR 34.204.3.195
SERVER_SOFTWARE nginx/1.21.4
GATEWAY_INTERFACE CGI/1.1
REQUEST_SCHEME http
SERVER_PROTOCOL HTTP/1.1
DOCUMENT_ROOT /mnt/www/p.ihwrm.com/public
DOCUMENT_URI /index.php
REQUEST_URI /px/index/appoint_company/pxid/458.html
SCRIPT_NAME /index.php
CONTENT_LENGTH
CONTENT_TYPE
REQUEST_METHOD GET
QUERY_STRING s=/px/index/appoint_company/pxid/458.html
SCRIPT_FILENAME /mnt/www/p.ihwrm.com/public/index.php
FCGI_ROLE RESPONDER
PHP_SELF /index.php
REQUEST_TIME_FLOAT 1711625765.893
REQUEST_TIME 1711625765