[10501] PDOException in Connection.php line 687

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'cate' 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 COUNT(*) AS t...', ['ThinkBind_1_' => ['jgwmg', 2]], false, true) in Connection.php line 1295
  3. at Connection->value(object(Query), ['COUNT(*) AS tp_count'], 0) in Connection.php line 1323
  4. at Connection->aggregate(object(Query), 'COUNT', 'COUNT(*) AS tp_count') in Query.php line 623
  5. at Query->aggregate('COUNT', '*', true) in Query.php line 658
  6. at Query->count() in Query.php line 1782
  7. at Query->paginate(6) in Ztzl.php line 68
  8. at Ztzl->jgwmg()
  9. at ReflectionMethod->invokeArgs(object(Ztzl), []) in Container.php line 395
  10. at Container->invokeReflectMethod(object(Ztzl), object(ReflectionMethod), ['convert' => false]) in Module.php line 132
  11. at Module->think\route\dispatch\{closure}(object(Request), object(Closure), null)
  12. at call_user_func_array(object(Closure), [object(Request), object(Closure), null]) in Middleware.php line 185
  13. at Middleware->think\{closure}(object(Request))
  14. at call_user_func(object(Closure), object(Request)) in Middleware.php line 130
  15. at Middleware->dispatch(object(Request), 'controller') in Module.php line 137
  16. at Module->exec() in Dispatch.php line 168
  17. at Dispatch->run() in App.php line 432
  18. at App->think\{closure}(object(Request), object(Closure), null)
  19. at call_user_func_array(object(Closure), [object(Request), object(Closure), null]) in Middleware.php line 185
  20. at Middleware->think\{closure}(object(Request))
  21. at call_user_func(object(Closure), object(Request)) in Middleware.php line 130
  22. at Middleware->dispatch(object(Request)) in App.php line 435
  23. at App->run() in index.php line 21

Exception Datas

PDO Error Info
SQLSTATE 42S22
Driver Error Code 1054
Driver Error Message Unknown column 'cate' in 'where clause'
Database Status
Error Code 10501
Error Message SQLSTATE[42S22]: Column not found: 1054 Unknown column 'cate' in 'where clause'
Error SQL SELECT COUNT(*) AS tp_count FROM `tp_ztzl` WHERE ( `cate` = 'jgwmg' ) AND `tp_ztzl`.`delete_time` IS NULL LIMIT 1
Database Config
type mysql
hostname 127.0.0.1
database tp_tykj
hostport
dsn
params []
charset utf8
prefix tp_
debug true
deploy 0
rw_separate false
master_num 1
slave_no
read_master false
fields_strict true
resultset_type array
auto_timestamp true
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
REDIRECT_STATUS 200
HTTP_ACCEPT */*
HTTP_USER_AGENT claudebot
HTTP_HOST tygckj.com
PATH C:\Program Files (x86)\Common Files\Oracle\Java\javapath;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\Java\jdk1.8.0_181\bin;C:\Program Files\Java\jdk1.8.0_181\jre\bin;C:\Program Files\MySQL\MySQL Utilities 1.6\;C:\Program Files\MySQL\MySQL Server 5.6\bin;
SystemRoot C:\Windows
COMSPEC C:\Windows\system32\cmd.exe
PATHEXT .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
WINDIR C:\Windows
SERVER_SIGNATURE <address>Apache/2.4.37 (Win64) PHP/7.2.14 Server at tygckj.com Port 80</address>
SERVER_SOFTWARE Apache/2.4.37 (Win64) PHP/7.2.14
SERVER_NAME tygckj.com
SERVER_ADDR 172.16.21.103
SERVER_PORT 80
REMOTE_ADDR 3.237.51.235
DOCUMENT_ROOT C:/wamp64/www/tykj/public
REQUEST_SCHEME http
CONTEXT_PREFIX
CONTEXT_DOCUMENT_ROOT C:/wamp64/www/tykj/public
SERVER_ADMIN wampserver@wampserver.invalid
SCRIPT_FILENAME C:/wamp64/www/tykj/public/index.php
REMOTE_PORT 50880
REDIRECT_URL /jgwmg.html
GATEWAY_INTERFACE CGI/1.1
SERVER_PROTOCOL HTTP/1.1
REQUEST_METHOD GET
QUERY_STRING
REQUEST_URI /jgwmg.html
SCRIPT_NAME /index.php
PATH_INFO /jgwmg.html
PATH_TRANSLATED redirect:\index.php\jgwmg.html
PHP_SELF /index.php/jgwmg.html
REQUEST_TIME_FLOAT 1711675093.764
REQUEST_TIME 1711675093
Environment Variablesempty
ThinkPHP Constants
SITE_URL http://www.tygckj.com