[10501] PDOException in Connection.php line 764

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

  1. 

  2.             $this->numRows = $this->PDOStatement->rowCount();

  3. 

  4.             return $this->numRows;

  5.         } catch (\PDOException $e) {

  6.             if ($this->isBreak($e)) {

  7.                 return $this->close()->execute($sql, $bind, $query);

  8.             }

  9. 

  10.             throw new PDOException($e, $this->config, $this->getLastsql());

  11.         } catch (\Throwable $e) {

  12.             if ($this->isBreak($e)) {

  13.                 return $this->close()->execute($sql, $bind, $query);

  14.             }

  15. 

  16.             throw $e;

  17.         } catch (\Exception $e) {

  18.             if ($this->isBreak($e)) {

  19.                 return $this->close()->execute($sql, $bind, $query);

Call Stack

  1. in Connection.php line 764
  2. at Connection->execute('UPDATE `zf_post` SE...', [], object(Query)) in Connection.php line 1157
  3. at Connection->update(object(Query)) in Query.php line 2923
  4. at Query->update(['hits' => ['INC', 1]]) in Query.php line 746
  5. at Query->setField('hits', ['INC', 1]) in Query.php line 779
  6. at Query->setInc('hits') in Cate.php line 209
  7. at Cate->detail('contactus')
  8. at ReflectionMethod->invokeArgs(object(Cate), ['contactus']) in Container.php line 395
  9. at Container->invokeReflectMethod(object(Cate), object(ReflectionMethod), ['id' => 'contactus', 'convert' => false]) in Module.php line 131
  10. at Module->think\route\dispatch\{closure}(object(Request), object(Closure), null)
  11. at call_user_func_array(object(Closure), [object(Request), object(Closure), null]) in Middleware.php line 185
  12. at Middleware->think\{closure}(object(Request))
  13. at call_user_func(object(Closure), object(Request)) in Middleware.php line 130
  14. at Middleware->dispatch(object(Request), 'controller') in Module.php line 136
  15. at Module->exec() in Dispatch.php line 168
  16. at Dispatch->run() in App.php line 432
  17. at App->think\{closure}(object(Request), object(Closure), null)
  18. at call_user_func_array(object(Closure), [object(Request), object(Closure), null]) in Middleware.php line 185
  19. at Middleware->think\{closure}(object(Request))
  20. at call_user_func(object(Closure), object(Request)) in Middleware.php line 130
  21. at Middleware->dispatch(object(Request)) in App.php line 435
  22. at App->run() in index.php line 23

Exception Datas

PDO Error Info
SQLSTATE 42S22
Driver Error Code 1054
Driver Error Message Unknown column 'contactus' in 'where clause'
Database Status
Error Code 10501
Error Message SQLSTATE[42S22]: Column not found: 1054 Unknown column 'contactus' in 'where clause'
Error SQL UPDATE `zf_post` SET `hits` = `hits` + 1 WHERE ( id=contactus )
Database Config
type mysql
hostname bdm721862671.my3w.com
database bdm721862671_db
hostport 3306
dsn
params []
charset utf8
prefix zf_
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
Cookies
PHPSESSID 8cnlocr7kq8n8j62218vii25l3
Sessionempty
Server/Request Data
DOCUMENT_ROOT /usr/home/wh-abi3sgmeuxztcoc6c65/htdocs
GATEWAY_INTERFACE CGI/1.1
HTTP_ACCEPT */*
HTTP_ACCEPT_ENCODING gzip
HTTP_COOKIE PHPSESSID=8cnlocr7kq8n8j62218vii25l3
HTTP_HOST www.biolandgroup.com
HTTP_USER_AGENT Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)
PATH /bin
PHPRC /var/www/php56/hichina_ini/wh-abi3sgmeuxztcoc6c65
QUERY_STRING
REDIRECT_DOCUMENT_ROOT /usr/home/wh-abi3sgmeuxztcoc6c65/htdocs
REDIRECT_GATEWAY_INTERFACE CGI/1.1
REDIRECT_HTTP_ACCEPT */*
REDIRECT_HTTP_ACCEPT_ENCODING gzip
REDIRECT_HTTP_COOKIE PHPSESSID=8cnlocr7kq8n8j62218vii25l3
REDIRECT_HTTP_HOST www.biolandgroup.com
REDIRECT_HTTP_USER_AGENT Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)
REDIRECT_PATH /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
REDIRECT_PATH_INFO /contactus.html
REDIRECT_PATH_TRANSLATED redirect:/index.php/contactus.html
REDIRECT_QUERY_STRING
REDIRECT_REMOTE_ADDR 50.2.50.110
REDIRECT_REMOTE_PORT 51798
REDIRECT_REQUEST_METHOD GET
REDIRECT_REQUEST_URI //detail/contactus.html
REDIRECT_SCRIPT_FILENAME /usr/home/wh-abi3sgmeuxztcoc6c65/htdocs/detail
REDIRECT_SCRIPT_NAME /detail
REDIRECT_SERVER_ADDR 10.22.37.245
REDIRECT_SERVER_ADMIN webmaster@wh-abi3sgmeuxztcoc6c65.my3w.com
REDIRECT_SERVER_NAME www.biolandgroup.com
REDIRECT_SERVER_PORT 80
REDIRECT_SERVER_PROTOCOL HTTP/1.1
REDIRECT_SERVER_SIGNATURE
REDIRECT_SERVER_SOFTWARE Apache
REDIRECT_STATUS 200
REDIRECT_TZ Asia/Shanghai
REDIRECT_UNIQUE_ID Y-cZCgoWJfUAP5QilN4AAAAE
REDIRECT_URL /detail/contactus.html
REMOTE_ADDR 50.2.50.110
REMOTE_PORT 51798
REQUEST_METHOD GET
REQUEST_URI //detail/contactus.html
SCRIPT_FILENAME /usr/home/wh-abi3sgmeuxztcoc6c65/htdocs/index.php
SCRIPT_NAME /index.php
SERVER_ADDR 10.22.37.245
SERVER_ADMIN webmaster@wh-abi3sgmeuxztcoc6c65.my3w.com
SERVER_NAME www.biolandgroup.com
SERVER_PORT 80
SERVER_PROTOCOL HTTP/1.1
SERVER_SIGNATURE
SERVER_SOFTWARE Apache
TZ Asia/Shanghai
UNIQUE_ID Y-cZCgoWJfUAP5QilN4AAAAE
ORIG_PATH_INFO /detail/contactus.html
ORIG_PATH_TRANSLATED /usr/home/wh-abi3sgmeuxztcoc6c65/htdocs/index.php
PHP_SELF /index.php
REQUEST_TIME_FLOAT 1677138186.8005
REQUEST_TIME 1677138186
Environment Variablesempty
ThinkPHP Constants
PINYIN_DEFAULT 4096
PINYIN_TONE 2
PINYIN_NO_TONE 4
PINYIN_ASCII_TONE 8
PINYIN_NAME 16
PINYIN_KEEP_NUMBER 32
PINYIN_KEEP_ENGLISH 64
PINYIN_UMLAUT_V 128
PINYIN_KEEP_PUNCTUATION 256
ThinkPHP V5.1.39 LTS { 十年磨一剑-为API开发设计的高性能框架 }