[10501] PDOException in Connection.php line 388

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Product' 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 2509
  4. at Query->find() in View.php line 16
  5. at View->index()
  6. at ReflectionMethod->invokeArgs(object(View), []) in App.php line 343
  7. at App::invokeMethod([object(View), 'index'], []) in App.php line 595
  8. at App::module(['home', 'view', 'index'], ['app_host' => '', 'app_debug' => true, 'app_trace' => false, ...], null) in App.php line 457
  9. at App::exec(['type' => 'module', 'module' => ['home', 'view', 'index']], ['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\guoruiwen...') in index.php line 19

Exception Datas

PDO Error Info
SQLSTATE
42S22
Driver Error Code
1054
Driver Error Message
Unknown column 'Product' in 'where clause'
Database Status
Error Code
10501
Error Message
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Product' in 'where clause'
Error SQL
SELECT * FROM `z_category` WHERE ( category_id=Product-996 ) LIMIT 1
Database Config
type
mysql
hostname
localhost
database
guoruiwenhua
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

PROCESSOR_ARCHITEW6432
AMD64
_FCGI_X_PIPE_
\\.\pipe\IISFCGI-4d0e171a-273d-493e-9e64-8383e351323f
PHP_FCGI_MAX_REQUESTS
10000
ALLUSERSPROFILE
C:\ProgramData
APPDATA
C:\Windows\system32\config\systemprofile\AppData\Roaming
APP_POOL_CONFIG
C:\inetpub\temp\apppools\DefaultAppPool\DefaultAppPool.config
APP_POOL_ID
DefaultAppPool
CommonProgramFiles
C:\Program Files (x86)\Common Files
CommonProgramFiles(x86)
C:\Program Files (x86)\Common Files
CommonProgramW6432
C:\Program Files\Common Files
COMPUTERNAME
iZbcz25njdnld0Z
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\;
PATHEXT
.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
PROCESSOR_ARCHITECTURE
x86
PROCESSOR_IDENTIFIER
Intel64 Family 6 Model 85 Stepping 4, GenuineIntel
PROCESSOR_LEVEL
6
PROCESSOR_REVISION
5504
ProgramData
C:\ProgramData
ProgramFiles
C:\Program Files (x86)
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
USERDOMAIN
WORKGROUP
USERNAME
iZbcz25njdnld0Z$
USERPROFILE
C:\Windows\system32\config\systemprofile
windir
C:\Windows
windows_tracing_flags
3
windows_tracing_logfile
C:\BVTBin\Tests\installpackage\csilogfile.log
ORIG_PATH_INFO
/index.php/home/view/index/id/Product-996.html
URL
/index.php
SERVER_SOFTWARE
Microsoft-IIS/7.5
SERVER_PROTOCOL
HTTP/1.1
SERVER_PORT_SECURE
0
SERVER_PORT
80
SERVER_NAME
www.guoruiwenhua.com
SCRIPT_NAME
/index.php
SCRIPT_FILENAME
C:\wwwroot\guoruiwenhua.com\public\index.php
REQUEST_URI
/home/view/index/id/Product-996.html
REQUEST_METHOD
GET
REMOTE_USER
REMOTE_PORT
20000
REMOTE_HOST
62.60.238.49
REMOTE_ADDR
62.60.238.49
QUERY_STRING
PATH_TRANSLATED
C:\wwwroot\guoruiwenhua.com\public\index.php\home\view\index\id\Product-996.html
PATH_INFO
/home/view/index/id/Product-996.html
LOGON_USER
LOCAL_ADDR
172.17.136.50
INSTANCE_META_PATH
/LM/W3SVC/4
INSTANCE_NAME
GUORUIWENHUA.COM
INSTANCE_ID
4
HTTPS_SERVER_SUBJECT
HTTPS_SERVER_ISSUER
HTTPS_SECRETKEYSIZE
HTTPS_KEYSIZE
HTTPS
off
GATEWAY_INTERFACE
CGI/1.1
DOCUMENT_ROOT
C:\wwwroot\guoruiwenhua.com\public
CONTENT_TYPE
CONTENT_LENGTH
0
CERT_SUBJECT
CERT_SERIALNUMBER
CERT_ISSUER
CERT_FLAGS
CERT_COOKIE
AUTH_USER
AUTH_PASSWORD
AUTH_TYPE
APPL_PHYSICAL_PATH
C:\wwwroot\guoruiwenhua.com\public\
APPL_MD_PATH
/LM/W3SVC/4/ROOT
IIS_UrlRewriteModule
7.1.0871.0
UNENCODED_URL
/home/view/index/id/Product-996.html
IIS_WasUrlRewritten
1
HTTP_X_ORIGINAL_URL
/home/view/index/id/Product-996.html
HTTP_USER_AGENT
Mozilla/5.0+(compatible;+Baiduspider/2.0;++http://www.baidu.com/search/spider.html)
HTTP_HOST
www.guoruiwenhua.com
HTTP_ACCEPT_ENCODING
deflate, gzip
HTTP_ACCEPT
*/*
HTTP_CONTENT_LENGTH
0
FCGI_ROLE
RESPONDER
PHP_SELF
/index.php/home/view/index/id/Product-996.html
REQUEST_TIME_FLOAT
1638780362.3469
REQUEST_TIME
1638780362
Environment Variables
empty

ThinkPHP Constants

APP_PATH
C:\wwwroot\guoruiwenhua.com\public/../apps/
THINK_VERSION
5.0.14
THINK_START_TIME
1638780362.3469
THINK_START_MEM
152816
EXT
.php
DS
\
THINK_PATH
C:\wwwroot\guoruiwenhua.com\thinkphp\
LIB_PATH
C:\wwwroot\guoruiwenhua.com\thinkphp\library\
CORE_PATH
C:\wwwroot\guoruiwenhua.com\thinkphp\library\think\
TRAIT_PATH
C:\wwwroot\guoruiwenhua.com\thinkphp\library\traits\
ROOT_PATH
C:\wwwroot\guoruiwenhua.com\
EXTEND_PATH
C:\wwwroot\guoruiwenhua.com\extend\
VENDOR_PATH
C:\wwwroot\guoruiwenhua.com\vendor\
RUNTIME_PATH
C:\wwwroot\guoruiwenhua.com\runtime\
LOG_PATH
C:\wwwroot\guoruiwenhua.com\runtime\log\
CACHE_PATH
C:\wwwroot\guoruiwenhua.com\runtime\cache\
TEMP_PATH
C:\wwwroot\guoruiwenhua.com\runtime\temp\
CONF_PATH
C:\wwwroot\guoruiwenhua.com\public/../apps/
CONF_EXT
.php
ENV_PREFIX
PHP_
IS_CLI
false
IS_WIN
true