[10501] PDOException in Connection.php line 385

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'News' 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 385
  2. at Connection->query('SELECT COUNT(*) AS t...', [], false, true) in Query.php line 255
  3. at Query->query('SELECT COUNT(*) AS t...', [], false, true) in Query.php line 2470
  4. at Query->getPdo() in Query.php line 441
  5. at Query->value('COUNT(*) AS tp_count', 0, true) in Query.php line 576
  6. at Query->aggregate('COUNT', '*', true) in Query.php line 551
  7. at Query->count() in News.php line 44
  8. at News->news()
  9. at ReflectionMethod->invokeArgs(object(News), []) in App.php line 343
  10. at App::invokeMethod([object(News), 'news'], []) in App.php line 611
  11. at App::module(['Index', 'News', 'news'], ['app_host' => '', 'app_debug' => true, 'app_trace' => false, ...], false) in App.php line 456
  12. at App::exec(['type' => 'module', 'module' => ['Index', 'News', 'news'], 'convert' => false], ['app_host' => '', 'app_debug' => true, 'app_trace' => false, ...]) in App.php line 139
  13. at App::run() in start.php line 19
  14. at require('C:\wwwroot\new.henge...') in index.php line 23

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 tp_count FROM `fa_adc` WHERE ( isdelete=0 and status='normal' and istop='hidden' and pid=News-Releases ) ORDER BY `starttime` DESC,`weigh` DESC,`id` DESC LIMIT 1
Database Config
type mysql
hostname 127.0.0.1
database new_hengerda
hostport
dsn
params []
charset utf8mb4
prefix fa_
debug false
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 false
sql_explain false
builder
query \think\db\Query
break_reconnect false

Environment Variables

GET Data
empty
POST Data
empty
Files
empty

Cookies

PHPSESSID
h78c6379q9j0k1hp2nkf3qhbq1
Session
empty

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
iZjgbo7pqm76a8Z
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:\Program Files\Microsoft SQL Server\110\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\;C:\Program Files\Microsoft SQL Server\110\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\;C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\PrivateAssemblies\;C:\Program Files (x86)\Microsoft SQL Server\110\DTS\Binn\;C:\Program Files\python;C:\Program Files\python\Scripts;;C:\BtSoft\panel\script;C:\Program Files\dotnet\;C:\Program Files (x86)\dotnet\;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 79 Stepping 1, GenuineIntel
PROCESSOR_LEVEL
6
PROCESSOR_REVISION
4f01
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;C:\Program Files (x86)\Microsoft SQL Server\110\Tools\PowerShell\Modules\;c:\Program Files\Microsoft Security Client\MpProvider\
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
iZjgbo7pqm76a8Z$
USERPROFILE
C:\Windows\system32\config\systemprofile
windir
C:\Windows
HTTP_ALI_CDN_ADAPTIVE_PORTS
443,443
HTTP_COOKIE
PHPSESSID=h78c6379q9j0k1hp2nkf3qhbq1
HTTP_ACCEPT
*/*
HTTP_USER_AGENT
Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
HTTP_ALI_CDN_REAL_IP
170.130.206.2
HTTP_X_CLIENT_SCHEME
http
HTTP_ALI_SWIFT_STAT_HOST
level2.www.hengerda.com
HTTP_ALI_SWIFT_LOG_HOST
www.hengerda.com
HTTP_EAGLEEYE_TRACEID
2ff617a117622787367815510e
HTTP_VIA
us22.l1, ens-cache1.us22, l2us4.l2, ens-cache13.l2us4
HTTP_CONNECTION
close
HTTP_REFERER
www.hengerda.com
HTTP_X_FORWARDED_FOR
170.130.206.2, 163.181.146.161
HTTP_REMOTE_HOST
163.181.146.161
HTTP_X_REAL_IP
163.181.146.161
HTTP_HOST
www.hengerda.com
REDIRECT_STATUS
200
SERVER_NAME
cs.hengerda.com
SERVER_PORT
8099
SERVER_ADDR
127.0.0.1
REMOTE_PORT
61720
REMOTE_ADDR
127.0.0.1
SERVER_SOFTWARE
nginx/1.17.2
GATEWAY_INTERFACE
CGI/1.1
REQUEST_SCHEME
http
SERVER_PROTOCOL
HTTP/1.0
DOCUMENT_ROOT
C:/wwwroot/new.hengerda.com/public
DOCUMENT_URI
/index.php
REQUEST_URI
/news/News-Releases
CONTENT_LENGTH
CONTENT_TYPE
REQUEST_METHOD
GET
QUERY_STRING
s=/news/News-Releases
PATH_INFO
/news/News-Releases
SCRIPT_NAME
/index.php
SCRIPT_FILENAME
C:/wwwroot/new.hengerda.com/public/index.php
FCGI_ROLE
RESPONDER
PHP_SELF
/index.php
REQUEST_TIME_FLOAT
1762278737.3702
REQUEST_TIME
1762278737
Environment Variables
empty

ThinkPHP Constants

APP_PATH
C:\wwwroot\new.hengerda.com\public/../application/
THINK_VERSION
5.0.24
THINK_START_TIME
1762278737.373
THINK_START_MEM
373248
EXT
.php
DS
\
THINK_PATH
C:\wwwroot\new.hengerda.com\thinkphp\
LIB_PATH
C:\wwwroot\new.hengerda.com\thinkphp\library\
CORE_PATH
C:\wwwroot\new.hengerda.com\thinkphp\library\think\
TRAIT_PATH
C:\wwwroot\new.hengerda.com\thinkphp\library\traits\
ROOT_PATH
C:\wwwroot\new.hengerda.com\
EXTEND_PATH
C:\wwwroot\new.hengerda.com\extend\
VENDOR_PATH
C:\wwwroot\new.hengerda.com\vendor\
RUNTIME_PATH
C:\wwwroot\new.hengerda.com\runtime\
LOG_PATH
C:\wwwroot\new.hengerda.com\runtime\log\
CACHE_PATH
C:\wwwroot\new.hengerda.com\runtime\cache\
TEMP_PATH
C:\wwwroot\new.hengerda.com\runtime\temp\
CONF_PATH
C:\wwwroot\new.hengerda.com\public/../application/
CONF_EXT
.php
ENV_PREFIX
PHP_
IS_CLI
false
IS_WIN
true
FILTER_VALIDATE_BOOL
258
ADDON_PATH
C:\wwwroot\new.hengerda.com\addons\
Baidu
sogou