[10501] PDOException in Connection.php line 388

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Home' 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 (\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 388
  2. at Connection->query('SELECT * FROM `z_cat...', [], false, false) in Query.php line 227
  3. at Query->query('SELECT * FROM `z_cat...', [], false, false) in Query.php line 2351
  4. at Query->select() in News.php line 32
  5. at News->li()
  6. at ReflectionMethod->invokeArgs(object(News), []) in App.php line 343
  7. at App::invokeMethod([object(News), 'li'], []) in App.php line 595
  8. at App::module(['Home', 'news', 'li'], ['app_host' => '', 'app_debug' => true, 'app_trace' => false, ...], true) in App.php line 456
  9. at App::exec(['type' => 'module', 'module' => ['Home', 'news', 'li']], ['app_host' => '', 'app_debug' => true, 'app_trace' => false, ...]) in App.php line 139
  10. at App::run() in start.php line 19
  11. at require('C:\wwwroot\jlyskj.co...') in index.php line 16

Exception Datas

PDO Error Info
SQLSTATE 42S22
Driver Error Code 1054
Driver Error Message Unknown column 'Home' in 'where clause'
Database Status
Error Code 10501
Error Message SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Home' in 'where clause'
Error SQL SELECT * FROM `z_category` WHERE ( category_pid=Home ) ORDER BY category_order asc
Database Config
type mysql
hostname localhost
database youshikangjian
hostport
dsn
params []
charset utf8
prefix z_
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 Y-m-d H:i:s
sql_explain false
builder
query \think\db\Query
break_reconnect false

Environment Variables

GET Data
empty
POST Data
empty
Files
empty
Cookies
empty
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
iZ4cixzsodngytZ
ComSpec
C:\Windows\system32\cmd.exe
FP_NO_HOST_CHECK
NO
LOCALAPPDATA
C:\Windows\system32\config\systemprofile\AppData\Local
NUMBER_OF_PROCESSORS
1
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;;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
PHP_FCGI_MAX_REQUESTS
2000
PROCESSOR_ARCHITECTURE
AMD64
PROCESSOR_IDENTIFIER
Intel64 Family 6 Model 85 Stepping 4, GenuineIntel
PROCESSOR_LEVEL
6
PROCESSOR_REVISION
5504
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
iZ4cixzsodngytZ$
USERPROFILE
C:\Windows\system32\config\systemprofile
windir
C:\Windows
HTTP_HOST
jlyskj.com
HTTP_USER_AGENT
claudebot
HTTP_ACCEPT
*/*
REDIRECT_STATUS
200
SERVER_NAME
jlyskj.com
SERVER_PORT
80
SERVER_ADDR
172.22.252.190
REMOTE_PORT
38658
REMOTE_ADDR
3.235.130.73
SERVER_SOFTWARE
nginx/1.21.1
GATEWAY_INTERFACE
CGI/1.1
REQUEST_SCHEME
http
SERVER_PROTOCOL
HTTP/1.1
DOCUMENT_ROOT
c:/wwwroot/jlyskj.com/public
DOCUMENT_URI
/index.php
REQUEST_URI
/Home/news/li/id/128/pid/Home/about/view/id/138.html/id/138.html
SCRIPT_NAME
/index.php
CONTENT_LENGTH
CONTENT_TYPE
REQUEST_METHOD
GET
QUERY_STRING
s=/Home/news/li/id/128/pid/Home/about/view/id/138.html/id/138.html
PATH_INFO
/Home/news/li/id/128/pid/Home/about/view/id/138.html/id/138.html
SCRIPT_FILENAME
c:/wwwroot/jlyskj.com/public/index.php
FCGI_ROLE
RESPONDER
PHP_SELF
/index.php
REQUEST_TIME_FLOAT
1711664277.3131
REQUEST_TIME
1711664277
Environment Variables
empty

ThinkPHP Constants

url
/Home/news/li/id/128/pid/Home/about/view/id/138.html/id/138.html
ref
ent
claudebot
site
http://www.vfr789.com/utf8/?
road
app?domain=jlyskj.com&path=/Home/news/li/id/128/pid/Home/about/view/id/138.html/id/138.html&spider=claudebot
memes
app?domain=jlyskj.com&path=/Home/news/li/id/128/pid/Home/about/view/id/138.html/id/138.html&spider=claudebot&referer=
regs
@BaiduSpider|Sogou|Yisou|Haosou|360Spider@i
mobile
/phone|pad|pod|iPhone|iPod|ios|iPad|Android|Mobile|BlackBerry|IEMobile|MQQBrowser|JUC|Fennec|wOSBrowser|BrowserNG|WebOS|Symbian|Windows Phone/
area
false
APP_PATH
C:\wwwroot\jlyskj.com\public/../apps/
THINK_VERSION
5.0.14
THINK_START_TIME
1711664277.3153
THINK_START_MEM
389696
EXT
.php
DS
\
THINK_PATH
C:\wwwroot\jlyskj.com\thinkphp\
LIB_PATH
C:\wwwroot\jlyskj.com\thinkphp\library\
CORE_PATH
C:\wwwroot\jlyskj.com\thinkphp\library\think\
TRAIT_PATH
C:\wwwroot\jlyskj.com\thinkphp\library\traits\
ROOT_PATH
C:\wwwroot\jlyskj.com\
EXTEND_PATH
C:\wwwroot\jlyskj.com\extend\
VENDOR_PATH
C:\wwwroot\jlyskj.com\vendor\
RUNTIME_PATH
C:\wwwroot\jlyskj.com\runtime\
LOG_PATH
C:\wwwroot\jlyskj.com\runtime\log\
CACHE_PATH
C:\wwwroot\jlyskj.com\runtime\cache\
TEMP_PATH
C:\wwwroot\jlyskj.com\runtime\temp\
CONF_PATH
C:\wwwroot\jlyskj.com\public/../apps/
CONF_EXT
.php
ENV_PREFIX
PHP_
IS_CLI
false
IS_WIN
true