错误语句:INSERT INTO `tp_goods_visit` (`user_id` , `goods_id` , `visittime` , `cat_id` , `extend_cat_id`) VALUES (:data__user_id , :data__goods_id , :data__visittime , :data__cat_id , :data__extend_cat_id)

[10501] PDOException in Connection.php line 463

SQLSTATE[HY000]: General error: 1366 Incorrect integer value: 'deleted' for column 'user_id' at row 1

  1.             $this->debug(false);

  2. 

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

  4.             return $this->numRows;

  5.         } catch (\PDOException $e) {

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

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

  8.             }

  9.             echo '错误语句:'. $sql;

  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);

  14.             }

  15. 	    echo '错误语句:'. $sql;

  16.             throw $e;

  17.         } catch (\Exception $e) {

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

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

Call Stack

  1. in Connection.php line 463
  2. at Connection->execute('INSERT INTO `tp_good...', ['data__user_id' => ['deleted', 1], 'data__goods_id' => [7, 1], 'data__visittime' => [1734091816, 1], ...]) in Query.php line 241
  3. at Query->execute('INSERT INTO `tp_good...', ['data__user_id' => ['deleted', 1], 'data__goods_id' => [7, 1], 'data__visittime' => [1734091816, 1], ...]) in Query.php line 2095
  4. at Query->insert(['user_id' => 'deleted', 'goods_id' => 7, 'visittime' => 1734091816, ...]) in Query.php line 2907
  5. at Query->add(['user_id' => 'deleted', 'goods_id' => 7, 'visittime' => 1734091816, ...]) in GoodsLogic.php line 619
  6. at GoodsLogic->add_visit_log('deleted', object(Goods)) in Goods.php line 59
  7. at Goods->goodsInfo()
  8. at ReflectionMethod->invokeArgs(object(Goods), []) in App.php line 346
  9. at App::invokeMethod([object(Goods), 'goodsInfo'], []) in App.php line 614
  10. at App::module(['Home', 'Goods', 'goodsInfo'], ['app_host' => '', 'app_debug' => true, 'app_trace' => false, ...], null) in App.php line 460
  11. at App::exec(['type' => 'module', 'module' => ['Home', 'Goods', 'goodsInfo']], ['app_host' => '', 'app_debug' => true, 'app_trace' => false, ...]) in App.php line 142
  12. at App::run() in start.php line 19
  13. at require('/www/wwwroot/bjjrds/...') in indexphp line 60

Exception Datas

PDO Error Info
SQLSTATE HY000
Driver Error Code 1366
Driver Error Message Incorrect integer value: 'deleted' for column 'user_id' at row 1
Database Status
Error Code 10501
Error Message SQLSTATE[HY000]: General error: 1366 Incorrect integer value: 'deleted' for column 'user_id' at row 1
Error SQL INSERT INTO `tp_goods_visit` (`user_id` , `goods_id` , `visittime` , `cat_id` , `extend_cat_id`) VALUES (0 , 7 , 1734091816 , 11 , 0)
Database Config
type mysql
hostname 127.0.0.1
database bjjrds
hostport 3306
dsn
params []
charset utf8
prefix tp_
debug true
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 false
builder
query \think\db\Query
break_reconnect false

Environment Variables

GET Data

id
7
POST Data
empty
Files
empty

Cookies

$Version
1
uname
deleted
$Path
/
cn
deleted
user_id
deleted
PHPSESSID
deleted
is_mobile
0

Session

think
{ "isset_requestjs": 1, "redirect_url": "\/indexphp\/Home\/Order\/order_list.html" }

Server/Request Data

USER
www
HOME
/home/www
FCGI_ROLE
RESPONDER
SCRIPT_FILENAME
/www/wwwroot/bjjrds/indexphp
QUERY_STRING
s=/Home/Goods/goodsInfo/id/7.html
REQUEST_METHOD
GET
CONTENT_TYPE
CONTENT_LENGTH
SCRIPT_NAME
/indexphp
REQUEST_URI
/Home/Goods/goodsInfo/id/7.html
DOCUMENT_URI
/indexphp
DOCUMENT_ROOT
/www/wwwroot/bjjrds
SERVER_PROTOCOL
HTTP/1.1
REQUEST_SCHEME
http
GATEWAY_INTERFACE
CGI/1.1
SERVER_SOFTWARE
nginx/1.24.0
REMOTE_ADDR
223.71.40.74
REMOTE_PORT
54814
SERVER_ADDR
172.29.104.98
SERVER_PORT
80
SERVER_NAME
jinrendingsheng.top
REDIRECT_STATUS
200
PATH_INFO
/Home/Goods/goodsInfo/id/7.html
HTTP_REFERER
http://www.jinrendingsheng.top/Home/Goods/goodsList/id/13.html
HTTP_COOKIE
$Version=1; uname=deleted; $Path=/; cn=deleted; $Path=/; user_id=deleted; $Path=/; PHPSESSID=deleted; $Path=/; is_mobile=0; $Path=/
HTTP_CONNECTION
keep-alive
HTTP_HOST
www.jinrendingsheng.top
HTTP_USER_AGENT
Mozilla/4.5 (compatible; HTTrack 3.0x; Windows 98)
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_ACCEPT_LANGUAGE
en, *
HTTP_ACCEPT_ENCODING
gzip, identity;q=0.9
PHP_SELF
/indexphp
REQUEST_TIME_FLOAT
1734091816.382
REQUEST_TIME
1734091816
Environment Variables
empty

ThinkPHP Constants

PLUGIN_PATH
/www/wwwroot/bjjrds/plugins/
UPLOAD_PATH
public/upload/
TPSHOP_CACHE_TIME
31104000
SITE_URL
http://www.jinrendingsheng.top
HTTP
http
INSTALL_DATE
1463741583
SERIALNUMBER
20160520065303oCWIoa
APP_PATH
/www/wwwroot/bjjrds/application/
NOW_TIME
1734091816
THINK_VERSION
5.0.15
THINK_START_TIME
1734091816.3824
THINK_START_MEM
282168
EXT
.php
DS
/
THINK_PATH
/www/wwwroot/bjjrds/thinkphp/
LIB_PATH
/www/wwwroot/bjjrds/thinkphp/library/
CORE_PATH
/www/wwwroot/bjjrds/thinkphp/library/think/
TRAIT_PATH
/www/wwwroot/bjjrds/thinkphp/library/traits/
ROOT_PATH
/www/wwwroot/bjjrds/
EXTEND_PATH
/www/wwwroot/bjjrds/extend/
VENDOR_PATH
/www/wwwroot/bjjrds/vendor/
RUNTIME_PATH
/www/wwwroot/bjjrds/runtime/
LOG_PATH
/www/wwwroot/bjjrds/runtime/log/
CACHE_PATH
/www/wwwroot/bjjrds/runtime/cache/
TEMP_PATH
/www/wwwroot/bjjrds/runtime/temp/
CONF_PATH
/www/wwwroot/bjjrds/application/
CONF_EXT
.php
ENV_PREFIX
PHP_
IS_CLI
false
IS_WIN
false
ADDON_PATH
/www/wwwroot/bjjrds/addons/
EXTEND_MODULE
1
EXTEND_ANDROID
2
EXTEND_IOS
3
EXTEND_ENTRUST
4
EXTEND_MINIAPP
5
EXTEND_H5
6
TIME_MOUTH
4
IS_AJAX
false
IS_GET
true
IS_POST
false
MODULE_NAME
home
CONTROLLER_NAME
Goods
ACTION_NAME
goodsInfo
PREFIX
tp_
SESSION_ID
ThinkPHP V5.0.15 { 十年磨一剑-为API开发设计的高性能框架 }