[10501] PDOException in Connection.php line 687

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

  1. $this->debug(false, '', $master);
  2. // 返回结果集
  3. return $this->getResult($pdo, $procedure);
  4. } catch (\PDOException $e) {
  5. if ($this->isBreak($e)) {
  6. return $this->close()->query($sql, $bind, $master, $pdo);
  7. }
  8. throw new PDOException($e, $this->config, $this->getLastsql());
  9. } catch (\Throwable $e) {
  10. if ($this->isBreak($e)) {
  11. return $this->close()->query($sql, $bind, $master, $pdo);
  12. }
  13. throw $e;
  14. } catch (\Exception $e) {
  15. if ($this->isBreak($e)) {
  16. return $this->close()->query($sql, $bind, $master, $pdo);

Call Stack

  1. in Connection.php line 687
  2. at Connection->query('SELECT `id`,`pid`,`t...', [], false, false) in Connection.php line 844
  3. at Connection->find(object(Query)) in Query.php line 3131
  4. at Query->find() in common.php line 516
  5. at nav_id('product') in One.php line 41
  6. at One->view()
  7. at ReflectionMethod->invokeArgs(object(One), []) in Container.php line 395
  8. at Container->invokeReflectMethod(object(One), object(ReflectionMethod), ['id' => 'product', 'index' => 'id']) in Module.php line 132
  9. at Module->think\route\dispatch\{closure}(object(Request), object(Closure), null)
  10. at call_user_func_array(object(Closure), [object(Request), object(Closure), null]) in Middleware.php line 185
  11. at Middleware->think\{closure}(object(Request))
  12. at call_user_func(object(Closure), object(Request)) in Middleware.php line 130
  13. at Middleware->dispatch(object(Request), 'controller') in Module.php line 137
  14. at Module->exec() in Dispatch.php line 168
  15. at Dispatch->run() in App.php line 432
  16. at App->think\{closure}(object(Request), object(Closure), null)
  17. at call_user_func_array(object(Closure), [object(Request), object(Closure), null]) in Middleware.php line 185
  18. at Middleware->think\{closure}(object(Request))
  19. at call_user_func(object(Closure), object(Request)) in Middleware.php line 130
  20. at Middleware->dispatch(object(Request)) in App.php line 435
  21. at App->run() in index.php line 25

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 `id`,`pid`,`title` FROM `yb_nav` WHERE ( id=product ) LIMIT 1
Database Config
type mysql
hostname 127.0.0.1
database zgkz
hostport
dsn
params []
charset utf8
prefix yb_
debug true
deploy 0
rw_separate false
master_num 1
slave_no
read_master false
fields_strict true
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
break_match_str []

Environment Variables

GET Dataempty
POST Dataempty
Filesempty
Cookiesempty
Sessionempty
Server/Request Data
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;;D:\BtSoft\panel\script;;C:\Program Files\python;C:\Program Files\python\Scripts;;D:\BtSoft\panel\script;
SYSTEMROOT C:\Windows
COMSPEC C:\Windows\system32\cmd.exe
PATHEXT .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
WINDIR C:\Windows
_FCGI_SHUTDOWN_EVENT_ 14872
SCRIPT_NAME /index.php
REQUEST_URI /home/one/view/id/product/index/id/3.html
QUERY_STRING s=/home/one/view/id/product/index/id/3.html
REQUEST_METHOD GET
SERVER_PROTOCOL HTTP/1.1
GATEWAY_INTERFACE CGI/1.1
REDIRECT_QUERY_STRING s=/home/one/view/id/product/index/id/3.html
REDIRECT_URL /home/one/view/id/product/index/id/3.html
REMOTE_PORT 7103
SCRIPT_FILENAME D:/wwwroot/acsinb.com/index.php
SERVER_ADMIN webmaster@example.com
CONTEXT_DOCUMENT_ROOT D:/wwwroot/acsinb.com
CONTEXT_PREFIX
REQUEST_SCHEME http
DOCUMENT_ROOT D:/wwwroot/acsinb.com
REMOTE_ADDR 111.248.181.252
SERVER_PORT 80
SERVER_ADDR 61.157.96.92
SERVER_NAME www.acsinb.com
SERVER_SOFTWARE Apache/2.4.54 (Win64) OpenSSL/1.1.1p mod_fcgid/2.3.9a
SERVER_SIGNATURE
SystemRoot C:\Windows
HTTP_ACCEPT_ENCODING gzip, identity;q=0.9
HTTP_ACCEPT_LANGUAGE en, *
HTTP_ACCEPT text/html,image/png,image/jpeg,image/pjpeg,image/x-xbitmap,image/svg+xml,image/gif;q=0.9,*/*;q=0.1
HTTP_USER_AGENT Mozilla/4.5 (compatible; HTTrack 3.0x; Windows 98)
HTTP_HOST www.acsinb.com
HTTP_CONNECTION close
HTTP_REFERER http://www.acsinb.com/home/one/view/id/23.html
gzip_only_text_html 1
REDIRECT_STATUS 200
REDIRECT_gzip_only_text_html 1
FCGI_ROLE RESPONDER
PHP_SELF /index.php
REQUEST_TIME_FLOAT 1694280484.9405
REQUEST_TIME 1694280484
Environment Variablesempty
ThinkPHP Constants
APP_DEBUG true
APP_PATH D:\wwwroot\acsinb.com/app/
BIND_MODULE home
ROOT_PATH D:\wwwroot\acsinb.com\
VENDOR_PATH D:\wwwroot\acsinb.com\vendor\
APP_CACHE_DIR D:\wwwroot\acsinb.com\data\
DS /