[10501] PDOException in Connection.php line 388

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'page' 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 (\Exception $e) {
  12. if ($this->isBreak($e)) {
  13. return $this->close()->query($sql, $bind, $master, $pdo);
  14. }
  15. throw $e;
  16. }
  17. }
  18. /**

Call Stack

  1. in Connection.php line 388
  2. at Connection->query('SELECT * FROM `yado_...', [], false, false) in Query.php line 225
  3. at Query->query('SELECT * FROM `yado_...', [], false, false) in Query.php line 2475
  4. at Query->find() in common.php line 108
  5. at get_category('page') in Index.php line 251
  6. at Index->page()
  7. at ReflectionMethod->invokeArgs(object(Index), []) in App.php line 196
  8. at App::invokeMethod([object(Index), 'page'], []) in App.php line 408
  9. at App::module(['index', 'index', 'page'], ['app_host' => '', 'app_debug' => true, 'app_trace' => false, ...], true) in App.php line 295
  10. at App::exec(['type' => 'module', 'module' => ['index', 'index', 'page']], ['app_host' => '', 'app_debug' => true, 'app_trace' => false, ...]) in App.php line 123
  11. at App::run() in start.php line 18
  12. at require('D:\wwwroot\hlpci_d0x...') in index.php line 19

Exception Datas

PDO Error Info
SQLSTATE
42S22
Driver Error Code
1054
Driver Error Message
Unknown column 'page' in 'where clause'
Database Status
Error Code
10501
Error Message
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'page' in 'where clause'
Error SQL
SELECT * FROM `yado_category` WHERE ( id = page ) LIMIT 1
Database Config
type
mysql
hostname
rm-2zerkbi85b9or2qi6.mysql.rds.aliyuncs.com
database
hlpci
hostport
3306
dsn
params
[]
charset
utf8
prefix
yado_
debug
false
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
true
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

_FCGI_X_PIPE_
\\.\pipe\IISFCGI-c185a463-c9f0-430c-9f94-e8c0c3a82b79
PHP_FCGI_MAX_REQUESTS
10000
ALLUSERSPROFILE
C:\ProgramData
APPDATA
C:\Windows\system32\config\systemprofile\AppData\Roaming
APP_POOL_CONFIG
C:\inetpub\temp\apppools\hlpci\hlpci.config
APP_POOL_ID
hlpci
CommonProgramFiles
C:\Program Files\Common Files
CommonProgramFiles(x86)
C:\Program Files (x86)\Common Files
CommonProgramW6432
C:\Program Files\Common Files
COMPUTERNAME
iZwb1b9tsmahzkZ
ComSpec
C:\Windows\system32\cmd.exe
LOCALAPPDATA
C:\Windows\system32\config\systemprofile\AppData\Local
NUMBER_OF_PROCESSORS
4
OS
Windows_NT
Path
C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\Git\cmd;D:\HwsHostMaster\phpweb\php71;C:\ProgramData\ComposerSetup\bin;C:\Windows\system32\config\systemprofile\AppData\Local\Microsoft\WindowsApps
PATHEXT
.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
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
USERDOMAIN
WORKGROUP
USERNAME
iZwb1b9tsmahzkZ$
USERPROFILE
C:\Windows\system32\config\systemprofile
windir
C:\Windows
ORIG_PATH_INFO
/index.php/index/index/page/catid/
URL
/index.php
SERVER_SOFTWARE
Microsoft-IIS/10.0
SERVER_PROTOCOL
HTTP/1.1
SERVER_PORT_SECURE
0
SERVER_PORT
80
SERVER_NAME
www.hlpci.com
SCRIPT_NAME
/index.php
SCRIPT_FILENAME
D:\wwwroot\hlpci_d0x3ar\web\index.php
REQUEST_URI
/index.php/index/index/page/catid/
REQUEST_METHOD
GET
REMOTE_USER
REMOTE_PORT
20002
REMOTE_HOST
154.208.246.222
REMOTE_ADDR
154.208.246.222
QUERY_STRING
PATH_TRANSLATED
D:\wwwroot\hlpci_d0x3ar\web\index.php\index\index\page\catid\
PATH_INFO
/index/index/page/catid/
LOGON_USER
LOCAL_ADDR
172.17.159.155
INSTANCE_META_PATH
/LM/W3SVC/6000
INSTANCE_NAME
INSTANCE_ID
6000
HTTPS_SERVER_SUBJECT
HTTPS_SERVER_ISSUER
HTTPS_SECRETKEYSIZE
HTTPS_KEYSIZE
HTTPS
off
GATEWAY_INTERFACE
CGI/1.1
DOCUMENT_ROOT
D:\wwwroot\hlpci_d0x3ar\web
CONTENT_TYPE
CONTENT_LENGTH
0
CERT_SUBJECT
CERT_SERIALNUMBER
CERT_ISSUER
CERT_FLAGS
CERT_COOKIE
AUTH_USER
AUTH_PASSWORD
AUTH_TYPE
APPL_PHYSICAL_PATH
D:\wwwroot\hlpci_d0x3ar\web\
APPL_MD_PATH
/LM/W3SVC/6000/ROOT
IIS_UrlRewriteModule
7.1.0871.0
HTTP_USER_AGENT
Mozilla/5.0+(compatible;+Baiduspider/2.0;++http://www.baidu.com/search/spider.html)
HTTP_HOST
www.hlpci.com
HTTP_ACCEPT_ENCODING
deflate, gzip
HTTP_ACCEPT
*/*
FCGI_ROLE
RESPONDER
PHP_SELF
/index.php/index/index/page/catid/
REQUEST_TIME_FLOAT
1563244970.9351
REQUEST_TIME
1563244970
Environment Variables
empty

ThinkPHP Constants

APP_PATH
D:\wwwroot\hlpci_d0x3ar\web/webappxin/
CONF_PATH
D:\wwwroot\hlpci_d0x3ar\web/confxin/
THINK_VERSION
5.0.10
THINK_START_TIME
1563244970.9361
THINK_START_MEM
366744
EXT
.php
DS
\
THINK_PATH
D:\wwwroot\hlpci_d0x3ar\web\yado\
LIB_PATH
D:\wwwroot\hlpci_d0x3ar\web\yado\library\
CORE_PATH
D:\wwwroot\hlpci_d0x3ar\web\yado\library\think\
TRAIT_PATH
D:\wwwroot\hlpci_d0x3ar\web\yado\library\traits\
ROOT_PATH
D:\wwwroot\hlpci_d0x3ar\web\
EXTEND_PATH
D:\wwwroot\hlpci_d0x3ar\web\extend\
VENDOR_PATH
D:\wwwroot\hlpci_d0x3ar\web\vendor\
RUNTIME_PATH
D:\wwwroot\hlpci_d0x3ar\web\runtime\
LOG_PATH
D:\wwwroot\hlpci_d0x3ar\web\runtime\log\
CACHE_PATH
D:\wwwroot\hlpci_d0x3ar\web\runtime\cache\
TEMP_PATH
D:\wwwroot\hlpci_d0x3ar\web\runtime\temp\
CONF_EXT
.php
ENV_PREFIX
PHP_
IS_CLI
false
IS_WIN
true