[10501] PDOException in Connection.php line 456

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '端午节 betway必威体育平台上演一场非遗盛会 精' for key 'keyword'

  1. // 调试结束
  2. $this->debug(false);
  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. 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. throw $e;
  15. } catch (\Exception $e) {
  16. if ($this->isBreak($e)) {
  17. return $this->close()->execute($sql, $bind);
  18. }

Call Stack

  1. in Connection.php line 456
  2. at Connection->execute('INSERT INTO `qb_sear...', ['data__keyword' => ['...', 2], 'data__searchnums' => [1, 1]]) in Query.php line 241
  3. at Query->execute('INSERT INTO `qb_sear...', ['data__keyword' => ['...', 2], 'data__searchnums' => [1, 1]]) in Query.php line 2208
  4. at Query->insert(['keyword' => '...', 'searchnums' => 1]) in Index.php line 56
  5. at Index->lists('...', '')
  6. at ReflectionMethod->invokeArgs(object(Index), ['...', '']) in App.php line 348
  7. at App::invokeMethod([object(Index), 'lists'], []) in App.php line 612
  8. at App::module(['search', 'index', 'lists'], ['app_host' => '', 'app_debug' => true, 'app_trace' => false, ...], true) in App.php line 461
  9. at App::exec(['type' => 'module', 'module' => ['search', 'index', 'lists']], ['app_host' => '', 'app_debug' => true, 'app_trace' => false, ...]) in App.php line 139
  10. at App::run() in start.php line 19
  11. at require('/www/wwwroot/xinyins...') in index.php line 29

Exception Datas

PDO Error Info
SQLSTATE
23000
Driver Error Code
1062
Driver Error Message
Duplicate entry '端午节 betway必威体育平台上演一场非遗盛会 精' for key 'keyword'
Database Status
Error Code
10501
Error Message
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '端午节 betway必威体育平台上演一场非遗盛会 精' for key 'keyword'
Error SQL
INSERT INTO `qb_search_keyword` (`keyword` , `searchnums`) VALUES ('端午节 betway必威体育平台上演一场非遗盛会 精彩节目吸引上万群众观看' , 1)
Database Config
type
mysql
hostname
xinyinsha.mysql.rds.aliyuncs.com
database
xinyinshamh
hostport
3306
dsn
params
[]
charset
utf8
prefix
qb_
debug
true
deploy
0
rw_separate
false
master_num
1
slave_no
fields_strict
false
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

keyword
端午节 betway必威体育平台上演一场非遗盛会 精彩节目吸引上万群众观看
POST Data
empty
Files
empty

Cookies

user_sid
3d66c21430
Session
empty

Server/Request Data

USER
www
HOME
/home/www
HTTP_ACCEPT_ENCODING
deflate, gzip
HTTP_ACCEPT
*/*
HTTP_HOST
www.xinyinsha.com
HTTP_USER_AGENT
Mozilla/5.0+(compatible;+Baiduspider/2.0;++http://www.baidu.com/search/spider.html)
PATH_INFO
/search/index/lists.html
REDIRECT_STATUS
200
SERVER_NAME
xinyinsha.com
SERVER_PORT
443
SERVER_ADDR
172.18.18.199
REMOTE_PORT
20005
REMOTE_ADDR
154.212.225.206
SERVER_SOFTWARE
nginx/1.16.1
GATEWAY_INTERFACE
CGI/1.1
HTTPS
on
REQUEST_SCHEME
https
SERVER_PROTOCOL
HTTP/1.1
DOCUMENT_ROOT
/www/wwwroot/xinyinsha.com
DOCUMENT_URI
/index.php
REQUEST_URI
/search/index/lists.html?keyword=端午节+betway必威体育平台上演一场非遗盛会+精彩节目吸引上万群众观看
SCRIPT_NAME
/index.php
CONTENT_LENGTH
CONTENT_TYPE
REQUEST_METHOD
GET
QUERY_STRING
s=/search/index/lists.html&keyword=端午节+betway必威体育平台上演一场非遗盛会+精彩节目吸引上万群众观看
SCRIPT_FILENAME
/www/wwwroot/xinyinsha.com/index.php
FCGI_ROLE
RESPONDER
PHP_SELF
/index.php
REQUEST_TIME_FLOAT
1594788477.9691
REQUEST_TIME
1594788477
Environment Variables
empty

ThinkPHP Constants

APP_PATH
/www/wwwroot/xinyinsha.com/application/
ENTRANCE
index
THINK_VERSION
5.0.18
THINK_START_TIME
1594788477.9693
THINK_START_MEM
397216
EXT
.php
DS
/
THINK_PATH
/www/wwwroot/xinyinsha.com/thinkphp/
LIB_PATH
/www/wwwroot/xinyinsha.com/thinkphp/library/
CORE_PATH
/www/wwwroot/xinyinsha.com/thinkphp/library/think/
TRAIT_PATH
/www/wwwroot/xinyinsha.com/thinkphp/library/traits/
ROOT_PATH
/www/wwwroot/xinyinsha.com/
EXTEND_PATH
/www/wwwroot/xinyinsha.com/extend/
VENDOR_PATH
/www/wwwroot/xinyinsha.com/vendor/
RUNTIME_PATH
/www/wwwroot/xinyinsha.com/runtime/
LOG_PATH
/www/wwwroot/xinyinsha.com/runtime/log/
CACHE_PATH
/www/wwwroot/xinyinsha.com/runtime/cache/
TEMP_PATH
/www/wwwroot/xinyinsha.com/runtime/temp/
CONF_PATH
/www/wwwroot/xinyinsha.com/application/
CONF_EXT
.php
ENV_PREFIX
PHP_
IS_CLI
false
IS_WIN
false
HTMLPURIFIER_PREFIX
/www/wwwroot/xinyinsha.com/vendor/ezyang/htmlpurifier/library
TEMPLATE_PATH
/www/wwwroot/xinyinsha.com/template/
IS_POST
false
PUBLIC_URL
/public/
PUBLIC_PATH
/www/wwwroot/xinyinsha.com/public/
UPLOAD_URL
/public/uploads/
UPLOAD_PATH
/www/wwwroot/xinyinsha.com/public/uploads/
STATIC_URL
/public/static/
STATIC_PATH
/www/wwwroot/xinyinsha.com/public/static/
PLUGINS_PATH
/www/wwwroot/xinyinsha.com/plugins/
CACHE_DIR
/www/wwwroot/xinyinsha.com/runtime/
QUN
社群
ADMIN_FILENAME
xinyinshaadminlogin.php
LOAD_INDEXBASE
true