[10501] PDOException in Connection.php line 764

SQLSTATE[22007]: Invalid datetime format: 1292 Truncated incorrect INTEGER value: 'beijing'

  1. $this->numRows = $this->PDOStatement->rowCount();
  2. return $this->numRows;
  3. } catch (\PDOException $e) {
  4. if ($this->isBreak($e)) {
  5. return $this->close()->execute($sql, $bind, $query);
  6. }
  7. throw new PDOException($e, $this->config, $this->getLastsql());
  8. } catch (\Throwable $e) {
  9. if ($this->isBreak($e)) {
  10. return $this->close()->execute($sql, $bind, $query);
  11. }
  12. throw $e;
  13. } catch (\Exception $e) {
  14. if ($this->isBreak($e)) {
  15. return $this->close()->execute($sql, $bind, $query);

Call Stack

  1. in Connection.php line 764
  2. at Connection->execute() in Connection.php line 1157
  3. at Connection->update() in Query.php line 2903
  4. at Query->update() in Query.php line 726
  5. at Query->setField() in Query.php line 759
  6. at Query->setInc() in Error.php line 100
  7. at Error->info()
  8. at ReflectionMethod->invokeArgs() in Container.php line 395
  9. at Container->invokeReflectMethod() in Module.php line 131
  10. at Module->think\route\dispatch\{closure}()
  11. at call_user_func_array() in Middleware.php line 185
  12. at Middleware->think\{closure}()
  13. at call_user_func() in Middleware.php line 130
  14. at Middleware->dispatch() 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}()
  18. at call_user_func_array() in Middleware.php line 185
  19. at Middleware->think\{closure}()
  20. at call_user_func() in Middleware.php line 130
  21. at Middleware->dispatch() in App.php line 435
  22. at App->run() in index.php line 21

Exception Datas

PDO Error Info
SQLSTATE 22007
Driver Error Code 1292
Driver Error Message Truncated incorrect INTEGER value: 'beijing'
Database Status
Error Code 10501
Error Message SQLSTATE[22007]: Invalid datetime format: 1292 Truncated incorrect INTEGER value: 'beijing'
Error SQL UPDATE `tp_article` SET `hits` = `hits` + 1 WHERE `id` = beijing
Database Config
type mysql
hostname localhost
database pc_yingivf_cn
hostport 3506
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
USER www-data
HOME /var/www
HTTP_HOST m.yingivf.cn
HTTP_REFERER http://m.yingivf.cn/jldy-50/beijing.html
HTTP_USER_AGENT claudebot
HTTP_ACCEPT */*
REDIRECT_STATUS 200
SERVER_NAME m.yingivf.cn
SERVER_PORT 443
SERVER_ADDR 47.89.25.83
REMOTE_USER
REMOTE_PORT 43378
REMOTE_ADDR 3.88.254.50
SERVER_SOFTWARE nginx/1.18.0
GATEWAY_INTERFACE CGI/1.1
HTTPS on
REQUEST_SCHEME https
SERVER_PROTOCOL HTTP/1.1
DOCUMENT_ROOT /usr/share/nginx/www.yingivf.cn/public
DOCUMENT_URI /index.php
REQUEST_URI /jldy-50/beijing.html
SCRIPT_NAME /index.php
CONTENT_LENGTH
CONTENT_TYPE
REQUEST_METHOD GET
QUERY_STRING s=/jldy-50/beijing.html
SCRIPT_FILENAME /usr/share/nginx/www.yingivf.cn/public/index.php
PATH_INFO
FCGI_ROLE RESPONDER
PHP_SELF /index.php
REQUEST_TIME_FLOAT 1711627190.3211
REQUEST_TIME 1711627190
Environment Variablesempty
ThinkPHP Constants
ADDON_PATH /usr/share/nginx/www.yingivf.cn/addons/