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

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

  1. 

  2.             return $this->PDOStatement;

  3.         } catch (\Throwable | \Exception $e) {

  4.             if ($this->reConnectTimes < 4 && $this->isBreak($e)) {

  5.                 ++$this->reConnectTimes;

  6.                 return $this->close()->getPDOStatement($sql, $bind, $master, $procedure);

  7.             }

  8. 

  9.             if ($e instanceof \PDOException) {

  10.                 throw new PDOException($e, $this->config, $this->getLastsql());

  11.             } else {

  12.                 throw $e;

  13.             }

  14.         }

  15.     }

  16. 

  17.     /**

  18.      * 执行语句

  19.      * @access protected

Call Stack

  1. in PDOConnection.php line 768
  2. at PDOConnection->getPDOStatement('SELECT COUNT(*) AS t...', [], false) in PDOConnection.php line 1100
  3. at PDOConnection->value(object(Query), 'COUNT(*) AS think_co...', 0, false) in PDOConnection.php line 1130
  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 BaseQuery.php line 623
  7. at BaseQuery->paginate(0) in Article.php line 195
  8. at Article->index()
  9. at ReflectionMethod->invokeArgs(object(Article), []) in Container.php line 343
  10. at Container->invokeReflectMethod(object(Article), object(ReflectionMethod), ['lm' => '', 'lm2' => '71', 'open' => '_top', ...]) in Controller.php line 110
  11. at Controller->think\route\dispatch\{closure}(object(Request)) in Pipeline.php line 59
  12. at Pipeline->think\{closure}(object(Request)) in Browers.php line 57
  13. at Browers->handle(object(Request), object(Closure))
  14. at call_user_func([object(Browers), 'handle'], object(Request), object(Closure)) in Middleware.php line 142
  15. at Middleware->think\{closure}(object(Request), object(Closure)) in Pipeline.php line 85
  16. at Pipeline->think\{closure}(object(Request)) in Pipeline.php line 66
  17. at Pipeline->then(object(Closure)) in Controller.php line 113
  18. at Controller->exec() in Dispatch.php line 89
  19. at Dispatch->run() in Route.php line 772
  20. at Route->think\{closure}(object(Request)) in Pipeline.php line 59
  21. at Pipeline->think\{closure}(object(Request)) in Pipeline.php line 66
  22. at Pipeline->then(object(Closure)) in Route.php line 773
  23. at Route->dispatch(object(Request), object(Closure)) in Http.php line 216
  24. at Http->dispatchToRoute(object(Request)) in Http.php line 206
  25. at Http->think\{closure}(object(Request)) in Pipeline.php line 59
  26. at Pipeline->think\{closure}(object(Request)) in MultiApp.php line 71
  27. at MultiApp->think\app\{closure}(object(Request)) in Pipeline.php line 59
  28. at Pipeline->think\{closure}(object(Request)) in Pipeline.php line 66
  29. at Pipeline->then(object(Closure)) in MultiApp.php line 72
  30. at MultiApp->handle(object(Request), object(Closure))
  31. at call_user_func([object(MultiApp), 'handle'], object(Request), object(Closure)) in Middleware.php line 142
  32. at Middleware->think\{closure}(object(Request), object(Closure)) in Pipeline.php line 85
  33. at Pipeline->think\{closure}(object(Request)) in SessionInit.php line 67
  34. at SessionInit->handle(object(Request), object(Closure))
  35. at call_user_func([object(SessionInit), 'handle'], object(Request), object(Closure)) in Middleware.php line 142
  36. at Middleware->think\{closure}(object(Request), object(Closure)) in Pipeline.php line 85
  37. at Pipeline->think\{closure}(object(Request)) in TraceDebug.php line 71
  38. at TraceDebug->handle(object(Request), object(Closure))
  39. at call_user_func([object(TraceDebug), 'handle'], object(Request), object(Closure)) in Middleware.php line 142
  40. at Middleware->think\{closure}(object(Request), object(Closure)) in Pipeline.php line 85
  41. at Pipeline->think\{closure}(object(Request)) in Pipeline.php line 66
  42. at Pipeline->then(object(Closure)) in Http.php line 207
  43. at Http->runWithRequest(object(Request)) in Http.php line 170
  44. at Http->run() in index.php line 20

Exception Datas

PDO Error Info
SQLSTATE 42S22
Driver Error Code 1054
Driver Error Message Unknown column 'news' in 'where clause'
Database Status
Error Code 10501
Error Message SQLSTATE[42S22]: Column not found: 1054 Unknown column 'news' in 'where clause'
Error SQL SELECT COUNT(*) AS think_count FROM `xxl_article` WHERE ( status = 3 and tid in (news,1,2,3,4,5,66,79,80,81,85,162) )
Database Config
type mysql
hostname 127.0.0.1
database ccvig_cn
hostport 3306
dsn
params []
charset utf8
prefix xxl_
deploy 0
rw_separate false
master_num 1
slave_no
read_master false
fields_strict true
fields_cache false
trigger_sql 1
builder
query
break_reconnect false
break_match_str []
schema_cache_path C:\wwwroot\ccvig.cn\runtime\schema\

Environment Variables

GET Data
lm
lm2 71
open _top
tj 0
hot 0
dot 1
lryname
tcolor 999999
POST Dataempty
Filesempty
Cookies
PHPSESSID 0b0ffdbca1d4074bf0fb10eb544270d2
Sessionempty
Server/Request Data
ALLUSERSPROFILE C:\ProgramData
APPDATA C:\Windows\system32\config\systemprofile\AppData\Roaming
BT_PANEL C:\BtSoft\panel
BT_PYTHON C:\Program Files\python
BT_SETUP C:\BtSoft
CommonProgramFiles C:\Program Files\Common Files
CommonProgramFiles(x86) C:\Program Files (x86)\Common Files
CommonProgramW6432 C:\Program Files\Common Files
COMPUTERNAME iZogk3loh75yxvZ
ComSpec C:\Windows\system32\cmd.exe
FP_NO_HOST_CHECK NO
LOCALAPPDATA C:\Windows\system32\config\systemprofile\AppData\Local
NUMBER_OF_PROCESSORS 2
OS Windows_NT
Path C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\python;C:\Program Files\python\Scripts;;C:\BtSoft\panel\script;
PATHEXT .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
PROCESSOR_ARCHITECTURE AMD64
PROCESSOR_IDENTIFIER Intel64 Family 6 Model 85 Stepping 7, GenuineIntel
PROCESSOR_LEVEL 6
PROCESSOR_REVISION 5507
ProgramData C:\ProgramData
ProgramFiles C:\Program Files
ProgramFiles(x86) C:\Program Files (x86)
ProgramW6432 C:\Program Files
PSModulePath C:\Program Files\WindowsPowerShell\Modules;C:\Windows\system32\WindowsPowerShell\v1.0\Modules
PUBLIC C:\Users\Public
SystemDrive C:
SystemRoot C:\Windows
TEMP C:\Windows\TEMP
TMP C:\Windows\TEMP
UNRAR_LIB_PATH C:\Program Files\python\Lib\site-packages\unrar\UnRAR.dll
USERDOMAIN WORKGROUP
USERNAME iZogk3loh75yxvZ$
USERPROFILE C:\Windows\system32\config\systemprofile
windir C:\Windows
windows_tracing_flags 3
windows_tracing_logfile C:\BVTBin\Tests\installpackage\csilogfile.log
HTTP_COOKIE PHPSESSID=0b0ffdbca1d4074bf0fb10eb544270d2
HTTP_ACCEPT_ENCODING gzip
HTTP_ACCEPT */*
HTTP_HOST www.chcic.com
HTTP_USER_AGENT Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
REDIRECT_STATUS 200
SERVER_NAME ccvig.cn
SERVER_PORT 80
SERVER_ADDR 172.28.18.104
REMOTE_PORT 43196
REMOTE_ADDR 107.158.144.246
SERVER_SOFTWARE nginx/1.18.0
GATEWAY_INTERFACE CGI/1.1
REQUEST_SCHEME http
SERVER_PROTOCOL HTTP/1.1
DOCUMENT_ROOT C:/wwwroot/ccvig.cn/public
DOCUMENT_URI /index.php
REQUEST_URI /news/news_more.asp?lm=&lm2=71&open=_top&tj=0&hot=0&dot=1&lryname=&tcolor=999999
CONTENT_LENGTH
CONTENT_TYPE
REQUEST_METHOD GET
QUERY_STRING s=//news/news_more.asp&lm=&lm2=71&open=_top&tj=0&hot=0&dot=1&lryname=&tcolor=999999
PATH_INFO
SCRIPT_NAME /index.php
SCRIPT_FILENAME C:/wwwroot/ccvig.cn/public/index.php
FCGI_ROLE RESPONDER
PHP_SELF /index.php
REQUEST_TIME_FLOAT 1714039554.548
REQUEST_TIME 1714039554
ThinkPHP V6.0.6 { 十年磨一剑-为API开发设计的高性能框架 } - 官方手册