错误语句:INSERT INTO `tp_goods_visit_statistics` (`user_id` , `goods_id` , `visittime` , `cat_id` , `channel` , `extend_cat_id`) VALUES (:data__user_id , NULL , :data__visittime , NULL , :data__channel , NULL) System Error

[10501] PDOException in Connection.php line 463

SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'goods_id' cannot be null

  1. $this->debug(false);
  2. $this->numRows = $this->PDOStatement->rowCount();
  3. return $this->numRows;
  4. } catch (\PDOException $e) {
  5. if ($this->isBreak($e)) {
  6. return $this->close()->execute($sql, $bind);
  7. }
  8. echo '错误语句:'. $sql;
  9. throw new PDOException($e, $this->config, $this->getLastsql());
  10. } catch (\Throwable $e) {
  11. if ($this->isBreak($e)) {
  12. return $this->close()->execute($sql, $bind);
  13. }
  14. echo '错误语句:'. $sql;
  15. throw $e;
  16. } catch (\Exception $e) {
  17. if ($this->isBreak($e)) {
  18. 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' => [0, 1], 'data__visittime' => [1701656625, 1], 'data__channel' => [1, 1]]) in Query.php line 241
  3. at Query->execute('INSERT INTO `tp_good...', ['data__user_id' => [0, 1], 'data__visittime' => [1701656625, 1], 'data__channel' => [1, 1]]) in Query.php line 2095
  4. at Query->insert(['user_id' => 0, 'goods_id' => null, 'visittime' => 1701656625, ...]) in Query.php line 2907
  5. at Query->add(['user_id' => 0, 'goods_id' => null, 'visittime' => 1701656625, ...]) in GoodsLogic.php line 665
  6. at GoodsLogic->add_visit_log(0, null, 1) in Goods.php line 56
  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, ...], false) in App.php line 459
  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('/web/xppen.com.cn/th...') in index.php line 62

Exception Datas

PDO Error Info
SQLSTATE 23000
Driver Error Code 1048
Driver Error Message Column 'goods_id' cannot be null
Database Status
Error Code 10501
Error Message SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'goods_id' cannot be null
Error SQL INSERT INTO `tp_goods_visit_statistics` (`user_id` , `goods_id` , `visittime` , `cat_id` , `channel` , `extend_cat_id`) VALUES (0 , NULL , 1701656625 , NULL , 1 , NULL)
Database Config
type mysql
hostname 127.0.0.1
database xppencomcn
hostport 3306
dsn
params []
charset utf8
prefix tp_
debug false
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
19
POST Data
empty
Files
empty

Cookies

is_mobile
0
Session
empty

Server/Request Data

USER
www
HOME
/home/www
HTTP_CONNECTION
Keep-Alive
HTTP_HOST
shop.xp-pen.com.cn
HTTP_ACCEPT_ENCODING
br,gzip
HTTP_IF_MODIFIED_SINCE
Mon, 27 Mar 2023 12:51:02 GMT
HTTP_ACCEPT_LANGUAGE
en-US,en;q=0.5
HTTP_ACCEPT
text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_USER_AGENT
CCBot/2.0 (https://commoncrawl.org/faq/)
PATH_INFO
Home/Goods/goodsInfo/id/19.html
PHP_ADMIN_VALUE
open_basedir=/home/wwwroot/default:/web/:/tmp/:/proc/
REDIRECT_STATUS
200
SERVER_NAME
shop.xp-pen.com.cn
SERVER_PORT
443
SERVER_ADDR
192.168.0.231
REMOTE_PORT
56688
REMOTE_ADDR
18.206.48.243
SERVER_SOFTWARE
nginx/1.14.0
GATEWAY_INTERFACE
CGI/1.1
HTTPS
on
REQUEST_SCHEME
https
SERVER_PROTOCOL
HTTP/1.1
DOCUMENT_ROOT
/web/xppen.com.cn
DOCUMENT_URI
/index.php
REQUEST_URI
/Home/Goods/goodsInfo/id/19.html
SCRIPT_NAME
/index.php
CONTENT_LENGTH
CONTENT_TYPE
REQUEST_METHOD
GET
QUERY_STRING
s=Home/Goods/goodsInfo/id/19.html
SCRIPT_FILENAME
/web/xppen.com.cn/index.php
FCGI_ROLE
RESPONDER
PHP_SELF
REQUEST_TIME_FLOAT
1701656624.9688
REQUEST_TIME
1701656624
Environment Variables
empty

ThinkPHP Constants

IS_SAAS
0
SAAS_BASE_USER
0
PLUGIN_PATH
/web/xppen.com.cn/plugins/
UPLOAD_PATH
public/upload/
TPSHOP_CACHE_TIME
1
SITE_URL
https://shop.xp-pen.com.cn
HTTP
https
INSTALL_DATE
1463741583
SERIALNUMBER
20160520065303oCWIoa
APP_PATH
/web/xppen.com.cn/application/
NOW_TIME
1701656624
THINK_VERSION
5.0.15
THINK_START_TIME
1701656624.9696
THINK_START_MEM
416704
EXT
.php
DS
/
THINK_PATH
/web/xppen.com.cn/thinkphp/
LIB_PATH
/web/xppen.com.cn/thinkphp/library/
CORE_PATH
/web/xppen.com.cn/thinkphp/library/think/
TRAIT_PATH
/web/xppen.com.cn/thinkphp/library/traits/
ROOT_PATH
/web/xppen.com.cn/
EXTEND_PATH
/web/xppen.com.cn/extend/
VENDOR_PATH
/web/xppen.com.cn/vendor/
RUNTIME_PATH
/web/xppen.com.cn/runtime/
LOG_PATH
/web/xppen.com.cn/runtime/log/
CACHE_PATH
/web/xppen.com.cn/runtime/cache/
TEMP_PATH
/web/xppen.com.cn/runtime/temp/
CONF_PATH
/web/xppen.com.cn/application/
CONF_EXT
.php
ENV_PREFIX
PHP_
IS_CLI
false
IS_WIN
false
ADDON_PATH
/web/xppen.com.cn/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